350 - 400 of 966 tags for Connectivity


SSAS DataSource View with .net data provider for Teradata doesn't
display tables in "select tables and views".
The conection test is Ok and explorer data is ok too, but when create the datasource view doesn't display nothing.
S.O:Microsoft Windows Server 2003 R2 - Standard x64 Edition Service Pack 2
Microsoft SQL Server

I need to run the below queries using a single Connection Wizard, but it gies error :
Only an ET or null statement is legal after a DDL Statement.
Please advice...it's urgent!!!
ProfileName VARCHAR(128)

Hi, I need to download version but I can't seem to find a place to get it. The latest version in Developers Exchange is .00.35 but due to support issues I can only use versions of 13.10 betweem .00.00 and 00.10
Anyone knows where should I go find those versions?

In our Teradata community we have a variety of Teradata JDBC 13 and 13.10 releases coupled with JREs ranging from 1.4 to 1.6 in various supported combinations.  

Hi Teame
I am new to teradata, I haved DB2, in which for connection to DB is quite easy, just call profile and connect to db and we can use UNIX command after SQL if need to do with that.

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?

I need to connect , OBIEE RPD  with teradata database. My OBIEE server is in Linux.
I need to install ODBC driver for Teradata in Linux.
I have downloaded the odbc software from "http://downloads.teradata.com/download/connectivity/odbc-driver/linux"
But the read me files says , ODBC installation depends on

Hi gurus,
I have an application where i have to download data from Teradata into SQL Server, update data in SQL Server and push it back to Teradata server.
I am able to import data from Teradata into SQL server using SQL Bulk Copy. I am trying to see how to push data to Teradata.

I have been looking for instructions on how to install the Teradata ODBC drive in a linux environement. I have Centos 6.4 installed with unixODBC 2.2.14 installed. I have downloaded the 64-bit ODBC drivers an attempted to install the TeraGSS, ICU and ODBC driver but I cannot connect using isql. I get the following error message: 

I'm just converting some Java JDBC code to use Teradata from DB2 - thought I would share a couple of things I found and ask for any other advice.
1) Remove "WITH UR" from your statements: DB2 supports uncommitted read in the syntax "WITH UR" at the end of a SQL statement, I guess Teradata does not recognize that syntax.

Hello - I got an error which sounds like it is supposed to mean I tried to insert an incompatible data type but I'm having trouble finding useful information about why the conversion failed.
Here's the error message:

Hi All
I'm an experienced SQL Server & data warehouse guy but am working with TD for the first time.
I'm trying to extract rows from a SQL server DB using SSIS & insert them into a TD table & I'm getting absolutely miserable performance (<1000rows/min).

Hi Dieter,
/* create New JDBC Data source for Teradata database in weblogic console*/
I downloaded JDBC Driver from teradata website and placed the jar files in my local system where i installed TTU but  NOT in server ( its not working ) 
Connection test failed.

Hi All,
I have installed Teradata 13.10 and i m using .NET data provider for connection. I am getting connection time out error when connecting database, though i m having access to the database.
11/04/2013 19:42:10
SQLA Version:

I am new to the forum so forgive me if this post seems remedial or incomplete.  We work with data coming from two types of data sources (MS SQL Severs, and Teradata Servers).  For a number of projects, we need to compare information across these two server types.  There are probably a number of ways to accomplish this but we are looking for an approach th

I am working on a Narrow Cast Server project in Microstrategy; teradata is the database. We have configured an ODBC connection to connect the NCS to teradata.
I get an ODBC error while trying to execute a multi pass sql using the ODBC connection. However, a simple query runs fine.  

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.

Hello. I'm working with some .NET code at the moment that performs the following operations:

I launched a Teradata 14 express on Amazon ec2 following instructions here: http://developer.teradata.com/database/articles/teradata-express-14-0-for-ec2-config-guide
When I try to connect through JDBC from an app, I get the following error. (This used to work fine with another instance last week.)

I have problem connectivity from data stage to Teradata database.
The error is "The connector could not establish connection to Teradata Server prdtdcop1. RDBMS Code 224MTDP : EM_NOHOST(224) ... "

Hi there,

Hi there,
I am still looking for a kind a compatibility table between Jdbc driver version level and Instance version level.
I would reckon jdbc drivers are not expected to be upward compatible (ie: using V12 versus instance level V14) and that it would be recommended to align Jdbc version level to Instance version level.

