7.38 Work Repository Editor

Use to configure work repositories.

The Work Repository is a data structure containing information about data models, projects, and their operation. This repository is stored on a relational database accessible in client/server mode from the different Oracle Data Integrator Navigators. Several work repositories can, if necessary, be declared with several master repositories. However, a work repository can be linked with only one master repository for version management purposes.

A work repository contains several functional domains:

  • Execution: This domain is compulsory, it allows launching and monitoring of job operations executed locally or by an agent. This domain is generally accessed through the Operator Navigator. An execution repository contains only this domain.

  • Project/Model: This domain is optional and it allows management of data models and projects (mappings, procedures, and so forth). This domain is generally accessed through the Designer Navigator. A development repository contains this domain as well as the execution domain.

The Work Repository Editor has the following tabs:

7.38.1 Definition

Properties Description
ID ID code for the work repository.

Important note: You must assign a unique ID code (across the whole information system) for each work repository when it is created. This unique ID code allows:

  • Work repositories to be referenced on several master repositories without conflict.

  • Objects in this repository to be referenced on the master repository for version management (by a company domain).

  • Objects to be transferred between work repositories without conflict. Since the unique ID code for the work repository enters the composition of the ID codes of these objects, this ensures their uniqueness among repositories.

For greater security, we recommend creating all work repositories from the same master repository.

Type Type of work repository. The possible types are Execution or Development.
Name Name of the work repository.
Password Work repository password. You can modify the password by clicking Change Password.
External ID Unique ID code of the repository.

"Changing a Work Repository Password" in the "Administering Repositories" chapter in Oracle Fusion Middleware Administering Oracle Data Integrator