More ways to get data from your database (without using the Databases data source)

Before you start

The quickest way to integrate your MySQL, PostgreSQL, and Amazon Redshift database with Geckoboard is with our secure Databases data source. 

The solutions and methods in this article are meant for customers who:

  • Don't have access to Databases on their pricing plan.
  • Would prefer to handle the database connection themselves.
  • Need to connect to a database we don't currently support in our Databases data source. Currently, Databases supports MySQL, PostgreSQL, and Amazon Redshift databases.

SQL-Datasets

SQL-Datasets is a command utility is a command-line tool developed by Geckoboard to easily connect your database data to Geckoboard via the Datasets API.

The SQL-Dataset functionality ensures your database credentials are maintained exclusively on your system.

Data sent to Geckoboard this way can then be visualized on a dashboard through Datasets. The SQL-Dataset utility can run on Windows, Mac, or Linux and supports the following Database types:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • SQLite

Supermetrics

With Supermetricsyou can easily schedule automatic synchronizations between your database(s) and Google Sheets. Once in Google Sheets, you can visualize this data on Geckoboard through Spreadsheets.

Supermetrics' Database integration supports the following databases:

  • MariaDB
  • MySQL
  • Oracle
  • PostreSQL
  • SQL Server
  • Amazon RDS Aurora
  • Amazon RDS MariaDB
  • Amazon RDS MySQL
  • Amazon RDS Oracle
  • Amazon RDS PostreSQL
  • Amazon RDS SQL Server
  • Amazon Redshift
  • Google Cloud SQL for MySQL
  • Microsoft Azure SQL

Supermetrics_Database_Integration.png

Visit the Supermetrics website for more information. We also have a short guide on how to use Supermetrics for Geckoboard.

Parabola

With Parabola you can import data from a variety of data sources. Once your data is in Parabola you can push it to many other services, including Geckoboard.

With Parabola you can import data from the following databases:

  • MongoDB
  • MySQL
  • PostreSQL
  • Amazon Redshift

Visit Parabola's website for more information. We also have a detailed article on how to use Parabola for Geckoboard.

Was this article helpful?

Awesome! 👍  Thanks so much for your feedback!

Sorry about that! Start a conversation now.