Teradata Utilities - BTEQ, FastLoad, FastExport, TPT

local_offer teradata local_offer teradata-utilities

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 ...

local_offer teradata local_offer teradata-utilities

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 ...

local_offer teradata local_offer teradata-utilities

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 ...

local_offer teradata local_offer teradata-utilities

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 ...

local_offer teradata local_offer fastload local_offer teradata-utilities

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 ...

local_offer teradata local_offer fastload local_offer teradata-utilities

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 ...

local_offer teradata local_offer fastload local_offer teradata-utilities

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 ...

local_offer teradata local_offer teradata-utilities

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 ...