Creating the Master Repository

1. Open ODI Studio:
• Launch ODI Studio.
• Go to File > New to open the New Gallery dialog.
2. Select Master Repository Creation Wizard:
• In the Categories tree, select ODI.
• From the Items list, choose Master Repository Creation Wizard.
• Click OK to proceed.
3. Specify Database Connection Parameters:
• Technology: Select the technology that will host the master repository (default is Oracle).
• JDBC Driver: Choose the driver used to access the database hosting the repository.
• JDBC URL: Enter the URL for establishing the JDBC connection to the database.
• Note: JDBC Driver and JDBC URL are synchronized and default values depend on the selected technology.
• User: Enter the user ID/login of the owner of the repository tables (e.g., odim).
• Password: Enter the password for the repository user.
• DBA User: Enter the database administrator’s username.
• DBA Password: Enter the password for the DBA user.
4. Test Database Connection:
• Click Test Connection to check if the connection to the master repository database is successful.
• An Information dialog will appear indicating whether the connection was successful.
• If the connection fails, fix the issues before proceeding to the next step.
5. Select Authentication Method:
• Use ODI Authentication: Choose to manage users using ODI’s internal security system. You will need to provide the following:
• Supervisor User: Enter SUPERVISOR.
• Supervisor Password: Enter the password for the supervisor.
• Confirm Password: Re-enter the supervisor’s password.
• Use External Authentication: Choose this option to use an external identity store (e.g., Oracle Internet Directory) for managing user authentication. Provide the supervisor’s login information:
• Supervisor User: Enter the supervisor username.
• Supervisor Password: Enter the supervisor password.
• Note: To use external authentication, ODI Studio must be configured for it.
6. Specify Password Storage Details:
• Internal Password Storage: Choose this option if you want to store passwords in the Oracle Data Integrator master repository.
• External Password Storage: Choose this option if you want to use the JPS Credential Store Framework (CSF) to store data server and context passwords remotely in a credential store. Provide MBean Server Parameters to access the credential store.
7. Finish Repository Creation:
• After reviewing your entries, click Finish in the Master Repository Creation Wizard to validate the configuration and create the repository.