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 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 Pro 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 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:
- 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
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:
- Amazon Redshift
Visit Parabola's website for more information. We also have a detailed article on how to use Parabola for Geckoboard.