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

[Rajesh_MDT]

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

[Alan_Wang · Accepted solution]

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/D...

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

It will be named Replication_Definition.json

[kmmreddy001]

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

[Dana_Baldwin]

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