There is now a new command line interface to Teradata Parallel Transporter!
TPT users have been asking for this for a while now, and we have delivered. We will explore here a brief summary of what it is and how to use it.
The command line name for this feature is "tdload". "tdload" is a front end "wrapper" to TPT that enables the user to load data from a (comma) delimited flat file into Teradata; without the need for writing a script!
We use the Unix convention command line options for the user to provide us with the necessary essentials (i.e. file name, user name, password, target table name, etc.).
The syntax is as follows (for example):
tdload -f filename -u username -p password -h hostname -t tablename
and the command line options are:
-f file name
-u user name
-h host name (tdpid)
-t target table name
-d delimiter character
-j job variable file
The default delimiter character is the comma (",") but this can be changed easily on the command line.
We also provide multi-letter command line options for those who want a little more control over their load job:
Single-letter command line options use a single hyphen; multi-letter command line options use double hyphen.
"tdload" also has the intelligence to determine the best loading method. It will first detect whether it is possible to use the Load operator (FastLoad protocol). If not, then it will check whether the Update operator can be used (MultiLoad protocol). If the target table cannot be loaded by either of those operators, then "tdload" will check whether the Stream operator (TPump protocol) is installed. If so, then the Stream operator will be used. If not, then the load job will use the SQL Inserter operator.
Under the covers, "tdload" will generate the TPT script and then run TPT. When the job is complete, "tdload" will delete the script, so there is no footprint. Since "tdload" is a feature of TPT, the output binary logs will still be generated.
Just like TPT, "tdload" supports the use of a job variable file. The job variable file for "tdload" supports the single-letter command line options and the multi-letter command line options. "tdload" will perform the necessary conversions to job variables and attributes that TPT understands.
Easy Loader is available as an efix to TPT 13.0. It is only available on the patch server and all 4 packages must be downloaded in order to get this feature, as we had to make changes to the TPT Infrastructure as well as the Load, Update and Stream operators.
Also, there is a README file on the patch server that provides more detailed information.