Preparing to run the Teradata collector
Setting up pre-requisites for running the collector
Make sure that the machine from where you are running the collector meets the following hardware and software requirements.
Item | Requirement |
---|---|
Hardware (for on-premise runs only) | |
RAM | 8 GB |
CPU | 2 Ghz processor |
Software (for on-premise runs only) | |
Docker | Click here to get Docker. |
JDBC Driver | |
data.world specific objects (for both cloud and on-premise runs) | |
Dataset | You must have a ddw-catalogs (or other) dataset set up to hold your catalog files when you are done running the collector. If you are using Catalog Toolkit , follow these instructions to prepare the datasets for collectors. |
Network connection | |
Allowlist IPs and domains |
Setting up database, user, and permissions in Teradata
The collector harvests metadata from Teradata using username and password authentication. This section walks you through the process of creating this user. See the Teradata documentation for more details on database privileges, users, roles, and profiles and Users, Roles and Profiles syntax and examples.
Important
You will use this information while setting up the collector parameters.
To set up an user to harvest from a target database:
Create a new user.
CREATE USER <user> as perm=60000000 BYTES, password=<password>
Grant select on privileges to the DBC to harvest extended metadata for databases, tables, views, user defined functions, stored procedures, triggers and user defined types.
GRANT SELECT ON <database> TO <user> GRANT SELECT ON DBC TO <user>