DbInsights

Last Updated: 24 April 2013

addons analytics

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:add 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 dbinsights

or by visiting the Heroku apps web interface 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:remove 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