1. Oracle Data Integrator Quick Reference Guide
  2. Create Repositories and Connections for Oracle Data Integrator

2 Create Repositories and Connections for Oracle Data Integrator

Learn about master and work repositories in Oracle Data Integrator (ODI) and how to create them. Also learn about ODI connections and how to create them using the repositories.

Topics

How to Create Master and Work Repositories

Follow the steps to create a master and one or more work repositories for Oracle Data Integrator.

  1. Use the Repository Creation Utility to create the repositories. The executable is in the oracle_common/bin directory in the Fusion Middleware home; launch it.
  2. The first screen is just a welcome screen. Click Next.
  3. Accept the default values and click Next.
  4. Specify the database connection details. Once entered, you can see a dialog box showing the progress of the three checks carried out on the database, making sure it is suitable.
  5. Select the repository components to install. Some are selected by default. Make sure you select the Master and Work repository option. Click Next.

    You can now see a dialog box showing the progress of the checks carried out on the prerequisites for the components you selected.

  6. If all the prerequisite checks pass, then enter the password for the schema users for the repositories. It's easiest to use the same passwords for all schemas, however, make sure you choose the option that conforms to your company security policy. Click Next.
  7. Enter the password for the Supervisor user, what type the work repository is, its name and the password for its user. Also specify the encryption algorithm. Click Next.
  8. Map the tablespaces. This is where you specify the name of the schema owners, and the default and temporary tablespace names for each component. You can accept the default names, or choose to specify your own. Click Next.
  9. The penultimate screen summarizes your selections, and from here, you create the repositories. Click Create. Note that it takes several minutes to create all the repositories.
  10. Click Close after you have reviewed the summary of the repositories just created. .

Once you have created a master repository and at least one work repository, you then create a connection, log in to ODI, and connect to these repositories: Create a Connection

The OBE, Oracle Data Integrator 12c - Creating and Connecting to ODI Master and Work Repositories, gives detailed steps of how to create your master and work repositories.

Create a Connection

Follow the steps to create a connection to Master and Work repositories in Oracle Data Integrator.

Once you have a master repository and a work repository, you can create a connection in Oracle Data Integrator (ODI).

  1. Start ODI Studio, and click Connect to Repository.
  2. Enter Wallet Password if you are using the wallet. Enter the wallet password. Click OK.
  3. Click New in the Oracle Data Integrator Login window.

    The Repository Connection Information dialog displays.

  4. Enter a name for the Login.
  5. Enter Supervisor as the user, and the password for it. (Note, it's what you entered when creating the repositories).
  6. Enter the database connection details for the master repository.
  7. Select work repository and enter the name of the one you just created.
  8. Test the connection, and assuming it is fine, create the connection.
  9. Now you can log into ODI.

See Connecting to the Master Repository in Installing and Configuring Oracle Data Integrator.