Connecting to Teradata

Contents[Hide]

1. Overview

This article shows you how to use the Teradata data provider in a Dundas BI data connector.

Tip
You can also use ODBC or JDBC drivers to connect to Teradata.

2. Install the driver

The Teradata data provider requires drivers to be installed on the server that connects to the database.

If you are using multiple servers to run Dundas BI, this is needed for each server installation.

2.1. Windows

When Dundas BI is installed on a Windows server, download and install the .NET Data Provider for Teradata for Windows on the server.

2.2. Linux

For Dundas BI installations on Linux, including Docker images and Kubernetes, download the Teradata .NET Data Provider NuGet Package. This file has a .nupkg extension but is a ZIP file that you can extract to find Teradata.Client.Provider.dll in the /lib/netstandard2.0 folder or similar.

Note
You will need the .NET Standard or .NET Core version of this file, not the .NET Framework version that may instead be located in a folder such as net461.

Find the App_Data folder within your Dundas BI installation's folder, create two additional subdirectories ExtensionsLib/netcore/ (if they do not exist), and place the DLL within netcore. This would place the DLL at this location for an installed Dundas BI instance:

/usr/share/dundas/bi/Files/{Instance Name}/www/BIWebsite/App_Data/ExtensionsLib/netcore/Teradata.Client.Provider.dll

Ensure the permissions allow the dundasbi group to read and execute the new file (e.g., chgrp dundasbi Teradata.Client.Provider.dll and chmod 751 Teradata.Client.Provider.dll), and restart the Dundas BI service to ensure the DLL is loaded: for a Dundas BI instance, restart the website service.

3. Create a data connector

In the main menu on the left, choose New and Data Connector.

Set a Name and set Provider to Teradata.

Connecting to Teradata
Connecting to Teradata

Set the remaining fields for the server name and credentials, and click to access additional options if needed from the expandable sections below. To see a description, hover over (or long-tap) one of the fields.

Click Test connection to confirm your entries, then click the submit button at the bottom to create the data connector and discover the available data structures to list under it for you to use.

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri