## Set up Teradata

URL: https://docs.atlan.com/apps/connectors/database/teradata/how-tos/set-up-teradata

> :::warning Who can do this? You need your Teradata administrator to run these commands - you may not have access yourself.

:::warning Who can do this?
 You need your Teradata administrator to run these commands - you may not have access yourself.

:::

Atlan supports the following authentication methods for fetching metadata from Teradata:

- [Basic authentication](#basic-authentication)
- [LDAP Authentication](#ldap-authentication)

## Basic authentication

Atlan supports the basic authentication method for fetching metadata from Teradata. This method uses a username and password to fetch metadata.

To create a username and password for basic authentication for Teradata, run the following commands:

## Create role

[Create a role in Teradata](https://docs.teradata.com/r/Teradata-VantageTM-NewSQL-Engine-Security-Administration/March-2019/Creating-Users-and-Granting-Privileges/Using-Roles-to-Manage-Privileges/Creating-Roles) using the following commands:

```sql
CREATE role atlan_user_role
```

## Create user

Create a new user for [integrating with Atlan](https://docs.atlan.com/llms/connectors/teradata/crawl-teradata/llms.txt) using the following commands:

```sql
CREATE USER atlan_user FROM [database] AS PASSWORD = [password] PERM = 20000000;
```

Grant access to the role or directly to the user with the following commands:

```sql
GRANT SELECT ON dbc.databases TO atlan_user_role;
GRANT SELECT ON dbc.tables TO atlan_user_role;
GRANT SELECT ON dbc.TablesV TO atlan_user_role;
GRANT SELECT ON DBC.TableStatsV TO atlan_user_role;
GRANT SELECT ON dbc.columns TO atlan_user_role;
GRANT SELECT ON dbc.TableTextV TO atlan_user_role;
GRANT SELECT ON dbc.TableSizeV TO atlan_user_role;
GRANT SELECT ON DBC.ColumnsV TO atlan_user_role;
GRANT SELECT ON DBC.IndicesV TO atlan_user_role;
GRANT SELECT ON DBC.All_RI_ChildrenV TO atlan_user_role;
```

Grant additional permissions to [mine query history](https://docs.atlan.com/llms/connectors/teradata/mine-teradata/llms.txt) with the following commands:

```sql
GRANT SELECT ON dbc.dbqlogtbl TO atlan_user_role;
```

## Grant role to user

To grant the `atlan_user_role` to the new user:

```sql
GRANT atlan_user_role TO atlan_user;
```

## LDAP authentication

Atlan supports LDAP authentication for fetching metadata from Teradata. This method uses LDAP credentials to authenticate with your corporate directory (like Active Directory).

To use LDAP authentication:

1. Make sure your Teradata instance is configured to support LDAP authentication. For details, see the [Teradata documentation on LDAP authentication](https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/Security-Administration/Changing-the-TDGSS-Configuration/Working-with-LDAP-Mechanism-Properties/Configuring-LDAP-for-Directory-Authentication-and-Authorization).
2. Create an LDAP user in your directory service (for example, Active Directory or OpenLDAP).
3. Grant the same permissions to the LDAP user as described in the [Basic authentication](#create-role) section earlier.

When configuring the connector in Atlan, select **LDAP** as the authentication method and provide your LDAP username and password.

---