--- title: A Technology Giant Delivers Fast Results with DreamFactory's REST API Platform description: A Technology Giant Delivers Fast Results with DreamFactory's REST API Platform image: https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/team-ben-May-07-2024-08-15-48-6708-AM.jpg --- [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) Products & Services [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) API Management [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) Use Cases AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) #### [Spotlight How enterprises run on DreamFactory From healthcare to energy to finance — governance baked into every endpoint. Browse case studies →](https://www.dreamfactory.com/case-studies) Connectors SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [![DreamFactory logo](https://cdn.prod.website-files.com/64ed8da8a866be7a702fbae0/68d51994d3678214b54acb60_dreamfactory-navbar-logo.svg)](https://www.dreamfactory.com/) ![hamburger](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/menu-hamburger.svg) ![close](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/close-menu.svg) Back to main menu Products & Services Use Cases Industries Connectors [Blog](https://blog.dreamfactory.com/) [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) [AI Data Gateway](https://www.dreamfactory.com/ai-data-gateway/overview) [Overview Why DreamFactory exists](https://www.dreamfactory.com/ai-data-gateway/overview) [Data Gov, Comp, Security Policy enforcement at the API layer](https://www.dreamfactory.com/ai-data-gateway/ai-data-governance) [Standard API Layer One contract for every backend](https://www.dreamfactory.com/ai-data-gateway/standard-api-layer) [API Gateway Functionality Routing, auth, rate limits, observability](https://www.dreamfactory.com/ai-data-gateway/api-gateway-functionality) [Deployment & Integration Self-hosted, cloud, hybrid](https://www.dreamfactory.com/ai-data-gateway/on-premise-deployment-and-integration) [Developer Productivity Auto-generated, never hand-coded](https://www.dreamfactory.com/ai-data-gateway/ai-development-accelerated) [AI App Architectures Patterns for RAG, agents, MCP](https://www.dreamfactory.com/ai-data-gateway/enterprise-ai-architectures) AI Data Models [AIOpenAI](https://www.dreamfactory.com/use-cases/openai) [GGoogle Gemini](https://www.dreamfactory.com/use-cases/google-gemini) [CAnthropic Claude](https://www.dreamfactory.com/use-cases/anthropic-claude-landing) [LMeta Llama](https://www.dreamfactory.com/use-cases/meta-llama) [MMistral AI](https://www.dreamfactory.com/use-cases/mistral) [CoCohere](https://www.dreamfactory.com/use-cases/cohere) Services and support [Quickstart Service Packages Expert-led Quickstarts to production](https://www.dreamfactory.com/services-and-support/quickstart-services-packages) AI Data Models [Generate & Manage REST APIs From any database, in seconds](https://www.dreamfactory.com/api-management/generate-rest-apis) [Features Security, scripting, self-hosted & more](https://www.dreamfactory.com/api-management/features) [API Generation The complete guide to auto-generated APIs](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) [API Management Concepts, tools, and best practises](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools?_gl=1*jl0njh*_gcl_au*MjQzMjgwMTc3LjE3ODIzMjI3MzY) AI Use Cases [AI Data Access Secure, governed reads for your LLMs](https://www.dreamfactory.com/use-cases/ai-data-access) [MCP Server Drop-in Model Context Protocol](https://www.dreamfactory.com/use-cases/mcp-server) [Legacy Modernization Wrap mainframes with REST](https://www.dreamfactory.com/use-cases/legacy-modernization) [Data Governance Audit every call, enforce every policy](https://www.dreamfactory.com/use-cases/data-governance) [Customer Case Studies](https://www.dreamfactory.com/case-studies) [Energy Modernization](https://www.dreamfactory.com/case-studies/energy-snowflake-modernization) [Government Modernization](https://www.dreamfactory.com/case-studies/government-mainframe-oracle-modernization) [Government Business Intelligence](https://www.dreamfactory.com/case-studies/government-sql-server-bi-analyst-queries) [Manufacturing Modernization](https://www.dreamfactory.com/case-studies/steel-manufacturing-sap-erp-modernization) [Financial Services Investor Portal](https://www.dreamfactory.com/case-studies/financial-services-sql-server-investor-portal) [Non-Profit Partner Data Sharing](https://www.dreamfactory.com/case-studies/non-profit-sql-server-partner-data-sharing) [Professional Services Exec Dashboards](https://www.dreamfactory.com/case-studies/professional-services-erp-dashboards) [Education HR and External Data Sharing](https://www.dreamfactory.com/case-studies/education-student-hr-sql-server-mysql-external-data-sharing) Industries #### [Healthcare HIPAA-grade APIs across EHR, claims, and labs.](https://www.dreamfactory.com/use-cases/healthcare) #### [Financial Services Portfolios, partners, and portals on one layer.](https://www.dreamfactory.com/use-cases/financial-services) #### [Government Modernize mainframes without re-platforming.](https://www.dreamfactory.com/use-cases/government) #### [Manufacturing SAP, MES, and shop-floor data, governed.](https://www.dreamfactory.com/use-cases/manufacturing) SQL Database [SQL SQL Server](https://www.dreamfactory.com/connectors/sql-server) [OR Oracle](https://www.dreamfactory.com/connectors/oracle) [PG PostgreSQL](https://www.dreamfactory.com/connectors/postgresql) [My MySQL](https://www.dreamfactory.com/connectors/mysql) NoSQL & Docs [Dy DynamoDB](https://www.dreamfactory.com/connectors/dynamodb) [Do DocumentDB](https://www.dreamfactory.com/connectors/azure-documentdb) [Mo MongoDB](https://www.dreamfactory.com/connectors/mongodb) [Cb CouchDB](https://www.dreamfactory.com/connectors/couch-db) Cloud Warehouses [S3 S3](https://www.dreamfactory.com/connectors/amazon-s3) [Ab Azureblob](https://www.dreamfactory.com/connectors/azure-blob) [FS FTP/SFTP](https://www.dreamfactory.com/connectors/ftp-sftp) [LS Local Storage](https://www.dreamfactory.com/connectors/local-storage) C & SaaS [Sf Salesforce](https://www.dreamfactory.com/connectors/salesforce) [API REST / SOAP](https://www.dreamfactory.com/connectors/soap-to-rest) [See all 30+ connectors](https://www.dreamfactory.com/connectors) [![back arrow](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/orange-arrow.svg) Blog](https://blog.dreamfactory.com/) # A Technology Giant Delivers Fast Results with DreamFactory's REST API Platform by Terence Bennett ![calendar icon](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/calendar-icon.svg) January 11, 2026 Table of contents RECOMMENDED ARTICLES - [A Complete Guide to API Generation](https://blog.dreamfactory.com/a-complete-guide-to-api-generation) - [10 Best API Management Tools](https://blog.dreamfactory.com/what-is-api-management-a-brief-overview-of-api-management-concepts-and-tools) - [Creating a Microsoft SQL Server API in Less Than 5 minutes with DreamFactory](https://blog.dreamfactory.com/creating-a-microsoft-sql-server-api-in-less-than-5-minutes-with-dreamfactory) - [Hasura vs. DreamFactory: A Comprehensive Comparison](https://blog.dreamfactory.com/hasura-vs-dreamfactory) - [Build A Snowflake REST API in Less Than 5 Minutes](https://blog.dreamfactory.com/generate-a-snowflake-rest-api-in-less-than-5-minutes) ![BenBusse](https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/team-ben-May-07-2024-08-15-48-6708-AM.jpg) Working in one of the world’s largest and most established technology giants, product manager Edo Williams used DreamFactory to make a significant impact on a multi-million dollar project: migrating the company's primary internal reporting systems from Microstrategy to a new [SAP Business Objects solution.](https://blog.dreamfactory.com/the-reusable-rest-api-platform-strategy/) Leveraging DreamFactory as a backend infrastructure to speed development, Williams has created an application that enables staff to recreate tens of thousands of user-generated Bespoke reports with the new SAP system. By allowing end users to transfer their own reports, Williams has dramatically reduced the cost of technical support for the migration. And by automating the transfer process, he has prevented the potential loss of millions of dollars of staff time and knowledge invested into building reports in the old system. **The Business Need** Microstrategy had been used for forecasting and analysis, delivering key business metrics to company executives across the entire organization. The self-service system had allowed users to create their own custom reports from a broad base of underlying company data. With countless hours of time and effort invested in creating these reports, it was vital that all this work was not simply discarded with the migration to the new system. “One senior executive had created over 2000 Bespoke reports,” Williams recounts. Williams was given the role of helping the supply chain business unit to navigate the new waters. His task was to analyze the content of the old Microstrategy reports and map this to the data source within the new system, allowing users to recreate critical reports. “Most of the work was manual: Tracking all the fields and renaming the data sources,” Williams explains. “Being an engineer, I thought that I could create an application to automate a lot of this process.” **Avoiding Backend Backlog** Certain that he could create something of significant value for the entire business, Williams wanted to produce a rapid proof of concept. “I wanted something that was fast and that I could just show people: here is what I am talking about, this is the value,” Williams continues. To create a new application under the company's existing five-star application process, Williams would have had to develop the backend himself in Java or .Net. Before he got to the real task of creating his new application, he would have needed to spend weeks of time on process, approval and configuration of the security and access rights to the highly sensitive data on the underlying SQL server. Related reading: [What is API Access?](https://blog.dreamfactory.com/what-is-api-access/) “I hadn't programmed in a while and this was not my main job. I knew that if I had to go to my boss and discuss the time and resources needed to build a backend application, the idea would be shot down straight away,” says Williams. Convinced there must be a simpler way, he started exploring the potential of AngularJS applications, using REST services on the backend. Searching online for suitable backend REST platforms, Williams came across a talk from Ben Busse, chief developer evangelist for DreamFactory. “I was amazed, I wondered if it really was that easy,” he recounts. ****DreamFactory**** As a start, Williams installed the open source DreamFactory platform locally on his MacBook, using a dedicated Mac OS X package from the [Bitnami website](https://bitnami.com/stack/dreamfactory). From the admin interface he connected securely to a MySQL database instance he had set up for his project. DreamFactory then automatically generated a comprehensive MySQL REST API for the database. The entire setup process took less than ten minutes: from installation to using the live REST API for his new application. “I liked the tool, I liked the fact it was just easy and straightforward. It had a slight learning curve, but this was fast, and after this, everything was just easy and straightforward,” says Williams. “The hardest part was populating the MySQL database before I started with DreamFactory. I had to extract the data, transform it and write a few scripts, but these are pretty straightforward things if you know what you are doing,” he continues. With the database in place, DreamFactory took care of all the remaining backend functionality. DreamFactory exposed the underlying MySQL database as a straightforward REST API, allowing Williams to get straight into developing his frontend AngularJS application. “The middle layer that talks to the database and then pushes data to your app can get pretty complex depending on what you are trying to do. DreamFactory just takes that out,” he explains. DreamFactory’s built-in user management gave Williams all of the necessary security and access controls out-of-the-box. Williams had not simply cut corners or bypassed the time-consuming backend configuration: by using the DSP, he had downloaded a solid, ready-made, open source solution. “DreamFactory streamlines everything and makes it easy to concentrate on building your frontend application,” he says. “I had found something that was just click, click, click.....connect, and you're good to go.” ![architecture-overview](https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/architecture-overview.png) **********The Power of Frontend Focus********** With the ability to focus on frontend development, Williams could get straight to the task of showcasing exactly what his application could do. He was able to create a more intuitive, user-friendly application. The user interface incorporated animation and made the application more touch friendly – an important factor with 70% of his company using Windows 8 notebooks. “Some might say this is the easy part, but it is actually a lot harder to get the frontend right so that people know exactly what they are doing,” argues Williams. “For the project to work, I needed buy-in from the end users. And for them, frontend usability is the bulk of the application.” The new application allows users to recreate their old reports themselves within the new SAP Business Objects system. By logging in with their user-id, the system shows staff all of the reports they had access to in the old Microstrategy system. Selecting a report reveals the underlying details of its contents and matches these through to the new data source. Users are shown the exact columns they need in order to recreate the report themselves. Having originally built the application for his role in the company's supply chain department, Williams has created a valuable tool for the entire organization. “The initial dataset is based around supply chain information, but the application works across the whole company, and IT are keen to let everyone use it,” he explains. “Having been able to focus on the application, the users love it and more users want it.” **********Outside the Enterprise********** Like many developers, Williams also maintains his side projects outside of work. Having discovered DreamFactory, he is excited about the prospects for using the DSP in his broader development. “It's great, just downloading the user management part of any application with all security built in,” William says. “I have been chatting with the DreamFactory dev team online about creating authenticated logins from LinkedIn, Google+ and Facebook.” As someone who “dabbles” in mobile app development, the availability of client SDKs for HTML5, native iOS and Android is also appealing. “I have used Facebook's Parse platform, but it’s a paid-for solution, you have no control over it and no control over your data. If your application grows and you want to start doing more specific things with your data, you really can’t do that within Parse,” Williams recounts. “It is appealing to have complete control of the backend, you can run DreamFactory on Amazon and you are able to do whatever you want with your data. It is also great to have the option to install the DSP anywhere, in-cloud or on-premises.” TAGS: [Social Links Menu](https://blog.dreamfactory.com/tag/social-links-menu) ![Terence Bennett](https://blog.dreamfactory.com/hs-fs/hubfs/1624046620145.jpg?width=100&height=100&name=1624046620145.jpg) Terence Bennett Terence Bennett, CEO of DreamFactory, has a wealth of experience in government IT systems and Google Cloud. His impressive background includes being a former U.S. Navy Intelligence Officer and a former member of Google's Red Team. Prior to becoming CEO, he served as COO at DreamFactory Software. Stay Connected with The Connector Newsletter! Subscribe to stay up-to-date with DreamFactory's latest product updates, API best practices, and tech humor in your inbox. [![Dreamfactory Logo](https://blog.dreamfactory.com/hubfs/raw_assets/public/dreamfactory/images/megamenu/Megamenu-logo.svg)](https://www.dreamfactory.com/) [Call Sales +1 (415) 993-5877](tel:+14159935877) Open – Mon–Fri 9–5 PT [FREE 30 Minute Demo](https://www.dreamfactory.com/demo) #### Follow us - [GitHub](https://github.com/dreamfactorysoftware/dreamfactory) - [Facebook](https://www.facebook.com/dfsoftwareinc/) - [X (Twitter)](https://twitter.com/dfsoftwareinc) - [LinkedIn](https://www.linkedin.com/company/dreamfactory-software) - [YouTube](https://www.youtube.com/c/dreamfactorysoftware) ### Features [Features](https://www.dreamfactory.com/features) [Self hosted](https://www.dreamfactory.com/features#self) [API Generation](https://www.dreamfactory.com/features#api) [Security](https://www.dreamfactory.com/features#secure) [Customization](https://www.dreamfactory.com/features#custom) [Pricing](https://www.dreamfactory.com/pricing) ### Installers [Linux](https://www.dreamfactory.com/features#installer) [Docker](https://www.dreamfactory.com/features#installer) [Kubernetes](https://www.dreamfactory.com/features#installer) ### API Resources [Documentation](https://docs.dreamfactory.com/) [Case Studies](https://www.dreamfactory.com/stories) [White Papers](https://www.dreamfactory.com/resources/whitepapers) [Academy](https://www.dreamfactory.com/academy) [API Calculator](https://calculator.dreamfactory.com) [Open Source](https://github.com/dreamfactorysoftware) ### Company [Blog](https://blog.dreamfactory.com/) [Hub](https://www.dreamfactory.com/hub) [About us](https://www.dreamfactory.com/about) [Partners](https://www.dreamfactory.com/partners) [Support](https://www.dreamfactory.com/support) [Connectors](https://www.dreamfactory.com/connectors) [Contact Us](https://www.dreamfactory.com/demo) © 2025 DreamFactory. All rights reserved. [Terms of Use](https://www.dreamfactory.com/terms-of-use) [Privacy Policy](https://www.dreamfactory.com/privacy-policy) [LLMs](https://www.dreamfactory.com/llms.txt) ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Terence Bennett", "url" : "https://blog.dreamfactory.com/author/terencebennett" }, "dateModified" : "2024-05-07T08:18:43.169Z", "datePublished" : "2026-01-12T00:00:00.000Z", "headline" : "A Technology Giant Delivers Fast Results with DreamFactory's REST API Platform", "image" : [ "https://blog.dreamfactory.com/hubfs/Imported_Blog_Media/team-ben-May-07-2024-08-15-48-6708-AM.jpg" ], "mainEntityOfPage" : { "@id" : "https://blog.dreamfactory.com/tech-giant-delivers-fast-with-dreamfactory", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.dreamfactory.com/hubfs/DreamFactory%20-%20Orange%20-%20Transparent-1.png" } } } ```