Systems | Development | Analytics | API | Testing

How to set up a Microsoft SQL Server API in DreamFactory

This video will show you how simple it is to set up a Microsoft SQL server using DreamFactory. Who we are: DreamFactory is an API generation solution for more than 20 databases and many other data sources. With DreamFactory you can connect to any data source and instantly access a full-featured, secure, and documented REST API for your projects. DreamFactory replaces months of API development and server-side integration work. Start your projects with reliable REST APIs from day one.

Self Host Your REST APIs with DreamFactory in Minutes

DreamFactory is a leading on-prem API generation and management platform built for data teams and backend developers to securely connect self-hosted and legacy systems and make them universally accessible. With DreamFactory, developers can connect nearly any database or data source with secure, compliant REST APIs in minutes instead of days.

How to set up a Microsoft SQL Server in DreamFactory

This video will show you how simple it is to set up a Microsoft SQL server using DreamFactory. Who we are: DreamFactory is an API generation solution for more than 20 databases and many other data sources. With DreamFactory you can connect to any data source and instantly access a full-featured, secure, and documented REST API for your projects. DreamFactory replaces months of API development and server-side integration work. Start your projects with reliable REST APIs from day one.

Calling SQL Server Stored Procedures from a REST API

Using the DreamFactory API management platform it's easy to expose your database stored procedures via API endpoints. This short video demonstrates how to use DreamFactory's auto-generated API endpoints to list available stored procedures, learn more about a specific stored procedure, and call a stored procedure with several input parameters.

Creating Read Only APIs with DreamFactory

As a best practice, you should take care to provide clients with the minimal API access privileges required to successfully complete their tasks. DreamFactory's role based access control manager ensures administrators never leave your data sources unnecessarily vulnerable, offering a point-and-click interface for quickly defining and reviewing privileges. In this video we'll walk through the configuration of a role-based access control, demonstrating how a client's API access privileges can be easily updated so as to allow only read access to a select set of API endpoints.