I connected Excel to my Teradata table and I get all of my data but every other row in my data set under one column of data, TIME1, is 0:00 instead of an actual time like 8:00. My data table in TD displays the correct timestamp for all rows of data but when I refresh the link in my excel file every other row under that one column TIME1 is 0:00 ?

Hello,

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

 Hello,
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!!!
Query:
 
CREATE VOLATILE TABLE profile_info
(
ProfileName VARCHAR(128)
)ON COMMIT PRESERVE ROWS;

Hi, I need to download version 13.10.00.10 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?
/Arturo
 

Greetings.
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.

Hi,
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
ODBC Dependencies

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:

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.

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?

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.

Hi,
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: 

Hello,
 
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 [

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.

I'm from Teradata Japan.
I'd like to let you know about great library for Teradata-Ruby connection.

We have rocking programmer, he is one of the Ruby commiter, in our PS division and he made the library for Teradata-Ruby connection.

Im able to connect to teradata DB through SQL assistant with required credentials

But unable to connect to teradata through .Net ODBC

The connection string that i used is

driver={Teradata};DBCName=provided Server address; UID=*****;PWD=*****;

Pls let me know if anything is needed

Hi,

What options do I have to use a GUI SQL client tool to access teradata from Mac OS X? For e.g. there is SQL developer for Oracle. Any Java tool would work I guess.

Thanks in advance.
Sunny

 
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.
Cannot load driver: com.teradata.jdbc.TeraDriver

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: 13.10.0.2
Teradata.Client.Provider.TdException

I Installaed TD-13 for Win-32. First surprise was this package does not contain SQL Assistant. 

Anyways I downlaoded TD studio and installed it. 

In the eobject explorer how do I connect to the server ? I never came accross an option to configure the server or set up a default database etc. Please help. 

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 that is 1) scriptable and 2) can be parame

Hello,
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 14.00.00.21] [Error 858] [SQLState 07004] No value has been set for parameter 3
 

Hi,

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

loadop.dll

pxicu.dll

exportop.dll

opcommon.dll

streamop.dll

telapi.dll

telapi.lib

updateop.dll

But, still I am getting this error?

Trying to connect through C# using an LDAP login:

 Teradata.Client.Provider.TdConnection con =
                    new Teradata.Client.Provider.TdConnection("Data Source=192.168.1.54;User ID=mw;Password=pwd;");

            con.Open();
 

Note I can log in with SQL Assistant with this server, user id, and password (so I think that's not the problem).