Data Connection to Teradata

Version

Application Scenario

This document introduces how to connect to the Teradata database in FineBI.

Version/Driver

Download the driver package and upload it to FineBI. For details, see the "Creating a Data Connection" section in Driver Management.

Connection Information Collection

Before connecting FineBI to the database, you need to collect the following information:

• IP address of the host where the database server is located

• Username and password of the database

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, click Create, and select Data Connection, as shown in the following figure.

Note:

If you are not the admin, you can configure data connections only after the admin assigns you the permission on the data connection module. For details, see Data Connection Permission Overview.

2. Find the Teradata database, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in section "Version and Driver", and enter the connection information collected in section "Connection Information Collection," as shown in the following figure.

URL description:
You can solve problems such as garbled characters and inability to filter characters by suffixing the URL with the parameter TMODE=ANSI, CHARSET=UTF8. 

4. Click Click to Connect Database, and select the required schema after successful connection. (If no schema is selected, the default schema will be used.) Finally, save the data connection, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

The field name in the Teradata table cannot be value. The value in the SQL statement select id,value from table executed by the driver will be wrongly recognized as a keyword, resulting in error reporting. (If you enclose the field name in double quotes ("value"), the driver can execute the SQL statement normally.)