Topic
  • 1 reply
  • Latest Post - ‏2013-08-08T13:06:03Z by ThomasBien
peterfa
peterfa
1 Post

Pinned topic Teradata from WMB

‏2013-08-01T09:17:48Z |

I would like to access Teradata from my Websphere Message Broker. It is my understanding that we have to use JDBC, and that ODBC is not supported. Can anyone please give me any pointers on how to set this up ? What little I have found says that I need a JDBC type 4 driver. So far all of my database access from Broker has been with ODBC, I am not familiar with JDBC, or type 4 drivers ( whatever they are ). Do I need a driver ? The other databases which I access ( using ODBC ) all use drivers, they are identified in the odbc.ini file.

Any help would be much appreciated. I am running Broker 8.0.0.1 on AIX 6.1, with WMQ 7.0.1., and DB2/client 9.7.

Thanks !

  • ThomasBien
    ThomasBien
    10 Posts

    Re: Teradata from WMB

    ‏2013-08-08T13:06:03Z  

    Peter,
    I believe you have already received this information, but we will post it here for the sake of others.

    It is true that Teradata is not currently on the list of supported databases for ODBC connections.
    Connectivity via JDBC was formerly impossible, until the release of APAR IC80701 in fixpacks 8.0.0.1 and 7.0.0.5.

    Currently, there is an outstanding issue with Teradata connections via JDBC.
    It is being tracked and resolved via APAR IC90239, and the fix should be included for 8.0.0.3.

     

    With regards to JDBC drivers for use with WMB, these should be obtained from the database provider.