7.5 Create ODI Work Repository Wizard

Use to create a new work repository.

Several work repositories can be designated with several master repositories, if necessary. However, a work repository can be linked with only one master repository for version management purposes.

Note: If an existing work repository is detected on this connection, you will be asked if you want to attach the work repository to the master repository or if you prefer to recreate the work repository.

How?

The Create Work Repository Wizard has the following steps:

7.5.1 Step 1 - Specify ODI Work Repository Connection Properties

Use to specify the Oracle Data Integrator work repository connection details.

Property Description
Technology Select the technology of the server to host your work repository. The default value is Oracle.
JDBC Driver Driver used to access the technology, that hosts the repository.
JDBC Url Path of the data server to host the work repository.

Note: The JDBC Driver and URL parameters are synchronized and the default values are technology dependent.
User User ID or login of the owner of the tables you are going to create and host of the work repository.
Note: The user name should be in uppercase to ensure compliance with the Upgrade Assistant and avoid issues when upgrading the repository.
Password Password of the user. This password is requested for attaching this work repository to a different master.

Click Test Connection to verify that the connection is working.

Click Next to move to the next step of the Create Work Repository Wizard.

Oracle Data Integrator verifies whether a work repository already exists on the specified connection.

If a work repository already exists on the specified schema a confirmation message opens.

7.5.2 Step 2 - Specify ODI Work Repository Properties

Use to specify the ODI work repository properties.

If no work repository is found, a new work repository will be created.

Property Description
Name Give a unique name to your work repository (for example: DEVWORKREP1).
Password Enter the password for the work repository.
Type Select the type for the work repository:

  • Development: This type of repository allows management of design-time objects such as data models and projects (including mappings, procedures, and so forth.). A development repository also includes the run-time objects (scenarios and sessions). This type of repository is suitable for development environments.

  • Execution: This type of repository only includes run-time objects (scenarios, schedules, and sessions). It allows starting and monitoring of data integration jobs in Operator Navigator. Such a repository cannot contain any design-time artifacts and the Designer Navigator cannot be used with it.

Click Test Connection to verify that the connection is working.

Click Finish to create a new work repository and close the wizard.

7.5.3 Step 3 - Specify the Password of the ODI Work Repository to attach

Use to specify the password of the ODI work repository to attach.

When an existing work repository has been detected on this connection, the next steps consist in attaching the work repository to the master repository.

In the Password field, enter the password of the Oracle Data Integrator work repository to attach.

Click Next to move to the next step of the Create Work Repository Wizard.

7.5.4 Step 4 - Specify the name of the ODI Work Repository to attach

Use to specify the name of the ODI work repository to attach.

Property Description
Name Enter a unique name for your work repository (for example: DEVWORKREP1).

Click Finish to create a new work repository and close the wizard.

Related Topics

"Creating a Work Repository" in the "Administering Repositories" chapter in Oracle Fusion Middleware Administering Oracle Data Integrator