Processing incremental data load of SAP datasources (extractors) with Xtract QV and QlikView

Incremental data load (delta load) is a very common task when extracting data from SAP, especially when extracting a big amount of data (e.g. transaction data like accounting line items). SAP delivers business content datasources (i.e. extractors) that can be extracted using the DeltaQ component in Xtract QV. Many of those extractors provide a delta mechanism (Update mode) that is managed by SAP. Executing an extractor in the Delta update mode delivers new, changed or deleted records since the last extraction. This sample uses the SAP extractor 0CUSTOMER_ATTR (for Customer Attributes) to develop…continue reading →

How to build perfect SAP Integration using Xtract Universal and Kettle

In this blog I will show how to use Kettle to run SAP extractions created with Xtract Universal to load it into an Oracle Database. Xtract Universal is an SAP connector by Theobald Software, a leading vendor of SAP Integration products. Xtract Universal supports integration of your SAP data in the most different target systems, like SQL Server, Oracle, IBM DB2, Teradata, flat files and others – fast, straight-forward and user-friendly. Kettle (aka Pentaho Data Integration (PDI)) is an open source data integration (ETL) engine that allows the user to define data integration…continue reading →

Activating Datasources in the SAP OLTP System

To be able to extract OLTP Datasources from SAP ERP, you first of all have to activate the relevant DataSources in the SAP OLTP system. After activating the DataSources you can extract data from all the active DataSources using the DeltaQ component. Thoses steps have to be carried out in the SAP ERP system (OLTP). No SAP BW system is required. 814continue reading →

How to use an SQL Configuration Table with Xtract IS

SQL Server Integration Services (SSIS) provides package configurations that you can use to update the values of properties at run time. In this blog I will show how to store your package configuration in an SQL table. In my sample I will use Xtract IS to load the SAP table T001 for company codes using a where statement. The goal is to use the SQL configuration table to update the value of the where statement and the value of the SAP connection string. 785continue reading →