Setup Your Own Cloud Database

One challenge many people face when trying to go digital and get more out of their data, is the problem of setting up a database online, in the cloud. In this video demonstration, we’ll show you how to set up a MySQL database on the Google Cloud platform and connect it to Holistics.

First, create an instance in Google Cloud SQL, by following the steps in the video starting from 0:28.

Google cloud instance

While configuring the settings of your Google Cloud instance, remember to whitelist the Holistics IP addresses by adding these to the list of authorized networks to be able to connect your MySQL database to Holistics, as mentioned at 1:42.

Google whitelist

Wait for a few minutes and once your instance is ready, you will then need to create a user account with a user name and password of your choice, which are details you will need in order to connect this data source to Holistics. You will also need to create a database inside this instance.

Google user

Once you have completed all the steps above, you are ready to connect your MySQL database to Holistics, as shown at 03:32. If you have provided the details correctly, you will see a message indicating that you have connected successfully, when you click on the “Test Connection” button. You can now connect this data source to Holistics.

Google connect

The rest of the guide video will show you how to load a table of data from Google Spreadsheets into your MySQL database using the Data Imports feature on Holistics, as well as how to build a simple area chart report on Holistics using the data that was imported.

For more information on how to start using Holistics, please have a look at our supporting documentation on Getting Started. If you have other questions you need help with, please feel free to directly contact us here.