We have an application which connects to Oracle before, now our database migrated to teradata, so need to connect. 
Here is what we use for oracle, 
Data Source=;User ID=;Password=;Provider=OraOLEDB.Oracle.1;Persist Security Info=True;

Hi there,
we upgraded from jdbc  12 to 13 (also made some tests with a jdbc 14) and we consistently get this error message
[TeraJDBC] [Error 1382] [SQLState HY000] The batch is empty
though for sure the select member executed on another jdbc connection/techno is returning rows.

I have strange problem. Consider below Teradata Stored Procedure:

How can we connect Aster and Teradata. 
Using load_from_teradata and load_to_teradata cammands, how are the 2 databases getting connect?
And what is Aster-Teradata adaptor? Is it a physical device or some driver that i can download or  what exactly is it and does  does it work?

my app connects to Teradata DB via JDBC driver. When I try to update a row of a ResultSet (the ResultSet is CONCUR_UPDATABLE), I get the following error:
com.teradata.jdbc.jdbc 4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 858] [SQLState 07004] No value has been set for parameter 3

Hi there. My organisation is just beginning with Teradata development, and I'm wondering which connectivity option (.NET Provider, ODBC etc) we should use. We develop against version 4 of the .NET framework using Visual Studio 2010 and 2012. Could anyone recommend one connectivity option over the others, or perhaps list the pros and cons of each?

Is there a way to tweak ODBC/Stata to work with volatile tables in Linux?
Stata (a statistics package) allows SQL statements to be issued directly to ODBC data source. I believe SAS has similar pass-thorugh functionality. There's some description of this here: http://www.stata.com/help.cgi?odbc

Since past one month, we are getting the error below in some of our informatica sessions during the daily load.
 013-02-22 02:11:10 : ERROR : (15655 | PRE-SESS) : (IS | IS_NAME) : node01_abc.com : CMN_1022 : Database driver error...
CMN_1022 [

Dear All
I have recently moved from Windows to Mac and am trying to get used to the change. At the same time I am new to Teradata and want to learn it. I have installed Teradata Studio on Mac but I am unable to create a database connection and database to start working on it. 

I have installed Datastage with fix pack 3, and TTU 12 with TPT 12, and teradata connector return following:
Teradata_Connector_5: Error loading connector library libcctera12.so. 0509-022 Cannot load module /ds_sw/IBM/InformationServer/Server/DSComponents/bin/libcctera12.so.



Hi, I am trying to understand what is Teradata_ICULibraries_D and purpose of it.


I would really appriciate If someone could provide me littlr information or point me to the right documentation.


I cannot find a single webpage on google or teradata website regarding this.


When I try and do an import into hadoop using the JDBC driver I recieve error 857 - Two different data types are being set for parameter 42
The data type in the file aligns with the data type in the TD table. Anyone know anything else I should check or try?
JDBC version is 14

We are Informatica Powerexchange for TPT. When we tried to load a table with 140  columns and row length of 55k, TPT connection is throwing invalid row length error. However same is working fine with relational connection. 

How to, is possible?

does anybody know where to download the latest JDBC drivers (4.5.1 or higher) for Aster Data?

I'm trying to connect using Teradata's OLE DB provider and most of the time the connection works, but occasionally it returns an error with two messages:
[OLE DB Provider for Teradata] Not enough information to log on
[OLE DB Provider for Teradata] Login timeout expired


I am trying to set up a connection in SSIS 2012 and get i the following error. 


Test connection failed because of an error in initializing provider. The 'TDOLEDB.1' provider is not registered on the local machine.



Hi All,
I am not sure of the exact perameters, so please bear with  me.

Hi Friends,
Can someone share me how to configure loader connection to informatica
we are using Informatica 9.1 hf4 on unix IBM AIX 64bit server

HI forum,
I am new to teradata, installed demo version 12 in my pc having windows xp sp2. After installing, the "start teradata" button is showing disabled in the teradata service control. Also I have loggin issues though the host entry in etc is :       localhost localtdcop1       localhost tdadmincop1

I am using connection pool with Tomcat 7.  The web server sits in the DMZ, while Teradata is in the internal network.  Port 1025 opened in the web server.  When the application first starts up, everything works fine.  But it seems after a short time, the pooled connection fails, with the following error:

I can establish the connection just fine.... 
My connection statement:

jdbcCon <- dbConnect(drv = JDBC("com.teradata.jdbc.TeraDriver"),user = UID, password = PWD, 

paste("jdbc:teradata://",DSN,"/database=",DataBase, ",TMODE=TERA,CHARSET=UTF8", sep = ""))