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][ODBC Teradata Driver] SQL request exceeds maximum allowed length of 1 MB Topic by CCMM 02 Aug 2011

What does the SQL request mean? Is the maximum allowed length configurable? Why still need the limitation in 64bit ODBC driver? Is there any workaround ?


5 replies, 2 years ago
Teradata Error while connecting to the TeraDatabase using Ibatis plugin.Getting JDBC exception Topic by Patnaik 28 Feb 2012

Hi,I have used the Ibatis Teradata plugin in Rational Application Developer.I have written a simple sql select query which is mapped in a SQL Map.Then i have created a DAO from the SQL Maps.When i run the JUnit test using the build.xml i am getting the following exception.

1 reply, 2 years ago
How to coonect to teradata server with business object tool? Topic by neetu1.a 01 Mar 2012

I recently joined business objects team for report development activity. my database server is teradata server.How can i connect to teradata server from business objevts tool? what drivers i needed , & from where i can download them? what steps i should follow for connectivity?

0 replies
.Net framework version 2.0 3.0 3.5 must be installed before installing .Net data provider for TD. Installation aborted. Topic by praj 09 Nov 2011 installation, .net framework 4.0

I have .Net framework 4.0 installed.

where do we get TD .Net data provider for 4.0 version? I don't want to downgrade my app to 3.5 or less from 4.0.

5 replies, 2 years ago
Problem executing .net batch program from server Topic by AndrewMaass 12 Jan 2012

Hi - I'm new to posting to forums.  I'll do my best to describe my problem.

4 replies, 2 years ago
dwhwrapper - cli wrapper for Teradata data warehouse utilities (BTEQ,etc..) Topic by FelixBarbalet 21 Feb 2012 bteq, python, mload, csv, fastld, fastexp

Hi All

We wanted to share a python tool we've developed recently which provides a cli to teradata bteq and other utilities to allow:
* easy execution of scripts/SQL queries from the command line
* download to csv (and binary) format without third-party conversion tools
* upload from csv (and binary) format without third-party conversion tools

0 replies
Slow .Net data provider. Topic by Jakob.E_SuperG 13 Feb 2012


We have a Teradata 13.10 backend installation and a front-end installation on MS SQL 2008, using Microsoft SSAS. Due to our data model and a minor "design-glitch" in MS SSAS, we have been forced to make a MOLAP solution, generating materialized cubes on the SQL server.

2 replies, 2 years ago
Installing Teradata .NET data provider on Windows 7 with Visual Studio 2010 Professional Topic by bishtawi 17 Feb 2012

I am having problems with the install.

I am doing the complete install but messes up visual studio packages.


Has anyone had issues with installing the .NET data provider on Windows 7 and VS 2010?

0 replies
ODBC driver (32-bit) installation on 64-bit machine Topic by pcavanaugh 21 Sep 2010 odbc connection, 32-bit connection

I have a 64-bit operating system on a server running Windows Server 2008 R2. I am attempting to create a 32-bit ODBC connection for BusinessObjects XI 3.2. I located the SysWOW64/odbcad32 application to create the 32-bit connection.

6 replies, 2 years ago
[SQLState 22003] A character string failed conversion to a numeric value. Topic by hidekoji 01 Feb 2012 jdbc case when

I was trying to do following with Teradata JDBC (


ps = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY );


And it gives me following error:

6 replies, 2 years ago
BTEQ/Fastload CLI Data Transfer Encryption Topic by TSchmolzi 30 Jan 2012 cli, bteq, fastload, encryption, dataencryption

Can anyone provide information as to the encrytion strength of BTEQ/Fastload/Multiload etc when DATAENCRYPTION is ON?

I have not been able to find the specification in the Manuals. I have found where the ODBC/JDBC encryption strength is AES-128 when using the TD2 mechanism. I would like to see a similar documented specification to be able to show to management.


2 replies, 2 years ago
TPTAPI not able to connect with Teradata database with the error [PXOPL_Open: slopen_error...] Topic by ujaiswal 20 Jan 2012


I did install Teradata 13.0 drivers on 64 windows setup.

I got below DLL's in location

