Fields in the HEI Connection Document

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

Connectivity

The Connectivity options are described below.


Field	Description
Name	Specifies a unique name that identifies this connection. The maximum number of characters allowed is 255.
Data Source	Specifies the name of the ODBC data source as listed in the ODBC Administrator. The Connector for ODBC is available with the following drivers: DataDirect HCL-branded driver for native Connector for ODBC (default) DataDirect Sybase Wire Protocol DataDirect Oracle Wire Protocol DataDirect DB2 Wire Protocol DataDirect SQL Server Wire Protocol DataDirect Informix Wire Protocol DataDirect MySql Wire Protocol The default driver is the native ODBC driver. You can optionally use the Sybase Wire Protocol or Oracle Wire Protocol by entering the appropriate data source name (DSN) in this field. To configure a DSN, see the section entitled "Understanding and Using the ODBC Drivers" earlier in this chapter. To indicate this property generically from the LC LSX or a Metaconnector, use the Server property. Note: The browse button is only configured for Microsoft Windows users -- all other platform users must manually enter the Data Source name in this field.
User Name	Specifies the user name required to log in to the ODBC data source.
Password	Specifies the password associated with the user name above. This displays as hidden text. Password encryption is described in the "Introduction to Connectors" chapter.
Driver Threading:	Specifies threading. Enable the Single Threading option to notify the LEI server that the ODBC driver being used is single-threaded and that it does not support a multi-threaded operation.

Connection Options

The Connection Options section provides options for managing data transactions, creating tables, and logging SQL commands. These settings have no effect on a Domino Enterprise Connection Services (DECS) Virtual Fields activity or in an HCL Enterprise Integrator (HEI) Advanced RealTime Virtual Fields activity document.

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.


Field	Description
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 below. 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.
Cursor Options:	Specifies whether ODBC cursors are to be used. Select "Disable ODBC Cursors" to disable ODBC cursors and use keyed operations instead. Note: LEI automatically checks whether or not the data source supports ODBC cursors. Disabling cursors may be required when the ODBC driver does not properly report support for ordered updateable cursors, causing an error for writeback operations (often from Scripted or Replication activities).
Rollback:	Select "Rollback Upon Error" if you want all changes in the current ODBC Connection's transaction rolled back at disconnect time when the activity terminates in an error state.

Logging Options

When you select the Logging Options tab, the following options appear. The Logging Options section provides a feature for including SQL statements 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.

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 ODBC table. Select View to connect to an ODBC view. Select Procedure to connect to an ODBC 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 above table, view, or procedure selection type in the specified database. On IBM i, this lists libraries by library name. A selection list displays all ODBC 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. Click the down-arrow button to select from the list of available tables, views, or procedures. A selection list displays all ODBC 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	Lists the columns or parameters (stored procedure) defined for the specified Name. Spaces in a table or column name are not permitted.