0

My client has his data stored on SQL Server hosted on an on-premise network. I established a VPN connection from Google to the network, but I don't know how to follow from here. My final goal is to process his data using cloud functions. Any suggestions?

PS: I read that Shared VPC can be used to accomplish this, but I don't have a proper organization for this purpose :/

Edit: I followed the suggestions on the comments but now I'm missing to extract the data since pyodbc is not pre-installed on Cloud Functions. Any ideas oh how to query an on-prem database on SQL Server through Cloud Functions?

Sebastian Tinoco
  • 1
  • 1
  • Are you using `Cloud Interconnect` or `Cloud VPN` to connect on-premises? If yes, then configure `Serverless VPC Access`. You will then be about to connect from Cloud Functions to on-premises SQL server. Edit your question with more details. Read this link for more information: https://cloud.google.com/vpc/docs/configure-serverless-vpc-access – John Hanley Jan 29 '21 at 16:01
  • Serverless VPC connector is the correct solution. In addition, be sure that your routing and firewall rules are OK. – guillaume blaquiere Jan 29 '21 at 16:05
  • I am using Cloud VPN to connect to the network. I configured the Serverless VPC Access and built a function using this VPC. It should be working, but I'm missing a way to test the connection since my script was built using pyodbc and this packaged is not installed on Cloud Functions. Any suggestions would be appreciated! – Sebastian Tinoco Jan 29 '21 at 19:04
  • @SebastianTinoco: Spending some time reading the docs on how to install the packages for your cloud function will go a long way. – Asdfg Jan 29 '21 at 19:15
  • Use Cloud Run, it's almost the same thing, but you have a container, and you can install easily what you want in your container. – guillaume blaquiere Jan 29 '21 at 19:44

0 Answers0