Exports scenarios identified by configurable build criteria from an ODI development repository.
Fully qualified path to the ODI installation directory which contains the odi folder.
|ODI JDBC Driver Path|
Classpath for locating the JDBC Driver.
This is the complete path to the jar file which contains the JDBC driver.
|ODI JDBC URL|
JDBC Connect String for the ODI Master/Work repositories.
|ODI JDBC Driver|
JDBC Driver to use for connecting to the ODI Master/Work repositories. (e.g. oracle.jdbc.driver.OracleDriver)
|ODI Master User|
Database schema owner of the ODI Master repository.
|ODI Master Password|
Database password for ODI Master User.
User to connect to ODI instance with (must have
Password for ODI User.
|ODI Work Repository|
The name of the target ODI work repository.
|ODI Thread Count|
Thread pool size used for exporting and importing scenarios (default is 5, max is 20).
|ODI Marker Group Code|
The code of the ODI Marker Group used for selecting scenarios within a build (default is
|ODI Project Code|
The code of the target ODI project.
|ODI Marker Code|
The code of the Marker within the defined Marker Group for this build.
|ODI Include Pattern|
Regular expression which identifies scenario name patterns to include in the build (e.g. .*_Order.*).
|ODI Exclude Pattern|
Regular expression which identifies scenario name patterns to exclude from the build (e.g. .*_Old.*).
List of scenario version numbers (comma-separated) to include in the build.
This operation produces artifacts that will be stored in the artifacts repository. The artifacts consist of one XML file per scenario that was exported during the build operation.
This operation will select all available endpoints associated to the environment/instance.
This operation will randomly execute on one of the endpoints identified during selection.
In addition to the required ODI project code (
FDODI_PROJECT_CODE) there are several options to further filter the scenarios that are included in the build:
- ODI Markers – Folders or objects (interfaces, mappings, packages, procedures, and variables) can be identified by tagging them with the ODI Marker (ODI Marker Code) within the ODI Marker Group (ODI Marker Group Code). Marking a folder will result in all scenarios within that folder being included in the build. See Oracle Data Integrator documentation for instructions on creating and using Markers and Marker Groups.
- Include/Exclude Patterns – Java regular expressions can be used within the ODI Include Pattern and ODI Exclude Pattern to identify which scenarios should be included or excluded in the build. In both cases the expressions are matched against the scenario name (not the owning object's name).
- Scenario Version – You have the option to identify the specify version numbers of the scenarios to include in the build by using the
FDODI_VERSIONproperty. Multiple version numbers can be specified by comma separating them. If no versions are specified, all versions of selected scenarios will be included. Specify -1 to only export the latest version.
If scenarios identified during build are linked to scenario folders, those folders are automatically exported (without children) and stored as part of the build artifacts. During deployment, any scenario folders in the build artifacts are imported (insert only) into the target folder. In order for scenarios to be linked correctly in the target repository, any existing scenario folders in the target must have the same global id as the the same folder on the source. If the folder was created manually on the target, but with the same name as the source, the deployment will not create the scenario folder and the scenario will be imported without being linked. This feature is only available for ODI 12.2+.