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

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
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