I want to connect to the Sense Resository PostgreSQL Database by PGAdmin in the server Qlik sense.
Has anyone in the community already done this?
I am curious why you are trying to accomplish this. Doing this is something that is marginally supported so I do need some clarity on what the purpose of this.
If you want to see the data then you can use a PostgreSQL ODBC driver and connect to it as a data source.
super easy to do - but as ltu suggested the chance of messing something up is huge and the benefit is minimal as you can do most of the updates/changes either manually via the QMC or programatically with the API
I’m agree with you. i don't amuse modify data in the repository data base.
In fact now I’am creating tags, stream, security rule etc in QMC on development environment etc. And I should recreate all of them on production. So I ask if there is a easyer way to do it. For example can I export list of tag from repository A and then import them into repository B.
I want to view all data base, par exemple FK, trigger etc.
I want to find a esayer way to copy all configuration from a site to another site.
Did you talk about repository snapshot manager of qlik sense?
Can you explain more detail please?
There is no easy method to swap settings between environments. To your question, you'd need to things here:
(1) can be accomplished using a PostgreSQL ODBC driver connection to the PostgreSQL database.
(2) is in no way supported so I cannot recommend a method of accomplishing this. As Martin gestured to, there are ways to accomplish this using the QRS API (https://help.qlik.com/en-US/sense-developer/3.0/Subsystems/RepositoryServiceAPI/Content/RepositorySe...) . I am by no means fluent in how to do it, but the endpoints seem there.
That being said, it does not pertain to tags / tasks / custom properties, but it does pertain to security rules, there is a Chrome extension (which doesn't look to work on 3.0.x at the moment) which can be used to accomplish this: Qlik Branch definitely check that out / follow up with the Dev there about getting this ported to work with 3.0.x if you're running that version.
I am using pgAdminIII
password: (used in installation)
You can see all the tables in the Schema option
Hope this helps you
This make not much sense since in next version v3.1 PostgreSQL database will be replaced by something else. I rather would start setting up a cluster to replicate things.