topic Get column mapping from Qlik Replicate in Qlik Replicate

Get column mapping from Qlik Replicate

diex — Wed, 25 Jan 2023 13:05:47 GMT

I would like to get a mapping of columns in a replication task. Columns that are taken from the source and columns that are passed to the target.

I tried to get metadata from Enterprise Manager and from Replicate. I used the documentation but it doesn't give the right information. Information about the origin of the columns is not contained in any of the API methods.

I found the dynamic_metadata.sqlite file in the replication task directory. It has a table_definitions table. The data column is encoded. It contains the column names and other information. But any attempts to decode it failed.

If you have information on how to get column mapping or decode column data, I will be very grateful to you.
Thank you.

Re: Get column mapping from Qlik Replicate

Heinvandenheuvel — Thu, 26 Jan 2023 16:56:44 GMT

Good question and good start finding dynamic_metadata.sqlite.

If only there was a tool to format the info right?! Well, there is inside good old REPCTL. Or at least there used to be one ?! I've used it a lot in the past but just now it failed using version 2022.5.0.499 and for now I do not know why. I tried as 'administrator' and changing directories and tried old untouched tasks and new ones. No joy, just table_descs.json, not the actual tables. Hmmmm....

You try!

First list all commands: repctl -d <your_repl_data_dir> help option=1

Now scan options and dumpmetadata and as for help on that:

>repctl -d <your_repl_data_dir> dumpmetadata ? command dumpmetadata: request arguments: sqlite_file:required string out_dir:optional string create_sub_dir:optional BOOL response arguments: out_dir:optional string [dumpmetadata command] Succeeded

Now try:

>repctl -d \Data dumpmetadata sqlite_file=\Data\tasks\Oracle_to_SqlServer\dynamic_metadata.sqlite command dumpmetadata response: { "out_dir": "\\Data\\tasks\\Oracle_to_SqlServer\\20230126114034257652" } [dumpmetadata command] Succeeded

And check the JSON result under the table_defs subdirectory (if all is well for you!)

Good luck,

Hein

Re: Get column mapping from Qlik Replicate

diex — Thu, 26 Jan 2023 19:02:46 GMT

It is very useful!
Thank you very much for your advice.
I managed to get the column mapping. I am using 2022.5.0.395 version of Replicate.