topic Re: How to set Qlik replicate to map an existing table for a new CDC source table in Qlik Replicate

How to set Qlik replicate to map an existing table for a new CDC source table

MdFazil — Thu, 29 Feb 2024 10:35:13 GMT

How to set Qlik replicate to map an existing table for a new CDC source table. how does it behave when the to be mapped table or column names are slightly different

Regards
Fazil M

Re: How to set Qlik replicate to map an existing table for a new CDC source table

john_wang — Thu, 29 Feb 2024 12:59:20 GMT

Hello Fazil M, @MdFazil
I think you are talking about 2 different questions.
1- How to map the columns between source and target tables
2- How to map the source table and target table especially if the target table contains some data

Well, for Question 1, you may change the column name in the table settings. In below sample we overwrite the column name to LOCATION, so far we map the source column ADDRESS to column LOCATION in target.

Q2, we may rename the target table in table settings level , or global level, For example in table level, the source table SCOTT.TESTDDL map to target side DBO.FINALDDL.

If the target side table contains existing data and you want to keep it, there are some options for the Target Table Preparation in task settings.

Hope this helps.

John.

Re: How to set Qlik replicate to map an existing table for a new CDC source table

Kent_Feng — Fri, 01 Mar 2024 00:32:56 GMT

Hi @MdFazil

I think you are asking how to map a source table to an existing target table to capture changes.

Just like what @john_wang instructed, map the source table to your existing table by giving the exact target schema name and table name, then in Transform tab, make sure to rename the column to match the column name of your exiting target table. You can also just select the columns you need, for example, you have 5 columns in source, you can just select 3 and rename them to match your target table column name.

Thanks

Kent

Re: How to set Qlik replicate to map an existing table for a new CDC source table

MdFazil — Fri, 01 Mar 2024 05:21:23 GMT

Hello @john_wang ,
thank you for the reply,

question 2 is what I want to ask, and thank you for the clarification. I have One more doubt regarding this. how does it behave when the source table or column names are slightly different. Thanks

Regards,
Fazil M

Re: How to set Qlik replicate to map an existing table for a new CDC source table

MdFazil — Fri, 01 Mar 2024 05:24:07 GMT

Hello @Kent_Feng ,
Thank yo for the reply,

You are right, and that is what I want to know. Thank you for the clarification

Regards
Fazil M

Re: How to set Qlik replicate to map an existing table for a new CDC source table

john_wang — Fri, 01 Mar 2024 07:43:48 GMT

Hello @MdFazil ,

Thanks for the feedback. Qlik Replicate supports the object identifier (table name, column name, PK or Unique Index name etc) mapping. The object identifier difference is not a challenge in Qlik Replicate and it's pretty easy to implement. Feel free to let us know if you need any additional information.

Regards,

John.

Re: How to set Qlik replicate to map an existing table for a new CDC source table

MdFazil — Fri, 01 Mar 2024 08:28:03 GMT

Hi @john_wang , Thank you for the reply.

I got clarified, Thank you

Regards
Fazil M

Re: How to set Qlik replicate to map an existing table for a new CDC source table

john_wang — Fri, 01 Mar 2024 08:31:42 GMT

Thank you so much for your support @MdFazil !