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.

How to schedule Xtract Universal extractions to load data from SAP

Xtract Universal supports integration of your SAP data in the most different target systems. After creating an extraction (Refer to the online help), you can run an extraction by just calling the correspondent URL that can be found in the Run Dialog (e.g. http://nbelzein:8065/?name=plants)

 

In this blog I will show you how to schedule the run of the Xtract Universal extractions that is as easy as calling a URL. Xtract Universal delivers the command tool XtractUniversalCmd.exe (to be found in the installation folder, e.g. C:\Program Files\XtractUniversal) to run an extraction using the cmd. We will use this approach to schedule an extraction with the windows Task Scheduler and the SQL Server Agent.

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 or InfoCubes.

How to open SAP GUI from browser

In this blog I will show how to launch SAP GUI from IE Browser using Javascript.

In Javascript we will use an ActiveXObject (wscript.shell) to call SAPshortcut.exe with the required parameters to open the SAP GUI.

The result should be as the following:

ERPConnect Services Video Tutorials

ERPConnect Services - Seamless connection of SAP and SharePoint 2010 ERPConnect Services (ECS) consists of two components, which allow you the complete range of data integration between SharePoint and SAP. No additional middleware is required – the integration runs completely within your SharePoint architecture.

• · ERPConnect Services Runtime (ECS Runtime) for interface programming with .NET
• · BCS Connector for connecting SharePoint lists with SAP objects or tables.

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 Datasources are used to transfer data from one SAP BW / BI system to another one.

With the DeltaQ component you can extract those Datasources to any third-party destination system supported by the Theobald Software products, even if you don't have an SAP BW / BI system.

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 cell).
SAP officially states: "In general the MDX interface is not suitable for accessing mass data".

In this blog I will show you how to proceed in this case.