Teradata

The Teradata connector for rudol allows you to connect your Teradata data warehouse instance.

Connection parameters

Name	Type	Description
Hostname	text	Publicly accessible Teradata server hostname
Port	number	Server port number (1025 by default)
User	text	Teradata user name, see User permissions
Password	password	Teradata user password

User permissions

To ensure that rudol has the required permissions to retrieve your database metadata, we recommend creating a new Teradata user. Create and assign a profile to this user, limiting access to only the necessary database objects you intend to integrate with rudol.

info

You can check the docs on how to create a Teradata DB profile here

Here is a sample code to create a new role, profile and user for rudol with minimal permissions:

CREATE ROLE rudol_role;

GRANT SELECT, EXECUTE ON your_database TO rudol_role;

CREATE PROFILE rudol_profile AS
ACCOUNT = ('your_account')
SPOOL = 536870912 -- Pool size of 512 MB, adjust if necessary
DEFAULT DATABASE = your_database;

CREATE USER rudol_user 
AS 
DEFAULT ROLE = rudol_role,
PERMANENT = 536870912 -- Pool size of 512 MB, adjust if necessary
PASSWORD = ABC123;

MODIFY USER rudol_user AS 
PROFILE = rudol_profile;

Restrict connections by IP Address

You can also restrict access to only accept incoming connections from the rudol public IP Address. Check here for more information: Security and Privacy