Configuring Staging Databases

Teradata Data Mover User Guide

Analytical Ecosystem
Teradata Data Mover
User Guide
You can configure and manage default staging databases. You can configure separate staging databases for tables and for temporary artifacts, including macros and error, log, and work tables.
  1. In the Daemons column, click the name of the daemon you want to configure.
  2. In the Daemon Setup column, click Staging Databases.
  3. Under Source Staging Database For Tables, click Add Staging Database. The Connect to System dialog box appears.
  4. In the Connect to System dialog box, enter the logon information.
  5. Click Next. The Select a Database dialog box appears.
  6. Click next to Select a Database. You can use the filter to display only the items that match the characters you enter.
  7. Click OK. The system and staging database display.
  8. [Optional] Click to add another staging database.
  9. [Optional] Click to remove a staging database.
  10. Under Target Staging Database For Tables and Target Staging Database For Temporary Artifacts, click Add Staging Database and repeat steps 4 through 9 for each.
  11. Click Apply. If the operation is successful, appears. If the operation fails, appears. Verify the settings are correct and try again.