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

Click Create. Your data source is now ready!