topic Re: Qlik Replicate | ETL in Qlik Replicate

Qlik Replicate | ETL

Sauree_10 — Thu, 17 Jun 2021 15:29:43 GMT

Can we perform transformations while copying data from one database to other in Qlik Replciate?

Re: Qlik Replicate | ETL

john_wang — Thu, 17 Jun 2021 15:38:49 GMT

Yes. There are different level transformations, table level, and task level (known as global rules. apply for all tables in the task). You may reference to the User Guide about the "transformation":

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/cust_tasks.htm

help it helps.

Regards,

John.

Re: Qlik Replicate | ETL

Sauree_10 — Thu, 17 Jun 2021 16:01:27 GMT

Thanks @john_wang, I am new to Qlik.. anywhere I can check how to do parameterization of jobs and learn the ways for deployment to different enviornment?

Thanks,

Saurabh

Re: Qlik Replicate | ETL

PGN — Thu, 17 Jun 2021 16:52:47 GMT

Regarding deployment to different environment: export the task from the menu to a .Json file. Manually edit the .json file to change the endpoint definitions (if needed) and the task name as the export process adds additional items to the filename and some .json tag contents. Import the .json file on the other environment. Use caution since the endpoint definitions in the .json file will overwrite the endpoint definition in the other environment which may impact other tasks.

Re: Qlik Replicate | ETL

Sauree_10 — Thu, 17 Jun 2021 19:00:16 GMT

@PGN any automated scripts for this? or reference?

Thanks,

Saurabh