Cloud SQL Integration

Cloud SQL Integration allows data to be transferred between survey responses and your SQL databases for advanced data analysis.


   Professional         
   Enterprise         
   ReportR     
   DistributR     

note
NOTE


What are the benefits of this integration?

  • You can replicate survey response data to a Google-managed Cloud SQL database. From there, you can integrate your database with many other applications.
  • It allows you to create a dashboard in Google Data Studio (Free application) that can compare multiple surveys at once.
  • You can use this database as a data source for data analysis BI tools (such as Google Data Studio) if you want to have a more extensive overview of the results.
  • It allows you to have an enriched network of data sources.

Read Google's Cloud SQL guide to learn about even more benefits!




This guide will teach you:

  1. Create instance
  2. Create database
  3. Connect database

1. Create instance

You'll first need to create a Cloud SQL instance - click Create instance.

Cloud SQL Integration - create instanceNext, choose your database engine. Click MySQL on the left.

Cloud SQL Integration - database engineNow complete the fields for instance ID and a root password (needed to get access to your database). Here you can also select the Region and time zone.

Cloud SQL Integration- Instance info

2. Create database

The next step is to create a database. Click the blue button Create database and set the character set as utf8mb4 rather than the default option. Now click Create.

Cloud SQL Integration- create database

Head over to IAM & admin settings and click on +Add (in the middle of the screen).


Add a new member sa-cloud-sql-integration@appspot.gserviceaccount.com and select Cloud SQL Client as the role.

Cloud SQL Integration- member

3. Connect database

It's now time to connect your database with Pointerpro. Copy the instance ID which you'll find on the Overview page.

Cloud SQL Integration-SQL overview

Now go to Pointerpro and click on the Extra Options tab of your survey. Now scroll down to find the Integrations option in the Other options section.


Choose the integration Cloud SQL on the left-hand side. Toggle to enable this integration and paste the instance ID which you copied + fill in the Database name, Username, and Database password.

Cloud SQL Integration-SQL setup

You're now all set up and ready to configure Google Data studio with SQL source.

What's next?

  • Google Tag Manager is a tag system that can be used for tracking and analytics on websites. It can be used to track respondents' behavior in your survey or to find out how effective an advert promoting your survey has been.
  • Zapier is a tool that enables the transfer of data from one web app to another one. By using Zapier in combination with Pointerpro, you can send the data collected within your survey to create contacts in Pointerpro or send data to apps such as Mailchimp, Salesforce, Trello, and many more. For example, to transfer email addresses collected in a survey to a Mailchimp email list.
  • Integromat allows you to automate many processes and simplifies the transfer of information between apps, saving you bags of time! Integromat offers similar features to Zapier but is more powerful as you can set a single event to trigger a number of different actions to be taken simultaneously.
S
Support is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.