Visual Reports: MongoDB, PostgreSQL and GitHub apps are available | Targetprocess - Enterprise Agility Solution
2 years ago

Visual Reports: MongoDB, PostgreSQL and GitHub apps are available

We have added the possibility to visualize data from MongoDB, PostgreSQL and GitHub.

Using MongoDB App

Targetprocess Image

  • Setup account

    Start with creating a new report, select MongoDB app, provide the name of connection and connection string to MongoDB. You can read more about connection string here.

    Targetprocess Image


  • Configure data settings using MongoDB collection source type

    You may proceed with selecting collection source type if the records count supposed to be retrieved are less than 200,000. It is possible to limit the count of retrieved rows by applying query or by providing limit with ordering. We have imported Stocks Dataset to "stocks" MongoDB collection for this example.

    Targetprocess Image

  • Create the chart for retrieved collection

    Targetprocess Image

  • Configure data settings using MongoDB aggregation pipeline source type

    Alternatively, you may proceed with configuring aggregation pipeline to build the same chart. It is useful in the case when records count supposed to be retrieved are more than 200,000. It can be a bit complex since requires knowledge on how MongoDB aggregation pipeline works, read more about that here. I prefer to use some GUI client (it is MongoHub in my case) for creating and testing pipeline before pasting it into the source form, but it is not necessary if you are MongoDB pro.

    [ 
        { $group : { _id : { company: "$company", date: "$date"}, price: { $sum: "$price" } } }, 
        { $project: { _id: { $concat: ["$_id.company", "-", "$_id.date"] }, company: "$_id.company", date: "$_id.date", price: "$price" } }
    ]

    Targetprocess Image

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

    You may proceed with selecting table source type if the records count supposed to be retrieved are less than 200,000. It is possible to limit the count of retrieved rows by applying query or by providing limit with ordering. 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 may proceed with configuring query source. It is useful in the case when records count supposed to be retrieved are more than 200,000.

    Targetprocess Image

    So the chart configuration may look like this.

    Targetprocess Image

Using GitHub App

Targetprocess Image
  • Setup account

    Start with creating a new report, select GitHub app and paste your personal GitHub token. You can generate it here if you don't have one.

    Targetprocess Image

    Create an account with your personal GitHub Token.

    Targetprocess Image

  • Select a chart from predefined templates or start creating from scratch

    We have added several templates for GitHub app, so you can select one or create the chart from scratch. There are two sources available — weekly contributions and pull requests.

    Targetprocess Image

    Select repositories to visualize by your profile or for your organization.

    Targetprocess Image

     

  • Explore GitHub data visually by changing chart settings

    Targetprocess Image

Let us know about any questions or comments.

 

Subscribe to the latest updates

Thank you!

Сheck out latest blog posts: Show all

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.