Oracle by Example brandingODI12c: Administering ODI Master and Work Repositories

section 0Before You Begin

This tutorial walks you through the steps that are needed to import the Oracle Data Integrator (ODI) Master Repository and Work Repository to a target machine, and to delete unwanted repositories.

This tutorial takes approximately 10 minutes to complete.

Background

Repositories are schemas and tables in a database that hold information about ODI Designs, Topologies, and Security. Over time you may develop repositories that would be useful to either move to other machines or clone on other machines. One way to do this is to export the repositories to a zip file. The process of how to do the export is not covered in this OBE, it is assumed that the zip files already exist. The zip file contains XML metadata that can be loaded on a new repository. If the new repository already contains information, you can choose to update or replace "duplicate" rows.

Suppose you have a repository that you need to delete. Perhaps it was created by mistake. Perhaps you just want to start from a clean slate. Before deleting any repositories, make sure that all applications are disconnected from using those schemas and tables.

What Do You Need?

The following is a list of software requirements:

  • A supported operating system
  • Oracle Database
  • Oracle Data Integrator 12c

The following is a list of OPTIONAL software:

  • Oracle WebLogic Server (WLS) 12c (other versions are supported as well)
  • Oracle SQL Developer 12c (included with Database 12c install)

    • If WLS is present, it must be in the same Middleware HOME directories as ODI.

Before starting this tutorial, you should have:

  • Started Oracle Database services and components such as the Listener
  • A Database user with DBA role privileges such as the SYS or SYSTEM account.
  • Installed the HR schema included in the Oracle Database. The Sample Schemas Installation Guide is part of the Oracle Database documentation set, and is also available online at: http://otn.oracle.com.
  • Already created ODI Master and Work Repositories
  • Mapped a plan for passwords. Best practices are MixedCase, at least eight characters in length, and contain a number. Examples: MyPasswd99, Welcome1.

section 1Importing Previous Repositories

To import both a master and/or work repository, copy the zip files to the target machine and perform the following steps:

Importing a Master Repository

  1. On the left panel, click the Topology tab, then click the blue factory pulldown icon on the top right of the tab column. Select Import...
  2. In the Import Selection dialog box, select Import the Master Repository. Click OK to continue.
  3. In the Import a Master Repository dialog box, select Import From a Zip File. Either browse for the file using the magnifying glass, or type the name of the zip file.
  4. Click OK to continue. A progress bar displays. Depending on the XML file size, this can take several minutes to complete.
  5. On the Import Report page, there is nothing to do, just review. Click Close to continue.

Importing a Work Repository

  1. On the left panel, click the Designer tab, then click the red triangle pulldown icon on the top right of the tab column. Select Import...
  2. In the Import Selection dialog box, select Import the Work Repository. Click OK to continue.
  3. In the Import a Work Repository dialog box, select Import From a Zip File. Either browse for the file using the magnifying glass, or type the name of the zip file.
  4. Click OK to continue. A progress bar displays. Depending on the XML file size, this can take several minutes to complete.
  5. On the Import Report page, there is nothing to do, just review. Click Close to continue.

section 2Deleting Repositories with RCU

RCU can be used to remove unwanted schemas from the database based on prefixes. Generally speaking, this is an unrecoverable action. It is recommended to backup any repository data just in case. You can do this either from the database using utilities such as RMAN, or from ODI Studio.

To delete repositories using RCU, perform the following steps:

  1. Navigate to the proper directory and launch RCU. The Welcome page is displayed. Click Next to continue.
  2. On the Create Repository page, select Drop Repository. (The page name on the top banner and left navigation will change from "Create" to "Drop" when you select Drop below. The number of steps will change as well.) Click Next to continue.
  3. On the Database Connection Details page, enter a Host Name such as localhost or an IP address, Database Listener Port such as 1521, Database Service Name such as orcl.example.com (note this is not the instance name), Database User Name such as sys, and the corresponding Password which will not display. The Role will change automatically as you type a Username.
  4. Click Next to continue. A progress bar displays. When the progress bar reaches 100% and all the lines have green checks, click OK to continue.
  5. On the Select Components page, use the with prefix pulldown to select the schemas to drop. Note that the prefixes of the components in the background reflect your choice.
  6. Click Next to continue. A progress bar displays. When the progress bar reaches 100% and all the lines have green checks, click OK to continue.
  7. On the Summary page, there is nothing to do, just review. Click Drop to continue. A progress bar displays. When the progress bar reaches 100% and all the lines have green checks, it will automatically go to the Completion Summary page.
  8. On the Completion Summary page, you have the option to view the various log files. Click Close to continue.

more informationWant to Learn More?

In this tutorial, you should have learned how to:

  • Import previous repository zip files
  • Delete repositories using RCU

Resources

The following are conceptual or procedural Help topics relevant to the topic of this tutorial:

  • Online documentation, viewlets, samples, and OLN URLs on OTN:
    • Current version: here
    • Older versions: here
  • External Web sites for related information:
  • To learn more about Oracle Data Integrator 12c, refer to additional OBEs in the Oracle Learning Library, or on the ODI Studio Start Page.

Credits

  • User Assistance Developer: Minu Nair
  • Other Contributors: Julien Testut