Posts mit dem Label SQL Server werden angezeigt. Alle Posts anzeigen
Posts mit dem Label SQL Server werden angezeigt. Alle Posts anzeigen

Mittwoch, 2. Oktober 2013

Extracting an Open Hub Destination based on InfoObject from SAP BW with SSIS / Xtract IS into SQL Server


In the following tutorial (pdf) I show how to create an Open Hub Service (OHS) destination and a Data Transer Process (DTP) on SAP BW 7.3 based on InfoObject Texts. After that I create a Process chain to execute the Data Transfer Process.

In the second step I use the Xtract IS OHS component within the Server Server Integration Services (SSIS) to extract the OHS Destination from BW and to load to a SQL Server table.

Links:
OHS with Xtract IS (pdf)
http://www.theobald-software.com/download/xtractis/ClickThroughXtractISOHS.pdf Xtract IS:
http://www.theobald-software.com/en/products/xtractis.htm 
SAP Open Hub Service:
http://help.sap.com/saphelp_nw04/helpdata/en/ce/c2463c6796e61ce10000000a114084/frameset.htm