Configuring the extraction script

Follow these steps to configure the extraction script.

1. Go to the App Templates page and open the documentation page for your app template.

2. Locate the section Loading data using Theobald Xtract Universal and download the extract_theobald_as.zip file for your app template. This extract_theobald_as.zip file contains the extract_theobald.ps1 script and the config.json file.

3. Unzip the content of the extract_theobald_as.zip file on the server where Theobald Xtract Universal is installed.

4. Configure the variables for the script in the config.json as listed below.

Variable	Description
xu_location	The Xtract Universal installation folder. This is the folder where you can find the xu.exe. For example: C:\\MyFolder.
xu_server	Address of the server where Xtract Universal is installed. The default is localhost.
xu_port	Port of the server where Xtract Universal is installed. The default port of an installation is 8065.
end_of_upload_api	The API that is called to start data processing in Process Mining, once all data has been uploaded. See Retrieving the SQL Server database parameters .
extraction_start_date	Start date to be used to limit extractions. Only tables where a date filter is applied are filtered on this date. Format is YYYYMMDD. The default is no limitation indicated by the start date 19700101. Note: extraction_start_date must have a value.
extraction_end_date	End date to be used to limit extractions. Only tables where a date filter is applied are filtered on this date. Format is YYYYMMDD. The default is no limitation indicated by the end date 20991231. Note: extraction_end_date must have a value.
language	The language in which data is extracted from the source system. The default is E.
exchange_rate_type	The exchange rate type that is used for currency conversion. The default is M.