The following section describes the minimum options required to establish a connection for drivers that support 32 and 64-bit platforms. For a complete list of supported connection options, refer to the chapter for your driver.
Greenplum Wire Protocol Sybase Wire Protocol
Progress OpenEdge Teradata

Greenplum Wire Protocol

Provide the following information on the General Tab:

  • Host Name: Type either the name or the IP address of the server to which you want to connect.
  • Port Number: Type the port number of the server listener. The default is 5432.
  • Database Name: Type the name of the database to which you want to connect by default.

Impala Wire Protocol

Provide the following information on the General Tab:

  • Host Name: Type either the name or the IP address of the server to which you want to connect.
  • Port Number: Type the port number of the server listener. The default is 21050.
  • Database Name: Type the name of the database to which you want to connect by default.

Progress OpenEdge Wire Protocol

Provide the following information on the General Tab:

  • Host Name: Type either the name or the IP address of the server to which you want to connect.
  • Port Number: Type the port number of the server listener.
  • Database Name: Type the name of the database to which you want to connect by default.
  • User ID: Type your user name of as specified on the Progress OpenEdge server.

Sybase Wire Protocol

Provide the following information on the General Tab:

  • Network Address: Type the IP address of the server to which you want to connect. Specify this address as IP_address, port_number. For example, you can enter 199.226.224.34, 5000.

    If your network supports named servers, you can specify an address as server_name, port_number. For example, you can enter SybSserver, 5000.

  • Database Name: Type the name of the database to which you want to connect by default. If you do not specify a value, the default is the database defined by the system administrator for each user.

Driver for the Teradata Database

Following is a list of connection options on the General Tab:
  • DBCName or Alias: Type the IP address or the alias name of the Teradata Server. Using an IP address reduces the time it takes to connect, but if that address is not available at connection time, the connection fails and the driver does not attempt to fail over to another address.

    Using an alias name increases the time it takes to connect because the driver must search a local hosts file to resolve the name to an IP address, but it allows the driver to try and connect to alternate IP addresses if the first address fails. If you use an alias name, you must have or create a local hosts file that contains the alias names. The alias name cannot be more than eight characters long.

  • DBCName List: Type the IP addresses or the alias names that are to appear in the drop-down list of the logon dialog box. Separate the names with commas. The same restrictions apply as described for the DBCName or Alias option.

    Using an alias name increases the time it takes to connect because the driver must search a local hosts file to resolve the name to an IP address, but it allows the driver to try and connect to alternate IP addresses if the first address fails. If you use an alias name, you must have or create a local hosts file that contains the alias names. The alias name cannot be more than eight characters long.

  • Integrated Security: Select this check box to enable the user to connect to the database through single sign-on (SSO) using one of the authentication mechanisms that support SSO. When this check box is not selected (the default), UserID is required.
  • Security Mechanism: Select TD2 from the drop-down list to specify the authentication mechanism used for connections to the data source. Valid values are:
    • Default—uses TD2.
    • KRB5— uses Kerberos as the authentication mechanism on Windows clients working with Windows servers if the server is V2R6.0.
    • KRB5C— uses Kerberos Compatibility as the authentication mechanism on Windows clients working with Windows servers if the server is pre-V2R6.0.
    • LDAP—uses LDAP as the authentication mechanism.
    • NTLM— uses NTLM as the authentication mechanism on Windows clients working with Windows servers if the server is V2R6.0.: Type a string of characters that is to be regarded as a parameter to the authentication mechanism. The string is ignored by the ODBC driver and is passed on to the TeraSSO function that is called to set the authentication mechanism. The characters [] {} () , ; ? * = ! @ must be enclosed in curly braces.
    • NTLMC— uses NTLM Compatibility as the authentication mechanism on Windows clients working with Windows servers if the server is pre-V2R6.0.
    • TD1—uses Teradata 1 as the authentication mechanism.
    • TD2—(default) uses Teradata 2 as the authentication mechanism.
  • Security Parameter
  • UserID: Type the default UserID for the Teradata database.