ODBC Connector Guide > ODBC Connections > ODBC Connection Properties
  

ODBC Connection Properties

Use an ODBC connection to connect to an ODBC object.
The following table describes the properties:
Connection Property
Description
Runtime Environment
Runtime environment that contains the Secure Agent you can use to access the system.
User Name
User name for the database login.
Password
Password for the database login. The password cannot contain a semicolon.
Data Source Name
System DSN.
Schema
Schema used for the source or target.
Code Page
The code page of the database server or flat file defined in the connection. 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.
  • - Japanese Extended UNIX Code (incl. JIS X 0212)
  • - Japanese EUC (with \<-> Yen mapping)
  • - Japanese EUC (Packed Format)
  • - IBM EBCDIC Japanese
  • - IBM EBCDIC Japanese CP939
  • - Japanese EBCDIC Fujitsu
  • - HITACHI KEIS Japanese
  • - NEC ACOS JIPSE Japanese
  • - UNISYS Japanese
  • - MITSUBISHI MELCOM Japanese
  • - Japanese EBCDIC-Kana Fujitsu
  • - HITACHI KEIS-Kana Japanese
  • - NEC ACOS JIPSE-Kana Japanese
  • - UNISYS-Kana Japanese
  • - MITSUBISHI MELCOM-Kana Japanese
  • - EBCDIC Japanese
  • - EBCDIK Japanese
  • - PC Japanese SJIS-78 syntax (IBM-942)
  • - PC Japanese SJIS-90 (IBM-943)
  • - EBCDIC Japanese Katakana SBCS
  • - EBCDIC Japanese Katakana (w/ euro)
  • - EBCDIC Japanese Latin-Kanji (w/ euro)
  • - EBCDIC Japanese Extended (DBCS IBM-1390 combined with DBCS IBM-1399)
  • - EBCDIC Japanese Latin (w/ euro update)
  • - EBCDIC Japanese Katakana SBCS (w/ euro update)
  • - MS Taiwan Big-5 w/ HKSCS extensions
  • - MS Windows Traditional Chinese, superset of Big 5
  • - Taiwan Big-5 (w/ euro update)
  • - Taiwan Big-5 (w/o euro update)
  • - PC Chinese GBK (IBM-1386)
  • - Chinese EUC
  • - Simplified Chinese (GB2312-80)
  • - Hong Kong Supplementary Character Set
  • - ISO 8859-8 Hebrew
  • - PC Hebrew (old)
  • - PC Hebrew (w/o euro update)
  • - PC Hebrew (w/ euro update)
  • - MS Windows Hebrew (older version)
  • - MS Windows Hebrew (w/o euro update)
  • - Lotus MBCS encoding for Windows Hebrew
  • - EBCDIC Hebrew (updated with sheqel, control characters)
  • - EBCDIC Hebrew (w/ euro)
  • - EBCDIC Hebrew (updated w/ euro and new sheqel, control characters)
  • - Israeli Standard 960 (7-bit Hebrew encoding)
ODBC Subtype
Categorizes the type of the connection so that pushdown optimization support can be enabled. Specify any one of the following subtypes:
  • - Redshift. When you read from or write to Amazon Redshift, select Redshift.
  • - Snowflake. When you read from or write to Snowflake, select Snowflake.
  • - Other. When you read data from or write data to any other databases, select Other. For example, to connect to other databases such as Microsoft Access, IBM DashDB, NetSuite, Microsoft Excel, and Teradata, you must select Other. Default is Other.
Driver Manager for Linux
When you create a new ODBC connection on Linux platform, you can select a driver manager for the Linux Secure Agent. Select one of the following driver managers:
  • - Data Direct
  • - unixODBC2.3.0
  • - unixODBC2.3.4
The default driver manager is UnixODBC2.3.0.
To connect to Teradata, you can use only Data Direct as the driver manager on Linux.