Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sauree_10
Contributor II
Contributor II

Qlik Replicate | ETL

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

Labels (1)
4 Replies
john_wang
Support
Support

Hello @Sauree_10 ,

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

 

help it helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Sauree_10
Contributor II
Contributor II
Author

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

PGN
Creator II
Creator II

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.

Sauree_10
Contributor II
Contributor II
Author

@PGN  any automated scripts for this? or reference?

 

Thanks,

Saurabh