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.
How to Connect Mainframe DB2 to Teradata Client V13.10 Topic by kedarshashishekar 23 Nov 2013 mainframe teradata TDP

Hi All,
Need your expertise in connectivity. I need to connect Mainframe DB2 on Z/OS to Teradata Client V13.10
Can anyone please guide me on what steps are to be taken for this ?
Thanks for your help.

0 replies
1 reply, 2 years ago
Moving data from DB2 to Teradata via AIX Topic by Kunal.jadhav.1987 19 Nov 2013 DB2 Teradata TPT AIX unix

       Is it possible to stream data from a DB2 table to Teradata table using a Unix script ? Can this be done using CONSUMER/PRODUCER operators and not ODBC operators ?

0 replies
Teradata connectivity with SAP Topic by HateOra 18 Nov 2013

Hi Team,
I need information on below points , we are looking to pull data from SAP ECC system into teradata:

4 replies, 2 years ago
Loading from oracle to TD using TPT Topic by Raja_KT 17 Nov 2013

If I have 500 GB of data to be tptied to TD, how much shared memory from the client system, should I allocate?
Thanks and regards,

0 replies
How to connect Teradata in entity data model wizard Topic by shravanigonela 18 Jul 2013 .net teradata client

I am trying to add Teradata in vs 2010. Can anyone please help me?

3 replies, 2 years ago
Informatica 9.1.0 64 bit AIX and TPT 14 Topic by EA230039 19 Sep 2013

I'm having trouble with the configuration of TPT 14 on an AIX 64 bit server and Informatica 9.1.0 64 bit.

4 replies, 2 years ago
Hibernate, blob and large files Topic by BLE 17 Oct 2013 hibernate, blob

I use Hibernate to read and load data into a database Terdadata.
I have large files (xml) to be stored in a table. For that I use a BLOB field.
I did not encounter any problem to store files via BTEQ, but when I go through hibernate, I get the following error :

7 replies, 2 years ago
ODBC and MS Access DSN-less connection VB Topic by tstrick4 07 Nov 2013 vb, access, odbc, connection string, link tables

I have succesfully set up an Access front-end that links tables from a Teradata database.  Everything works fine when I have the tables linked through a DSN.  I am trying to set up a DSN-less connection, but I am encountering the following error:  "Reserved Error (-7778): there is no message for this error"

1 reply, 2 years ago
looking for libicudatatd Topic by alexl.charter 06 Nov 2013

the teradata driver requires libicudatatd however the files included in the driver, TeraGSS and tdodbc, don't include that file,
do you know where to find this file?

1 reply, 2 years ago
ODBC call failed error - windows 7 64 bit machine Topic by pjonas 30 Apr 2013

I have installed Teradata 13.1 on a new machine. It appeared to install correctly. It is using Windoes 7 enterprise with a 64 bit operating system. When I attempt to use it I get an ODBC Call Failed error. Ideas?

2 replies, 2 years ago
Enterprise Library Data Acccess Application Block Implementation using Teradata .Net Provider Topic by ayman 04 Nov 2013 enterprise library, data access application block, daab

Has anybody tried extending the Enterprise Libraray Data Access Application Block so that it works with the Teradata .Net Provider?
To get things up and running, my prototype extends the abstract Database class and passes TdFactory as a constructor argument..  

0 replies
ODBC - decimal symbol Topic by h.h 04 Nov 2013

Hi all,
I'm importing data from Teradata database into MS Access database (Windows 7) using an ODBC driver. The decimal symbol is set to '.' (because the 'Use Regional Settings for Decimal Symbol' is unchecked in the ODBC driver options). The decimal symbol is different in OS (',') thus the import of decimal values is not correct.

0 replies
bteq .logon error Topic by 24 May 2013

Hey all,
having an issue with connecting to the teradata 13 server with bteq
if i do this
.LOGON localhost/dbc,dbc
*** Error: Invalid Logon!
but if it try this
UserId: dbc
Password: dbc
*** Logon Sucessfully complete

