100 - 150 of 935 tags for Connectivity

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.

I am trying to query some Teradata data in SQL Server. When doing so, I get an error, "Cannot find either column "XDate" or the user-defined function or aggregate "XDate.ToString", or the name is ambiguous.

We are evaluating options to Extract/insert large volume of data (Millions of rows) from Teradata and process within a Java application.

Hi Experts ,
Is it possible to send multiple rows ( a table ) from .net environment to teradata environment .
I think it should be possible but as I am completely at DB side I have no idea of connections and .NET to teradata bridge .
Kindly help . Thanks in advance .

I got the TD 15 installed using '

Teradata Tools and Utilities - Windows Installation Package'
But i am getting the below error while connecting to SQL Assistant
'Unknown Error Occured in Terasso Libarary'
Kindly Advice.

Hi Guys,
I am strugling to connnect teradata usning python. I have a user ID and password in text file and i need to read the test file to connect to teradata.. could you please help me with theb syntax if anyone has already done this

Hi guys.
I have some troubles with ODBC driver. I'm facing error HY092 Invalid attribute when try to run SQLPrepare function.
My connection sting to Teradata: DRIVER={Teradata};DBCName=192.***;uid="dbc";pwd=********;QUIETMODE=YES;LoginTimeout=210;UseNativeLOBSupport=Yes;NoScan=Yes;

I have the following unit test which is failing due to a TdException with the message "[Teradata Database] [2689] Field is null for column defined as NOT NULL."

I am attempting to execute a parametrized non-query SQL command using TdCommand.ExecuteNonQuery().  The parameter in question is DbType.DateTimeOffset and TdType.TimestampWithZone; the parameter value was generated using DateTime.Now and appears to be completely defined (as verified via the Visual Studio debugger).

I am using Teradata jdbc driver to connect to Teradata data base from my java application. Couple of days back I got the following issue 'TeraResultSet:getTimestamp function failed'.

I'm using VBA and the Microsoft ActiveX Data Objects 2.6 Library to access our Teradata server using Teradata ODBC Driver

I'm looking at the Teradata Appliance for SAS High Performance Analytics, which I see is connected directly to the BYNET. Is it possible to connect other non-Teradata servers to the BYNET for connectivity, or is this specific to Teradata appliances?

I have a simple unit test which is failing the final assertion:

I am getting error when trying to use vba code to connect teradata sql through excel 2010. I also want to execute records to excel. Can someone help me with the query for the same

I am currently using Datastage v9.1 and would like to know if I can use Teradata Connector to connect Teradata Aster.
If not do we have any alternate db connectors/stages to connect to Aster. Also please let me know the configuration details that I have to setup before connecting to Aster db.

I'm a bit of a novice in this arena, so I hope this doesn't seem like an odd question

Hi All,
I am facing an issue with reconnect in .NET and ODBC connectors from SQLA when i do a DBS restart. I am seeing this in TD Expres 15.0 SLES 10 40GB  VM.
Teradata .NET Data Provider :
Issue here is that after a successful DBS restart, SQLA is not maintaining the current session context.

Hi Folks,
Recently i started my carrier in teradata, i would like to install teredata in my personel lap tap while selecting datasource i am getting 10061 WSA EConnRefused error. Could you please provide the solution for this issue.