C:\Program Files\Teradata\Client\13.0\Teradata Parallel Transporter\bin64









But, still I am getting this error?

1 reply, 2 years ago
OdbcParameter TIMESTAMP in .Net C# problem Topic by pjozwiak 12 Jan 2012 odbc, timestamp, parameter, c#, procedure

I am trying to call Stored Procedure with parameters. Procedure have two TIMESTAMP parameters for example use below one:

    select cast(timestamp '2008-06-24 01:02:33' as timestamp(6)) into pOUT;

One IN and one OUT.

2 replies, 2 years ago
Java and .net connectors for Teradata Topic by DavidThi808 05 Jan 2012

Hi all;

We're now adding OLAP support to our reporting system and I want to make sure we handle Sql Server, Oracle, & Teradata out of the box. Where can I get information on how to access Teradata from both .net and Java?
thanks - dave

2 replies, 2 years ago
teradata .net provider usage Topic by az_maverick 06 Jan 2012 .net provider, connection string, teradata connection

Hello folks,

                I am new to Teradata , and was hoping to connect to the Teradata DB using the .net provider.

However I am unable to connect. I am getting a invalid connection string error.


I was wondering if you have to follow certain steps to connect using the .net provider ?


What is the connection string used?

1 reply, 2 years ago
Informatica/ Teradata INSERT Access WITH GRANT Issue while Loading Topic by aamirhussainciit 04 Jan 2012 teradata, informatica, insert with grant option

Hi all,


i am trying to load data in my database using informatica but getting the error that is placed below:


 Execute Direct -- [Teradata][ODBC Teradata Driver][Teradata Database] An owner referenced by user does not have INSERT WITH GRANT OPTION access to BATABASE_NAME.TABLE_NAME.ID.Unable to get catalog string.


0 replies
JMS Universal Connector feature request Topic by msschenck 26 Dec 2011 jms universal connector

Would it be possible for the next release for JMSUC to NOT hardcode the Metadata Tables DDLs and names ? I found it quite inconvenient to integrate in an existing EDW infrastructure, which follows strict naming conventions and database objects structure...

0 replies
Teradata Erro 8017 using SQL Assistant Topic by JustMe 16 Dec 2011 8017, connecting

Our users have been receiving the [8017] The UserID, Password or Account is invalid error more frequently lately.  Normally, I can reset the password and they are fine.

However, today I have a user experiencing the problem repeatedly after resetting the password.  He is attempting to connect vi SQL Assistant and using Teradata .NET Data Provider.

1 reply, 2 years ago
Teradata ODBC on Red Hat Enterprise Linux 5 64bit System Topic by Daniele.Passarella 28 Jan 2010

Hi,I tried to connect Teradata 12 Database from Red Hat Enterprise Linux v5.2 64 bit. I have installed drivers in this sequence:tdicu__linux_indep. have also installed but, when I try to connect to my DB i receive the error:Connect failed.Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be loadedMy odbc.ini is as follow:----------------------------[ODBC]InstallDir=/opt/teradata/client/ODBC_32/Trace=0TraceDll=/opt/teradata/client/ODBC_32/lib/odbctrac.soTraceFile=/MSTR/bin/odbctrace.outTraceAutoStop=0[ODBC Data Sources][svil]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=[default]Driver=/opt/teradata/client/ODBC_32/lib/tdata.soDescription=Teradata_12_ServerDBCName=10.XX.XX.XXX LastUser=Username=Password=Database=DefaultDatabase=----------------------------My question is: is Teradata ODBC Driver ver.13 (I tried also with 12 and 8) supperted on a Red Hat Enterprise Linux 5.2 64 bit platform?Many thanks in advance.

2 replies, 2 years ago
SQL Server linked server to Teradata specifying authentication mechanism (LDAP) Topic by tjwong 01 Nov 2011 sql server linked server ole db provider teradata authentication mechanism ldap

