Configuring a DSN Using the ODBC Administrator Tool - Aster Client

Teradata Aster® Client Guide
Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
  1. In the Finder, under Favorites, select Applications > Utilities > ODBC Administrator.
  2. The User DSN tab shows a list of DSNs saved in the ~/Library/ODBC/odbc.ini file. To modify or remove an existing DSN, select it and click the respective button. To add a new user DSN, click the Add button.


  3. Select AsterDriver64 for 64-bit or AsterDriver32 for 32-bit and click OK.

  4. In the ODBC Driver Setup for Aster Data window, fill in the required information and click OK to save the DSN. The OK button does not become available until the required fields are filled in.


    • Data Source Name: Use this field to give this database connection an easy-to-recognize name.
    • Server Name/IP: The hostname or IP address of your Aster Database queen.
    • Port: The port on which your Aster Database queen listens for client connections. The default is 2406.
    • Database: The name of the database in Aster Database you want to connect to. Default system database is beehive.
    • Username: Database user name.
    • Password: Database user password.
    • Fetch Count: See Throttle Query Results in ACT and Aster Database.
    • SSL Settings: See SSL Basics for ODBC.
    • SSO Settings: See ODBC with SSO Client-Side Settings.
    • enable_quoted_identifiers: See Quoted-Identifier Handling.
    • enable_backslash_escapes: See Escape Character Handling.
    • Map NUMERIC/DECIMAL to DOUBLE: This option can be set to force all NUMERIC and DECIMAL columns to be described as DOUBLE. Teradata Aster recommends that you turn this feature on. The flag’s default is to be unset. If left unset, you cannot use the NaN value in the Numeric data type because Aster ODBC does not support NaN values for the Numeric data type. If you do not use NaN, and care about data precision, you can leave the flag unset.