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: Geckoboard ensures that the SQL-Datasets feature is accessible across all pricing plans, removing barriers for businesses of all sizes to leverage advanced data visualizations.
Are looking for alternatives to the native Databases feature despite its availability across all pricing plans.
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. This feature is included in all pricing plans, ensuring accessibility for all users regardless of their subscription level.
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.