Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajesh_MDT
Contributor
Contributor

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

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

Labels (1)
1 Solution

Accepted Solutions
Alan_Wang
Support
Support

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

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

3 Replies
Alan_Wang
Support
Support

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

If the issue is solved please mark the answer with Accept as Solution.
kmmreddy001
Contributor
Contributor

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

Dana_Baldwin
Support
Support

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