---
title: "Teradata@1"
description: "Teradata@1 — Teradata databases over Teradata.Client.Provider, no driver needed"
url: "https://docs.justcat.it/reference/data-sources/providers/teradata-1/"
---
# Teradata@1


## Connects to

Teradata databases, on premises or hosted.

## Example


**Properties**



Name
: MyTeradataDatabase

Provider
: Teradata@1

Technology
: Teradata

Connection string
: ```
  Data Source=TeradataServer;
  User Id=myuser;
  Password=%PASSWORD%;
  ```





**YAML**


```yaml
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 <a href="https://teradata-docs.s3.amazonaws.com/doc/connectivity/tdnetdp/20.00/help/Teradata.Client.Provider~Teradata.Client.Provider.TdConnection~ConnectionString.html" target="_blank">ConnectionString property</a> 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](https://docs.justcat.it/reference/data-sources/providers/introduction/#how-every-provider-is-used "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](https://docs.justcat.it/reference/project-file/lists/ "Lists") of definitions: any statement that returns the columns of a [test](https://docs.justcat.it/reference/tests/properties/ "Test properties"), [data source](https://docs.justcat.it/reference/data-sources/properties/ "Data source properties") or [query](https://docs.justcat.it/reference/queries/properties/ "Query properties") definition works. Ready-made table scripts are in [Store definitions in a database](https://docs.justcat.it/how-to-guides/organize-and-run-tests/store-definitions-in-a-database/ "Store definitions in a database").

## Related

* [Technologies](https://docs.justcat.it/reference/data-sources/technologies/ "Technologies").