Connecting to a Work Repository FAQS

1. What is a work repository in ODI?

A work repository is a database repository that stores the metadata related to ODI's operations, such as mappings, scenarios, and integration processes. It is different from the master repository, which holds metadata about users, security, and configuration settings.

2. How do I create a new work repository in ODI?

A new work repository can be created during the ODI repository creation process by selecting the option to create a work repository. You’ll need to provide the database connection details and specify a name for the repository.

3. What is the difference between a master repository and a work repository?

• Master Repository: Holds global metadata like user information, ODI configuration, and repository connections.
• Work Repository: Stores project-related metadata such as mappings, transformations, and other project-specific data.

4. Why can't I connect to the work repository?

There may be several reasons you are unable to connect:

• Incorrect login credentials (user or password).
• Incorrect database connection details (driver, URL, etc.).
• The master repository may not be accessible.
• Network issues or firewall restrictions blocking access.

5. How do I test the connection to the work repository?

You can test the connection by clicking the Test button in the "Repository Connection Information" dialog box in ODI Studio. This will attempt to establish a connection using the details you’ve entered, providing feedback on whether it is successful.

6. What should I do if I forget my ODI supervisor password?

If you've forgotten the ODI supervisor password, you may need to reset it via the Security Navigator or database level (if direct access to the master repository is available). You may also need to create a new user if that is not feasible.

7. Can I connect to multiple work repositories at the same time?

Yes, you can connect to multiple work repositories, but only one work repository can be active at a time within ODI Studio.

8. What is the "Driver List" in the database connection settings?

The "Driver List" lets you select the database driver that corresponds to the type of database (e.g., Oracle, MySQL, SQL Server) used to host the ODI master repository. You must ensure the correct driver is selected to establish a successful connection.

9. What is the ODI supervisor user?

The ODI supervisor user is a special user account created when setting up the master repository. This user has full administrative privileges and can perform all actions in ODI, such as managing repositories and users.

10. Can I edit the connection details after setting up the work repository?

Yes, you can modify the connection details later by opening the "Repository Connection Information" dialog in ODI Studio and updating the necessary fields.

11. How do I add a new work repository to an existing master repository?

If you need to add a new work repository, you can do so by navigating to the ODI Studio "New Gallery" and selecting the option to create a new ODI repository login. From there, follow the prompts to specify the details of the new work repository.

12. How can I see a list of available work repositories in my master repository?

You can click on the button next to the Work Repository Name field in the "Repository Connection Information" dialog to view and select from the available work repositories.

13. Can I connect to a work repository if the master repository is not accessible?

No, you must be able to connect to the master repository in order to access the work repository since the master repository holds the necessary metadata and credentials.