Have any questions? Email: info@flynet.email. US: +1 617-778-7259. UK: +44 (0)3333-110-370. ES/PT: +351-300-500-441.

Teradata

DataConnect offers the Full Experience with Teradata. This allows you to create queries using a tile-based drag and drop query builder. The tile-based editor functions with Teradata Provider for .NET 4.0, OLEDB and ODBC.

However, automatic joins are currently only supported on Teradata Provider for .NET 4.0 based connections.

We recommend using the Teradata Provider for .NET 4.0 where available.

Create a New Connection

To create a new connection to a Teradata server, make sure you are on the Connections tab. Then press the (+) icon at the very left hand side of the window.

Give your Connection a Name

You then need to give your connection a name, and optionally a description.

Connection Type

You then have a choice of connection technologies. We recommend using the Teradata Provider for .NET 4.0 where possible.

Teradata Connections

Select the Connection Type 'Teradata Connections'.

The Data Source is the host name or IP address of the machine running Oracle.

User Id is your username, and Password is your password.

Missing Teradata Provider for .NET 4.0

If you attempt to use the Teradata Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.

The message will say:

The Teradata .NET Provider cannot be found. Please ensure you have the driver installed and configured correctly.

Contact your system administrator or you can download directly from here:

http://downloads.teradata.com/download

The driver must be installed on the server where the DataConnect Runtime service is installed.

After installing this driver, you may need to reboot the server.

Select the Connection Type 'ODBC Connections' and the Odbc Driver Type of 'Teradata Connection'.

The Server is the host name or IP address of the machine running Oracle.

Uid is your username, and Pwd your password.

Missing Teradata Provider for .NET 4.0

If you attempt to use the Teradata Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.

The message will say:

The Teradata .NET Provider cannot be found. Please ensure you have the driver installed and configured correctly.

Contact your system administrator or you can download directly from here:

http://downloads.teradata.com/download

The driver must be installed on the server where the DataConnect Runtime service is installed.

After installing this driver, you may need to reboot the server.

Select the Connection Type 'OLEDB Connections' and the Oledb Driver Type of 'Teradata'.

The Data Source is the host name or IP address of the machine running Oracle.

User Id is your username, and Password your password.

Missing Teradata Provider for .NET 4.0

If you attempt to use the Teradata Provider for .NET 4.0 and you don't have it installed, you will receive an error directing you to the driver download location.

The message will say:

The Teradata .NET Provider cannot be found. Please ensure you have the driver installed and configured correctly.

Contact your system administrator or you can download directly from here:

http://downloads.teradata.com/download

The driver must be installed on the server where the DataConnect Runtime service is installed.

After installing this driver, you may need to reboot the server.

Copyright © 2016 Flynet Limited. All rights reserved.

Terms of Use | Privacy & Cookie Policy