Oracle Data Integrator 11g - Attaching a Work Repository to a Master Repository
Attaching a work repository consists of linking an existing work repository to the current master repository.
This existing work repository already exists in the database and has been previously detached from this or another master repository.
Below are the steps to attach a work repository to master repository.
1. In the Topology Navigator, go to the Repositories panel.
2. Right-click the Work Repositories node and select New Work Repository. The Create Work Repository Wizard opens.
3. Specify the Oracle Data Integrator work repository connection details as follows:
Technology: From the list, select the technology that will 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.
4. Click Test Connection to check the connection is working and then click Next.
5. Specify the Password of the Oracle Data Integrator work repository to attach and then click Next.
6. Specify the Name of the Oracle Data Integrator work repository to attach and then click Finish.
Related:
Deleting a work repository
Erasing a work repository
Renumber a work repository
Renumber a master repository
Attaching a work repository consists of linking an existing work repository to the current master repository.
This existing work repository already exists in the database and has been previously detached from this or another master repository.
Below are the steps to attach a work repository to master repository.
1. In the Topology Navigator, go to the Repositories panel.
2. Right-click the Work Repositories node and select New Work Repository. The Create Work Repository Wizard opens.
3. Specify the Oracle Data Integrator work repository connection details as follows:
Technology: From the list, select the technology that will 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.
4. Click Test Connection to check the connection is working and then click Next.
5. Specify the Password of the Oracle Data Integrator work repository to attach and then click Next.
6. Specify the Name of the Oracle Data Integrator work repository to attach and then click Finish.
Related:
Deleting a work repository
Erasing a work repository
Renumber a work repository
Renumber a master repository
No comments:
Post a Comment