What is the complete Teradata Client software?

Question

I read several online docs to get you started with the basics of Teradata.

I am curious to know what is the full Teradata client version for installation on Windows / unix / Linux? What is best for installing a client?

I see that different versions of the client depend on the types of drivers / applications

1. Teradata JDBC 2. Teradata ODBC 3. Teradata dot net provider 4. Teradata SQl assist/BTSE 5. Teradata Express 6. Teradata OLE DB provider 7. TTU .... etc 

For more clarity in my question .. DB2 and Oracle have full client software that can be installed locally on windows / unix systems and it can use all types of connections (odbc, jdbc, ole db, ado.net ... etc.)

Answer 1

A typical basic set of tools for end users / developers sending special requests from each environment:

Windows ( TTU 13.10 Client Installation - 400 MB)

• Teradata SQL Assistant
• Teradata.Net Provider and / or ODBC Driver
• Teradata GSS and ICU Libraries.
• (optional) WinBTEQ
• (optional) CLI Teradata - for WinBTEQ

Linux / UNIX / Mac OS X

• Teradata JDBC Driver
• Teradata studio express
• (Optional - when using Eclipse) Teradata Plugin for Eclipse

Many of these components can be found in the Teraata Developer Exchange Downloads section. Starting with Teradata 12, they have reset version numbers in an attempt to eliminate confusion with the different development life cycles of each component contained in their Tools and Utilities. Teradata 13.x tools must be compatible with Teradata 12 and Teradata 14. However, some features related to this version of the database may not be available if you are not using a client version that is equal to or greater than the database version.

For ETL development, you will rely on BTEQ, FastLoad, FastExport, MultiLoad in conjunction with the Teradata CLI to connect to Teradata.

Answer 2

This answer is for Windows only. To run queries on the Teradata database, you need the following:

• Teradata SQL Assistant
• Teradata.NET Data Provider
• ODBC Teradata li driver>

To find out if the Teradata ODBC driver is on your system, select "Control Panel", "Administrative Tools" → "Data Sources" → "Add" and see if Teradata is turned on.

Example screenshot below:

Answer 3

If you are working on a new database and (if you have a license to use), you can take a look at the Teradata parallel transporter. It provides extraction capabilities with custom scripts.