17.9 Provision the Oracle Data Transforms for Metadata Repository

The very first screen you will see after you access the Oracle Data Transforms URL is the Administration tab, which provides easy wizards that allow you to either create a new Data Transforms repository or connect to an existing Data Transforms repository to store your transformations.

Follow the below procedure to provision the Oracle Data Transforms metadata repository:

1. On the Administration tab, select one of the following options:
   • Create a new Data Transforms Repository
   • Connect to an existing Data Transforms Repository
2. In the Database Details page, enter the JDBC URL and password to connect to the repository.
3. In the Schema Details page, enter the following:
   • Schema Prefix - Specify the prefix used for the Oracle Data Transforms Schemas to identify them.

     Note:

     A valid prefix should contain only alpha-numeric characters. It should not start with a number and should not contain any special characters. A maximum of 12 characters are allowed.

     For existing repository, the Schema Prefix field is a drop down that lists the schema prefixes available based on the Database Instance you selected in the Database Details page.

   • Schema Password - Specify the password used for accessing the Oracle Data Transforms schema.

     For existing repository, provide the password configured during repository creation. Note that the schema password expires in 180 days from the date when the repository was created. In such cases, provisioning fails when you try to connect to the existing repository. See Reset the Schema User Password for instructions on how to reset the schema password.

4. In the Repository Details page, provide the ODI Supervisor password.

   Note:

   The Supervisor password that you provide should:

   • contain alpha-numeric characters,
   • be 6-12 characters in length,
   • not start with a number,
   • not contain any special characters except $, # and _.
5. Click Save. The final screen of the wizard displays all the processes that run to complete the configuration. This takes about 15 minutes. The screen auto-refreshes to display the status of each process. You can also click the Refresh icon to view the status of the configuration.
6. Click Download Log File to download the configuration logs. The log files are downloaded in a zip file named provlogs.zip.
7. When the configuration completes successfully, the Login to Data Transforms button is activated, which allows you to navigate to the Oracle Data Transforms login page.