Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement to do the CDC from AS400 to Azure Data Lake Storage (Azure ADLS)
There are 2 things I want to keep on Azure data lake storage
1. Change transaction
2. Data and structure same as Source endpoint (with realtime update) <-- realtime update to file on ADLS
I checked the Qlik document and found that if I choose the target end point as Azure Data lake Storage
There is a limitation for
If this solution cannot, what is alternative solution?
PS. I dont have environment to test but need to propose the solution very soon.
If anyone has suggestion, feel free to share.
Thanks
Hello @ppeeradej ,
It's true about UPDATE and DELETE statements are not supported in Apply Changes replication mode. You could use the Store Changes and use transactional apply and it should work for you. I have an existing cusomer is is doing this now.
Please let me know if this helps you !
Sincerely,
Barb
Hello @ppeeradej ,
It's true about UPDATE and DELETE statements are not supported in Apply Changes replication mode. You could use the Store Changes and use transactional apply and it should work for you. I have an existing cusomer is is doing this now.
Please let me know if this helps you !
Sincerely,
Barb
Hello @ppeeradej ,
I am working with the ADLS endpoint.
Does the stored changes permit you the update and delete ?
Thank you