Create Generic Datasource using Function Module and Timestamps

You can create a generic datasource using a function module. For delta functionality you need a delta field. Some tables like VBAK (Sales Document: Header Data) don't have a timestamp field for creation/change that we can use as a unique delta field but have separate fields for creation date (ERDAT), creation time (ERZET) and change date (AEDAT). To get the data of the VBAK table by using delta functionality we will create a generic datasource using a custom function module which implements the necessary logic. We will create an extraction structure that has…continue reading →

How to use Xtract Universal with HTTPS

Xtract Universal offers a feature to deliver SAP data extraction via https.You have to install a signed certificate or create a self signed certificate on your windows. This blog describes how to set up Xtract Universal and how to configure your IIS on windows 7 to use Xtract Universal with https. An older version of this blog has described the scenario for Xtract QV. Other windows versions may have different configuration. 389continue 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 →