Register a Teradata Connection

Immuta policies will not be automatically enforced in Teradata

While you can author and apply subscription and data policies on Teradata data sources within Immuta, these policies will not be enforced natively in the Teradata platform. You can use Immuta webhooks to be notified about changes to user access and make appropriate access updates in Teradata using your own process.

Requirement

• Teradata VantageCloud or Teradata VantageCore

Permissions

The user registering the connection must have the permissions below.

• APPLICATION_ADMIN Immuta permission

• The Teradata user registering the connection must have the following privilege: DBADMIN

Create the database user

1. ​Create a new user in Teradata to serve as the Immuta system account. Immuta will use this system account continuously to crawl the database you register.

2. ​Grant this account the SELECT Teradata privilege on the DBC user.

Register a Teradata connection

1. In your Teradata environment, create an Immuta database that Immuta can use to connect to your Teradata instance to register the connection and maintain state with Teradata.

   Having this separate database for Immuta prevents custom ETL processes or jobs deleting the database you use to register the connection, which would break the connection.

2. In Immuta, click Data and select Connections in the navigation menu.

3. Click the + Add Connection button.

4. Select the Teradata tile.

5. Enter the host connection information:

   1. Display Name: This is the name of your new connection. This name will be used in the API (connectionKey), in data source names from the host, and on the connections page.

   2. Hostname: Your Teradata host (e.g., your-host.env.teradata.com )

   3. Port: Port configured for Teradata.

   4. Database: The Teradata database you created for Immuta. All databases in the host will be registered.

   5. SSL Mode: Use the dropdown to select your SSL mode.

   6. SSL Protocol: Based on your SSL mode selection, also select the protocol.

6. Select Username and Password or LDAP from the dropdown.

7. Enter the username and password of the Teradata user you created above.

8. Click Save connection.