Which connectivity option should I use?

Connectivity
Enthusiast

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?

Cheers.

Tags (3)
2 REPLIES
Teradata Employee

Re: Which connectivity option should I use?

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

Enthusiast

Re: Which connectivity option should I use?

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