Forum Discussion

iW1DOV's avatar
iW1DOV
Icon for Helper II rankHelper II
5 months ago
Solved

How to connect to a SQL server publicly exposed on the Internet?

So this customer wants me to connect to a SQL Server database they configured to be directly exposed on the Internet (please don't ask, don't tell).  I am trying to design a test semantic model direc...
Need Help
  • Cookistador's avatar
    Cookistador
    5 months ago

    To avoid  using a gateway, you must rely on one of the following database:

    • Azure SQL Database
    • Azure Synapse Analytics
    • Amazon Redshift or Google BigQuery

    For other databases such SQL Server (even when exposed via a public IP), Postgres,mysql, oracle , ... the use of a gateway is required
    The simplest approach to eliminate the gateway, would be to migrate to Azure SQL Database

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
5 months ago

Hi iW1DOV, 

 

If it's a recent version of SQL Server, you might be able to connect to it using the Azure SQL Database connector. 

I've found that works sometimes and othertimes it doesn't. 

If that doesn't work, then you will either need to set up a gateway, migrate the database to Azure, or set up some other kind of hop to put data someplace that Fabric can access it without thinking it needs a gateway.