Skip to main content

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.

Table 1.

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

The Teradata 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

Follow these instructions to configure your network.



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:

  1. Create a new user.

    CREATE USER <user> as perm=60000000 BYTES, password=<password>
  2. 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>