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