Have had success establishing and using SQL Server linked server (SQL Server 2008 R2) connected to Teradata using OLE DB Provider for Teradata (Version using native Teradata (TD2) authentication.
Our Teradata data source will transition to use LDAP authentication, so we must adapt our linked server for this new authentication method. (To prepare for that transition and to conduct tests, we’re provided access to a Teradata database that requires LDAP authentication.)

3 replies, 2 years ago
Calling Teradata sp from .Net Topic by Kazzie 09 Nov 2011 .net, teradata stored procedures


I am new to using Teradata and am trying to use it with to build a user app.

Can anyone please tell me how to call a teradata sp from (Visual Studio 2005)

I have a simple sp with input and output parameters, something like:

REPLACE PROCEDURE dbname.spname (IN inputnumber Integer, OUT outputnumber Integer)


2 replies, 2 years ago
Errors Installing Teradata SQL Assistant Topic by saspert 23 Nov 2011 sql assistant 13.10


I am having issues installing Teradata SQL assistant on my work laptop. We have Teradata 13.10 installation package and my system has Windows XP 2002.

None of my colleagues are able to help on this issue. So, I am posting it here.

1 reply, 2 years ago
Connect Excel to Multiple sessions in Teradata, possible? Topic by Dr Zenith 22 Nov 2011

Hey Guys...

I am connecting excel to teradata through ADODB connection and getting the results in the recordset.

The thing is, I have a slew of SQL's to be run around (10-15) which need not be sequentially. Using the below method, I am able to run each SQL query one after the other,

1 reply, 2 years ago
Teradata Connectivity Using Windows PowerShell Topic by mhackerott 16 Nov 2011 odbc, .net data provider, script, powershell

How can a connection to a Teradata database be implemented as a PowerShell script using ODBC, .Net Data Provider, or other protocol.

3 replies, 2 years ago
Java UDF on Teradata 13 demo is very slow. (Vista OS) Topic by pganelin 07 Dec 2009

Test Case:Table INDATA with two column X,Y. Create table OUTDATA with two columns S and D which are sum and difference of X and Y respectively.Using SLQ the problem can be solved easily as CREATE TABLE OUTDATA AS ( SELECT X+ Y AS S, X - Y AS D FROM INDATA ) WITH DATATable INDATA is populated with 100K rows for this experiment.On dual-core Vista laptop (Dell XPS) the SQL statement above takes 0.285 seconds to execute.Java Variable TABLE UDF can be used to do the same calculations. Java class has a function "evaluate" with two inputs and outputs (the complete code is attached);class Example { public static void calculate( double x, double y, double[] sum, double[] diff) { …. }}The SQL query with Java UDF is CREATE TABLE OUTDATA AS ( SELECT * FROM TABLE (evaluate(INDATA.X, INDATA.Y)) AS t ) WITH DATAOn the same hardware the query above takes 42 seconds, i.e. 150 times slower than SQL query without UDF.I tried to investigate further the performance bottleneck. It is not possible to connect java profiler tool to Teradata database so I had to resolve to crude System.nanoTimer() for performance measurements.Here is the summary of the results:Evaluate is called 400K +4 times. (two AMPs) 100K times is called with phase=TBL_INIT 100K times is called with phase=TBL_BUILD and actual row is calculated 100K times is called with phase=TBL_BUILD and SQL exception "02000" is thrown 100K times is called with phase=TBL_FINITime spent within each function400K constructor new Tbl() 4 sec400K getPhase() 6 sec200K tbl.getCtxObject/ tbl.setCtxObject 10 sec100K actual calculations <0.1 sec400K total time within evaluate 22 secTime spend outside of Java within Teradata itself 22 secAs you could see there is a huge overhead for EACH call. For the actual application I would have more input/outputs and 10 mln rows. Even if I assume that overhead does not increase with the number of parameters I would estimate that overhead would take more than one 1 hour on Vista. I have not run the experiments on the actual production Teradata yet. Here are my questions:1. Should I expect the same overhead on production Teradata (i.e. Teradata hardware), may be divided over the number of AMPs?2. Am I doing something wrong and is there a better approach to accomplish the same? 3. Does Teradata have any plans to address the performance bottleneck? Any recommendation how I can minimize the overhead?4. I noticed in the documentation that for C/C++ UDF you can run the functions INPROCESS. I did not find any such option for Java. Does it exist?

2 replies, 2 years ago