All Forums

Covers all topics related to Teradata database connectivity, including the use of client technologies such JDBC, ODBC, .NET Provider etc. For articles, blogs and more, see the Connectivity section of this site.

You must login to post to the forums.
The NTLM authentication token is not supported Topic by gfinzer 06 Dec 2013

I am using integrated security with TeraData and ASP.NET MVC3.  I am getting the following exception when trying to open a connection:
Server Error in '/' Application.
The NTLM authentication token is not supported.
ErrorCode: -452984668 Severity: Error Facility: DotNet

1936 views
1 reply, 2 years ago
.NET Managed Drivers Topic by gfinzer 06 Dec 2013

In order to use Teradata with .NET, do I need to do a full install of the drivers on the web server or do I just need Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll?

1080 views
1 reply, 2 years ago
Teradata library(ICU) and teradata connector(PIOM) are not available in install package Topic by sandeep_kundal 04 Dec 2013

Hi,
 
I have downloaded TTU14.10 but i dont see any installable componnets for Teradata library(ICU) and teradata connector(PIOM).
also i am facing issue while installing some package
jmsaxsmod1410
npaxsmod1410
mqaxsmod1410
 
when i opened tar file i got  following fodlers which had rpms
mqaxsmod1410
fastld
mload

1406 views
1 reply, 2 years ago
Need icu 13.10.00.01 Topic by jdarton 18 Sep 2013

Can someone provide the ICU Library 13.10.00.01?  I need to uninstall it but it won't unless it has the orginal tdicu.msi.  The closest one available for download is icu 13.10.00.02 but it doesn't work.

1333 views
2 replies, 2 years ago
Unable to connect with integrated security in ASP.NET MVC3 Topic by gfinzer 06 Dec 2013

I have an ASP.NET MVC3 application that uses integrated security.  I have both the driver and the Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll in my bin directory.  I am unable to connect to the TeraData database. 
[Teradata Database] [8017] The UserId, Password or Account is invalid.
Here is my connection string in my web.config:

1496 views
1 reply, 2 years ago
Connection From ORACLE using TPT TD 14.10 Topic by DIECORP24 05 Dec 2013

Hello,
I need to do a connection to Oracle (Version 11g) using ODBC, from a OS Linux Suse 11 64Bits. Do you know, what the driver version is?
 
Thank you! 

1150 views
1 reply, 2 years ago
How to establish Connection from Teradata to Hadoop and also for Hana Topic by User786 22 Nov 2013

Hi
 
Can somebody tried or did any poc to connect from Teradata to Haddop or Hana
Do we have any Teradata connectors available where can use. Want to use Bi -Directional either way
 
Thanks
Ravi Shanker Ayyadevara

1609 views
4 replies, 2 years ago
LDAP Authorization and Simple Binds Topic by fg255006 26 Nov 2013 ldap

Hello everybody,
I need to configure LDAP Authorization using the native directory schema. 
I already configured LDAP Authentication using simple binds and an Identity Search (since I needed to look for the sAMAccountName in the Active Directory).

2370 views
1 reply, 2 years ago
Problem with server name Topic by wmv 24 Nov 2013

