Showing posts with label ODI Topology Navigator. Show all posts
Showing posts with label ODI Topology Navigator. Show all posts

Tuesday, 29 October 2013

Oracle Data Integrator 11g - Erasing a Work Repository

Oracle Data Integrator 11g - Erasing a Work Repository

Deleting a work repository is equivalent to detaching a work repository from the master repository. 

Erasing a work repository consists of deleting the work repository from the database.

WARNING:

Erasing your work repository is an irreversible operation. All information stored in the work repository will be definitively deleted, including the metadata of your models, projects and run-time information such as scenarios, schedules, and logs.

Erasing a Work Repository

To erase a work repository from the database:

1. In the Topology Navigator, go to the Repositories panel.

2. Expand the Work Repositories node and right-click the work repository you want to delete.

3. Select Erase from Database.

4. In the Confirmation dialogue click Yes, if you want to definitively erase the work repository from the database.

5. The work repository is erased from the database and is deleted from the Repositories panel in Topology Navigator.

Related:

Attaching a work repository to a master repository

Deleting a work repository

Renumber a work repository

Renumber a master repository

Oracle Data Integrator 11g - Deleting a work repository

Oracle Data Integrator 11g - Deleting a work repository

Deleting a work repository deletes its link to the master repository. This is an opposite operation to attaching (Read Attaching a work repository to a master repository).

This operation does not destroy the work repository content.

Deleting a Work Repository

To delete the link to the master repository:

1. In the Topology Navigator, go to the Repositories panel.

2. Expand the Work Repositories node and right-click the work repository you want to delete.

3. Select Delete.

4. In the Confirmation dialog click Yes.

5. The work repository is detached from the master repository and is deleted from the Repositories panel in Topology Navigator.

Related 

Attaching a work repository to a master repository

Erasing a work repository

Renumber a work repository

Renumber a master repository

Oracle Data Integrator 11g - Attaching a Work Repository to a Master Repository

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