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:
Step 3 - Specify the Password of the ODI Work Repository to attach
Step 4 - Specify the name of the ODI Work Repository to attach
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.
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:
|
Click Test Connection to verify that the connection is working.
Click Finish to create a new work repository and close the wizard.
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.
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.
"Creating a Work Repository" in the "Administering Repositories" chapter in Oracle Fusion Middleware Administering Oracle Data Integrator