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.

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.

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.

How to generate a REST API and publish into Klipfolio.

Sure you can instantly create an API for any database but it is what comes next that will really blow your mind. Secure, automate, scale, deploy multiple APIs across multiple applications. Convert SOAP to REST, merge multiple data tables, automatically translate messages, formulate custom tables and dashboards- You get the knife, the toothpick and the screwdriver!

Microapps help employees get work done faster, providing a highly tailored user interface, mobile-first experience, and push notifications to quickly power through daily responsibilities. Thanks to the native microapp builder Citrix Workspace users have access to a particularly powerful solution for creating microapps, and the builder can easily plug into the DreamFactory platform in order to almost instantly generate modern user interfaces for twenty different databases including Microsoft SQL Server, MySQL, Oracle, MongoDB, and others.