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 →

Using Xtract RS with the ReportBuilder 3.0

The ReportBuilder is a standalone application to connect with a Report Server and create reports based on shared data sources / datasets. As the ReportBuilder does not support 3rd party Data Providers, we must rely on shared data sources to be able to use Xtract RS within the Report Builder. 185continue 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 →

Using ERPConnect to send IDocs to your SAP system within an ETL process based on SQL Server Integration Services (SSIS)

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 →