what is the full Teradata Client software?

teradata
Krish212124 picture Krish212124 · Jan 23, 2012 · Viewed 13k times · Source

I read couple of online documents to get start with the Teradata basics.

I am curious to know what is full client version of Teradata client software to install on Windows/unix/Linux environments? What is best suited for client install?

I see different client versions depends on the type 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

To more clarity on my Question .. DB2 and Oracle have a full client software which can install locally on windows/unix systems and it will be able to use or all type connectivity(odbc,jdbc,ole db,ado .net...etc)

Answer

Rob Paller picture Rob Paller · Jan 24, 2012

Typical base toolset for end users/developers submitting ad hoc queries from each environment:

Windows (TTU 13.10 Client Install - 400MB)

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

Linux/UNIX/Mac OS X

  • Teradata JDBC Driver
  • Teradata Studio Express
  • (Optional - if using Eclipse)Teradata Plug-in for Eclipse

Many of these components can be found in the Teradata Developer's Exchange Downloads section. Starting with Teradata 12 they have reset the version numbers in an attempt to address the confusion with the different development life cycles of each component contained within their Tools and Utilities. Tools for Teradata 13.x should be compatible with Teradata 12 and Teradata 14. However, certain features specific to a given database release may not be available unless you are using a version of the client that is equal to or greater than the database version.

For ETL Development, then you will be relying upon the BTEQ, FastLoad, FastExport, MultiLoad combined with the Teradata CLI to connect to Teradata.

Related questions

SQL SELECT multi-columns INTO multi-variable

I'm converting SQL from Teradata to SQL Server in Teradata, they have the format SELECT col1, col2 FROM table1 INTO @variable1, @variable2 In SQL Server, I found SET @variable1 = ( SELECT col1 FROM table1 ); That only allows a single column/variable …

Read More
What is ROWS UNBOUNDED PRECEDING used for in Teradata?

I am just starting on Teradata and I have come across an Ordered Analytical Function called "Rows unbounded preceding" in Teradata. I tried several sites to learn about the function but all of them uses a complicated example explaining the …

Read More
Find which rows have different values for a given column in Teradata SQL

I am trying to compare two addresses from the same ID to see whether they match. For example: Id Adress Code Address 1 1 123 Main 1 2 123 Main 2 1 456 Wall 2 2 456 Wall 3 1 789 Right 3 2 100 Left I'm just trying to figure out whether the address for each ID …

Read More