Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 02 Feb 2009 @ 13:59:53 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Data acces from JDBC, ODBC and CLI
From:   Anomy Anom

<-- Anonymously Posted: Mon, 2 Feb 2009 08:51 -->

On the Teradata side they are all talking to the same gateway (TCP listener). The real difference is on the client side.

CLI is the lowest level - most flexible and potentially highest performance but a lot more coding effort. ODBC is much easier to code but available performance features are somewhat constrained by adherence to the standard API. JDBC is somewhere in between - the standard lends itself to additional "extensions" that ODBC does not. And if your client is Windows, strongly consider using the OLEDB or .NET provider rather than ODBC.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016