a white and orange logo with the letter mfa white and orange logo with the letter mf
Products

Features

Self Hosted
API Generation
Security
Customization
Rate Limiting

Lorem ipsum dolor sit amet consectetur elit

Installers

Linux
Docker
Kubernetes

What is DreamFactory

DreamFactory is the fastest way to build internal, secure REST APIs into any database

Learn More
Resources

Educate

What is DreamFactory
Guide
Wiki
Academy
White Papers

What's Next

API Calculator
Case Studies
Community Forum

Featured from Blog

a black and orange logo with the word soap rest
Turn SOAP to RESTful API

The fastest and most secure way to turn any SOAP web services into REST APIs with DreamFactory.

Read more
the logo for a software company
API Generation for MS SQL Server

A step-by-step guide to generate a secure & fully documented API for MS SQL Server.

See guide
See all articles
ConnectorsBlogTalk to an Engineer
Talk to an Engineer

Shortrunposters.com

Business objective

Drive revenue and business efficiency goals by enabling national and international retailers to transact directly with an existing in-house order-processing system.

Technical challenge

Replace existing document-based workflow and process-management systems with a unified system, while creating a gateway to an external e-commerce system used by large retailers.

The solution

The DreamFactory open source API platform automatically generates APIs that enable communication between the shop floor, a backend MySQL database, and a proprietary e-commerce portal. The solution was developed by a single developer in 30 days.

Priority 1 - Leapfrog the competition by offering more efficient delivery of custom print services

  1. Connect external ordering systems with in-house order management and back-end databases via an automatically generated REST API
  2. Automate existing internal processes to compete with larger and more technically advanced competitors
  3. Strong ROI: within months, the project increased revenue by 10 percent

Priority 2 - Focus limited technical resources on customer experience and brand-building

  1. Eliminate the need to hire development talent, saving thousands of dollars
  2. Focus in-house expertise on optimizing customer experience and brand-building
  3. Reduce development time from months to weeks

A regional on-demand print shop seeks to attract large, big-box retail business

To expand the firm's capabilities and ramp up the volume of his business, John Von Colln, founder and president of Shortrunposters.com, wanted to migrate from the existing paper-based system, which used Excel documents to capture and track orders, to a fully digital system that would streamline order transmission, eliminate order-entry errors, and provide two-way communication with his firm's enterprise customers.

"To offer a viable system to our clients, we needed to develop an API that would provide a gateway from our clients' e-commerce systems and our backend system. The challenge was that I didn't have the in-house technical skills this would require," says Von Colln. "This daunting technical task—I am not a professional software developer—coupled with the fact that the manual system worked pretty well, meant we never seemed to get around to tackling the project."

Connects the shop floor with two backend services, and automates a manual process

Von Colln and his team were confronted with two challenging technical requirements:

Replace manual systems on the shop floor with a direct connection to an existing in-house MySQL database. Enable the ShipWorks system used by his clients to query the same MySQL database.

As the team assessed the technical project, they became concerned that in-house expertise would be stretched to manage these requirements, especially the development of custom APIs. DreamFactory, which auto-generates REST APIs for a wide range of situations, emerged as a possible solution.

"A developer friend told me about DreamFactory—an open source solution that would handle a lot of the API development for me. While the learning curve is still pretty steep for a novice developer such as myself, the excellent documentation and DreamFactory's technical support gave me the confidence to give it a try," says Von Colln. "DreamFactory enabled me to take on a technical project that I would otherwise have to outsource and pay someone else thousands of dollars to develop for me."

A fast time to market and a clear ROI—with revenue upside

The DreamFactory REST API facilitates connections between the shop floor, a MySQL database, and a local ShipWorks server. JSON is used to transmit tracking numbers from the ShipWorks server as orders are placed by customers, and also provides a method for ensuring production status updates from the backend printing systems are available to shop-floor personnel.

"Now that we have a method to receive orders through an automated system, we can compete for larger and more time-sensitive business. This opens up many new doors of opportunity for us," says Von Colln. "Within just a few months, we've already signed up half-a-dozen large clients, and increased our business by more than 10 percent. This is still in its infancy, but we anticipate this portion of the business to become 30-40 percent of our revenue within 2 years."

‍

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.

We only spam cat pictures—promise
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
a white and orange logo with the letter mf
+1 415-993-5877
Request A Demo
Features
Self HostedAPI GenerationSecurityCustomization
Installers
LinuxDockerKubernetes
Educate
Getting StartedAcademyWhite Papers
What's Next
API CalculatorCase StudiesCommunity ForumOpen Source
Company
BlogAbout UsPartnersSupportConnectorsAWS PricingContact Us
© 2023 DreamFactory. All rights reserved.
Terms of Use