Setting up Theobald Xtract Universal

Tip:

See the official Theobald Software documentation for more information on installing and updating Theobald Xtract Universal and customizing the function module for table extraction in SAP.

Theobald Xtract Universal is the SAP certified extraction tool used for data extraction from SAP source systems, integrating with SAP through Remote Function Calls (RFC). Theobald Xtract Universal contains the read-only custom function module Z_THEO_READ_TABLE-transport1 that is to be installed in SAP.

You can use the following link to download the custom module: Z_THEO_READ_TABLE-transport1.zip.

Attention:

The latest version of the Z_THEO_READ_TABLE-transport1.zip file will always be included when you download Xtract Universal.

Follow these steps to set up Theobald Xtract Universal.

1. Download the latest trial version of Theobald Xtract Universal from our website, see Download Trial Version. Install Theobald Xtract Universal on a Windows Server / Virtual Machine.

2. On the server where Theobald Xtract Universal is installed, check if the network access to your SAP system is open, see SAP TCP/IP Ports.

3. Grant SAP user rights to access the SAP instance.

   Important:

   Use the SAP profile for Table. See Authority Objects - SAP User Rights for Table.

   Make sure that the user has Display access for the process-specific tables of the app template that are used for extraction.

4. Add the Z_THEO_READ_TABLE Function Module in SAP using the SAP transport file.

5. Configure Theobald Xtract Universal for the required app template(s). See App Templates. If you encounter any issues, contact UiPath® Customer Support for help.

Note:

Steps 2-4 will require validation from your SAP team.

Setup credentials for the SQL Server database

Uploading data to Process Mining (Automation Suite) requires access to the SQL Server database location to which the extracted data needs to be uploaded. To set up a SQL Server destination connection you need the following setup parameters to authenticate access to the SQL Server database location.

• Server
• Database
• Schema
• Role

See Retrieving the SQL Server database parameters.