Fields in the HEI Connection Document - 4

See the following tables for descriptions of the connection document fields.

Connectivity

The Connectivity options are described as follows.

Oracle connection document connectivity options


Field	Description
Name	Specifies a unique name that identifies this connection. The maximum number of characters allowed is 255.
Oracle Version	There is only one field value available for all supported Oracle versions.
Host String	Specifies the Service Name as defined in your local tnsnames.ora file. Service names are simple names commonly used to specify the location of database services on a network.
User Name	Specifies the user name required to log in to the Oracle database.
Password	Specifies the password associated with the preceding user name. This displays as hidden text. Password encryption is described in the "Introduction to Connectors" chapter.
Alternate Default Test Translation Format	Enables you to override the existing text translation format with an alternative default. Use this option to enter an alternative default Oracle text format if the standard default results in improper translation. The text format must be supported by Oracle.

Connection Options

The Connection Options section provides options for managing data transactions, creating tables, and logging SQL commands. These settings have no effect on Advanced RealTime activities.

Transaction Options

When you select the Transaction Options tab, the following options appear. The Transaction Options apply to operations that create, modify, or delete data.

Oracle connetion document transaction options bmp


Field	Description
Rollback:	Select "Rollback upon Error" if you want all transactions rolled back at disconnect time when an activity using this connection terminates in an error state.
Commit Options:	Specifies how commit actions should occur. The choices are as follows. Commit At Disconnect: Enable this option to commit changes to the database as the database is being disconnected at the end of the operation. This is the default Commit option. Commit Every N Operations: Commits changes periodically after a specified number of changes are made. This number is specified as the Commit Frequency. Commit Every Operation: When enabled, this option causes immediate commits for each change to the database. Note that this option reduces performance.
Commit Frequency	This is used with the option Commit Every N Operations to specify how many actions must occur before the changes are committed.

Logging Options

The Logging Options provide a feature for including any SQL statements generated during an activity to be included in the activity log.


Field	Description
SQL Statements Option:	Select "Output SQL Statements to Log" to include in the activity log all SQL statements generated during processing of the activity. Note: Selecting this option slows down performance. Use it only for troubleshooting.
Log Warning Statements:	Select "Output Warnings to Log" to enable warning statements to display in the activity log.

Selection Type

Regardless of which Options tab you select, the following option is available.


Field	Description
Selection Type	Enables you to specify the metadata type for a connection. Select Table to connect to an Oracle table. Select View to connect to an Oracle view. Select Procedure to connect to an Oracle stored procedure. Spaces in a table or column name are not permitted.

Table Options

These settings display a current list of tables and allow you to specify which tables will be accessed and how. You can also specify a table name not shown in the list by selecting the Manual button.


Field	Description
Owner	Lists the available owner names for the preceding table, view, or procedure selection type in the specified database. A selection list displays all Oracle owners. Choose the owner of the table, view, or procedure being connected to from the list (Optional).
Name	Lists the available table, view, or procedure names defined for the specified owner. A selection list displays all Oracle tables, views, or procedures for the selected owner. Choose the table, view, or procedure to connect to. If an owner is not specified, all names are listed for the specified Selection Type. Spaces in a table or column name are not permitted.
Column(s)	Lists the columns or parameters (stored procedure) defined for the specified name. Spaces in a table or column name are not permitted.