Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The default location for the export will be C:\Program Files\Attunity\Replicate\data\imports
It will be named Replication_Definition.json
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
The default location for the export will be C:\Program Files\Attunity\Replicate\data\imports
It will be named Replication_Definition.json
Do you have any process if replicate is installed on Linux ?
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