topic Re: Qlik Replicate - Compress Table on Oracle as Target in Qlik Replicate

Qlik Replicate - Compress Table on Oracle as Target

johannn — Thu, 13 Oct 2022 11:12:45 GMT

Hello everyone,

we use Qlik Replicate to load data from an Oracle DB to an another Oracle DB (Source: Oracle, Target: Oracle) with "Apply Changes Processing" set to ON. In some cases there are large tables (on average about 500GB each).

Is it possible to make a compression on the target site as a configuration in the Qlik task? Can we make the compression afterwards on Oracle, will it affect the load in any way?

Does anyone have experience with it?

Thank you for your help.

Greets
Johann

Re: Qlik Replicate - Compress Table on Oracle as Target

john_wang — Thu, 13 Oct 2022 14:31:42 GMT

Hello @johannn ,

Yes, it's supported. The compression in target side is transparent to Replicate - If the table is created before the Replicate task running, and you choose truncate the table (rather than drop/re-create it) while the target table exists (see screen copy below).

Regarding the source side compression, the detailed info can be found at Supported compression methods .

Hope this helps.

Regards,

John.

Re: Qlik Replicate - Compress Table on Oracle as Target

johannn — Thu, 13 Oct 2022 15:01:40 GMT

Hi John,

thank you for your reply. I will test immediatly.

Regards,

Johann