Teradata@1
Teradata@1 reads data from Teradata databases. Nothing to install.
Connects to
Teradata databases, on premises or hosted.
Example
- Name
- MyTeradataDatabase
- Technology
- Teradata
- Provider
- Teradata@1
- Connection string
Data Source=TeradataServer; User Id=myuser; Password=%PASSWORD%;
Data sources:
- Name: MyTeradataDatabase
Provider: Teradata@1
Technology: Teradata
Connection string: >
Data Source=TeradataServer;
User Id=myuser;
Password=%PASSWORD%;
Connection string
A standard Teradata.Client.Provider (.NET Data Provider for Teradata) connection string — Key=Value pairs separated by semicolons. The keys you will use most:
| Key | Meaning |
|---|---|
Data Source |
Server name or address |
User Id, Password |
Credentials |
Database |
Default database for unqualified names |
Connection Timeout |
Seconds to wait for the connection to open |
The full list is in the ConnectionString property reference of the driver.
A password, or the whole string, can come from an environment variable — %NAME% is replaced with the value of NAME; see How every provider is used.
Settings
None beyond Connection string.
Query
One SQL statement in Teradata’s dialect that returns a result set — a SELECT.
Prerequisites
None. The driver ships with CAT. Windows; on Linux it has no extra dependencies and is expected to work, but it has not been tested there.
Serving test and data source definitions
Teradata@1 can also serve lists of definitions: any statement that returns the columns of a test, data source or query definition works. Ready-made table scripts are in Store definitions in a database.