Teradata pivot table reports

Teradata can be used as a live SQL data source via official .NET client library. SeekTable is the perfect self-service BI interface for querying a Teradata data warehouse in a controlled and manageable way, making it accessible to non-IT users without needing SQL knowledge.

Because report queries run and execute in real time, it's crucial that your Teradata data warehouse responds quickly. The execution time is limited by 2 minutes by default, this limit can be extended in a self-hosted SeekTable setup. For long-running queries you may consider to organize some kind of persisted cache layer (can be organized on SeekTable side too).

Teradata connection setup

1. Click the "Connect to Database" to open a new data cube configuration form.
2. Choose Data Source Type: SQL-compatible database (this opens SQL Settings section).
3. Choose Database Connector: Teradata
4. Connection String example:

   Data Source=teradataHost;Database=db;User Id=user;Password=password;

   Data Source	The Teradata server name, or equivalently the DBC Name or TDPID.
   User Id	The Teradata user id.
   Password	The Advanced SQL Engine password.
   Database	The database selected as the default database when a Teradata connection is opened.
   Port Number	Specifies the TCP/IP port number that the .NET Data Provider for Teradata uses for connection to the Teradata Gateway.
   Account String	Identifies an individual user account, and is associated with a specific User Id. The account identifier can be up to 30 characters long.
   Disable Token Cache	Disables the use of the OIDC Token Cache.

   Note: this is an incomplete list of supported Teradata connection string properties. If you need to use specific connection settings, please check the ".NET Data Provider For Teradata" documentation or contact us for assistance.