Use to set general properties and review executions, scenarios, markers, memos, versions, privileges, and flexfields of a mapping.
The following tabs are available:
This tab defines the general properties of a mapping.
| Properties | Description |
|---|---|
| Name | Name of the mapping as it appears in the Oracle Data Integrator user interface. |
| Description | Detailed description of the mapping. |
A mapping can be executed directly without generating a scenario. Execution is launched by clicking Run... in the menu bar.
The Execution tab is organized into the Direct Executions and Scenario Execution tabs and shows the results of previous executions.
| Properties | Description |
|---|---|
| Agent | Name of the agent that executed the scenario. Internal indicates that the agent used is the one built in the Oracle Data Integrator Studio. |
| Context | Execution context of the scenario. |
| Status | State of the scenario (Done, Error, Running, Waiting, Warning). |
| Start | Start date and time of execution of the scenario. |
| End | End date and time of execution of the scenario. |
| Duration | Time taken for execution of the scenario. |
| Return Code | Return code of the scenario. |
| Message | Scenario execution error message. |
| Rows | Total number of rows processed by the scenario. |
| Inserts | Number of rows inserted during the scenario. |
| Updates | Number of rows updated during the scenario. |
| Deletes | Number of rows deleted during the scenario. |
| Errors | Number of rows in error in the scenario. |
This tab displays in a table view the scenarios generated for this component, as well as their schedules. Double-click a scenario or a schedule to display its properties.
Create and delete scenarios by clicking the Generate Scenario and Delete buttons.
The popup menus for scenarios and schedules are also available from this tab.
| Properties | Description |
|---|---|
| Name | Name of the scenario. |
| Version | Version of the scenario. |
Markers can be defined in a Project (Project Markers) or in the Others navigation tree in Designer Navigator (Global Markers). The project markers can be used only on objects of the project, and global markers can be used in all models of the repository.
A marker can be set on an object and can contain a value that will appear in the tooltip of the marker icon in the tree view.
The Markers tab lists the markers set on this object.
| Properties | Description |
|---|---|
| Group | Name of the marker's group. See Marker Group Editor. |
| Marker | Marker assigned to the object. |
| Value | Marker value specified for the object. |
Use to attach a descriptive memo to a Project or Model element to reflect your project's methodology or to help with development.
Almost all Project and Model elements can have descriptive memos attached to them.
A memo is an unlimited amount of text attached to virtually any object, visible on its Memo tab. When an object has a memo attached, the Memo icon appears next to it in the Projects navigation tree.
Use to view and manage versions of your object.
A version is a backup copy of an object; it is checked in at a given time and may be restored later. Versions are saved in the master repository.
The version management system allows flags on developed objects (such as projects, models, and so forth) to be set automatically to indicate their status (such as new or modified). The version management system also allows these objects to be backed up as stable checkpoints, and later restored from these checkpoints. These checkpoints are created for individual objects in the form of versions.
Creation and Update Information
| Properties | Description |
|---|---|
| Created By | User who created the object. |
| Created On | Date and time when the object was created. |
| Updated By | User who updated the object. |
| Updated On | Date and time when the object was updated. |
| Properties | Description |
|---|---|
| Lock | Name of user holding a lock on this object. This is empty if the object is not locked. |
| Properties | Description |
|---|---|
| Internal ID | ID used for internal and legacy purposes. The Internal ID is unique within a repository. |
| Global ID | Global ID of the object. The global ID is unique for the object type across repositories. |
This table lists the version number, the creation date of the version, the name of the user who created the version, and a version description.
You can perform the following actions by clicking the corresponding button:
Create a new version
Delete a version
Restore a version
Export a version
| Properties | Description |
|---|---|
| Version | Version of mapping. |
| Date | Date when the version was created. |
| User | User who created the version. |
| Description | Description of version. |
Use to view the authorized methods for a given user on this specific object instance.
An object instance (instance) is attached to an object type (an object). For example, the project MY_PROJ_1 is an instance of the project object type (or object). Similarly, another instance of a project object type is YOUR_PROJ_2.
Privileges are set up and managed in Security Navigator. The most common actions in Security Navigator are:
Creating and editing users and profile
Assigning user rights for methods on ODI objects (such as data server and datatypes)
Fine-tuning user rights on the object instances
| Properties | Description |
|---|---|
| Method | Name of the object method.
A method is a type of action that can be performed on an object, for example edit or delete. Each object has a series of methods that are specific to it. The concept of methods in Oracle Data Integrator is similar to the concept in Object-Oriented Programming. |
| User | Oracle Data Integrator user corresponding to the login name used for connecting to a repository.
A user has profile privileges, privileges on objects, and privileges on instances. |
Use to customize the properties of Oracle Data Integrator objects.
Flexfields are user-defined fields that are set for each object instance through the Flexfield tab of the object editor, and their values are defined for each object instance through the Flexfield tab of the object's instance window. Flexfield values can be used through Oracle Data Integrator substitution methods.
Note:
Flexfields exist only for certain object types. Objects that do not have a flexfield tab do not support them.| Properties | Description |
|---|---|
| Name | Label of the flexfield as it appears in the Flexfield tab of the object editor. |
| Code | Code of the flexfield. |
| Technology | Technology for which the flexfield is activated. For instance, a flexfield on a Procedure appears only for Procedures using this technology. |
| Type | Type of the flexfield (String or Numeric). |
| Default | Default value of the flexfield. |
"Using Flexfields" in the "Introduction to the Substitution API" chapter in Oracle Fusion Middleware Developing Knowledge Modules with Oracle Data Integrator
"Navigating the Mapping Editor" in the "Creating and Using Mappings" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator