All Forums Connectivity
adam.mcdonnell 5 posts Joined 02/13
24 Feb 2013
Which connectivity option should I use?

Hi there. My organisation is just beginning with Teradata development, and I'm wondering which connectivity option (.NET Provider, ODBC etc) we should use. We develop against version 4 of the .NET framework using Visual Studio 2010 and 2012. Could anyone recommend one connectivity option over the others, or perhaps list the pros and cons of each?

NetFx 346 posts Joined 09/06
13 Mar 2013

I assume you are asking about the "Microsoft .NET Data Provider for ODBC" and the ".NET Data Provider for Teradata".
The answer is very simple; use the ".NET Data Provider for Teradata"; the top four reasons are:
1- Teradata supports the .NET Data Provider for Teradata. We do not support "Microsoft .NET Data Provider for ODBC".
2- ".NET Data Provider for Teradata" has custom features (e.g. TdDecimal, TdNumber and list goes on). 
3- Simple setup and deployment options.
4- ".NET Data Provider for Teradata" is faster than the "Microsoft .NET Data Provider for ODBC".

adam.mcdonnell 5 posts Joined 02/13
13 Mar 2013

Looks like I made the right decision, thanks :-)

You must sign in to leave a comment.