About #
This article shows how to execute and schedule all defined extractions in the Xtract Universal Designer.
The implementation of this scenario is realized via the integration of an SSIS-package.
The package uses the onboard SSIS tasks to sequentially call all existing extractions in Xtract Universal.
The execution is implemented via the SQL Server Agent as part of the SSIS-DB.
Requirements #
The following programs and tools are a prerequisite for using the above-mentioned SSIS-package:
- Install SQL Server
- Install SQL Server Management Studio (SSMS)
- Configure SQL Server Agent
- Install Xtract Universal Server
- Download SSIS-package XtractUniversalScheduler.dtsx
Note: The Xtract Universal Server must be installed on the same environment as the SQL-Server / SSIS-DB using the default directory C:\Program Files\XtractUniversal
.
Step-by-Step Guide #
- Import the SSIS-package XtractUniversalScheduler.dtsx into the SSIS-DB using the Microsoft SQL Server Management Studio.
-
Adjust the SSIS parameters to the correct values of the customer installation.
SSIS Parameter Data type Sensitive Required Example Value Info XtractUniversalServer String False True [ServerName.theobald.local] Xtract Universal Server XtractUniversalServerPort String False True 8065 XU-Server Ports - Schedule the deployed SSIS package using the integrated SQL Server Agent execution jobs. For more information, see Microsoft Documentation: Create a SQL-Server Agent Job.
- Execute the created step of the SQL Server Agent.
- Check the correct execution of all defined extractions within the Xtract Universal Designer window.
- Check the results in the extraction destination(s).
About the SSIS Package
The SSIS package contains the following SSIS variables:
SSIS Variables | Data type | Example Value | Expression |
---|---|---|---|
extraction_arguments | String | -s todd.theobald.local -p 8065 -n ExtractionName | "-s " + @[$Package::XtractUniversalServer] + " -p " + @[$Package::XtractUniversalServerPort] + " -n " + REPLACE ( SUBSTRING( @[User::extraction_folder_name], 53, LEN(@[User::extraction_folder_name]) - 52 ) , "\\general.json", "") |
extraction_folder_name | String | C:\Program Files\XtractUniversal\config\ extractions\ExtractionName\general.json | - |