100 - 150 of 952 tags for Connectivity

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

Hi all,
our customer is building a mobile application and is requesting our ok for them using JPA.
Here are the rulse they are sugesting to make it work in a performant manner. Is there anyone out there who could review them and point us pitfalls / problems that could arise from JPA usage...

To whom it may concern,
The dev team here are trying to implementing the solution for publishing medium/high volumn of the data into Teradata database (insert and update statements @ around  /hour) via jdbc transaction.
The connection string that's used is normal JDBC Connection string:

Having major issues with ODBC driver 15
we've recently upgraded to Win 7 64bit machines from Win XP 32 bit machines.
On the old machines, using ODBC driver 8 the following worked in VBA
adodb.connection.Open "DSN=" & "DW Master" & ";" & _
                   "Uid=" & user & ";" & _

I am using JDBC FastLoad to transfer data between different teradata environments.
I have been hitting an error message:

I try to connect PerformancePoint 2010  to Teradata. I did'nt find how to connect it. 
I already try this : 
- To connect with standard connexion
- To connect with connexion string like this "Provider=Teradata;Database=DataBase_Name;Data Source=Data_Source;USER ID=User_Name;Password=Password;"

I am trying to insert data into a table using a .Net DataAdapter.  The following simplified example shows my problem (hopefully)
The DataTable has 3 columns
Now the insert command sql for the DataAdapter is the following (and works in Sql Assistant with values)

I am very new to teradata. Please help me. 
Is it possible to connect to teradata using Entity framework 6.0. 
If so, is there any sample application or source code(some kind of tutorial) for reference.
Previn S

I could enable the driver trace on Linux. (modify the odbc.ini file.)
But for windows, do we have the same functionality? I did not see it. Enable DSN Tracing is not the option in windows.
I need to see SQL and function calls to the driver from application. Any idea?

Hi everyone,
I'm pretty green at this field but I have to create a table from a select statement i've made and it has to be done though a
stored procedure.
I'm wondering if someone nows any good ToDo-guides I can use. I have no experience so far regarding what the key stones are in

How do i set-up the JDBC drivers on Cognos and Teradata database? I've downloaded the jdbc drivers but i don't know how to set them up in both Cognos and Teradata database. Can anyone help me figure this out? Thanks :) 

Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC.
On 32-bit Windows platforms everything is peachy.

Hi all,
I installed Teradata express 13.0 (not vmware) on Win7.
I run TD Service Control - it ends up as: "PDE state is RUN/READY".
I executed sysinit and after restart my configuration is 2 AMPs and 1 PE, all are Online:
(under vprocmanager: STATUS NOTONLINE

All DBS vprocs are fully online.

I am trying to run my query after my linked table in Access 2007 is done and all is fine. I get an ODBC call failed periodically. It normally happens during business hours. On the weekends, early morning, it is fine. Others on my team sometimes get it and sometimes they don't.