PostgreSQL app in Visual Reports | Targetprocess - Enterprise Agility Solution

PostgreSQL app in Visual Reports

It is possible to visualize data from PostgreSQL using Targetprocess Visual Reports.

Using PostgreSQL App

Targetprocess Image

  • 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.

    Targetprocess Image

  • 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.

    Targetprocess Image

  • Create an awesome chart

    Targetprocess Image

  • 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.

    Targetprocess Image

    So the chart configuration may look like this.

    Targetprocess Image

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.

Or contact
a sales representative

Get a live
product demo

Let one of our product specialists create your account
and shape Targetprocess for your company needs.