This add-on is operated by Ivan Schneider
Business intelligence insights and analytics from your database
DbInsights
Last updated 03 February 2016
Table of Contents
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.
The currently supported RDBMS are PostgreSQL and MySQL.
Installing the add-on
DbInsights can be installed to a Heroku application 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 install and run a plugin for the Heroku command line tool :
$ heroku plugins:install git://github.com/isc/heroku-dbinsights $ heroku dbinsights
The plugin execution will store an encrypted version of the DATABASE_URL of your application in the DbInsights database (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 dbinsight
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:newplan
Removing the add-on
DbInsights can be removed via the CLI.
This will destroy your charts configuration data and your DATABASE_URL from DbInsights database and 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 :