Can we connect Azure SQL managed instance to google cloud?

[kirankumar1728]

Hello,

Thanks in advance for reading my message. Is it possible to connect google cloud storage from Azure SQL managed instance? Can we connect through ODBC? As there is vm for SQL managed instance, not sure what is the best way to read the data.

Source: Google Cloud

Target: Azure SQL managed instance

Appreciate your help.

Regards

Kumar

[v-venuppu · Accepted solution]

Hi @kirankumar1728 ,

Thank you for reaching out to Microsoft Fabric Community.

Yes, you can connect Google Cloud Storage to Azure SQL Managed Instance, but not directly from within the SQL instance itself. Here's how you can do it:

Best way is to Use Azure Data Factory (ADF):

• ADF lets you read data from Google Cloud Storage and load it into Azure SQL Managed Instance.
• It has built-in connectors for both GCS and SQL MI.
• This is the easiest and most reliable option.

ODBC Driver is Not supported directly:

• SQL Managed Instance doesn’t allow you to install ODBC drivers or run custom code, so you can’t connect to GCS directly from inside SQL MI.
• If you want to use ODBC, you’d need to set it up on a separate VM, pull data from GCS there, and push it into SQL MI.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[kirankumar1728]

Hello, Thank you for the detailed explaination. The first approach seems to be the best way to read data from google cloud. I will try that one and reach out to the community in case of any questions. Thanks again. 

Kiran