topic Re: Considerations when running DDL changes on an Oracle source table in Qlik Replicate

Considerations when running DDL changes on an Oracle source table

MoeE — Thu, 07 Nov 2024 04:59:56 GMT

Hi,

I have a scenario where some columns are required to be added to some Oracle tables. The task is from Oracle to Azure Synapse, it runs in Full Load and CDC mode.

What are the considerations when it comes to running these changes? Are there any best practices? I'm thinking the tables changed should be reloaded or to ensure that the task is stopped before running the DDL changes, then resuming the task.

Help with this is much appreciated. Thank you.

Regards,

Mohammed

Re: Considerations when running DDL changes on an Oracle source table

john_wang — Thu, 07 Nov 2024 07:02:46 GMT

Hello Mohammed, @MoeE

Qlik Replicate supports DDL operations for Oracle source endpoint and Azure Synapse target Endpoint. I do not think you need to stop the task prior to the DDL, instead, please keep the task running and perform the DDL operations eg adding columns. Just please make sure all the existing DML changes are replicate to target side , then do the DDL changes.

BTW, I'd like to suggest a sanity test before implement in PROD system.

Hope this helps.

John.

Re: Considerations when running DDL changes on an Oracle source table

MoeE — Thu, 07 Nov 2024 22:05:31 GMT

Hi John,

Thanks. A test task will be done before the changes occur on the production tables.

Regards,

Mohammed

Re: Considerations when running DDL changes on an Oracle source table

john_wang — Fri, 08 Nov 2024 04:29:00 GMT

Thank you so much for your great support! Mohammed @MoeE