com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 14.10.00.17] [Error 1000] [SQLState 08S01] Login failure for Connection to testServer Mon Nov 25 00:48:26 COT 2013 socket orig=testServer cid=3dc01d78 sess=0 java.net.UnknownHostException: testServer   at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)   at java.net.InetAddress$1.lookupAllHostAddr(Unknown S

2585 views
3 replies, 2 years ago
How to Connect Mainframe DB2 to Teradata Client V13.10 Topic by kedarshashishekar 23 Nov 2013 mainframe teradata TDP

Hi All,
 
Need your expertise in connectivity. I need to connect Mainframe DB2 on Z/OS to Teradata Client V13.10
Can anyone please guide me on what steps are to be taken for this ?
Thanks for your help.
 
Cheers,
Kedar!

1451 views
0 replies
1349 views
1 reply, 2 years ago
Moving data from DB2 to Teradata via AIX Topic by Kunal.jadhav.1987 19 Nov 2013 DB2 Teradata TPT AIX unix

Hi,
       Is it possible to stream data from a DB2 table to Teradata table using a Unix script ? Can this be done using CONSUMER/PRODUCER operators and not ODBC operators ?
 
Cheers,
Kunal
 

1206 views
0 replies
Teradata connectivity with SAP Topic by HateOra 18 Nov 2013

Hi Team,
 
I need information on below points , we are looking to pull data from SAP ECC system into teradata:
 

1890 views
4 replies, 2 years ago
Loading from oracle to TD using TPT Topic by Raja_KT 17 Nov 2013

Hi,
If I have 500 GB of data to be tptied to TD, how much shared memory from the client system, should I allocate?
Thanks and regards,
Raja

1242 views
0 replies
How to connect Teradata in entity data model wizard Topic by shravanigonela 18 Jul 2013 .net teradata client

I am trying to add Teradata in vs 2010. Can anyone please help me?

2260 views
3 replies, 2 years ago
Informatica 9.1.0 64 bit AIX and TPT 14 Topic by EA230039 19 Sep 2013

Hi,
I'm having trouble with the configuration of TPT 14 on an AIX 64 bit server and Informatica 9.1.0 64 bit.

4301 views
4 replies, 2 years ago
Hibernate, blob and large files Topic by BLE 17 Oct 2013 hibernate, blob

Hello,
I use Hibernate to read and load data into a database Terdadata.
I have large files (xml) to be stored in a table. For that I use a BLOB field.
I did not encounter any problem to store files via BTEQ, but when I go through hibernate, I get the following error :

3869 views
7 replies, 2 years ago
ODBC and MS Access DSN-less connection VB Topic by tstrick4 07 Nov 2013 vb, access, odbc, connection string, link tables

I have succesfully set up an Access front-end that links tables from a Teradata database.  Everything works fine when I have the tables linked through a DSN.  I am trying to set up a DSN-less connection, but I am encountering the following error:  "Reserved Error (-7778): there is no message for this error"

4908 views
1 reply, 2 years ago
looking for libicudatatd Topic by alexl.charter 06 Nov 2013

hi,
the teradata driver requires libicudatatd however the files included in the driver, TeraGSS and tdodbc, don't include that file,
do you know where to find this file?
thanks,

1290 views
1 reply, 2 years ago
ODBC call failed error - windows 7 64 bit machine Topic by pjonas 30 Apr 2013

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?

2073 views
2 replies, 2 years ago
Enterprise Library Data Acccess Application Block Implementation using Teradata .Net Provider Topic by ayman 04 Nov 2013 enterprise library, data access application block, daab

Has anybody tried extending the Enterprise Libraray Data Access Application Block so that it works with the Teradata .Net Provider?
To get things up and running, my prototype extends the abstract Database class and passes TdFactory as a constructor argument..  

1640 views
0 replies
ODBC - decimal symbol Topic by h.h 04 Nov 2013

Hi all,
I'm importing data from Teradata database into MS Access database (Windows 7) using an ODBC driver. The decimal symbol is set to '.' (because the 'Use Regional Settings for Decimal Symbol' is unchecked in the ODBC driver options). The decimal symbol is different in OS (',') thus the import of decimal values is not correct.

1373 views
0 replies
bteq .logon error Topic by devdb@tableausoftware.com 24 May 2013

Hey all,
having an issue with connecting to the teradata 13 server with bteq
if i do this
$>bteq
.LOGON localhost/dbc,dbc
*** Error: Invalid Logon!
 
but if it try this
$>bteq
.LOGON
UserId: dbc
Password: dbc
*** Logon Sucessfully complete
 

2328 views
3 replies, 2 years ago
Error 8017: The UserId, Password or Account is invalid. Topic by JustMe 21 Oct 2013 ldap, 8017

We are having an issue with users attempting to logon to the system using LDAP authentication.
They are able to logon using a set password with no mechanism chosen.
 
Any suggestions regarding resolution?

4130 views
1 reply, 2 years ago
OLE DB Teradata Provider for Windows (64-bit) Topic by warrent 28 Oct 2013

Is there a 64 bit version of the OLE DB Teradata Provider? If so where can I get it?

1496 views
2 replies, 2 years ago

Pages