Upside Innovations Pulls QuickBooks Data into Proprietary Tracking App for Data Analysis

CData Drivers facilitate QuickBooks integration with proprietary tracking App for Data Analysis, saving time and increasing on-time delivery performance.

Download the Case Study
Simple Connectivity

Upside Innovations can now easily retrieve business-critical data from Quickbooks and Quickbooks online.

Key Business Improvements

Upside Innovations saw a reduction in manufacturing lead-time and an increase in on-time deliveries.

Low Cost of Entry

CData provided Upside Innovations with powerful a Quickbooks connectivity solution at a budget-friendly rate.


Upside Innovations is an aluminum steps and ramps manufacturer serving the modular building and classroom industry. With customers located all over the United States and a large, ever-changing inventory to maintain, Upside Innovations often faces inconsistent manufacturing lead time and delivery. This problem is due to a lack of integrated planning software within QuickBooks which Upside Innovations uses to track and manage their inventory.

"We are a growing manufacturer using QuickBooks Manufacturer to track inventory," Jim Webster said. "Unfortunately, MRP / ERP programs are out of our budget, so we decided to create our own solution to help us continue to grow while keeping our orders on track."

The CData ADO.NET Provider for QuickBooks gives Upside Innovation the power to easily retrieve data from QuickBooks and QuickBooks Online, including Customers, Transactions, Invoices, Sales Receipts, Reports, and more. The QuickBooks Provider makes these QuickBooks constructs look like SQL tables. With the CData ADO.NET Provider for QuickBooks, Upside Innovations is able to simply DataBind to their data, just like using SQLServer.

With the CData QuickBooks Provider at their disposal, Upside Innovations was able to develop a solution that pulls their QuickBooks data which can then be analyzed in their custom tracking application. The information generated from QuickBooks then provides key summary data for planning and inventory management.

"If you need a way to interface to a QuickBooks environment, this is the tool. I have used three different tools and the ADO.NET Data Provider for QuickBooks far exceeded all others."

– Jim Webster, Upside Innovations, LLC.


Highlights:

  • After evaluating or using three other QuickBooks integration tools, Upside Innovations choose the CData ADO.NET Provider for QuickBooks

  • The ADO.NET Provider interfaces QuickBooks data with Upside's in-house inventory tracking application

  • The solution has streamlined their business processes and Upside now enjoys a decrease in lead-time and an increase in on-time delivery


"The product works great and we are very pleased with it. We saved a great deal of development time by simply integrating your data provider into our custom application," Webster said.

After using their CData-powered custom application, Upside Innovations saw a reduction in inventory and lead-time, along with an increase in on-time delivery performance. In addition, there was a marked reduction in planning time for personnel.

"If you need a way to interface to a QuickBooks environment, this is the tool. I have used three different tools and the CData ADO.NET Data Provider for QuickBooks far exceetded all others," Webster said.


About Upside Innovations – Upside Innovations specializes in making commercial ramps and steps targeted at modular building leasing companies. The company is located in Cincinnati, Ohio, and is privately held. To learn more about Upside Innovations, visit www.upsideinnovations.com or call 1-855-844-2811.

Get started with CData today