Create a Microsoft SQL Server REST API
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.
Full CRUD Capabilities
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.
Role-based Access Controls
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.
Multiple Databases, One API Response
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.
Real Time Analytics
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 you'd like to build powerful API-driven applications, get in touch, or start a hosted trial today! We can quickly set you up with a hosted or on-premise trial so you can experience the power of the DreamFactory Platform.