INFO

Column-level Lineage is not currently supported for Teradata.

Steps to complete:

  1. Install HASH_MD5 user-defined function
  2. Configure user in Teradata
  3. Create schema for Datafold
  4. Configure your data connection in Datafold

​
Install HASH_MD5 user-defined function

Follow the steps here for the database that Datafold will be connecting to (e.g., DB1).

Once completed, execute the following SQL commands in the database:

ALTER FUNCTION HASH_MD5 COMPILE;
ALTER FUNCTION HASH_MD5 EXECUTE NOT PROTECTED;

​
Configure user in Teradata

To connect to Teradata, create a user with read-only access to all databases you may wish to diff, including the login database:

CREATE USER DATAFOLD AS PERMANENT=1000000000 BYTES PASSWORD= <PASSWORD> COLLATION = ASCII TIME ZONE ='GMT';
GRANT EXECUTE FUNTION ON DB1 TO DATAFOLD;
GRANT SELECT ON DB1 TO DATAFOLD;
...
GRANT SELECT ON DB9 TO DATAFOLD;

​
Create a temporary database for Datafold

Datafold requires a database to store temporary data with full permissions:

CREATE DATABASE DATAFOLD_TMP AS PERMANENT=10000000000 BYTES;
GRANT ALL ON DATAFOLD_TMP TO DATAFOLD;

​
Configure in Datafold

Field NameDescription
Connection NameA name given to the data connection within Datafold.
HostThe hostname for your Teradata instance (e.g., account-name-2e3ba8b32qac9d.env.clearscape.teradata.com for Teradata SaaS).
PortTeradata endpoint port; the default value is 1025.
User IDUser ID, e.g., DATAFOLD.
PasswordPassword from above.
DatabaseThe connection database, e.g., DB1 from above.
Database for Temporary TablesThe temporary database, e.g., DATAFOLD_TMP from above.

Click Create. Your data source is now ready!

StarburstNetezza