NPrinting 17 - accessing the postgres database

[kdmarkee]

I'm hoping someone will have some info on this topic and/or offer some suggestions.  We are using QV 12 and NP 17 and would like a way to explicitly determine if a NP Publish Task was in fact successful (NOT just attempted) so that we can take that data and then import it into our QV app to set some flags and do some other analysis. Are any of these ideas below feasible or does anyone have other experiences or suggestions?  Thanks.

Idea 1:  If possible, access and query the NP postgres database with the hopes that all task statistics are stored in it, which we can then use as a datasource for our QV app.  If we can connect, can you provide info on "how to"?

Idea 2:  Dump the report output to a network location and have my QV app look to see that reports exist there for the day.

[Ruggero_Piccoli]

Hi,

To retrieve information about Tasks you can use Qlik NPrinting APIs https://help.qlik.com/en-US/nprinting/November2017/Content/Extending/Intro-Extending.htm. In particular task executions APIs returs the status of tasks https://help.qlik.com/en-US/nprinting/November2017/APIs/NP+API/index.html#TaskExecutions

We strongly suggest to connect to the PostgreSQL database only if you are aware of what you are doing. There is the risk that an error compromises the Repository so, first of all, create a backup and keep it updated. Then connect to PostgreSQL.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[kdmarkee]

So even just simply querying the database is risky?

[Ruggero_Piccoli · Accepted solution]

When you install the Repository you create only one PostreSQL user with administrative rights. So the first connection to the DB can be done only with that superuser. If you do the wrong actions with a superuser you can damage the repository and compromise Qlik NPrinting. The only way to restore it is by using a backup.

So if you are skilled with PostgreSQL you already know how to connect, you already know that you must create a backup before and you know how to create a new PostgreSQL user with only querying rights. If you don't already know these information my suggestion is to avoid to connect to avoid the risk to damage your Qlik NPrinting installation or to ask to an expert to assist you.

If you want to connect in any case you can but you'll do at your own risk.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

[kdmarkee]

Thanks for the info, appreciate it.  That all makes sense; I just wanted to make sure there wasn't some other obscure reason.

[i_shamaev]

How to connect to postgresql database from another server? I can connect using localhost on NPrinting Server. But I want to connect from the QlikView server.
Please do not advise the API.