Imports scenarios or LoadPlans generated by the odiBuild operation into an ODI execution repository.

This operation supports full deployment projects and package-based projects of type Oracle Data Integrator. If you are using odiDeploy with the package-based model, then each file within the package will sequentially be processed. Multithreading will not apply in this case.

Target Properties

Property Name	Property Code	Required	Description

Property Name	Property Code	Required	Description
ODI Home	`FDODI_ODI_HOME`	Yes	Fully qualified path to the ODI installation directory.
ODI JDBC Driver Path	`FDODI_JDBC_DRIVER_PATH`	Yes	Class path for locating 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.
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).
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).

Inputs

Input Name	Input Code	Required	Description

Input Name

Input Code

Required

Description

Scenario Audit Flag

FDODI_INP_SCENARIO_AUDIT_FLAG

No

When enabled, after importing a scenario FIRST_USER and LAST_USER are updated to FDODI_ODI_USER and LAST_DATE is updated to time of deployment. If false, then FIRST_DATE and LAST_DATE are updated based on scenario file FIRST_DATE and LAST_DATE. FIRST_USER and LAST_USER would be unchanged.

Defaults to false.

Loadplan Audit Flag

FDODI_INP_LOADPLAN_AUDIT_FLAG

No

When enabled, after importing a Loadplan FIRST_USER and LAST_USER are updated to FDODI_ODI_USER and LAST_DATE is updated to time of deployment. If false, then FIRST_DATE and LAST_DATE are updated based on LoadPlan file FIRST_DATE and LAST_DATE. FIRST_USER and LAST_USER would be unchanged.

Defaults to false.

Artifacts

This operation consumes the artifacts produced from the odiBuild operation of this plugin, which consists of one or more XML files representing exported ODI scenarios or LoadPlans.

Endpoint Selection

This operation will select all available endpoints associated to the Target.

Endpoint Execution

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

Special Considerations

This deploy operation implements change detection by avoiding importing scenarios /LoadPlans which have not been modified, therefore providing increased throughput for builds containing a large number of scenarios/LoadPlan. This is accomplished by comparing the update date of source XML scenarios against the target repository and taking care to preserve the update dates from the source repository.

Note that a deployment request marked Force Deploy will deploy all scenarios/LoadPlans contained in the build independent of whether they match what is in the target repository.

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