Integrate DreamFactory with Microsoft SQL Server

Microsoft SQL Server is Microsoft's flagship database, relied upon by millions of enterprises around the globe as a mission critical data store. SQL Server's popularity is also apparent within the DreamFactory community, as the platform's SQL Server connector is by far the most used of the 19 supported databases.

Using this connector, developers and database administrators can instantaneously generate full featured, fully documented, and secure REST APIs for any SQL Server database. In addition to endpoints for all of the usual CRUD operations, developers can additionally interact with views and stored procedures, and can even inspect and interact with the schema.

This auto-generated API is however only the beginning. DreamFactory users can then proceed with assigning highly specific role-based access controls (RBAC) capable of limiting access to specific tables or stored procedures, and even determining what actions a client can take (GET, POST, PUT, PATCH, DELETE). It's also possible to define row-based limits, further restricting client access.

Another popular DreamFactory feature used in conjunction with SQL Server APIs is Data Mesh. Data Mesh allows you to create virtual relationships between SQL Server and other databases such as Oracle or MySQL, even when these databases reside in different clouds. To learn more about data mesh, DreamFactory Academy offers a detailed video titled "Merging Multiple Database API Calls with Data Mesh". We've also recently published a blog post titled Easier Data Marts with Data Mesh.

Because performance and analytics are crucial to modern devops, all SQL Server API behavior can be closely monitored through DreamFactory's Elastic Stack integration. The amazing Kibana-powered dashboards provide up-to-the-second insights into API key usage, HTTP response codes, data consumption, and much more.

If your team is seeks to build powerful applications atop SQL Server, get in touch! We can quickly set you up with a hosted or on-premise trial so you can experience for yourself the power of the DreamFactory Platform.