Generate SAP Integration Packages with SSIS and Xtract IS using BIML

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database that can be used to perform a broad range of data integration and data extraction, transformation, and loading (ETL) tasks. Xtract IS is an SAP Integration solution for SSIS that provides all kinds of integration with SAP ERP and SAP BW in a secure and type-safe way with a graphical editor. Business Intelligence Markup Language (Biml) is a domain-specific XML dialect for defining business intelligence (BI) assets. Biml authored BI assets can currently be used by the BIDS Helper…continue 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 →

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 →

Extracting Datasources with the DeltaQ component

In this blog I will give an overview about extracting Datasources with the DeltaQ component to extract Extractors / Datasources from SAP ERP / ECC or Export Datasources from SAP BW / BI and give some tips how to troubleshoot errors that may occur. A Datasource is a set of fields that provide the data for a business unit (e.g. Customer, Material). Datasources are one of the data retrieval mechanisms in the SAP source system. Generally Datasources are used to transfer data from SAP ERP / ECC into SAP BW / BI. Export…continue reading →

The 1 Million Cell Limit when extracting BEx Queries and InfoCubes with the BWCube component from SAP BW

The BWCube component enables you extracting a BEx query or an InfoCube via the MDX interface. The MDX interface of the SAP BW system has a known restriction if the result contains too many cells (more than 1 million cells). SAP officially states: "In general the MDX interface is not suitable for accessing mass data". To solve this problem the BWCube component provides the following solutions: 647continue reading →