Connecting to an ODBC Data Source
After defining the ODBC data source, connect to it.
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.
