Azure Synapse Analytics

• Purpose: Connect to Microsoft Azure Synapse Analytics, a unified analytics service for large-scale data warehousing.
• When to use it: Ideal for enterprise analytics on data in Azure Synapse dedicated SQL pools.
• How to create it:
  1. Go to Data Sources and click Add.
  2. Select Azure Synapse.
  3. Name: Enter a unique name for this connection.
  4. Host: Your Synapse workspace SQL endpoint (e.g., workspace.sql.azuresynapse.net).
  5. Port: Default is 1433.
  6. Database Name: The dedicated SQL pool (database) name.
  7. Schema: (Optional) Default is dbo.
  8. Username / Password: SQL user credentials.
  9. Encrypt: Enable if your Synapse workspace requires encrypted connections (recommended).
  10. Click Test Connection to verify, then Save.

Note: Ensure the Synapse firewall rules allow the Datalytics IP address, or use a managed private endpoint.