Would you like to talk to your Microsoft SQL Server database using REST? Using DreamFactory’s MS SQL connector you can immediately generate a REST API for your MS SQL databases, avoiding the inconvenience, cost, and effort of having to write these APIs yourself.
But You Need More Than Just MS SQL to REST...
DreamFactory’s auto-generated APIs are secure, documented, and extensible, in line with industry best practices. You’ll save money, time, and effort by not reinventing the wheel and instead taking advantage of the following features:
Worried about unauthorized third-parties access your service logic and data? DreamFactory requires all REST interactions to be accompanied by an API key that restricts access to the service and its underlying functionality and data.
Application code riddled with ad hoc role-based access control logic? With the click of a button, you can create, assign, and manage access groups that are as granular as you need. For instance, you could use this capability to limit certain applications to read-only requests, while allowing others to both retrieve and manage data.
Custom Business Logic
Unable to modify legacy service business logic? Use DreamFactory’s pre- and post-request event handling scripting capabilities to validate request input, throw exceptions, and even completely transform your domain models using one of five supported languages (Node.js, PHP, Python, Ruby, and the V8.js scripting language).
Need to perform complicated SQL queries and joins? DreamFactory’s got you covered with click-not-code capabilities allowing you to retrieve data from multiple tables, create virtual keys, and even use our powerful Data Mesh solution to combine information from multiple and otherwise unrelated databases. You can also interact with stored procedures and views, ensuring you can take full advantage of your database capabilities.
Logging and Limiting Requests
In the dark regarding who is accessing your services? What about usage volume? DreamFactory’s logging and limiting features allow you to create audit trails identifying who accessed services and determine when they were accessed. Additionally, you can assign API request quotas to users and services, defining and monitoring request volume on a monthly, weekly, daily, hourly, and even on a minute by minute basis.
Auto-generated API Documentation
Team grumbling about missing and inconsistent API documentation? All DreamFactory services come with auto-generated and interactive Swagger documentation. Team members can use these documents to become familiar with the endpoints, functionality, and payloads before even writing a single line of code!
DreamFactory is Easy
No special changes to your MS SQL database server are required. Just supply the authentication credentials, and DreamFactory will generate the corresponding REST API, complete with a Swagger document allowing you to interact with the service via DreamFactory’s interface.
DreamFactory is Enterprise Ready
Our enterprise customers rely on DreamFactory to manage thousands of REST services, sending millions of daily requests through their environments. Supported within any enterprise environment, your on-premise instance can be installed, managed and scaled with ease. Our 24x7 support team is committed to ensuring your project succeeds, and our engineering team is ready to assist in proof of concept development and custom implementations.
Want to see the MS SQL-to-REST connector in action, or have questions about what else DreamFactory can do for you? Schedule a demo with our technical team now!