Originally posted by: SystemAdmin

Hi all,

I have to connect to a Solid DB Database using TX 8.1 on Windows and extract data from that database. There is no existing TX database adapter for Solid DB (which is based on MySQL I think). The only way to connect to this database would be the use of JDBC.

Here is the problem: How to I connect to a database via JDBC with TX ?

• I could use the Java-API and extract the data from the database and then pass it to a map.
• If there is a suitable JDBC-driver I could use the JDBC-ODBC-Bridge with the TX ODBC-Driver

Is there any other way to connect to a database via JDBC with TX 8.1 ??

Thanks,
Buke
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Hi,

You can connect to Database using WTX 8.0 through Database Adapter.
You should configure the settings through Control Panel ->Administrative settings- > ODBC settings and select the driver you want.Create DATABASE name.
Use that DATABASE name in DATABASE INTERFACE DESIGNER and select the appropriate settings so taht you can connect to the database which you want.

All the Best

Regards,
Srinivas.M
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange