User parameters

The following user parameters configure the behavior of Oracle Data Integrator. They can be set through the File > User parameters....

User parameters are saved in the userpref.xml file in the /bin sub-directory in the Oracle Data Integrator installation directory.

Parameter

Values

Description

Check for concurrent editing

 

0 | 1

 

When saving changes to any object, checks whether other changes have been made to the same object, by another user. If another user has made changes, the object cannot be saved.

Automatic Mapping

 

Yes | No | Ask

Automatically maps source columns to target columns when new datastores are added to an interface by detecting column name matches.

Use New Load Balancing

 

Yes | No

When using load balancing, agents that run out of sessions can be reallocated sessions from other agents that have not yet been started. Otherwise, sessions are only allocated once each.

Help for Interface Diagram

0 | 1

If 1, causes a help message to display whenever editing an interface diagram with no datastores attached.

Warn before purging logs

Yes | No

Displays a warning when User or Session name filter are specified and you have selected to purge the scenario reports notifying that only scenario reports linked to sessions will be deleted and that orphaned scenario reports will not be deleted.

Lock object when opening

 

0 | 1| Ask

When opening an object for edition:

  • 1: It is automatically locked

  • 0: It is not locked

  • Ask: the user is prompted to lock the object.

Unlock object when closing

 

0 | 1| Ask

 

When closing a modified object:

  • 1: It is automatically unlocked

  • 0: It is not unlocked

  • Ask: the user is prompted to unlock the object.

Delete linked sessions with scenarios

Yes | No | Ask

When deleting a scenario in the Scenarios view of Operator, linked sessions are automatically deleted if set to Yes.

Default path for generation of Data Services

Directory

 

This is the default path to store the generated Data Service in. Oracle Data Integrator places the generated source code and the compiled Web Service here. This directory is a temporary location that can be deleted after generation.

Process Model Datastores Only

Yes | No | Ask

Whether to generate DDL code for datastores which do not exist in this model. If "Ask", displays a confirmation message.

Operator display limit (0=no limit)

Numeric

When there are more than this number of sessions to display in Operator, a confirmation message is displayed. Default: 100

Delay between two refresh (seconds)

Numeric

The number of seconds to wait between two refreshes in Operator. Only applies when auto-refresh mode is enabled.

Default PDF generation directory

Directory

When generating a report, the default directory to save the generated .pdf file to.

Default Context for Designer

Context name

Default context used in Designer. This context will be displayed by default in the different lists, and selected when opening Designer.

Default Agent

 

Agent name

 

When executing any object, the agent selected by default in the Execution options window. If an invalid agent name is specified, the local agent is used.

PDF Viewer

Path to file

Complete path including filename of program to view generated .pdf files. Required to use the Open file after generation option.

Directory for Saving your Diagrams (PNG)

Directory

When printing a model diagram with Common Format Designer, specifies the default directory to save the generated .png file to.

Query buffer size

Numeric

The number of prepared SQL statements cached by Data Integrator for accessing the repository. In some cases this should be set to 1 to effectively disable query caching.

Default Context for Execution

Context name

When executing any object, the context selected by default in the Execution options window. If an invalid context name is specified, the default context in Designer is used.

Oracle Data Integrator Timeout

Numeric

Number of seconds to wait during database connections before giving up. Increase this value if you regularly encounter timeout problems. Default: 30.

Display resource names in the tree view

Yes | No

Whether to display the resource name of a datastore in the Models view. This might be useful when the resource name used in Oracle Data Integrator differs from the resource name recognized by the data server which stores it.