odiBuild

Exports scenarios identified by configurable build criteria from an ODI development repository.

  

Environment/Instance Properties

Property Name

Property Code

Required

Description

ODI Home

FDODI_ODI_HOME

Yes

Fully qualified path to the ODI installation directory which contains the odi folder.

ODI JDBC Driver Path

FDODI_JDBC_DRIVER_PATH

Yes

Classpath for locating the JDBC Driver.

This is the complete path to the jar file which contains the JDBC driver.

ODI JDBC URL

FDODI_JDBC_URL

Yes

JDBC Connect String for the ODI Master/Work repositories.

ODI JDBC Driver

FDODI_JDBC_DRIVER

Yes

JDBC Driver to use for connecting to the ODI Master/Work repositories. (e.g. oracle.jdbc.OracleDriver)

ODI Master User

FDODI_MASTER_USER

Yes

Database schema owner of the ODI Master repository.

ODI Master Password

FDODI_MASTER_PASSWORD

Yes

Database password for ODI Master User.

ODI User

FDODI_ODI_USER

Yes

User to connect to ODI instance with (must have SUPERVISOR privileges). (e.g. SUPERVISOR)

ODI Password

FDODI_ODI_PASSWORD

Yes

Password for ODI User.

ODI Work Repository

FDODI_WORK_REPOSITORY

Yes

The name of the target ODI work repository.

ODI Thread Count

FDODI_THREAD_COUNT

Yes

Thread pool size used for exporting and importing scenarios (default is 5, max is 20).

ODI Marker Group Code

FDODI_MARKER_GROUP_CODE

No

The code of the ODI Marker Group used for selecting scenarios within a build (default is FLEXDEPLOY).

  

Project Properties

Property Name

Property Code

Required

Description

ODI Project Code

FDODI_PROJECT_CODE

Yes

The code of the target ODI project.

ODI Marker Code

FDODI_MARKER_CODE

No

The code of the Marker within the defined Marker Group for this build.

ODI Include Pattern

FDODI_INCLUDE_PATTERN

No

Regular expression which identifies scenario name patterns to include in the build (e.g. .*_Order.*).

ODI Exclude Pattern

FDODI_EXCLUDE_PATTERN

No

Regular expression which identifies scenario name patterns to exclude from the build (e.g. .*_Old.*).

ODI Versions

FDODI_VERSIONS

No

List of scenario version numbers (comma-separated) to include in the build.

  

Inputs

Input Name

Input Code

Required

Description





  

Outputs

Output Name

Required

Description




  

Artifacts

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.

  

Endpoint Selection

This operation will select all available endpoints associated to the environment/instance.

  

Endpoint Execution

This operation will randomly execute on one of the endpoints identified during selection.

  

Special Considerations

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_VERSION property. 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+.