Creating a Data Source Name

Typically, after installing the Simba Teradata ODBC Connector, you need to create a Data Source Name (DSN).

Alternatively, for information about DSN-less connections, see Using a Connection String.

To create a Data Source Name:

  1. Open the ODBC Data Source Administrator corresponding to the bitness of the connector that you installed.
  2. Choose one:
    • To create a DSN that only the user currently logged into Windows can use, click the User DSN tab.
    • Or, to create a DSN that all users who log into Windows can use, click the System DSN tab.

    Note:

    It is recommended that you create a System DSN instead of a User DSN. Some applications, such as Sisense, load the data using a different user account, and might not be able to detect User DSNs that are created under another user account.

  3. Click Add.
  4. In the Create New Data Source dialog box, select Simba Teradata ODBC Connector and then click Finish. The Simba Teradata ODBC Connector DSN Setup dialog box opens.
  5. In the Name field, type a name for your DSN.
  6. Optionally, in the Description field, type relevant details about the DSN.
  7. In the Name or IP Address field, type the IP address or host name of the Teradata Database instance.
  8. Use the options in the Authentication area to configure authentication for your connection. For more information, see Configuring Authentication.

    9. Note:

    If the TeraGSS program specifies the appropriate authentication settings for your connection, then you do not need to configure authentication settings in the connector. By default, the connector uses the authentication mechanism that the TeraGSS program specifies in the tdgssconfigure.xml file.

    Typically, the TeraGSS program specifies TD2 as the authentication mechanism to use.

  9. Configure the following optional settings if needed:
    1. In the Default Database field, type the name of the database to access by default.
    2. In the Account String field, type your account string for accessing the database.
    3. To access additional optional settings, click Options.
  10. From the Session Character Set drop-down list, select the character set to use for the session.
  11. To configure logging behavior for the connector, click Logging Options. For more information, see Configuring Logging Options.
  12. To test the connection, click Test. If you have not already specified the necessary authentication parameters and credentials during step 8, type those values in the Test Connection dialog box that opens, and then click OK. Review the results of the connection test as needed, and then click OK.

    13. Note:

    If the connection fails, then confirm that the settings in the Simba Teradata ODBC Driver DSN Setup and Test Connection dialog boxes are correct. Contact your Teradata Database server administrator as needed.

  13. To save your settings and close the Simba Teradata ODBC Connector DSN Setup dialog box, click OK.
  14. To close the ODBC Data Source Administrator, click OK.

Related topics