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. Currently, Databases supports MySQL, PostgreSQL, and Amazon Redshift databases.
SQL-Datasets is a command line app developed by Geckoboard to easily connect your database data to Geckoboard via the Datasets API.
To connect use our Datasets API, you must be on a paid plan.
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
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:
Amazon RDS Aurora
Amazon RDS MariaDB
Amazon RDS MySQL
Amazon RDS Oracle
Amazon RDS PostreSQL
Amazon RDS SQL Server
Google Cloud SQL for MySQL
Microsoft Azure SQL
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:
Visit Parabola's website for more information. We also have a detailed article on how to use Parabola for Geckoboard.