Archives of the TeradataForum

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

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

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