Follow

ODX SAP Tables Data Source Guide

Before we start

Requirements

https://help.theobald-software.com/en/xtract-is/requirements-and-installation/requirements
Theobald Xtract IS is sold and licensed separate from Discovery Hub which means a full license or a trial license is required to use the Data Source.
Prerequisites

Download the product Xtract IS from Theobald Software website and run the normal setup according to this guide: https://help.theobald-software.com/en/xtract-is/requirements-and-installation/installation
If the ODX storage destination is an Azure Data Lake the ‘Azure feature pack for integration services’ is also required. Download available here: https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-2017 NB: Select version according to the SSIS server instance. The SAP Table Data Source is only compatible with ODX storage Azure Data Lake gen1 and SQL server.

Add ODX SAP Table Data Source

You don’t have to do this step, you can skip directly to the next step, but for completion sake here is how you add the data source manually.

In the ODX pane right click on data sources and select ‘Manage Data Source Providers…’.

mceclip4.png

Press the Add… button to get a list of available data sources.

mceclip5.png

Find and select ‘TimeXtender SAPTable Data Source’ and press OK

mceclip6.png

Setup the SAP Table Data Source

In the ODX pane right click on data sources and select ‘Add Data Source…’.

mceclip2.png

Specify a name for the data source and press Next.

Search for sap in the search field, select ‘Timextender SAPTable Data Source’ and press Next.

mceclip3.png

Specify connection info and press next (example below)

mceclip8.png

Notable fields:

  • LegacyStorageMode is sometimes necessary for it to work.
  • SSISVersion is important as it looks at the edition you have on your server
  • CustomFunction and UseDataCompression has to do with data compression. It lets you use less storage space for the same amount of data, reduces cache memory consumption and improves performance because of lower I/O demands.

Select tables

For the ‘SAP Table Data Source’ using option ‘All tables’ will only fetch the first 5000 tables. That is a limitation implemented due to a typical SAP system is containing more than 100.000 tables which is too much to handle, performance wise, at once. We recommend when working with the SAP data source that you choose the option “let me select the tables” and press next.

mceclip10.png

Make a selection rule:
Select the ‘Include all tables’ rule and press remove.
In this example I add a rule ‘Include if table equal ‘MAKT’’ by selecting Equal, typing MAKT and finally pressing ‘Include matches’.
Make multiple rules for the tables to include.

mceclip12.png

Synchronization/Execution

Synchronize the SAP data source and add a task for execution like with any other data source. After the execution the included tables will be present in the ODX storage ready to include in a DH project.

Limits to the SAP provider

It is not possible to use Manage Query Tables, the Query Tool, you cant preview a Filter Rows rule and it is not possible to make an exclude rule in the column select menu.

 

 

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.