Connecting to an ODBC Data Source - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Connecting to an ODBC Data Source

After defining the ODBC data source, connect to it.

To connect to an ODBC data source

1 Use the provider drop down menu to select ODBC data source.

2 Do one of the following:

  • Select Tools > Connect.
  • On the toolbar click .
  • The prompt asks for the name of the data source.

    3 Select a data source and click OK.

    4 In the Teradata Database Connect dialog box:

    a Do one of the following:

  • Select Use Integrated Security
  • Enter the Mechanism and Parameter
  • Enter the Userid and Password
  • b [Optional] Enter a Default Database or an Account String.

    When the connection is complete, the Connect icon can be disabled and the Disconnect icon to its right enabled. The connect icon is disabled only if connection to multiple data sources is not allowed.

    For more information on the fields in this dialog box, refer to the ODBC Driver for Teradata User Guide.

    When Connected to ODBC

    The following lists describes what occurs when connection is established with an ODBC source:

  • All columns are returned as character strings when Interval columns are selected, so you cannot select LOBs or Byte columns if the Select includes Interval columns.
  • You can only select CLOBs if connecting using the UTF-16 Session Character Set.
  • Only type F User Defined Functions are listed under the Functions node of the Database tree.
  • Time columns do not display fractional seconds or Time Zone information.
  • Decimal columns with more than 28 digits might display incorrectly.
  • If a macro (or execute parallel) returns zero rows from a Select statement, no rows are returned from any later Select statements in that macro or parallel query.
  • Batch Import functionality is not available.
  • The Edit Table function is not available.
  • The location of Syntax errors will not be highlighted.