Home
HCL Domino Designer Basic User Guide and Reference
Basic product usage information and programming language reference information.
Connectors
Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
Connectors and Connectivity Guide
Chapter 8 Connector for Oracle
This chapter provides information about the Connector for Oracle, including descriptions of the fields in the connection document.
Fields in the DECS Connection Document - version and user information
The fields in the Domino® Enterprise Connection Services (DECS) connection document are described as follows.

Fields in the DECS Connection Document - version and user information

The fields in the Domino® Enterprise Connection Services (DECS) connection document are described as follows.

Oracle connection document for DECS bmp


Field	Description
Oracle Version	Select the version of the Oracle client to use with this connector. Note: If you have an existing Oracle connection document and you change the "Oracle Version" value, you may receive unexpected results.
Host String	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 login to the Oracle database.
Password	Specifies the password associated with the User Name. This displays as hidden text.
Alternate Default Text Translation	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.
Selection Type	Specifies 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/View/Procedure Selection

The Table/View/Procedure section is described as follows.


Field	Description
Owner	Lists the available owner names for the preceding table, view, or procedure selection type in the specified database. This option enables you to narrow the selection of data sources to a specific owner level. 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/Parameter	Lists the columns or parameters (stored procedure) defined for the specified name. This automatically lists the procedures or columns and corresponding data types of the selected parameter, table, or view. Spaces in a table or column name are not permitted.
Comment	Enables you to add comments to the connection document that help describe its intent or usage. This is a rich text field. You can paste Notes® doclinks, as well as normal text characters here.