It is possible to visualize data from PostgreSQL using Targetprocess Visual Reports.
Using PostgreSQL App
-
Setup account
Start with creating a new report, select PostgreSQL app, provide the name of connection and connection string to PostgreSQL. You can read more about connection string here.
-
Configure data settings using PostgreSQL table source type
Select table source type if the the count of records is less than 200,000. It is possible to limit the count of retrieved rows using Filter, Sort, Limit options. We have imported Flowers Dataset to "flowers" PostgreSQL table for this example.
-
Create an awesome chart
-
Retrieve data using PostgreSQL query source
Alternatively, you can use the Query source. It is useful in the case when the count of records is bigger than 200,000.
So the chart configuration may look like this.
Still have a question?
We're here to help! Just contact our friendly support team
Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.