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.
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.
