Connect to Teradata Database (FireDAC)
Go Up to Database Connectivity (FireDAC)
This topic describes how to connect to an installation of Teradata Database using FireDAC.
Contents
Supported Versions
The FireDAC native driver supports Teradata Database version 13 or later.
Client Software
Windows Client Software
FireDAC requires you to install the Teradata ODBC Driver For Windows on your workstation. To install this driver:
- Download the ODBC Driver Suite archive for Windows
- Extract the downloaded archive.
- Run the
setup.exe
installer that you can find inside the extracted folder. - Let the installer guide you through the steps required to install the driver on your system.
If the Teradata Database ODBC driver has not been properly installed, an exception is raised when you try to connect:
[FireDAC][Phys][ODBC][Teradata][ODBC Teradata Driver] Not enough information to log on.
Linux Client Software
FireDAC requires you to:
The Teradata ODBC driver is not compatible with unixODBC. Instead, you must use the DirecData ODBC driver manager supplied with the Teradata ODBC Driver for Linux. For more information see:
- Does Teradata ODBC client work with UnixODBC and Unicode on Linux?
- ODBC Driver for Teradata Application Development, Application Considerations
Driver Linkage
To link the driver:
- Drop a TFDPhysTDataDriverLink component from the "FireDAC Links" palette page.
- Or include the FireDAC.Phys.TData unit in the uses clause.
Connection Definition Parameters
To connect to the registered database, an application should specify its name using the Server parameter. Also specify User_Name and Password parameters (see Defining Connection (FireDAC) for details).
DriverID=TData
Parameter | Description | Example value |
---|---|---|
Server |
IP address of the Teradata Database server or alias of that server. When an alias name is specified, it is resolved at connect time. |
192.168.43.140 |
User_Name | The Teradata Database user name. | dbc |
Password | The Teradata Database user password. | dbc |
Database | Database name. | MyDatabase |
CharacterSet |
Specifies the charset name to override the Teradata Database server character set. The following values are supported:
|
UTF8 |
OSAuthent |
If enabled ( This option overrides the value set for the same option during DSN configuration. When
|
Yes |
SessionMode |
This option allows you to select the mode ( |
Teradata |
Encrypt |
When enabled ( When disabled ( |
Yes |
ExtendedMetadata |
Controls the extended description of the query result sets:
|
False |
Use Cases
- Connect to Teradata Database server:
DriverID=TData Server=192.168.43.140 Database=MyDatabase User_Name=dbc Password=dbc