Teradata Utilities - BTEQ, FastLoad, FastExport, TPT
Tutorials about Teradata utilities incl. BTEQ, FastLoad, FastExport, TPT, etc.
Examples are provided about loading XML, JSON and CSV files into Teradata and also about exporting data from Teradata database.
Load JSON File into Teradata via BTEQ
BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. It also works with XML and JSON files too. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This ...
Load XML File into Teradata via BTEQ
BTEQ is a Teradata utility tool that can be used to run Teradata SQL statements incl. DDL, DML, etc. It can also be used to import data from text file into Teradata databases. Like TPT and FASTLOAD, it can run in both batch and interactive modes. This article demonstrates how to load XML file into ...
Export CSV File via TPT
Teradata Parallel Transporter (TPT) provides rich functions to load data into Teradata and to export data. In article Load CSV into Teradata via TPT , it shows how to load CSV files into Teradata. This page provides examples to export data from Teradata to CSV. Use TPT wizard GUI tool to create a ...
Export Text File via Teradata FastExport
Teradata FastExport is a command utility tool that can transfer large amount of data from Teradata database to a file. One of the commonly used scenarios is to export data from a table or view to a text file and then load the export file into a different server. Follow the following ...
Teradata FastLoad with Optional Quotes
In article Teradata FastLoad - Load CSV File , it shows how to load CSV into Teradata. The input file is very basic CSV file. This article expands on that to provide examples about loading CSV files with optional quoted fields to skip delimiters. It also shows how to load files with ...
Teradata FastLoad Skip Header Line
Teradata FastLoad can be used to load CSV/TSV or other delimited files into database. Refer to article Teradata FastLoad - Load CSV File for more details about how to load CSV into Teradata. This article shows how to skip header line or multiple lines in the input file. Create a ...
Teradata FastLoad - Load CSV File
Teradata FastLoad is a command line utility that can be used to load large amount of data into an empty table on Teradata database. The performance will be greater than line by line or batch processing mechanism. This article provides example of using FastLoad to load CSV file into Teradata ...
Load CSV into Teradata via TPT
TPT (Teradata Parallel Transporter) is a client suit that support multiple instances of data extracting, loading, and updating functions in a scalable, high-speed, parallel-processing environment. It utilize other client tools like FastLoad, FastExport, MultiLoad, etc. It is written with Java ...