Creating a 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.

To create a new work repository: First create the schema for work repository
I am using sql developer to create schemas

www.odiguru.com

In the Topology Navigator, go to the Repositories panel.

Right-click the Work Repositories node and select New Work Repository.

www.odiguru.com

The Create Work Repository Wizard opens.

Specify the Oracle Data Integrator work repository connection details as follows:

Technology: Choose the technology of the server to host your work repository. Default is Oracle.

JDBC Driver: The driver used to access the technology, that will host the repository.

JDBC URL: The complete path of the data server to host the work repository.

Note that the parameters JDBC Driver and URL are synchronized and the default values are technology dependant

User: User ID / login of the owner of the tables you are going to create and host of the work repository.

Password: This user's password. This password is requested for attaching this work repository to a different master.

www.odiguru.com

Specify the Oracle Data Integrator work repository properties:

ID: A specific ID for the new repository, rather than the default 0.




Note: It is strongly recommended that this ID is unique and not used for any other work repository, as it affects imports and exports between repositories


Click Test Connection to verify that the connection is working.

Click Next.

www.odiguru.com

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 interfaces, procedures, etc). A development repository includes also 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 launching and monitoring of data integration jobs in Operator Navigator. Such a repository cannot contain any design-time artifacts. Designer Navigator cannot be used with it. An execution repository is suitable for production environments.

Click Finish.

www.odiguru.com

The Create Work Repository login dialog opens. If you want to create a login for the work repository, click Yes and you will be asked to enter the Login Name in a new dialog. If you do not want to create a work repository login, click No.

Click Save in the toolbar.

www.odiguru.com

www.odiguru.com