All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
Teradata .NET data provider - LEFT() function doesn't work in both V13.x and V14.x of SQL Assistant? Topic by ChrisMelitaDiaz 05 Jun 2015 LEFT()

Just wondering why the string function LEFT() doesn't work with the Teradata .NET provider in both versions of SQL Assistant V13.x and v14.x.  It works perfectly well when use ODBC with SQL Assistant the same function.  I had to convert to substr() to make it work for both ODBC and Teradata .NET.  Unfortunately I'm forced to use ODBC at the client side.  Do I need an updated driver?  Is there a

3 replies, 5 years ago
.NET Data Provider Teradata - Session Issue - Volatile Table Topic by Thomas_D_W 02 Jun 2015 NET provider, siss, volatile tables, stored sprocedure

Teradata Fans,

2 replies, 5 years ago
Unable to connect to TERADATA from SSIS ADO.Net source Topic by GTREDDY 27 May 2015

Hi All ,
I m trying to connect to TERADATA server from SSIS using .Net Providers\.Net data provider for TERADATA. After giving the server name and credentials i m getting the below error.    

1 reply, 5 years ago
Does TeraJDBC works with JDK/JRE 8 version? Topic by s_reddy 01 Mar 2015

From the latest version of TeraJDBC .It's currently works with JDK/JRE 1.4.2, 5.0, 6.0, or 7.0.
Is there any TeraJDBC version that is supporteed and works with JRE8?

5 replies, 5 years ago
Issue Loading Records from Informatica to Teradata Using Odbc Connection Topic by Guha 29 May 2015

Hi Everyone,

It is a strange issue, I am loading few records from SAP source to Target TD table through Informatica after ABAP generation. Now the issue is that every time I load with any range of Data reading from param file, its always the first 2 records gets rejected.

Issue on session log is - [Teradata][ODBC Teradata Driver] Invalid date/time/timestamp value

0 replies
Teradata ODBC Soutrce Topic by joger 24 Jan 2015 odbc, teradata, source, error, localhost

Hello. Unfortunatelly the net is really empty with that information. I didn't find anything right about that. Please, help me with that common problem. I can't connect my Teradata SQL Assistant to ODBC Teradata Source. I'm working alone at my home pc (local host). I've got mysql client and database where i was studying sql first.

11 replies, 5 years ago
unable to connect to Teradata server from ssis Topic by GTREDDY 26 May 2015 please provide the solution

unable to connect to Teradata server from ssis

0 replies
Install DBD::ODBC using DataDirect Driver Manager Topic by islanderman 26 May 2015

Please help.  Vhari, you helped me on this in the past and I'm hoping you can help here as well.

0 replies
OLEDB Authentication Connection String Attribute Topic by toadrw 02 Oct 2009 oledb connection string authentication


I'm trying to add authenticatio to an OLEDB connction string. What is the correct format?

I'm looking for something like this possibly:

Authentication=ldap;Authentication Parameter=params;

The Teradata manuals only have an example of the Teradata Connection Dialog, but I'm unable to tell how this translates into a connection string. Thanks.

5 replies, 5 years ago
Import data from Teradata 14.0 to Hive Table Topic by nirmal_hbti 22 Apr 2014 Hive, hadoop, teradata connector for hadoop

