Process data from on-premise SQL Server with cloud functions?

923 Views Asked by At

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?

0

There are 0 best solutions below