topic Re: ODBC - JDBC Driver issue in Qlik Replicate

ODBC - JDBC Driver issue

rshekharubp23 — Tue, 24 Sep 2024 04:03:57 GMT

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

Re: ODBC - JDBC Driver issue

john_wang — Tue, 24 Sep 2024 04:31:24 GMT

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.

Re: ODBC - JDBC Driver issue

narendersarva — Tue, 24 Sep 2024 21:19:22 GMT

Hi @rshekharubp23

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

Thanks
Naren