CASE STUDY

Upside Innovations

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





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.







Connectivity is our Core: Any source, Any technology, Any platform.

CData Software (www.cdata.com) is a leading provider of data access and connectivity solutions. We offer a straightforward approach to integration, with easy-to-use, data providers, drivers, and tools available from any technology capable of interacting with major data standards.

Learn More





* All product names, trademarks and registered trademarks are property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names,trademarks and brands does not imply endorsement.