B User Parameters

This appendix lists the Oracle Data Integrator user parameters. User parameters configure the behavior of Oracle Data Integrator.

To set the user parameters:

  1. From the ODI main menu, select User Parameters.

  2. In the Editing User Parameters dialog, set the values of the user parameters.

  3. Click OK.

Table B-1 contains the complete list of ODI user parameters.

Table B-1 User Parameters

Parameter Values Description

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. Refer to Section 11.3.5, "Define the Mappings" for more information.

Bypass 'Exit ODI' prompt on exit

Yes | No | Ask

If this user parameter is set to Yes, the exit confirmation dialog will NOT be shown.

Bypass displaying "Fix issues" Dialog for Interfaces

Yes | No

If set to Yes, the Fix issues dialog for interfaces will NOT be shown.

Bypass Web Service operation changed warning

Yes | No |Ask

If this user parameter is set to Yes, the Operation Changed warning will NOT be shown.

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.

Refer to Section 18.5.1, "Concurrent Editing Check" for more information.

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.

Default Context for Designer

Context name

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

Default Context for Execution

Context name

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

Refer to Chapter 21, "Running Integration Processes" for more information.

Default Designer Context

Context name

When executing an integration interface, this is the context selected by default in the Execution dialog.

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.

Refer to Section 8.3, "Generating and Deploying Data Services" for more information.

Default PDF generation directory

Directory

When generating a report, the default directory to save the generated .pdf file to. Refer to Section 18.6, "Creating PDF Reports" for more information.

Delay between two refresh (seconds)

Numeric

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

Delete linked sessions with scenarios

Yes | No | Ask

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

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. Refer to Chapter 7, "Working with Common Format Designer" for more information.

Display lock icons in the tree

Yes | No

Display lock icons in the Designer Navigator tree for locked objects. Disabling this option can provide a speed improvement when displaying the tree view. Refer to Section 18.5.2, "Object Locking" for more information.

Display resource names in the tree

Yes | No

Whether to display the resource name of a datastore in the Models accordion. This might be useful when the resource name differs from the datastore name.

Enable Operator display limit dialog

0 | 1

If 1, a warning dialog is shown each time the Operator display limit is exceeded.

If 0, no warning dialog is displayed.

Enable specific interface issues for the Platform Compiler

Yes | No

If set to Yes, the interfaces will be checked to enable specific issues for the Platform Compiler. It is advised not to enable this parameter unless you use the platform compiler for the interfaces you develop.

Export default Java encoding

Java encoding

Export default Java encoding. Default is ISO8859_1. You will find a list of supported encodings at the following URL: http://java.sun.com/j2se/1.4.2/docs/guide/intl/encoding.doc.html

Refer to Chapter 20, "Exporting/Importing" for more information.

Export default version

0 | 1

If 1, the versioned objects will be exported during the master repository export. If 0, the versioned objetcs are not exported. Default is 1.

Refer to Chapter 20, "Exporting/Importing" for more information.

Export default XML charset

Charset encoding

Default export charset encoding. Default is ISO-8859-1. You will find a list of supported encodings at the following URL: http://java.sun.com/j2se/1.4.2/docs/guide/intl/encoding.doc.html

Refer to Chapter 20, "Exporting/Importing" for more information.

Help for Interface Diagram

0 | 1

If 1, a help message is displayed whenever editing an interface diagram with no datastores attached.

Hide On Connect and Disconnect steps

Yes | No

If this user parameter is set to Yes, the On Connect and Disconnect steps will NOT be shown. Default is No.

Keeps in the cache the list of models whose DBMS is not accessible.

Yes | No

If this user parameter is set to true, the list of models whose DBMS is not accessible is kept in the cache. This speeds up expanding and displaying the nodes under these models.

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.

Refer to Section 18.5.2, "Object Locking" for more information.

Never transform non ASCII characters to underscores

Yes | No

When true, no characters are transformed during an export or an alias generation. Beware, should only be used on platforms fully supporting your encoding.

Operator display limit (0=no limit)

Numeric

When the number of sessions to display in Operator Navigator exceeds this number, a confirmation message is displayed. Default: 100

Oracle Data Integrator Timeout

Numeric

Only for internal agent: Number of seconds to wait during database connections before giving up. Increase this value if you regularly encounter timeout problems. Default: 30. Changes in this value are only taken into account when the application is restarted

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.

Refer to Section 18.6, "Creating PDF Reports" for more information.

Process Model Datastores Only

Yes | No | Ask

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

Refer to Section 7.3, "Generating DDL scripts" for more information.

Query buffer size

Numeric

Size of the cache used for prepared statements (Queries) issued on the repositories. Only applies to repositories on Oracle instances. Changes in this value are only taken into account when the application is restarted.

Scenario Name Convention

Naming convention

Only for internal agent: Use this parameter to define the default naming pattern for new scenarios created for objects via the Studio or the tools. The following tags can be used in the pattern.

  • %PROJECT_NAME% : Name of the project containing the object.

  • %FOLDER_PATH%: Folder path to the object from in the project tree, separated with underscores.

  • %FOLDER_NAME(n)%: Name of one folder in the path, starting from the bottom (n=1 corresponds to the object's parent) to the top folder in the project tree. If the folder does not exist for the given index, returns an empty string.

  • %FOLDER_NAME%: Shortcut to %FOLDER_NAME(1)%

  • %OBJECT_NAME%: Name of the source object of the scenario

Show the CDC modifications in the tree

0 | 1

Shows the CDC modifications in the tree (1=Enabled/0 = Disabled). Default is 1.

Refer to Chapter 6, "Working with Changed Data Capture" for more information.

Skip Move Warning

Yes | No

If set to No, the Object Move Warning dialog will be displayed when an object or folder is moved within the Navigator.

Skip Shortcut Name changed warning

Yes | No

If set to No, the Move Shortname Name Warning dialog will be displayed when a shortcut is moved within the Navigator.

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.

Refer to Section 18.5.2, "Object Locking" for more information.

Use New Load Balancing

Yes | No

Only for internal agent: 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. Refer to Section 4.3.3, "Load Balancing Agents" for more information.