Details on Teradata Connection


This dialog is used to configure a connection to a Teradata database. You can choose whether to analyze data in-database, or to import it into your analysis.

To use the Teradata connector, you must install a data source driver on your computer. See the system requirements at http://support.spotfire.com/sr_spotfire_dataconnectors.asp to find the correct data source driver. Note that the driver version must match the Teradata version you are using. For example, if your Teradata version is 14, then the driver version must also be 14.

Note: The latest Teradata version supported in Spotfire is Teradata 16.

View Getting Started with Connectors for general information about accessing connectors in Spotfire. To learn more about Teradata, refer to the official Teradata documentation.

  1. Select Tools > Manage Data Connections.

  2. Click Add New > Data Connection and select Teradata.

  1. Select File > Add Data Tables.

  2. Click Add.

  3. Select Connection To > Teradata.

General tab

tera_teradata_connection_general_d.png

Option

Description

Server

The name of the server where your data is located. To include a port number, add it directly after the server name, preceded by colon.

Example with port number:
MyTeradataDatabaseServer:1234

Authentication method

The authentication method to use when logging into the database. Choose from Teradata authentication (TD2), LDAP authentication, and Windows authentication.

Teradata authentication (TD2)

Authenticate using a database user.

Users who open the connection, or an analysis using the connection, will be prompted to enter database credentials to connect to the data source.

Tip: You can save database credentials, unencrypted, as part of an analysis file, using a setting in the Data Source Settings dialog. If credentials are embedded in your analysis, it means that users will not be prompted to enter credentials to connect to the data source. Note that it can be a security risk to embed database credentials in an analysis file.

LDAP authentication

When using LDAP authentication, users are prompted to enter their LDAP credentials. Users with valid accounts in the LDAP directory will be able to connect and read data.

Windows authentication

When using Windows Authentication, for example Kerberos, the access token of the logged in user will be used. Users that have been given the appropriate access rights to Teradata will be able to connect and read data.

Domain credentials are not stored in the analysis file.

Username

The username you wish to use when logging into the Teradata database.

Password

The password for the specified username.

Connect

Connects you to the specified server, and populates the drop-down list of available databases.

Database

Lists the available databases after a successful connection has been made.

Advanced tab

tera_teradata_connection_advanced_d.png

Option

Description

Use data encryption

Select this check box to use data encryption when connecting to Teradata.

Use X Views

Select this check box to use X Views. X Views limit a user's view to only those objects that the user has permission to access.

Session character set

Select which session character set to use when connecting to Teradata.

Session mode

Select which session mode to use when connecting to Teradata. Which mode you select affects how errors in the transaction process are handled, as well as performance.

Connection timeout (s)

Specifies the maximum number of seconds allowed for a connection to the database to be established.

Note: If you set the connection timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to connect. This is generally not recommended.

Command timeout (s)

Specifies the maximum number of seconds allowed for a command to be executed.

Note: If you set the command timeout to zero, it will be interpreted as no timeout. That is, there will be no upper limit for trying to execute the command. This is generally not recommended.

Query Banding tab

tera_teradata_connection_querybanding_d.png

Option

Description

Use proxy settings

Select this check box to connect to the data source using a proxy user.

   Proxy user

 

      Use current Spotfire user

Select this option to use the Spotfire username of the user opening the connection as the proxy user.

      Other

Select this option to manually specify a proxy user for the connection.

   Proxy role

Optionally, you can specify a proxy role for the connection.

See also:

Teradata Data Types

Supported Functions