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.

How to load SAP-data with Xtract Universal to Microsoft Access (and Excel)

Xtract Universal is since 2011 the newest member of the Xtract product line. Eight different SAP extraction types allow the BI architect to create an optimal, stable and fast data layer between SAP and different consumer applications.

Xtract Universal essentially consists of two components: a server component and a designer (client). The server component is responsible for the actual extraction. The consumer application communicates with the Server component, and these in turn with SAP. You use the Xtract designer for the design and configuration of the extractions.

Fore more information refer to the products page: http://www.theobald-software.com/en/products.htm
or to the help page: http://help.theobald-software.com

In this blog, I will show you how to load SAP-data with Xtract Universal to Microsoft Access.

How to extract a BEx Query and a BW Hierarchy with SSIS / Xtract IS from SAP BW and build them in SSAS

In this blog I will use Xtract IS to extract a BEx query and a BW hierarchy from an SAP BW system and load them into SQL Server. Then I will show how to build a cube in SSAS upon the BEx query and the BW hierarchy.

How to load a BW Hierarchy into QlikView using Xtract QV

In this blog I will use Xtract QV to extract a BW hierarchy from an SAP BW system and load it into QlikView.

SAP BW hierarchies are modeled as parent-child hierarchies. I will show how to convert it to a naturalized Hierarchy to use in QlikView.

How to load a BW Hierarchy into PowerPivot using Xtract PPV

In this blog I will use Xtract PPV to extract a BW hierarchy and a BEx query from an SAP BW system and load them into PowerPivot. Then I will show how to build the relation between the Hierarchy and the BEx query in PowerPivot.