Every project has access to its own data via a connection string that you can copy from Kes. The connection strings can be used to set up a standard JDBC connection from any tool that supports JDBC like Tableau or PowerBI.
Once you've connected you have access to activities_data view that holds all your data (select * from activities_data).
What tools can read Kes data with this solution?
All tools that support jdbc or postgres connections. That's a million tools :-)
For Tableau have a look here for additional documentation.
For PowerBI here.
Excel here.
What does the connection string look like?
The connection string is a standard Postgresql connection URL like this:
postgres://username;:password@kes.postgres.database.azure.com:5432/prod
where
UserName : your rhdhv user name without the '@rhdhv.com'
Password : a onetime only generated and shown password, keep it safe
We will not be able to provide it to you after you've copied it.
What access does the string provide?
The connection string provides acccess to all your projects and all of their data in a read-only fashion.
Can I change data using the connection string?
No, you cannot change data using the provided string. If you want to change data please use the Kes Python Client API.
How do I get the string?
1. Click the 'Database' button in the top right corner.
2. Click the notification that appears to copy the connection URL to your clipboard.
The password is not shown on screen but it is in your clipboard (so control-v on Windows to paste it somewhere)
What to do when I forget to save the connection string?
Please contact us. We'll reset it for you.