Product
Microsoft SQL Server
About
Microsoft SQL Server is a relational database engine a firm runs on its own Windows or Linux servers, or in a container. In AEC it is mostly a destination rather than a tool anyone opens: construction platforms replicate project and financial data into it so reporting runs off one store. Microsoft sells it per core in Enterprise, Standard and Developer editions, and the current release is SQL Server 2025. Azure SQL Database and Azure SQL Managed Instance are separate managed services built on the same engine.
How teams use it
By audience
- IT & Systems Administration
- Runs, patches and sizes the instance the firm owns, on Windows, Linux or in a container, licensed per core rather than per seat
- Receives replicated Procore project data through a partner tool, so reporting queries a copy instead of the live platform
- Lands Procore Analytics 2.0 Delta Share output through Procore's own SQL Server packages on a schedule the customer sets
- Serves Power BI, Tableau and Qlik Sense over ODBC, so reports written against an existing instance keep working
- Mirrors into Microsoft Fabric OneLake from SQL Server 2016 onward, using change data capture on releases before 2025
Integrations (15)
| Integrates with | Connection | Details |
|---|---|---|
| NativeQuick Sight Microsoft SQL Server connector | ||
 | NativeAppSheet SQL Server data source | |
 | iPaaSAquifer Microsoft SQL Server connector | |
 | NativeArcGIS database connection and enterprise geodatabase on SQL Server | |
 | NativeTransactional replication to Azure SQL Database | |
 | NativeData Studio Microsoft SQL Server connector | |
 | NativeLakehouse Federation for SQL Server | |
 | NativeLooker Microsoft SQL Server dialect | |
 | NativeMirroring SQL Server in Fabric | |
 | iPaaSSQL Server connector for Power Automate | |
 | NativePower Query SQL Server connector | |
| NativeAnalytics Cloud Connect (Delta Share → SQL Server) | ||
 | NativeQGIS MS SQL Server data provider | |
| NativeTableau Microsoft SQL Server connector | ||
| NativeTBC GIS Connection Manager: SQL Server Service data source |
Only partners listed on AEC Integrations appear here. If one is missing, suggest a correction.
Reviews
No reviews yet — be the first to review this product.
Directory updates
Know when new tools and reviews land
AEC Integrations is live and still growing. Add your email for occasional updates as we expand the directory with new tools, integrations, and reviews.