Teradata Loader

The Teradata Loader allows you to load data to any Teradata database configured in the Spectrum Data Integration platform.
Note: The loader is supported only on Windows systems.
Option Name Description

Connection

Select the database connection you want to use. Your choices vary depending on what connections are defined in the Connection Manager of Spectrum Management Console. If you need to make a new database connection, or modify or delete an existing database connection, click Manage Connections.

If you are adding or modifying a database connection, complete these fields:
Connection name
Enter a name for the connection. The name can be anything you choose.
Database driver
Select the appropriate database type.
Connection options
Specify the host, port, instance, user name, and password to use to connect to the database.
Table/View Click the browse button ([...]) to navigate to the table or view you want to use.
Database fields This column lists the field names in the database. You cannot modify these field names.
Stage fields This column lists the field names used in the dataflow. You cannot modify these field names.
Types This column lists the data type of each field.

Runtime Tab

Option Name Description
Load method
Specifies the method of writing data to the Teradata database tables.
  • Select Insert to write data to an empty table
  • Select Append to write data to an existing data table.
  • Select Truncate and Insert to truncate the data before writing it to the database table.
Log file folder Select the folder location for saving the log files of the upload process.
Generate bad file Mark this check-box to generate a log of the records that failed to get uploaded.
Bad file folder Select the folder location for saving the log of failed records. The log gives details, such as error codes and error field names of the failed records.
Maximum errors allowed Specify the limit of permitted errors for the upload session. If the number of errors exceeds this value, the upload process pauses.
Note: Multiple runtime instances are not supported for Teradata Loader.