Qlik Replicate

[Neelima111]

Hello,

We have Oracle source and Snowflake as target.

DDL changes  are applied to the Oracle Source for monthly releases.

We have noticed that  the DDL changes are not migrated to snowflake in several occasions and the behavior is very inconsistent.

In the most recent release, the following DDL changes on Source Oracle have not been migrated to snowflake when the CDC task resumed.

• Add Column
• Modify PK
• Add Partition and Localize Index
• Modify Nullability

Please provide resolution for this issue to have DDL changes automictically migrate without intervention (intervention in most cases required reload target tables to capture DDL changes.)

thank you so much.

[lyka · Accepted solution]

Hello,

Replicate only supports the following DDL statements:

Supported DDL statements include:

• Create table
• Drop table
• Rename table
• Add column
• Drop column
• Rename column
• Change column data type

There are also some limitations like:

• The DDL statement ALTER TABLE ADD/MODIFY <column> <data_type> DEFAULT <> does not replicate the default value to the target and the new/modified column is set to NULL. Note that this may happen even if the DDL that added/modified the column was executed in the past. If the new/modified column is nullable, the source endpoint updates all the table rows before logging the DDL itself. As a result, Qlik Replicate captures the changes but does not update the target. As the new/modified column is set to NULL, if the target table has no Primary Key/Unique Index, subsequent updates will generate a "zero rows affected" message.

For a complete list please refer to:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Endpoints/DDLStatements.htm#Sup...

Thanks

Lyka