Skip Navigation
Show nav
Heroku Dev Center
  • Get Started
  • Documentation
  • Changelog
  • Search
  • Get Started
    • Node.js
    • Ruby on Rails
    • Ruby
    • Python
    • Java
    • PHP
    • Go
    • Scala
    • Clojure
  • Documentation
  • Changelog
  • More
    Additional Resources
    • Home
    • Elements
    • Products
    • Pricing
    • Careers
    • Help
    • Status
    • Events
    • Podcasts
    • Compliance Center
    Heroku Blog

    Heroku Blog

    Find out what's new with Heroku on our blog.

    Visit Blog
  • Log inorSign up
View categories

Categories

  • Heroku Architecture
    • Dynos (app containers)
    • Stacks (operating system images)
    • Networking & DNS
    • Platform Policies
    • Platform Principles
  • Command Line
  • Deployment
    • Deploying with Git
    • Deploying with Docker
    • Deployment Integrations
  • Continuous Delivery
    • Continuous Integration
  • Language Support
    • Node.js
    • Ruby
      • Working with Bundler
      • Rails Support
    • Python
      • Background Jobs in Python
      • Working with Django
    • Java
      • Working with Maven
      • Java Database Operations
      • Working with the Play Framework
      • Working with Spring Boot
      • Java Advanced Topics
    • PHP
    • Go
      • Go Dependency Management
    • Scala
    • Clojure
  • Databases & Data Management
    • Heroku Postgres
      • Postgres Basics
      • Postgres Getting Started
      • Postgres Performance
      • Postgres Data Transfer & Preservation
      • Postgres Availability
      • Postgres Special Topics
    • Heroku Data For Redis
    • Apache Kafka on Heroku
    • Other Data Stores
  • Monitoring & Metrics
    • Logging
  • App Performance
  • Add-ons
    • All Add-ons
  • Collaboration
  • Security
    • App Security
    • Identities & Authentication
    • Compliance
  • Heroku Enterprise
    • Private Spaces
      • Infrastructure Networking
    • Enterprise Accounts
    • Enterprise Teams
    • Heroku Connect (Salesforce sync)
      • Heroku Connect Administration
      • Heroku Connect Reference
      • Heroku Connect Troubleshooting
    • Single Sign-on (SSO)
  • Patterns & Best Practices
  • Extending Heroku
    • Platform API
    • App Webhooks
    • Heroku Labs
    • Building Add-ons
      • Add-on Development Tasks
      • Add-on APIs
      • Add-on Guidelines & Requirements
    • Building CLI Plugins
    • Developing Buildpacks
    • Dev Center
  • Accounts & Billing
  • Troubleshooting & Support
  • Integrating with Salesforce
  • Add-ons
  • All Add-ons
  • DbInsights
DbInsights

This add-on is operated by Ivan Schneider

Business intelligence insights and analytics from your database

DbInsights

Last updated February 20, 2019

Table of Contents

  • Installing the add-on
  • Integration
  • DbInsights interface
  • Migrating between plans
  • Removing the add-on
  • Support
  • Additional resources

DbInsights provides you with business intelligence insights and database analytics with minimum efforts on your part. This add-on provides you with an interface to define line charts, pie charts and custom queries on your database that you can then assemble in reports. It also supports advanced features such as cohort analysis and automatic joins for building complex queries.

You can check out the sandbox account to get the feel of it.

DbInsights Graph

The currently supported RDBMS are PostgreSQL and MySQL.

Installing the add-on

DbInsights can be installed for a Heroku application either via your Heroku dashboard or via the CLI:

$ heroku addons:create dbinsights

In order to generate charts on your data, DbInsights needs to be able to connect to your database. The easiest way to do that is to open the DbInsights interface either through the Heroku dashboard or from the CLI:

$ heroku addons:open dbinsights

You will be prompted for an Heroku OAuth permission, DbInsights will fetch and store an encrypted version of the DATABASE_URL of your application (removing the add-on from your application will delete that info from the DbInsights database).

Integration

DbInsights doesn’t need to integrate at a code-level and thus isn’t tied to a particular language. It can be used with any app hosted on Heroku, be it Ruby, Node.js, Clojure, Java, Python, or Scala, as long as it makes use of a PostgreSQL or MySQL database.

Once you’ve completed the previous section you’re all set to use the DbInsights interface.

DbInsights interface

The interface can be accessed via the CLI:

$ heroku addons:open dbinsights

or by visiting the Heroku Dashboard and selecting the application in question and then selecting DbInsights from the add-ons menu.

For more information on using the DbInsights interface please see the docs at dbinsights.herokuapp.com/docs.

Migrating between plans

Use the heroku addons:upgrade command to migrate to a new plan.

$ heroku addons:upgrade dbinsights:standard

Removing the add-on

DbInsights can be removed via the CLI.

This will destroy your charts configuration data and the encrypted version of your DATABASE_URL from DbInsights database. This cannot be undone.

$ heroku addons:destroy dbinsights

Support

All DbInsights support and runtime issues should be logged with Heroku Support. Any non-support related issues or product feedback is welcome at dbinsights.uservoice.com.

Additional resources

Additional resources are available at :

  • DbInsights Website
  • DbInsights documentation
  • DbInsights sandbox account

Keep reading

  • All Add-ons

Feedback

Log in to submit feedback.

Ziggeo Dead Man's Snitch

Information & Support

  • Getting Started
  • Documentation
  • Changelog
  • Compliance Center
  • Training & Education
  • Blog
  • Podcasts
  • Support Channels
  • Status

Language Reference

  • Node.js
  • Ruby
  • Java
  • PHP
  • Python
  • Go
  • Scala
  • Clojure

Other Resources

  • Careers
  • Elements
  • Products
  • Pricing

Subscribe to our monthly newsletter

Your email address:

  • RSS
    • Dev Center Articles
    • Dev Center Changelog
    • Heroku Blog
    • Heroku News Blog
    • Heroku Engineering Blog
  • Heroku Podcasts
  • Twitter
    • Dev Center Articles
    • Dev Center Changelog
    • Heroku
    • Heroku Status
  • Facebook
  • Instagram
  • Github
  • LinkedIn
  • YouTube
Heroku is acompany

 © Salesforce.com

  • heroku.com
  • Terms of Service
  • Privacy
  • Cookies
  • Cookie Preferences