Solved: Do I need a gateway for SQL?

grupomacarena · ‎10-24-2022

I'm working with some data stored in a SQL database (not in my computer) and in Google Sheets. Do I still need a gateway for that?

Computer is not always turned on. I don't want to leave it turned on everytime I need to refresh the reports.

Thanks in advance!

ibarrau · ‎10-24-2022

Hi. Where is this SQL Database hosted? the need of the gateways depends on source and on hosting. If your database is on Azure you probably don't need one, but if the database is on a local server on premise then you must use a gateway. You can use a VM/PC that has networks connectivity to the database to keep it turned on all day instead of using your PC.

I hope that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

ibarrau · ‎10-24-2022

Hi. Where is this SQL Database hosted? the need of the gateways depends on source and on hosting. If your database is on Azure you probably don't need one, but if the database is on a local server on premise then you must use a gateway. You can use a VM/PC that has networks connectivity to the database to keep it turned on all day instead of using your PC.

I hope that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog