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 target connection. This property is not required for an ODBC connection, except if used to connect to an IBM DB2 database. Use uppercase letters when you specify the schema name for an Oracle database.
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.
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.
  • - Azure DW. When you read from or write to Azure Data Warehouse, select Azure DW.
  • - Other. When you read from or write to any other databases, select Other.
Default is Other.