ODBC - JDBC Driver issue

[rshekharubp23]

Hi 
I have my sql Source version 5.1 which odbc driver is not able to extract data 
informatca is able to extract data using jdbc driver

few Questions
1. can we have ODBC and JDBC drivers for both MYSQL and SQL Server.

2. How to write the connection string for jdbc in MYSQL Qlik replicate 

3. does Qlik replicate support MYSQL JDBC 

other sources are able to extract data but qlik is not able to 

[john_wang]

Hello @rshekharubp23 ,

Thanks for reaching out to Qlik Community!

Qlik Replicate primarily uses the ODBC API to connect to most databases. Currently, connecting to MySQL via JDBC is not supported.

Additionally, MySQL 5.1 is not supported for Change Processing tasks. Only Full Load tasks are supported, but this depends on the compatibility between newer MySQL client versions (e.g., 8.x) and the MySQL 5.1 server.

Hope this helps.

John.

[narendersarva]

Hi @rshekharubp23 

Try to upgrade MySQL to a newer version that is better supported by latest ODBC drivers.

Thanks
Naren