idea Re: Ability to Set Isolation Level on ODBC with CDC in Suggest an Idea

Ability to Set Isolation Level on ODBC with CDC

DerickMulder — Mon, 26 Sep 2022 12:52:20 GMT

Hi Qlik Team.

We would like a parameter to set the isolation level on ODBC with CDC source endpoint in Qlik Replicate.

We do understand the risk of reading uncommited data ( beter known as doing a Dirty Read ) and we do understand the risks to this, but we do accept these risks, as we need Replicate to Move our Operation System's data to our data warehouse to fully utilize the QDI enviroment. We have already purchased the QDI Package ( Qlik Replicate, Qlik Compose, Qlik Catalog and we are in the process to migrate our QlikView enviroment to QlikSense ).

However, our biggest challange currently is to extract the data from our operational system as Qlik Replicate sets an Isolation level of 2 ( Read Committed ) when executing the statement which in return locks our system's table and affects our business system dramatically.

We would like the ability to be able to set the isolation level on the ODBC with CDC source either by an internal parameter or a "More Option".

We have been using Qlik ( QlikView ) for more then a decade and we want to migrate to Qlik's latest solution but we would need this enhancement to be able to migrate.

I have attached our source systems documentation as well as the ODBC Driver of our source system.

Kind Regards

Re: Ability to Set Isolation Level on ODBC with CDC - Status changed to: Open - Collecting Feedback

Nulee_Massaro — Tue, 28 Jun 2022 11:41:36 GMT

Thank you for your comment. We are collecting feedback on this issue. Could you please confirm what source system you are referring to?

Re: Ability to Set Isolation Level on ODBC with CDC

DerickMulder — Tue, 28 Jun 2022 14:03:54 GMT

Hi Nulee

The Source system is Rocket U2 Universe Link : https://www-50.ibm.com/partnerworld/gsd/solutiondetails.do?solution=49945&expand=true&lc=en

We are using ODBC to connect to the source system, The source System has a ODBC Driver Link : https://www.rocketsoftware.com/products/rocket-unidata-0/rocket-u2-clients

Hope this helps

Regards

Re: Ability to Set Isolation Level on ODBC with CDC

bobvecchione — Fri, 15 Jul 2022 14:26:30 GMT

Thanks - We are still evaluating but this is certainly a valid request and we will make every effort ti expose the isolation level.

Re: Ability to Set Isolation Level on ODBC with CDC

DerickMulder — Mon, 18 Jul 2022 12:37:58 GMT

Hi Bobvecchione

Thanks for the positive feedback, If there is any assistance i can provide please let me know

Regards

Re: Ability to Set Isolation Level on ODBC with CDC

DerickMulder — Thu, 18 Aug 2022 10:51:08 GMT

Hi Bobvecchione

Hope you are well, Do you maybe have any feedback for me regarding the above?

Regards

Re: Ability to Set Isolation Level on ODBC with CDC - Status changed to: Open - On Roadmap

marina_marshak — Thu, 16 Feb 2023 15:26:34 GMT

We have added this feature request to our roadmap.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 14:54:06 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Ability to Set Isolation Level on ODBC with CDC - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 14:54:10 GMT