How to: Load data into a BW InfoObject with Xtract BW Loader

Xtract BW Loader is one out of the nine components of Xtract IS, the SAP Connector for the SQL Server Integration Services (SSIS) by Theobald Software. BW Loader allows to load data to SAP BW objects using an InfoPackage (refer to SAP help to know more about InfoPackages). In this blog I will show you how to use BW Loader in conjunction with an Infopackage to load data into InfoObject Texts. You can use BW Loader in conjunction with other Infopackages too, to load data to other BW objects, like InfoObject attributes, hierarchies…continue reading →

Building SSIS Package with Xtract IS Table Programmatically

In this blog I will show, how to create a SSIS package with Xtract IS Table programmatically. Our Package will extract data from an SAP table and load it to the SQL server. This scenario is very helpful to create your own packages, that you can load and reconfigure for different projects and customers. In this sample we will: create a Package add a data flow task add connection managers add an Xtract IS Table source component add an OLE DB destination component connect data flow components and map columns 316continue reading →

Performing lookups by joining sap data with reference dataset in SSIS

In an SAP table many fields can belong to the table key. In some scenarios when you extract an SAP table with Xtract IS to load it into an SQL table, you want to replace the SAP key fields by another custom key, e.g. a GUID. The customer sales data (KNVV) table e.g. has the following fields as key: MANDT: Client KUNNR: Customer Number VKORG: Sales Organisation VTWEG: Distribution Channel SPART: Division 247continue reading →

Extracting data from SAP BW/BI via Export DataSources with Xtract IS

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 →