Prerequisites¶

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Before you install and use the Teradata OCF connector, perform the following:

Configure Network Connectivity
Create a Service Account
Grant Required Permissions

Configure Network Connectivity¶

Open outbound TCP port to the Teradata server. Ensure that the Alation server can reach the Teradata server over this port. The default port is 1025.

Create a Service Account¶

Sample SQL to create an account:

CREATE USER alation1 from “dbc” AS PERM = 100000000 SPOOL = 100000000 PASSWORD = "123" NO FALLBACK NO BEFORE JOURNAL NO AFTER JOURNAL DEFAULT CHARACTER SET LATIN DATEFORM=INTEGERDATE;

Grant Required Permissions¶

The service account you want to use requires a specific set of permissions on Teradata.

Grant Permissions for Metadata Extraction¶

Ensure the user alation has the following privileges on system tables.

Required Permissions	Purpose
`GRANT SELECT ON dbc.dbase TO alation`	Grants permissions on schemas.
`GRANT SELECT ON dbc.databasesv TO alation`	Grants permissions on schema.
`GRANT SELECT ON dbc.tablesv TO alation`	Grants permissions for Tables ,Views, Columns, Functions, Function Definitions
`GRANT SELECT ON dbc.tabletextv TO alation`	Grants permissions on tables, and views.
`GRANT SELECT ON dbc.tablesizev TO alation`	Grants permissions on tables.
`GRANT SELECT ON dbc.columnsv TO alation`	Grants permissions on columns.
`GRANT SELECT ON dbc.indicesv TO alation`	Grants permissions on primary key and indexes
`GRANT SELECT ON dbc.all_ri_parentsv TO alation`	Grants permission on foreign key.
`GRANT SELECT ON dbc.indexconstraintsv TO alation`	Grants permissions on functions, function definitions.
`GRANT SELECT ON dbc.tvm TO alation`	Grants permissions on functions, function definitions.
`GRANT SELECT ON dbc.tvfields TO alation`	Grants permissions on columns

If permissions for the DBase table are not granted and only the DatabasesV view is allowed, then disable the Extract Schemas From DBASE option on the Metadata Extraction tab.

Grant Permissions for Sampling and Profiling¶

For sampling and profiling, grant the service account the SELECT permissions on all schemas and tables that you want to retrieve samples from.

Grant Access Rules¶

Grant the following access rules to the service account:

GRANT SELECT ON dbc.rolemembersv TO alation;
GRANT SELECT ON dbc.allRoleRightsv TO alation;
GRANT SELECT ON dbc.databasesv TO alation;
GRANT SELECT ON dbc.allrightsv TO alation;