Can Qlik Replicate update/delete on Datalake?

[ppeeradej]

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 

• UPDATE and DELETE statements are not supported in Apply Changes replication mode

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

[Barb_Fill21 · Accepted solution]

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. 

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Microsoft%20Azure%20ADLS/azurea...

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Custom...

Please let me know if this helps you !

Sincerely, 

Barb

[JonathanHoarau]

Hello @ppeeradej , 

I am working with the ADLS endpoint.

Does the stored changes permit you the update and delete ?

Thank you