AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3K members online now
3K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data studio and Security

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I would like to know or are the evolutions for the security at the level of exchanges between the database mySQL and Data Studio. Is it secure or not? and if it is not can i make smth to make it more secure? 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Thomas M
May 2017

Data studio and Security

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hey Thomas,

 

Opening your database so that Google Data Studio can access it can make your data quite vulnerable if done carelessly. There are a couple of things you could do to make it as secure as possible.

1. Create a special MySQL user for analytics that has read-only access only to the databases, tables, and views you want to include in your reports.

2. On your MySQL server, do not expose the database to the world. Use firewall to only allow the IPs listed in here to access your database port: https://support.google.com/datastudio/answer/7088031?hl=en

3. Setup SSL. There are tools to create self-signed certificates and use those on your MySQL server. Without SSL all your data will flow through the internet between your server and Google in a format that would allow a "man in the middle" to read it.

 

Hope this helps.

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author Thomas M
May 2017

Data studio and Security

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

Hey Thomas,

 

Opening your database so that Google Data Studio can access it can make your data quite vulnerable if done carelessly. There are a couple of things you could do to make it as secure as possible.

1. Create a special MySQL user for analytics that has read-only access only to the databases, tables, and views you want to include in your reports.

2. On your MySQL server, do not expose the database to the world. Use firewall to only allow the IPs listed in here to access your database port: https://support.google.com/datastudio/answer/7088031?hl=en

3. Setup SSL. There are tools to create self-signed certificates and use those on your MySQL server. Without SSL all your data will flow through the internet between your server and Google in a format that would allow a "man in the middle" to read it.

 

Hope this helps.

 

Data studio and Security

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks good idea Smiley Happy