I doubt this is the only version of MySQL that is compatible, but what has been tested for compatability?
As an admin of client-managed Qlik Replicate, I need to know what versions are tested to work with the 2023.5 version, though this request extends to future versions of Replicate as well, as our system will be upgraded at some point.
8.0.32 is the only driver certified with 2023.5 and all later versions up to 2024.5. Minor patches to later versions of this driver should also be supported. If there is a business or technical need to use a different version driver, please open a support case and we will check with our internal support team (we do not have a way to elevate issues to them via Community).
8.0.32 is the only driver certified with 2023.5 and all later versions up to 2024.5. Minor patches to later versions of this driver should also be supported. If there is a business or technical need to use a different version driver, please open a support case and we will check with our internal support team (we do not have a way to elevate issues to them via Community).
In addition to @Dana_Baldwin comments, there are compatibility issues with certain versions of MySQL ODBC Drivers. For instance, some versions of the ODBC Driver fail to correctly return the primary key (PK) information of tables, causing the Qlik Replicate table transformation GUI to not display any primary keys. Generally, one of the most updated MySQL ODBC Version will be certified, For Qlik Replicate 2023.5, MySQL ODBC Driver 8.0.32 is certified and should be used.
Hope this helps.
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Qlik Help Document will help you to find which driver will be used and which Qlik replicate version will be used under the Adding and managing source endpoints. Check for the required Endpoint under the pre-requisite section.
