Teradata

Steps to complete:

1. Configure user in Teradata
2. Create a temporary database for Datafold
3. Configure data connection in Datafold

​

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 FUNCTION 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 Name	Description
Connection Name	A name given to the data connection within Datafold.
Host	The hostname for your Teradata instance (e.g., account-name-2e3ba8b32qac9d.env.clearscape.teradata.com for Teradata SaaS).
Port	Teradata endpoint port; the default value is 1025.
Username	The user, e.g., DATAFOLD.
Password	Password from above.
Database	The connection database, e.g., DB1 from above.
Database for Temporary Tables	The temporary database, e.g., DATAFOLD_TMP from above.
Transaction mode	Session transaction mode; defaults to ANSI. Choose TERA only if your environment requires Teradata-mode transaction semantics.

Click Save. Your data connection is now ready!