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 intended 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.
SQL-Datasets
SQL-Datasets is a command line app 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 Supermetrics you 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
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.