This appendix lists the Oracle Data Integrator user parameters. User parameters configure the behavior of Oracle Data Integrator.
To set the user parameters:
From the ODI main menu, select User Parameters.
In the Editing User Parameters dialog, set the values of the user parameters.
Click OK.
Table B-1 contains the complete list of ODI 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 |
|
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 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 interfacces 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 encodingss at the following URL: 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 encodingss at the following URL: 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:
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.
|
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:
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. |