![]() |
The .NET Data Provider for Teradata is an implementation of the Microsoft ADO.NET specification. It provides direct access to the Teradata Database and integrates with the DataSet. .NET Applications use the .NET Data Provider for Teradata to load data into the Teradata Database or retrieve data from the Teradata Database.
17 Jun 2022
,
|
![]() |
Hi,
24 Aug 2016
,
|
![]() |
Hi,
16 Dec 2015
| 2 comments
,
|
![]() |
I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)
21 Nov 2015
| 1 comment
,
|
![]() |
I have a VB2012 application that I have successfully setup to connect to our Teradata server. I have set it up using the data adapter for .NET. With my testing I can hit the Teradata db via the TdDataReader or TdDataAdapter (resultsing in a DataTable) and all that is working great.
04 Nov 2014
,
|
![]() |
I have the following unit test which is failing due to a TdException with the message "[Teradata Database] [2689] Field is null for column defined as NOT NULL."
23 Jul 2014
| 2 comments
,
|
![]() |
I am attempting to execute a parametrized non-query SQL command using TdCommand.ExecuteNonQuery(). The parameter in question is DbType.DateTimeOffset and TdType.TimestampWithZone; the parameter value was generated using DateTime.Now and appears to be completely defined (as verified via the Visual Studio debugger).
22 Jul 2014
| 1 comment
,
|
![]() |
Hello,
16 Jul 2014
| 4 comments
,
|
![]() |
This will be part 1 of a multi-part blog about how the .NET Data Provider for Teradata 15.0 can now In-Line Large Objects (LOB) that are sent to a Teradata Database when executing an INSERT or UPDATE statement. This first blog will introduce In-Lining of LOB. Blogs will also be written that discuss how to take advantage of this featur
14 Jul 2014
,
|
![]() |
.NET Data Provider for Teradata version 14.11.0.1 (or above) supports integration with Visual Studio 2012 and Visual Studio 2013. This exposes the .NET Data Provider for Teradata objects necessary for development of ADO.NET applications utilizing the Teradata Database within Microsoft Visual Studio 2012 and 2013.
30 Jan 2014
| 3 comments
,
|
![]() |
I am using the Teradata 13.10 virtual machine and I have assigned it a static IP address (192.168.88.10) for host only access. I am able to connect via BTEQ - .LOGON 192.168.88.10/dbc,dbc - and with SQL Assistant. When I try to connect via the .NET provider, I get an error saying that it cannot resolve 192.168.88.10 to an IP address.
22 Jan 2014
| 1 comment
,
|
![]() |
Alright. So I looked at this page: http://developer.teradata.com/doc/connectivity/tdnetdp/14.10/webhelp/EntityProviderCanonicalFunctions.html. It mentions that canonical functions for .NET 4.0 are supported under the "Teradata" namespace. Where in the world is this namespace?
20 Jul 2013
| 6 comments
,
|
![]() |
We perform ETL on a table of transactions. After loading the transaction table, we want to use Stored Procedures (SPs) to perform the very complex business validations, and then to apply the transactions against a dozen permanent state tables.
18 Mar 2013
,
|
![]() |
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?
24 Feb 2013
| 2 comments
,
|
![]() |
Teradata Database supports Inline and Deferred Large Object Retrieval modes. The LOB retrieval modes control the content of rows and accessibility of LOB columns.
24 Dec 2012
,
|
![]() |
The following reference documentation is available:
03 May 2012
,
|
![]() |
The Teradata Database has support for several data types where there is no equivalent Framework Class Library (FCL) type. For these types, the Teradata Data Provider has a corresonding Provider Specific Type. All the provider types support:
20 Apr 2012
,
|
![]() |
After following the the example shown here :
http://developer.teradata.com/blog/tnguyen/2010/11/retrieving-entity-types-with-a-stored-procedure
26 Mar 2012
| 1 comment
,
|
![]() |
This is a brief introduction to the new provider specific type called TdNumber . It will be released in the 14.0 version of the .Net Data Provider for Teradata. This new type corresponds to the NUMBER data type introduced in 14.0 release of the Teradata Database.
30 Dec 2011
,
|
![]() |
Support for a new dynamically allocated parameter type (TD_ANYTYPE) is available in Teradata Database 14.0. This Teradata enhancement supports input and result parameter types that may be defined dynamically at execution time. The use of the TD_ANYTYPE data type definition in functions and external stored procedures will be discussed.
20 Dec 2011
,
|
![]() |
Im able to connect to teradata DB through SQL assistant with required credentials But unable to connect to teradata through .Net ODBC The connection string that i used is driver={Teradata};DBCName=provided Server address; UID=*****;PWD=*****;
Pls let me know if anything is needed
06 Dec 2011
| 2 comments
,
|
![]() |
Hi, I am new to using Teradata and am trying to use it with vb.net to build a user app. Can anyone please tell me how to call a teradata sp from vb.net (Visual Studio 2005) I have a simple sp with input and output parameters, something like:
09 Nov 2011
| 2 comments
,
|
![]() |
The Open Data Protocol (OData) is a protocol to share or exchange data over the web. The protocol was developed by Microsoft in 2007 as part of the ADO .NET Data Services technology (a.k.a. Project Astoria) for creating and consuming data services using the Web. This protocol became widely used that Microsoft gave the protocol its own identification, named it OData and considered ADO.NET Data Services as the .NET implementation of OData.
19 Oct 2011
,
|
![]() |
Using Sql server and connecting to Teradata 13.0 using 64 bit .net bring data FROM Teradata - everything is fine
23 Aug 2011
,
|
![]() |
I'm trying to run a query from a search form by date and I'm receiving the following error: [Teradata Database] Partial string matching requires character operands. The code for the search is: ElseIf OptDate.Checked = True Then
01 Aug 2011
| 1 comment
,
|
![]() |
The Entity Provider for Teradata 13.10 did not support the VIEWS and VIEWCOLUMNS store schemas. Therefore, views were not accessible when using the EDM Wizard.
11 Apr 2011
| 9 comments
,
|
![]() |
TdCommandBuilder class, part of the .NET Data Provider for Teradata, generates Insert, Update and Delete commands for a Batch Update. But How can you associate a Transaction with CUD commands given that you have no direct control over the Command generation?
08 Apr 2011
,
|
![]() |
Hi, This setup requires the .NET Framework 2.0 or greater. Please install the .NET Framework 2.0 and run this setup again.
09 Feb 2011
| 3 comments
,
|
![]() |
This blog describes how to convert .NET Data Provider for Teradata Learning Examples from C# to VB or C++.
22 Dec 2010
| 2 comments
,
|
![]() |
Data Source with Fully Qualified Domain Name can speed up logons plagued with slow "Name to IP-Address resolution".
17 Dec 2010
,
|
![]() |
In this BLOG I will describe how to register a .NET Data Provider with the ADO.NET DbProviderFactories Class.
16 Dec 2010
| 2 comments
,
|
![]() |
A common question about the Entity Framework(EF) is how to use stored procedures within the framework for insert, update and delete operations. The answer is that leveraging stored procedures for insert, update and delete is actually a built-in capability of EF.
22 Nov 2010
,
|
![]() |
A Stored procedure that is defined in a database can be exposed in a conceptual model in two ways:
22 Nov 2010
| 2 comments
,
|
![]() |
The .NET Data Provider for Teradata is integrated with Microsoft's Visual Studio 2005 and 2008. This article addresses the Visual Studio Server Explorer integration with a Teradata data connection and the various database objects that are supported.
18 Nov 2010
,
|
![]() |
18 Nov 2010
,
|
![]() |
This blog will show you how to retrieve the SQL statement that is generated by the Entity Provider when it processes a LINQ to Entities or Entity Sql statement. LinqPad will be used to show you how this can be done. The blog Using LINQPad to Access Teradata
12 Nov 2010
,
|
![]() |
In this blog I am going to show you how to setup LINQPad v2.26.2 to access a Teradata Database. LINQPad is a very flexible query tool. I use LINQPad to primarily execute LINQ to Entities and Entity Sql statements against Teradata when testing the Entity Provider for Teradata. It is free to use and is available here:
12 Nov 2010
,
|
![]() |
Support for the Entity Framework 3.5 SP1 is coming in .Net Data Provider for Teradata (TDNETDP) 13.10. This release of the Data Provider for Teradata includes the Entity Provider for Teradata.
04 Nov 2010
| 6 comments
,
|
![]() |
26 Oct 2010
| 1 comment
,
|
![]() |
14 Oct 2010
| 1 comment
,
|
![]() |
Microsoft Visual Studio DataSet designer generates code (C#/VB.NET) to read data from a .NET Data Provider data source or apply changes to the data source. DataSet designer generates parameterized queries and sets the properties of DbParameter object to the corresponding column data type attributes.
09 Oct 2009
,
|
![]() |
Hi: I left this post on the main Teradata website forum, but I thought this might be more appropriate and perhaps get a response. Thanks for taking a look. I just found this little nook inside of Teradata and I'm glad it exists. I've created a Windows named pipe in a vb.net application using the System.IO.Pipes namespace. I'm creating a pipe, my process appears to be connecting to the pipe block and waiting to read and now I would just like to feed the pipe from Teradata.
11 Sep 2009
| 5 comments
,
|
![]() |
This blog discusses how Query Bands have been implemented in the .Net Data Provider for Teradata 13.01.00.00.
04 Aug 2009
,
|
![]() |
Microsoft and Teradata worked together last year to integrate SQL Server Reporting, Analysis and Integration Services with Teradata Database. Some MSDN links that provide additional information:
02 Jun 2009
,
|
![]() |
.NET Framework has a very broad support for Asynchronous operations including a well defined Asynchronous Programming Model. All asynchronous operations are started by invoking a Begin method; later a corresponding End method is invoked to retrieve the result.
21 May 2009
,
|