topic Re: Extract All tables from all tasks on a server in Qlik replicate in Qlik Replicate

Extract All tables from all tasks on a server in Qlik replicate

Rajesh_MDT — Fri, 15 Nov 2024 22:14:52 GMT

Hi All

In Qlik replicate, I wanted to extract all the tasks along with their source and endpoints and the associated tables along with global and table level conversion to an excel file or in any other structured format. Have anyone tried this earlier? if successful, please share the steps, this would be a great help for us.

Thanks

Rajesh. B

Re: Extract All tables from all tasks on a server in Qlik replicate

Alan_Wang — Wed, 13 Apr 2022 18:30:44 GMT

Hi Rajesh,

You can extract all your server-level information with repctl commands. It will include tasks, task settings, task endpoints, table info, and any transformations in the tasks. This is outputted in a json format.

repctl commands are run in the Replicate bin directory (Be sure to run the command line as Admin)

Command to export server info

repctl exportrepository

Note: If you installed the Replicate data directory in a separate drive, you will need to add "-d data_directory_file_path" after repctl

Please refer to the user guide below for syntax and the command to export individual tasks

https://help.qlik.com/en-US/replicate/November2021/Content/Global_Common/Content/SharedEMReplicate/Design%20Tasks/Export_Tasks.htm

The default location for the export will be C:\Program Files\Attunity\Replicate\data\imports

It will be named Replication_Definition.json

Re: Extract All tables from all tasks on a server in Qlik replicate

kmmreddy001 — Fri, 21 Apr 2023 22:16:01 GMT

Do you have any process if replicate is installed on Linux ?

Re: Extract All tables from all tasks on a server in Qlik replicate

Dana_Baldwin — Fri, 21 Apr 2023 23:43:54 GMT

Hi @kmmreddy001

Yes, the "repctl exportrepository" command will also work when Qlik Replicate is hosted on Linux. You would just need to run the script that sets your environment variables before running the command:

source ./arep_login.sh

The resulting JSON file will include all your tasks, tables and server settings.

Thanks,

Dana