assets.en-US.Database.Teradata.md Maven / Gradle / Ivy
# Teradata
In this section, we provide guides and references to use the Teradata connector.
## Requirements
### Profiler & Data Quality
Executing the profiler Workflow or data quality tests, will require the user to have `SELECT` permission on the tables/schemas where the profiler/tests will be executed. More information on the profiler workflow setup can be found [here](https://docs.open-metadata.org/how-to-guides/data-quality-observability/profiler/workflow) and data quality tests [here](https://docs.open-metadata.org/connectors/ingestion/workflows/data-quality).
You can find further information on the Teradata connector in the [docs](https://docs.open-metadata.org/connectors/database/teradata).
## Connection Details
$$section
### Connection Scheme $(id="scheme")
SQLAlchemy driver scheme options.
$$
$$section
### Username $(id="username")
Username to connect to Teradata. By default, any valid user has privileges to read all the metadata in Teradata.
$$
$$section
### Password $(id="password")
Password to connect to Teradata.
$$
$$section
### Logon mechanism (Logmech) $(id="logmech")
Specifies the logon authentication method. Possible values are TD2 (the default), JWT, LDAP, KRB5 for Kerberos, or TDNEGO.
$$
$$section
### Extra data for the chosen logon authentication method (LOGDATA) $(id="logdata")
Specifies additional data needed by a logon mechanism, such as a secure token, Distinguished Name, or a domain/realm name. LOGDATA values are specific to each logon mechanism.
$$
$$section
### Host and Port $(id="hostPort")
This parameter specifies the host and port of the Teradata instance. This should be specified as a string in the format `hostname:port`. For example, you might set the hostPort parameter to `example:1025`.
$$
$$section
### Transaction mode $(id="tmode")
Specifies the transaction mode for the connection. Possible values are DEFAULT (the default), ANSI, or TERA. More information about this parameter can be found [here](https://teradata-docs.s3.amazonaws.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#TMODESEC)
$$
$$section
### Teradata Database account $(id="account")
Specifies an account string to override the default account string defined for the database user. Accounts are used by the database for workload management and resource usage monitoring.
$$
$$section
### Connection Arguments $(id="connectionArguments")
Additional connection arguments such as security or protocol configs that can be sent to service during connection.
You can find further information about Connection Arguments [here](https://pypi.org/project/teradatasql/).
$$
$$section
### Connection Options $(id="connectionOptions")
Additional connection options to build the URL that can be sent to service during the connection.
You can find further information about Connection Options [here](https://pypi.org/project/teradatasql/).
$$