Use to create the Oracle Data Integrator Master Repository.
How?
The Master Repository Creation Wizard has the following steps:
Use to enter the database connection and the repository configuration details.
| Properties | Description |
|---|---|
| Technology | Technology type of the master repository database. |
| JDBC Driver | Driver used to access the technology that hosts the repository. |
| JDBC URL | The complete path for the data server that hosts the repository. |
| Registry Database Name | Existing database name used to create registry information. This field only appears when you select MySQL. |
| User | The user ID/login of the owner of the tables. Note: The user name should be in uppercase to ensure compliance with the Upgrade Assistant and avoid issues when upgrading the repository. |
| Password | The user's password. |
| DBA User | The database administrator's username. |
| DBA Password | The user's password. |
Click Test Connection to test the connection to your Master Repository.
Click Next to move to the next step of the Master Repository Creation Wizard.
Use to select the authentication mode that the Master Repository uses.
Do one of the following:
Select Use ODI Authentication to manage users using ODI's internal security system and enter the following supervisor login information:
| Properties | Description |
|---|---|
| Supervisor User | User name of the ODI supervisor. |
| Supervisor Password | Password of the supervisor. ODI is installed with a built-in password policy that prevents passwords shorter than 6 characters to be used. |
| Confirm Password | Password of the supervisor. |
Select Use External Authentication to use an external enterprise identity store, such as Oracle Internet Directory, to manage user authentication and enter the following supervisor login information:
| Properties | Description |
|---|---|
| Add principals to Role | Allows the selection of Oracle Platform Security Services (OPSS) principals who have supervisor privileges in ODI master repository. The OPSS principals can be enterprise roles, enterprise users, or both. |
Click Next to move to the next step of the Master Repository Creation Wizard.
Use to select the password storage mode. Do one of the following:
Select Internal Password Storage to store passwords in the Oracle Data Integrator repository.
Select External Password Storage to use JPS Credential Store Framework (CSF) to store the data server and context passwords in a remote credential store. Indicate the MBean Server Parameters to access the credential store.
Enter the following MBean Server Parameters:
| Properties | Description |
|---|---|
| Host | MBeans Server Host, for example: mymachine.oracle.com |
| Port | MBeans Server Port, for example: 7001 |
| User | MBeans Server User Name, for example: weblogic |
| Password | MBeans Server Password, for example: weblogic |
Click Test Connection to test the connection to your MBean Server.
Click Finish to complete the Master Repository Creation Wizard and create the Master Repository.
"Setting Up External Password Storage" in the "Managing Security in Oracle Data Integrator" chapter in Oracle Fusion Middleware Administering Oracle Data Integrator