Connector for Teradata

On this page, you find information about downloading and installing the drivers you need to be able connect to data sources with the connector for Teradata in Spotfire.

Preparations

Before downloading and installing any driver software for use with this connector, read the system requirements for the connector for your version of Spotfire. Make sure that your database version and driver version is supported in your version of Spotfire.

System requirements for connectors

Remember that additional requirements and third party dependencies might apply for using the drivers. Refer to the official documentation from the driver vendor for more information.

Supported data sources

You can use the Spotfire Connector for Teradata to connect to the following data source types:

Teradata

Driver information

To use the Teradata connector, you must install .NET Data Provider for Teradata on your computer.

Note: The version of the .NET Data Provider for Teradata driver must match the Teradata version you want to connect to. For example, if your Teradata version is 14, then you must install version 14 of the driver on your computer.

Downloading the .NET Data Provider for Teradata driver

Prerequisites: To access the download, you must have a Teradata account, which you can create on the Teradata website.

The .NET Data Provider for Teradata driver is available on the Teradata download page.

Note: When you obtain third-party software or services, it is your responsibility to ensure you understand the license terms associated with such third-party software or services and comply with such terms.

Installing the driver on Linux (Spotfire 12.0 and later)

To use the Teradata connector on a Linux system with Automation Services or Web Player services, you must package .dll files from the Teradata Client Provider NuGet package in an .spk file and deploy it on the deployment area on the Spotfire Server.

Prerequisites: You need the Spotfire Package Builder console from the Spotfire Developer software.

Get the NuGet package Teradata.Client.Provider.
Create a new .pkdesc package description file for Linux systems.
Tip: You can start from and modify the sample further down on this page.
In the .pkdesc file, include the following files from the NuGet package:
<.NET Version>\Teradata.Client.Provider.dll

<.NET Version>\Teradata.Net.Security.Tdgss.dll
Also include any required file dependencies.

Open a command-line interface. To create an .spk file from your .pkdesc file, run the Package Builder console with this command:

Spotfire.Dxp.PackageBuilder-Console.exe /target:"output-directory\teradata-driver.spk /pkdesc:"input-directory\teradata-driver.pkdesc" /basefolder:"basefolder-directory" /intendedplatform:linux /targetframework:netcore

Deploy the .spk package to the appropriate deployment area on the Spotfire Server.

Sample .pkdesc file

You can modify and use this .pkdesc sample to create an .spk package file. The sample is written based on having included the NuGet package in a C# project and then built it. That downloads the .dll files in the folder structure used in the sample. All file paths in the .pkdesc are relative to the /basefolder parameter that you provide when you run the Package Builder Console.

Important: This sample is based on a specific version of the Teradata.Client.Provider NuGet package. Details such as file dependencies might be different in the version you want to use, so always consult the official documentation for the NuGet package and modify your .pkdesc file accordingly.

<?xml version="1.0"?>
<PackageDescription xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" SchemaVersion="1.0" Name="Spotfire Driver for Teradata NET Core" Version="1.0.0.0" SeriesId="1dfd04f8-c045-4e12-93d1-357bea0942a2" IntendedClient="Any" TargetFramework="netcore" IntendedPlatform="linux">
  <File SourceFile="Teradata.Net.Security.Tdgss.dll" TargetFilename="Teradata.Net.Security.Tdgss.dll" Type="Assembly">
    <Compatibility Min-version="13.11.0.1" Max-version="#.*.*.*" />
  </File>
  <File SourceFile="Teradata.Client.Provider.dll" TargetFilename="Teradata.Client.Provider.dll" Type="Assembly" />
  <File SourceFile="IdentityModel.dll" TargetFilename="IdentityModel.dll" Type="Assembly" />
  <File SourceFile="IdentityModel.OidcClient.dll" TargetFilename="IdentityModel.OidcClient.dll" Type="Assembly" />
  <File SourceFile="System.IdentityModel.Tokens.Jwt.dll" TargetFilename="System.IdentityModel.Tokens.Jwt.dll" />
  <File SourceFile="Microsoft.IdentityModel.Tokens.dll" TargetFilename="Microsoft.IdentityModel.Tokens.dll" />
</PackageDescription>

What to do next?

If you want to learn more about how to use this connector, see the Spotfire User Guide. There you can find everything from basic instructions to detailed information about how you can load and analyze data in Spotfire.

Spotfire User Guide