Creating the Master Repository FAQS

1. What is the Master Repository in Oracle Data Integrator?

• The Master Repository is a central data structure that stores metadata, technology definitions, and built-in security profiles. It is created during the setup of ODI and serves as the foundation for other repositories.

2. How do I create a Master Repository?

• You can create the Master Repository using the Master Repository Creation Wizard in ODI Studio. This process involves specifying database connection parameters, selecting authentication methods, and configuring password storage options.

3. What are the required parameters to create the Master Repository?

• The parameters include:
• Technology (e.g., Oracle, SQL Server)
• JDBC Driver and JDBC URL for database connection
• User (repository owner) and DBA User credentials
• Authentication method (ODI or external authentication)
• Password storage options (internal or external)

4. How do I test the connection to the master repository?

• After entering the required database connection parameters, click Test Connection in the wizard. This will verify whether the connection to your master repository database is successful. If the connection fails, resolve the issues before proceeding.

5. What is the difference between ODI Authentication and External Authentication?

• ODI Authentication: This method uses ODI's internal security system to manage user access. It requires entering the SUPERVISOR user credentials.
• External Authentication: This method integrates with external identity management systems, such as Oracle Internet Directory, for user authentication. It requires configuring ODI Studio for external authentication.

6. What is the Supervisor user in ODI Authentication?

• The Supervisor user is a predefined user in ODI that has administrative privileges over the repository. The username is always SUPERVISOR, and you must set a password for this user during the repository creation process.

7. What is the purpose of the "Internal Password Storage" and "External Password Storage" options?

• Internal Password Storage: Stores passwords for data servers directly in the Oracle Data Integrator master repository.
• External Password Storage: Uses an external credential store, such as the JPS Credential Store Framework (CSF), to store and manage passwords remotely.

8. Can I use an external identity store for user authentication?

• Yes, you can choose to use an external identity store (e.g., Oracle Internet Directory) for user authentication, but ODI Studio must be properly configured for external authentication before selecting this option.

9. How do I finish creating the Master Repository?

• After filling out all required information, click Finish in the Master Repository Creation Wizard to validate your entries and complete the creation of the master repository.

10. What happens if the connection to the database fails during the setup?

• If the connection fails, the wizard will notify you, and you will need to fix the connection issue (e.g., check credentials, JDBC URL, or database settings) before proceeding.