Skip to main content

Azure SQL Database

Category: Direct connection · Azure

Managed SQL database in Azure. Direct connection: Yres reads the tables via a Copy activity in Azure Data Factory and loads them into the data warehouse.

Expected input​

When adding the source (type Azure SQL Database), you fill in the same five database fields as for SQL Server:

FieldExplanation
HostThe full server name, in the form xxx.database.windows.net.
PortThe database's listening port. For Azure SQL Database always 1433.
Database nameThe name of the database (catalog) you want to connect to.
UsernameA SQL login (Yres uses SQL authentication).
PasswordThe password for that login.

Authentication: Basic (username + password, SQL authentication).

Integration runtime: Azure SQL Database is publicly reachable from the cloud, so the default AutoResolveIntegrationRuntime (cloud) is sufficient. A self-hosted Integration Runtime is only needed if the database is shielded behind a private network or firewall and is not directly reachable.

Requirements / preparation:

  • A SQL login with read access to the relevant database (see Where to find these).
  • Allow the Azure Data Factory IP range in the SQL server's firewall, or enable the "Allow Azure services and resources to access this server" option on the Azure SQL server, so the cloud Integration Runtime can reach the database.
A single connection-string secret in the Key Vault

Yres does not store the credentials itself: the connection is placed as a single secret adf-{sourcename}-connectionstring in the customer's Azure Key Vault and read from there by the linked service (type: AzureSqlDatabase).

Where to find these​

You'll find these values in the Azure Portal.

  • Host / Port — Host is the full server name in the form xxx.database.windows.net. In the Azure Portal, open your SQL database → Overview and copy the value next to Server name. Port is always 1433.
  • Database name — The database name, also found on the SQL database's Overview screen.
  • Username / Password — Use a SQL login (Yres uses SQL authentication). Preferably create a dedicated account with read-only rights on the relevant database.

Official documentation: Microsoft Learn — Connect and query Azure SQL Database

See also: Integration catalog · All data source requirements · Integrations — overview