Before we start
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.
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.
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…’.
Press the Add… button to get a list of available data sources.
Find and select ‘TimeXtender SAPTable Data Source’ and press OK
Setup the SAP Table Data Source
In the ODX pane right click on data sources and select ‘Add Data Source…’.
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.
Specify connection info and press next (example below)
- 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.
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.
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.
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.