Hi All,
I am using teradata-connector-1.2.1 with the following versions:
->Teradata 14.0
->HDP 2.0(Hadoop
->Hive 0.11

I am trying to import data from teradata tables to Hive.
/*Created table and inserted a row in teradata*/
CREATE MULTISET TABLE example3_td ( c1 INT,c2 VARCHAR(100));

1 reply, 5 years ago
UDFs using C which needs to get data from a Teradata Table Topic by cteagle5 11 May 2015

Hello all,
I have an intersting dilema. We need to create some UDFs which call a C program. This C program will perform some processing on the incoming data and then perform a lookup into a Teradata table. The data will come back and the UDF will in turn go back to the SQL and then perform the same function for the next row.

0 replies
Connection string of Teradata for Topic by mahendragurav 05 Feb 2015

    I want put teradata connection strng inside the web.config file and open it in .net code behind to access Teradat. I tried as belo
 <add name="TDCnnString" connectionString=";Initial Catalog=yyy; User ID=xxx; Password=xx123"/>
  And in code behind

3 replies, 5 years ago
Which Teradata drivers support data encryption? Topic by peeperj 14 Jan 2014

We have a 12 year old classic ASP web application that uses an ODBC Teradata driver.  It does only selects from the database.  We are being told by our local Teradata administrator to use the new .net version 14 driver.  Does anyone know if this driver will work with classic ASP or will some version of the ODBC or OLEDB Teradata drivers support data encryption as well?

8 replies, 5 years ago
Mac/OSx TTU or CLI Target or Release Dates? Topic by MadMac 17 Dec 2013

Does anyone know the Target Date or Release Date for an OSx TTU release? 

3 replies, 5 years ago
Teiid Designer table metadata read through teradata jdbc connect slow >30sec. Topic by cb11 05 May 2015 jdbc_metadata_fetch_slow

Hello,  I am using a Data Virtualization tool, Teiid Designer, to create a teradata "source model" which is fetching metadata for each table I select for the model.  This connectivity is supported using JDBC connection URL  "jdbc:teradata://database/tmode=ANSI".

1 reply, 5 years ago
Connection error with Eclipse Kepler to Teradata Topic by tomcat711 24 Apr 2015

Hi All,
Trying to connect to Teradata by using Eclipse Kepler. By testing connection I am getting the msg that ping succeeded. Once I proceed with connection  I am getting the following error msg - "Error creating SQL Model Connection connection to TeraS. (Error: com.teradata.datatools.dao.TeradataCatalogDAO cannot be cast to com.teradata.datatools.dao.CatalogDAO)

0 replies
Where is SQL-H Documentation? Topic by djmdata 22 Apr 2015

For Teradata Aster, we can use SQL-H to pull data from Hadoop to Aster.
After some searching, I am still not able to find any documentation (syntax details, etc.).
Does anyone have a link to official TD doc?

1 reply, 5 years ago
Where is the README file for the ODBC Driver Suite 15.00.04 for Windows? Topic by pm121918 03 Apr 2015

Where is the README file for the ODBC Driver Suite 15.00.04 for Windows?
I looked in the zip file but there is no README file. Should there be one?

1 reply, 5 years ago
Connecting to Teradata from .net application using ODBC/OLEDB Topic by lakeshgarg 24 Mar 2015

I want to connect to Terdata from my .net application using .net ODBC provider. I have installed the TeraData ODBC adapter. But I am not able to connect. Please help is thata anything I am missing here?

1 reply, 5 years ago
ODBC error Topic by pmatsuda 11 Apr 2015

[nQSError: 16001] ODBC error state: 08S01 code: 4 message: [Teradata] [Unix system error] 4 Unable to get catalog string
can someone please let us know what that message means?

3 replies, 5 years ago
TeraData ODBC errors Topic by pmatsuda 08 Apr 2015

We have OBIEE Linux platform and recently one of our applications have hogging thread alerts with below error message:
[nQSError: 16001] ODBC error state: S1000 code: -3156 message: [Teradata][ODBC Teradata Driver][Teradata Database] Request aborted by TDWM. Exception criteria exceeded
Can someone please tell us what this message means?...

1 reply, 5 years ago
Teradata OLEDB Access Module versus versus OLEDB adapter Topic by fddeschenes 08 Apr 2015

When do I want to use each of these? If I have a source OLEDB system and am continually moving data from there to Teradata via scheduled SQL jobs on the Teradata side, I like that OLEDB Access supports FASTLOAD functionality. Are there limitations to OLEDB access module that would prevent me from using it?

0 replies
Teradata connectivity Issue through JDBC Driver in java Topic by geetikak 01 Apr 2015

Hi All,
I am trying to connect my Teradata server through JDBC Driver in java to my Web Application. I am using the following Connection String:
String connectionString ="jdbc:teradata://DatabaseServerName/DATABASE=xxx,DBS_PORT=1025,USER=xxxx,PASSWORD=xxxxx";
I am getting the following error:

3 replies, 5 years ago
Where is SQL Assistant located in TTU 15? Topic by devanconroy 09 Mar 2015

I downloaded TTU 15 today and need to install the SQL Assistant 15. I can't seem to locate it in any of the folders...

1 reply, 5 years ago
PowerCenter Express ODBC connection to local VM Topic by JimHudd 30 Sep 2014 powercenter express odbc

Hi, I've installed PowerCenter Express and I'm trying to create a connection in the Adminstrator but I'm getting an error.  I'll try to attach the screen shots of the ODBC set up screen and the error message.  I think I just need to set up the ODBC connection string but I've never set one up like this before.

2 replies, 5 years ago