Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
boonhaw_tan
Contributor III
Contributor III

NPrinting cluster connection changes after QlikView server migration

Hi All,

QlikView server migration will require change of "Address" & "ClusterID" of NPrinting cluster connection. We have >50 clusters connection setup in NPriting. Below is sample of Address & ClusterID used in cluster connection

http://<QMS server name>:4799/QMS/Service
QVWS@<QVWS server name>

Would like to check is there is any method to mass update Address & ClusterID in cluster connection instead of update 1 by 1. Meanwhile, I would like to understand what is the best practice to use generic "Address" & "ClusterID" in cluster connection to prevent mass update when there is server migration.

Thanks,
Boon Haw

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

Hi,

you must provide required entities.

I would use API to read all connections and then update all of them:

https://help.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=82#Connections

Since we are Qlik developers I would use Qlik script and Qlik rest connector to write it. API was recently updated with the ability to create and update connections so my NPrinting.qvs does not contain ready to use script but you can easily use it to write your own script:

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

 

another option (!!! but not officially supported!!!) would be to run update on NPrinting repository database using tools like pgAdmin. It is much easier to do, but at the same time it is not officially supported and therefore I do not recommend it. Before using this method I would definitelly take a backup of NPrinting repository!

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

1 Reply
Lech_Miszkiewicz

Hi,

you must provide required entities.

I would use API to read all connections and then update all of them:

https://help.qlik.com/en-US/nprinting/May2021/APIs/NP+API/index.html?page=82#Connections

Since we are Qlik developers I would use Qlik script and Qlik rest connector to write it. API was recently updated with the ability to create and update connections so my NPrinting.qvs does not contain ready to use script but you can easily use it to write your own script:

https://nprintingadventures.com/2019/04/08/nprinting-api-qlik-rest-subroutines/

 

another option (!!! but not officially supported!!!) would be to run update on NPrinting repository database using tools like pgAdmin. It is much easier to do, but at the same time it is not officially supported and therefore I do not recommend it. Before using this method I would definitelly take a backup of NPrinting repository!

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.