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.

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


Step 1: Create an Extraction. Go to General Settings and set Output to XML:
SAP Extraction
Step 2: Click on Run and copy the URL:
Extraction URL
Step 3: In Access click on XML File and follow those steps:
Access XML File

Step 4: Paste the URL in the field File Name. Click on OK.
Extraction URL

Step 5: Select the Table. Click on OK.

Step 6: Click on Close.

Step 7: Now you have the SAP-data in an Access Table.

You can also load the SAP-data alternatively to Excel via “Data -> From Other Sources -> From XML Data Import”.
To load SAP-data directly to PowerPivot refer to our Product Xtract PPV.

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.