100 - 150 of 966 tags for Connectivity

I hope this is the right place to ask...
In order to define system ODBC DSN we use the following command on various windows platform/version :
odbcconf.exe configsysdsn "Teradata" "DSN=Teradata|Description=Teradata blah blah|DBCName=tdata.xxxxx.local" /Lv c:\temp\o.log

We are running Informatica 9.5 with Teradata V14.10 using TTU 13.10.  For some of the Informatica jobs, it gives error as 'Faulting module name: tdata32.dll version' and jobs fail though data gets loaded correctly in Teradata. Only few jobs fail beacuse of this error and not all. Is there any solution for this?  

I am trying to locate the Teradata 32Bit ODBC Drivers for Windows version to reproduce a problem at a customer site. The latest that I can find are which are in the 14.10.15 version of the ODBC suite on the Teradata ODBC Driver for Windows download page. Is there a download for

Hi.  I'm fairly new to Qlikview and Teradata connectivity.
Using the TPT connector I can NOT make a connection at all.
Using ODBC (32 or 64) I get the dreaded:
Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

In our new TD14.10 system, we have a new feature that I have never dealt with in past releases: "PE only" nodes. In our new TD14.10 system we have some "PE only" nodes which only
contain PEs (i.e. they do not contain any AMPs). Should these "PE only" nodes be included in the DNS/hosts "COP" list?


$ /opt/teradata/client/14.10/odbc_32/samples/C/adhoc


Enter Data Source Name: tddev

Enter UserID: a_gilliee

Enter Password:


Connecting with SQLConnect(DSN=tddev,UID=a_gilliee,PWD=*)...



I am very new to Teradata. I have simple java program to connect to terdata database and get metadata information e. column name , datatype etc. I have requirement to call this java code inside Oracle database.

Jdbc Version :
Terdata Version : 14.10.00
Oracle Version :
Java :

I recently installed TTU 15. The Windows version is XP Sp3 32 bit.
I was using the TTU 14 previously and it was working fine.
Prior to installing the new version, I completely uninstalled all the tools related to v14 using the unintall vb script provided alongwith the TTU 15 package

Dear Teradata Community,
I got a failure message - "name  in HOSTS file" - when trying to connect from SAS to Teradata Platform.
The current architecture is using a DNS server performing translation between IP adress of the different nodes and an "alias name - AN -" issued in the logon string connection.

I need to know if ENVISION RSA to link the DBC.AccLog.Tbl audit table with only the SELECT query can block Teradata table.
The DBA tell me this:

I have created a database through web sql assistant and have created a java program to connect to this database and retrieve data.  The connection will not work as it seems that I am not able to specify the database server name.
I have connected to a Oracle database through this program with no problems.
Any suggestions?

Looking to see if someone out there has seen this issue.
We have an excel application accessing Teradata via ODBC.
We are seeing connection issue using FIOS network with Excel via ODBC. FIOS hangs and no error message is given. The interesting thing is that SQL-A works fine with the same ODBC setup with FIOS.

Does anybody know what can cause this exception?  Running my application in a local appserver using MyEclipse and WAS is working fine however after deploying my application to a remove test environment, be it on Intel or Linux with the same Websphere version, I get this exception below.  I did talk to a Teradata DBA and she said if I use m

