Creating a Work Repository FAQS

1. What is a Work Repository in Oracle Data Integrator?

• A Work Repository is where Oracle Data Integrator stores runtime objects like scenarios, sessions, and schedules. It can also store design-time objects like data models, projects, and mappings, depending on the type (Development or Execution).

2. Can a Work Repository be associated with more than one Master Repository?

• No, a work repository can only be associated with one master repository. However, a master repository can have multiple work repositories associated with it.

3. What is the difference between a Development and Execution Work Repository?

• Development Work Repository: Contains both design-time (e.g., data models, projects, mappings) and runtime objects (e.g., scenarios, sessions). Suitable for development environments.
• Execution Work Repository: Contains only runtime objects (e.g., scenarios, schedules, sessions) and is used for job monitoring and execution in Operator Navigator. It does not store design-time artifacts and is suited for production environments.

4. How do I specify the connection details for the Work Repository?

• In the Work Repository Creation Wizard, you'll need to specify:
• Technology (e.g., Oracle)
• JDBC Driver and JDBC URL (connection details to the database)
• User ID/Password for the repository owner (ensure the username is in uppercase)

5. Why is it recommended to use the full machine name in the JDBC URL?

• Oracle recommends using the full machine name (not localhost) in the JDBC URL to avoid connection issues, especially for remote clients where the client machine (ODI Studio or SDK) is different from the machine hosting the repository.

6. What happens if the Work Repository already exists?

• If an existing work repository is found on the connection, the wizard will guide you on how to attach the work repository to the master repository. You will then specify the password for attaching the repository (if required).

7. What is the purpose of the Work Repository Password?

• The password is used if you need to attach the work repository to a different master repository. If no password is set, no authentication will be required for attaching the repository.

8. Do I need to create a login for the Work Repository?

• Creating a login for the work repository is optional. You can choose whether to create a login during the repository creation process. If you choose to create one, you’ll be prompted to enter a Login Name.

9. Can I change the type of the Work Repository after it is created?

• No, the type (Development or Execution) of the work repository must be set during creation and cannot be changed afterward.

10. How do I test the connection to the Work Repository during setup?

• Before proceeding to the next step, click the Test Connection button in the wizard. This will verify if the connection details are correct and that ODI can connect to the work repository database.

11. What should I do if the connection to the Work Repository fails?

• If the connection fails, review the JDBC connection details (user credentials, database URL, driver settings) and fix any issues before continuing with the repository creation process.