How to set-up generic odbc in Talend 6.0.1

One Star

How to set-up generic odbc in Talend 6.0.1

We have a business case that requires us to use an existing ODBC connection from Talend, is there a way we could do that in Talend 6.0.1?
Options? Workarounds?
Moderator

Re: How to set-up generic odbc in Talend 6.0.1

Hi,
ODBC is deprecated in 6.0 since java 8 not support it any more.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to set-up generic odbc in Talend 6.0.1

In previous version, 5.1.2 I used the Generic ODBC connection:
String of connection: jdbc: odbc: Unims32
Login: Admin
Password: <Password>
DataSource: Unims32
Mapping File: MSODBC

In version 6.1.1 I can choose Generic JDBC Connection:
JDBC URL: jdbc: odbc: Unims32
Driver Jar: ?????
Class Name: ?????
Username: Admin
Password: <Password>
Mapping File: MSODBC
What must I fill in by Driver Jar and Class Name?