All Forums Training
googinup 15 posts Joined 06/12
03 Aug 2012
Introduction to Teradata Client Software ( www.olineinformaticatraining.com )

Teradata Client  Software components include:
 
  BTEQ
Basic Teradata Query is a general-purpose program that you can use to submit data,
commands and SQL statements to Teradata RDBMS.  
 
  C / COBOL / PL/I  preprocessors

If you use embedded SQL to develop client applications, you need these tools to pre-compile your programs.
 
  CLI
 
  ODBC
 
  TDP/MTDP/MOSI
 
  Achieve/Restore data to/from tape (ASF2)
 
  Queryman

Queryman is based on ODBC, you can logon through a DSN and enter any SQL
statement to manipulate the data in database.
 
  FastLoad
 
  MultiLoad
 
  FastExport
 
  Open Teradata Backup (OTB)
 
  Tpump
 
  Teradata Manager
 
  WinDDI

 
 
All client components are based on CLI or ODBC or Both of them. So, once you install the client
software, you should configure these two components appropriately before you execute these
client utilities.  
 
Teradata RDBMS is able to support JDBC programs in both forms of application and applet. The
client installation manual mentions that we need to install JDBC driver on client computers, and
we also need to start a JDBC Gateway and Web server on database server. Teradata supports at
least two types of JDBC drivers. The first type can be loaded locally and the second one should
be downloadable. In either of two ways, to support your development, you need local JDBC
driver or Web server / JDBC Gateway running on the same node on which Query Manager is
running. But in the setup CD we received, there is no JDBC driver and any Java Development
Tools. Moreover, Web server is not started on tour system yet.

 

for more information regarding trainig and certification of teradata

visit : http://www.onlineinformaticatraining.com/online- teradata-training/

You must sign in to leave a comment.