Oracle Connector Guide > Oracle Connections > Oracle Connection Properties
  

Oracle Connection Properties

When you create an Oracle connection, you must configure the connection properties.
The following table describes the connection properties:
Connection Property
Description
Runtime Environment
Runtime environment that contains the Secure Agent used to access Oracle.
User Name
User name for the database login. The user name cannot contain a semicolon.
Password
Password for the database login. The password cannot contain a semicolon.
Host
Name of the machine that hosts the database server.
Port
Network port number used to connect to the database server. Default is 1521.
Service Name
Service name or System ID (SID) that uniquely identifies the Oracle database.
Specify the SID in the following format to connect to Oracle databases: SID:<ORACLE_SID>
Schema
Schema used for the Oracle connection.
Code Page
The code page of the database server. Select one of the following code pages:
  • - MS Windows Latin 1. Select for ISO 8859-1 Western European data.
  • - UTF-8. Select for Unicode data.
  • - Shift-JIS. Select for double-byte character data.
  • - ISO 8859-15 Latin 9 (Western European).
  • - ISO 8859-2 Eastern European.
  • - ISO 8859-3 Southeast European.
  • - ISO 8859-5 Cyrillic.
  • - ISO 8859-9 Latin 5 (Turkish).
  • - IBM EBCDIC International Latin-1.
You can configure the following Oracle-specific custom properties under the Secure Agent configuration properties:
Custom Property
Description
OdbcDataDirectNonWapi
For Data Synchronization tasks, Mapping Configuration tasks, Data Replication tasks, and mappings that use relational multibyte data, add the OdbcDataDirectNonWapi property and set the property to 0 to process Unicode data.
Note: When you set this property to 0, the processing time of single-byte data might increase.
Enter the following values:
For Type, select DTM.
For Sub-type, select INFO.
For Name, enter OdbcDataDirectNonWapi.
For Value, enter 0.
oracle.use.varchar.for.number
For Data Synchronization tasks, Mapping Configuration tasks, Data Replication tasks, and mappings that have an Oracle source and a Salesforce target, set the oracle.use.varchar.for.number custom property if the Oracle source contains many fields with the Number data type. Values for fields with the Number data type do not load correctly in Salesforce. Enter the following values:
For Type, select Tomcat.
For Name, enter oracle.use.varchar.for.number.
For Value, enter true.