Microsoft Fabric / Azure Synapse
Live, over the same protocol as SQL Server.
- How it connects
- Live, over the same protocol as SQL Server. On Fabric it signs in with a Microsoft Entra app; on Synapse, with an Entra app or a SQL user. It does not store the data: it reads it where it lives.
- What it reads
- The warehouse's tables, views, external tables and procedures. Declared keys are shown, though the warehouse does not enforce them. Missing ones are only proposed for a person to review, based on the joins in views and the query history.
- Which account it needs
- The Entra app with read-only access to the warehouse (Read permission and SELECT) or, on Synapse, a read-only SQL user.
- Can it write?
- No: it is read-only.
More Data warehouses connectors
All connectorsShall we connect it in your company?
We tell you what your case needs and leave it running on your server.