3 replies, 2 years ago
Error 8017: The UserId, Password or Account is invalid. Topic by JustMe 21 Oct 2013 ldap, 8017

We are having an issue with users attempting to logon to the system using LDAP authentication.
They are able to logon using a set password with no mechanism chosen.
Any suggestions regarding resolution?

1 reply, 2 years ago
OLE DB Teradata Provider for Windows (64-bit) Topic by warrent 28 Oct 2013

Is there a 64 bit version of the OLE DB Teradata Provider? If so where can I get it?

2 replies, 2 years ago
ODBC IM014: The DSN specified architecture mismatch between the driver and the application. Topic by AlexQuiroz 30 Oct 2013 ODBC IM014

I tried configure Teradata SQL Assistant, but said next error with tittle "Logon failed":
ODBC IM014: The DSN specified architecture mismatch between the driver and the application.
teradata version: 12
windows 7 64 bit
please help me thank you so much

0 replies
JDBC Connection from Oracle 11g Java Stored Procedure Topic by cjeanmarie 29 Oct 2013 jdbc, oracle 11g

When using a Java Stored Procedure from within the Oracle 11g database, an attempt to open a connection to Teradata using the JDBC driver version 14 throws the following error.
Exception in thread "Root Thread" java.lang.NullPointerException

at com.teradata.jdbc.jdbc_4.parcel.ClientAttributesParcel.<init>(

1 reply, 2 years ago
JDBC Bug with exact batch sizes Topic by lil-dice 16 Oct 2013 jdbc bugreport

Noticed this error:
Caused By: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty.

2 replies, 2 years ago
F5 versus DNS Topic by StevenSchmid 15 Oct 2013

Can anyone advise if an F5 load balancer should be used over a DNS, each configured with all Teradata COP's.  We have a 2650 Appliance running TD 13.10 with 15 nodes, 10 of which are Network connected.

3 replies, 2 years ago
Unable to create a connection using the jdbc:teradata:// Topic by vasu6 17 Oct 2013

HI Team,
Here is the log file for connectivity through JDBC application from Application server to TD server on linux.
16-Oct-2013 09:57:01IST Unable to create a connection using the jdbc:teradata://,TMODE=ANSI,CHARSET=UTF16 URL with dbc username because of the following error: [Teradata JDBC Driver] [TeraJDBC 1

1 reply, 2 years ago
ODBC SQL_ACTIVE_STATEMENTS limit error using Python / pyodbc Topic by Willimoa 14 Oct 2013 python pyodbc

I'm accessing Teradata through a python based web application, using pyodbc.  I get the error [Teradata][ODBC Teradata Driver] Beyond SQL_ACTIVE_STATEMENTS limit'
which has come up before :

2 replies, 2 years ago
Unable to Create Metadata Topic by balze 15 Oct 2013

Hi guys
I am a newbie and just downloaded TW Miner Express. Following the tutorial, I was trying to create metadata through "Metadata Creation". The "Select Data Source" pops up without any Data Source. I created Data Source on my win 7 machine and also through Tools -> ODBC Administrator in TWM, but it still does not show any Data Soure in my "Select Data Source" popup. 

1 reply, 2 years ago
Problem with teradata SQLA 13 'object reference not set' Topic by Selvazeal 25 Aug 2011

Hi Guys,

I have installed the teradata 13 client in my machine (Win XP). Whenever i run a query in SQLA  it gives the error msg

'object reference not set to an instance of object'

If any of u people encountered this error kindly help me out the solution ASAP    thanks

6 replies, 2 years ago
Visual Studio 2012 Server Explorer does not show Teradata provider Topic by fwaris 18 Mar 2013 VS 2012

Hi I installed the latest version of the .Net driver (14.10).
I have both VS 2010 and VS 2012 installed.
In VS 2010 the Server Explorer shows the .Net provider for Teradata but VS 2012 does not.
I was expecting the latest version to work with the Visual Studio 2012.
Can someone please clarify.

6 replies, 2 years ago