To extract data from an SAP BW/BI system, Xtract IS suite provides 3 different components supporting the following interfaces: MDX engine: Xtract IS BWCube component supports the MDX engine and enables the extraction of InfoCubes and BEx Queries. Open Hub Services: Xtract IS OHS component supports the Open Hub Services that allow you to distribute data from BW/BI system using Infospokes or Open Hub Destinations. Export DataSource: An Export DataSource enables the extraction of the following InfoProviders: InfoCubes, DataStores and InfoObjects. In contrast to Export DataSources, DataSources are provided to transfer data from…continue reading →
For SSIS based integration processes with SAP R/3, ERP and BI/BW systems, Xtract IS offers many components for SAP interface technologies: SAP Table/View, SAP Query, SAP BAPI/RFC, BW Cube (InfoCube, InfoQuery), BW Hierachy, Open Hub Services (OHS), ABAP Report, SAP DeltaQ and BWLoader (see Xtract IS website). Here is a sample scenario, if you want to send Idocs with SSIS, where the Data is in SQL Tables. 76continue reading →
Learn how to create, fill and use an SSIS variable together with the Xtract IS components.