For simplicity, SAS treats the Microsoft Fabric Data Warehouse as a SQL Server endpoint. Microsoft provides this endpoint—known as the SQL analytics endpoint or TDS endpoint—as part of Fabric to enable compatibility with third-party applications.
SAS leverages this endpoint using existing SQL Server drivers (e.g., ODBC Driver 18 or later), allowing SAS to connect and query data in Fabric without requiring custom connectors. This approach aligns with Microsoft’s design, which exposes the Fabric Data Warehouse through a Tabular Data Stream (TDS) protocol, the same protocol used by SQL Server.
This means SAS can interact with Fabric in much the same way it does with traditional SQL Server databases, simplifying integration and reducing the need for specialized configuration. However, it’s important to note that Fabric’s SQL analytics endpoint is currently read-only, and writing data into OneLake may require alternative methods such as REST API calls or using supported file formats like Parquet.
How to Connect - Microsoft Fabric | Microsoft Learn SAS Help Center: Access an Azure SQL Database
... View more