Skip to main content
W
WadeBald
Participant
July 5, 2007
Question

Teradata Connect

  • July 5, 2007
  • 1 reply
  • 570 views
How do I go about setting up a database source/connection to Teradata Data Warehouse. I need to query within a CF application just as I would if using Oracle or SQL Server.
This topic has been closed for replies.

1 reply

C
cf_dev2
Inspiring
July 5, 2007
I've never done it but if you have a JDBC Type 2 driver for Teradata, theoretically you can set up a dsn in the CF Administrator using driver type "other".

Here is an example of how to setup a MySQL datasource using an external driver. Obviously the teradata jar, jdbc url and driver name will all be different, but the basic concept is the same
http://kb.adobe.com/selfservice/viewContent.do?externalId=6ef0253&sliceId=2
A
Anonymous
July 9, 2007
The best connection is to use a JDBC driver made for Teradata. NCR/Teradata appear to have their own type II and Type III drivers. iWay also lists drivers for Teradata. I got this info from the Sun Java site here.
Alternately, you could use an existing ODBC datasource using a datasource of ODBC socket. Or you could create a bridged JDBC connection using the info in this technote. Although the technote talks about an MSAccess DSN, any odbc dsn should work.
Warning: Bridged connections are a poor substitute for direct JDBC connections and you may run into performance issues.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices