Para Conectar MySQL desde Google Data Studio y generar reportes puede ver documentación oficial en siguiente enlace https://support.google.com/datastudio/answer/7088031, al final hay una nota que dice lo siguiente:
Notas
Si su base de datos tiene activado un cortafuegos, debe abrir el acceso a las direcciones IP que se incluyen a continuación. Data Studio las utiliza para conectarse a su base de datos de MySql y consultarla.
64.18.0.0/20
64.233.160.0/19
66.102.0.0/20
66.249.80.0/20
72.14.192.0/18
74.125.0.0/16
108.177.8.0/21
173.194.0.0/16
207.126.144.0/20
209.85.128.0/17
216.58.192.0/19
216.239.32.0/19
Realizamos pruebas para Conectar MySQL e ingresamos las IP a la lista blanca. Pero la conexión fue rechazada
Lista de IPs
Notas
108.177.8.0
108.177.8.1
108.177.8.10
108.177.8.11
108.177.8.12
108.177.8.13
108.177.8.14
108.177.8.15
108.177.8.16
108.177.8.17
108.177.8.18
108.177.8.19
108.177.8.2
108.177.8.20
108.177.8.21
108.177.8.3
108.177.8.4
108.177.8.5
108.177.8.6
108.177.8.7
108.177.8.8
108.177.8.9
173.194.0.0
173.194.0.1
173.194.0.10
173.194.0.11
173.194.0.12
173.194.0.13
173.194.0.14
173.194.0.15
173.194.0.16
173.194.0.2
173.194.0.3
173.194.0.4
173.194.0.5
173.194.0.6
173.194.0.7
173.194.0.8
173.194.0.9
207.126.144.0
207.126.144.1
207.126.144.10
207.126.144.11
207.126.144.12
207.126.144.13
207.126.144.14
207.126.144.15
207.126.144.16
207.126.144.17
207.126.144.18
207.126.144.19
207.126.144.2
207.126.144.20
207.126.144.3
207.126.144.4
207.126.144.5
207.126.144.6
207.126.144.7
207.126.144.8
207.126.144.9
208.91.198.97
209.85.128.0
209.85.128.1
209.85.128.10
209.85.128.11
209.85.128.12
209.85.128.13
209.85.128.14
209.85.128.15
209.85.128.16
209.85.128.17
209.85.128.2
209.85.128.3
209.85.128.4
209.85.128.5
209.85.128.6
209.85.128.7
209.85.128.8
209.85.128.9
216.239.32.0
216.239.32.1
216.239.32.10
216.239.32.11
216.239.32.12
216.239.32.13
216.239.32.14
216.239.32.15
216.239.32.16
216.239.32.17
216.239.32.18
216.239.32.19
216.239.32.2
216.239.32.3
216.239.32.4
216.239.32.5
216.239.32.7
216.239.32.8
216.239.32.9
216.58.192.0
216.58.192.1
216.58.192.10
216.58.192.11
216.58.192.12
216.58.192.13
216.58.192.14
216.58.192.15
216.58.192.16
216.58.192.17
216.58.192.18
216.58.192.19
216.58.192.2
216.58.192.3
216.58.192.4
216.58.192.5
216.58.192.6
216.58.192.7
216.58.192.8
216.58.192.9
64.18.0.0
64.18.0.1
64.18.0.10
64.18.0.11
64.18.0.12
64.18.0.13
64.18.0.14
64.18.0.15
64.18.0.16
64.18.0.17
64.18.0.18
64.18.0.19
64.18.0.2
64.18.0.20
64.18.0.3
64.18.0.4
64.18.0.5
64.18.0.6
64.18.0.7
64.18.0.8
64.18.0.9
64.233.160.0
66.102.0.0
66.102.0.1
66.102.0.10
66.102.0.11
66.102.0.12
66.102.0.13
66.102.0.14
66.102.0.15
66.102.0.16
66.102.0.17
66.102.0.18
66.102.0.19
66.102.0.2
66.102.0.20
66.102.0.3
66.102.0.4
66.102.0.5
66.102.0.6
66.102.0.7
66.102.0.8
66.102.0.9
66.249.80.0
66.249.80.1
66.249.80.10
66.249.80.11
66.249.80.12
66.249.80.13
66.249.80.14
66.249.80.15
66.249.80.16
66.249.80.17
66.249.80.18
66.249.80.19
66.249.80.2
66.249.80.20
66.249.80.3
66.249.80.4
66.249.80.5
66.249.80.6
66.249.80.7
66.249.80.8
66.249.80.9
72.14.192.0
72.14.192.1
72.14.192.10
72.14.192.11
72.14.192.12
72.14.192.13
72.14.192.14
72.14.192.15
72.14.192.16
72.14.192.17
72.14.192.18
72.14.192.2
72.14.192.3
72.14.192.4
72.14.192.5
72.14.192.6
72.14.192.7
72.14.192.8
72.14.192.9
74.125.0.0
74.125.0.1
74.125.0.10
74.125.0.11
74.125.0.12
74.125.0.13
74.125.0.14
74.125.0.15
74.125.0.16
74.125.0.2
74.125.0.3
74.125.0.4
74.125.0.5
74.125.0.6
74.125.0.7
74.125.0.8
74.125.0.9
Para Conectar MySQL, Funciono cuando le agregamos las direcciones IP con símbolos de porcentaje
64.233.%.%
66.102.%.%
66.249.%.%
72.14.%.%
74.125.%.%
108.177.%.%
173.194.%.%
207.126.%.%
209.85.%.%
216.58.%.%
216.239.%.%
Siguiente tema de interés sugerido:
“Envío automático de informes en Google Analytics vía correo electrónico”
0 comentarios