Creating a Work Repository

1. Open the Topology Navigator:
• In ODI Studio, open the Topology Navigator and locate the Repositories panel.
2. Right-click on Work Repositories:
• Right-click the Work Repositories node in the panel.
• Select New Work Repository from the context menu.
3. Open the Work Repository Creation Wizard:
• The Work Repository Creation Wizard will open, prompting you to enter the necessary connection details.
4. Specify Work Repository Connection Details:
• Technology: Choose the technology for the server that will host the work repository. (Default is Oracle).
• JDBC Driver: Select the driver used to access the database technology hosting the repository.
• JDBC URL: Enter the full path of the data server where the work repository will be hosted.
• Note: Use the full machine name instead of localhost in the JDBC URL to avoid connection issues, especially for remote clients.
• User: Enter the user ID/login of the owner of the tables to be created for the work repository.
• Ensure the username is in uppercase to comply with the Upgrade Assistant and avoid upgrade issues.
• Password: Enter the password for the user specified above.
5. Test the Connection:
• Click Test Connection to verify that the connection details are correct and that a successful connection to the work repository can be established.
6. Proceed to Next Step:
• If the connection is successful, click Next.
• Oracle Data Integrator will check if a work repository already exists for the specified connection:
• If an existing work repository is found, the wizard will guide you on how to attach it to the master repository.
• If no existing work repository is found, the wizard will proceed to create a new one.
7. Specify Work Repository Properties:
• Name: Provide a unique name for the work repository (e.g., DEVWORKREP1).
• Password: Optionally, enter a password for attaching the work repository to a different master repository (leave blank if no password is required).
• Type: Choose the type of the work repository:
• Development: This type includes both design-time objects (data models, mappings, procedures) and runtime objects (scenarios, sessions). Suitable for development environments.
• Execution: This type only includes runtime objects (scenarios, schedules, sessions). Suitable for production environments and can only be used in Operator Navigator for job monitoring and execution. Designer Navigator is not available for this type.
8. Finish the Work Repository Creation:
• Click Finish to complete the process.
• The Create Work Repository Login dialog will appear.
9. Create a Work Repository Login (Optional):
• If you want to create a login for the work repository, click Yes. A new dialog will ask you to enter the login name.
• If you do not want to create a login, click No.
10. Save the Work Repository: