topic Re: Can I replicate partition information? in Qlik Replicate

Can I replicate partition information?

shekhar0413 — Wed, 04 Sep 2024 05:23:00 GMT

I have a source table that is partitioned. I did not create the schema for the table in the target before replication and let Qlik handle schema creation. Once replication was complete, I found that the target table was not partitioned. How can i ensure that when the source table is partitioned, the target is partitioned as well?

Re: Can I replicate partition information?

john_wang — Wed, 04 Sep 2024 06:08:09 GMT

Hello @shekhar0413 ,

Thanks for reaching out to Qlik Community!

This is not supported yet in the current major versions. BTW, What's the source and target databases types?

thanks,

John.

Re: Can I replicate partition information?

Heinvandenheuvel — Wed, 04 Sep 2024 13:23:54 GMT

Replicate concerns itself strictly and only with the row data itself, and where available a primary / unique key to facilitate updates and deletes.

Anything else, like additional indexes, constraints need to be added separately, outside Replicate control.

For some target attributes, like partitioning, this may mean that the target table needs to be pre-created and the task settings changed to 'do nothing' for existing target tables.

Note, you any table which does not exist will be created as usual, even in 'do nothing' setting.

Hein.

Re: Can I replicate partition information?

shekhar0413 — Wed, 04 Sep 2024 16:08:17 GMT

Hi @john_wang, thanks, the source is DB2 and the target is Google Cloud AlloyDB.

Re: Can I replicate partition information?

shekhar0413 — Wed, 04 Sep 2024 16:10:10 GMT

Hi @Heinvandenheuvel, thanks for the response. So, if I pre-create the table as a partitioned table in the target, and then do a full load, then the data should be populated according to the appropriate partitions. Is my understanding correct?

Re: Can I replicate partition information?

john_wang — Thu, 05 Sep 2024 00:39:09 GMT

Hello @shekhar0413 ,

Yes, you are correct:

1- Qlik Replicate cannot create partition table (as target table) at present;

2- If the table is pre-created with partitions then it works for Qlik Replicate. You just need to change the Full Load Option Target Table Preparation to "TRUNCATE before loading" or "Do Nothing", as:

Hope this helps.

John.

Re: Can I replicate partition information?

Dana_Baldwin — Thu, 05 Sep 2024 18:24:51 GMT

Hi @shekhar0413

I do not know if it is feasible to add this feature to the software, but we encourage you to submit a feature request here if this is something you would like added: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana