Force Qlik Replicate to use HTTP instead of HTTPS for version 2023.5 and above

[Steve_Nguyen]

Qlik Replicate can be instructed to use HTTP instead of HTTPS. This article documents the required steps for versions 2023.5 and above (Notes for Windows install of Replicate UI only)

Resolution

Previous versions of Qlik Replicate had a ServiceConfiguration.xml to make this change. Later versions require a change to the GlobalRepo.sqlite file in the Qlik Replicate data folder.

Since in Replicate 2023.5 and above there is no ServiceConfiguration.xml

Therefore, you can do this by modifying the host_configuration entry in the GlobalRepo.sqlite file in Replicate data folder.

A sqlite editor and knowledge on how to use it is required for this change, such as the DB Browser for SQLite: https://sqlitebrowser.org/

1. Stop the Qlik Replicate server service and the Qlik Replicate UI service
2. Open GlobalRepo.sqlite in any sqlite browser (as administrator)
3. Go to Browse data
4. Go to Objects
5. Locate host_configuration
6. Locate the JSON column
7. Edit the JSON column by changing the following: 
   
   "host_https_port":0
   "test_https":false
   "allow_unsafe_protocols":true
   
   
8. Save the GlobalRepo.sqlite file
9. Start the Qlik Replicate server service and Qlik Replicate UI service

Environment

Qlik Replicate Qlik Replicate 2023.5 and above