Hi All,
I am unable to set the Session to Latin.
I am using TD 14 & trying to logon from Unix terminal using below command:
bteq -c Latin1 .logon server/user,pwd
(Note: i am able to set the same for Acii which is default or utf8 using "bteq -c Ascii" or "bteq -c utf8)
I referred below links

I'm trying to build an Excel self-service tool front end for a Teradata database, but the end users will not have any Teradata drivers installed on their machines.  Is it possible to use a generic ODBC connection, and if so, does someone know what connect string to use for an ADODB recordset?

We have 24nodes 2650 model with 576 amps on 1GB internal LAN connection.
We are planning to have Teradata Hadoop of 17 DATA nodes with 36TB / node on 1GB or 10GB internal LAN Card.
Our client wants to know the speed for transferring data for both directions. It might be during heavy workload of both systems (teradata and TeradataHadoop)

Hi guys I tried to install both on Yosemite.
Clicked through the wizard (accepting defaults) and it looks like it's on the last step that the installer says the installation failed.

We are getting intermittent "Unable to get catalog string" errors when connecting to our Teradata DB via ODBC using Informatica.
We set the NLSPATH but do not get more detailed errors.
Re-running the job once or twice works. But we need to find why this keeps happening.

I am attempting to connect to teradata using Perl.  I am not able to get it to connect.  We are getting the following error when trying to connect:
/usr/local/bin/perl: symbol lookup error: /usr/local/lib64/perl5/auto/DBD/Teradata/Cli/Cli.so: undefined symbol: DBCHINI

I have a package in SSIS 2012 catalog trying to get some data from Teradata DB. The connection is not working for me and I keep getting the error:
ADO.NET Source has failed to acquire the connection with the following error message:
"Could not create a managed connection manager".

Can anyone tell me where to find the Viewpoint server IP address and port number once the Viwepoint sevices have been started?

My code:

import pyodbc
td_connstr = "DRIVER={Teradata};DBCNAME=%s;UID=%s;PWD=%s;DATABASE=%s;QUIETMODE=YES;" % (my_credentials)
pyodbc.pooling = False
td_conn = pyodbc.connect(td_connstr)

I get an error message:
 File "<stdin>", line 1, in <module>

Hi All,
I am using the Hortonworks connector for teradata + sqoop.  When I import with a query statment the connector adds in a create view statment.  I don't have permissions to create a view (and I cannot get a connection with said permissions).  Please see below for error and sqoop statment.

hello there
We are using SAP interface to load data from Stage area to TD, I use Parallel Transporter and when Ixecute the jon , it fails with message which is in Subject.
I understand that this file is missing and I cannot find it in C:\Program Files (x86)\Teradata\Client\15.00\bin .

TPT Help with SSIS

I have intalled Teradata 13 in Windows 7 32 bit machine. I am getting an error 10054 WSA E ConnReset: Connection reset by peer.
I  tried to connect to local host ( and same local host address is available in the host file but still I are not able to connect. I have started all the service related to Teradata.

Does TD SQL-H support reading ORC File tables?

I already post about that kind of subject in the past and we achieved to succeed it in Java/JDBC mode.
Our issue
We are executing macro statement in a multithreaded batch mode. We just cannot achieve to take advantage of statement cache (cacheFlag=T).

I am trying to package the ODBC driver for installation at our company and am encountering some issues with setup.exe. The GUI claims it is installshield but all the usual command line arguements are not working. I jsut get an error "The setup command line is invalid. The setup cannot proceed".
I have tried ...

I have written a C# ASP.NET application that uses the Windows TD ODBC driver (v  In my code, I create an open a connection, perform my query, then close the connection.  However, what we are seeing is that the connection (session) persists in Teradata for some arbitrary amount of time after the application has finished with the connection an

We installed the Teradata ODBC drivers (v15.00) on an Exalytics T5-8 clustered environment (2 nodes) - with all prerequisites in place.
We tested on both nodes with nqcmd and we can select metadata and data from both Solaris nodes.

I have a Teradata Datasource that uses TeraData JDBC driver for connection running locally on Websphere  In this datasource, I have a custom property called 'databaseName' which represents a schema from the Teradata datasource.  I have a java class that needs to call a Teradata stored procedure that accepts 2 string parameters and outputs a resul

I am trying to load Teradata table using fastload in Informatica. But it gives below error.
WRT_8098 External loader error. Error executing external loader process:[No such file or directory] Errno = [2]

Hi All,
I have a perl script that calls a sp in TD. The SP returns rows where each row has 4 clob columns.
I am using the following code scrippet to fetch the row and facing issue.

Hi all,
   I need to get data from users from a webpage (jsp) and connect to a teradata database and load them into the tables in the database. I am using jsp to create the webpage. Is it possible to directly connect to the teradata database by scripting in jsp?. If so, some guidance will be appreciated. Thank you

Does teradata have the concept of a linked server? I would like to create a view on our Teradata Test Box which views a Dataset on the Production server.
I know that datamover could be scripted to bring the data across but space on the test server is at a premium.

While connecting thru TVA client getting the following error. The client machine has Windows 7 Enterprise Edition
 The application encountered the following error and cannot be loaded
ERROR[42S02][Teradata][ODBC Teradata driver][Teradata Database]

I have windows 2008 R2 64 bit. My Informatica application is 9.1 HF6 32 bit. I have installed Teradata TTU 13.10 utilities (ODBC, GSS , ICU). While running application I get ‘Specified DSN contains an architecture mismatch between the Driver and Application’.

Hi Guys,
I am a BODS developer working on some interface to get data in Teradata using bulkload stream operator.
Currently facing BODS job failure with connectivity. Below are logs
Teradata <tbuild> failed with the following error: <TPT_INFRA: TPT02268: Error: Cannot write message to Data Stream, status =


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.

We are upgrading from Teradata 12 to Teradata 14, and DataStage 7.5.2 to DataStage 9.1
Existing Teradata DataStage stages will not be converted.  The following parameters are used to read and write from Teradata.

Parameters to read From Teradata 14

I am using the following code to read clob data from teradata. 

I am connecting to Teradata via JDBC and LDAP using the following URL format:

I have been developing a demo MVC application and trying it to connect to Teradata Database. But I have been failing since long . I tried whatever I could do as a newbie to this field but apparently have not been able to solve the problem.

I have a new laptop with Windows 7 64bit and MS Visio 2010 64bit.
How do I get Visio to see Teradata? Teradata isn't one of the Visio Database Driver options listed.
Here is what I have on my laptop so far:
Version                 Display Name