OVERVIEW
Vertical Lift is a Microsoft Dynamics 365 consulting firm with over 15 years of experience providing technology solutions to not-for-profit and public sector organizations. The company specializes in designing and implementing scalable systems that enhance data management and improve operational processes. For the San Francisco-Marin Food Bank, Vertical Lift introduced a more efficient approach to managing key workflows, ensuring better coordination and data accuracy across their systems.
Target:
Integrating Microsoft Dynamics 365 with the Food Bank's customized ERP system using KingswaySoft to automate processes.
Challenge:
- Managing food distribution across multiple systems required extensive manual data entry,
making it difficult to maintain accuracy and efficiently coordinate operations.
Required SSIS Integration Toolkit:
We have always received excellent service from KingswaySoft support. It’s a primary reason we continue to use and recommend your product to any of our clients. We appreciate receiving the newsletters and updates and often refer to your online tutorials for help.
~Gerrit Twynstra
Sr. Solution Architect/ Co-founder
Vertical Lift Business Solutions Inc.
THE CHALLENGE
The San Francisco-Marin Food Bank managed food distribution across multiple systems, including spreadsheets, SharePoint, and a customized ERP system. Their team manually entered and tracked data across these platforms to coordinate deliveries, update inventory, and manage food requests. This process required significant time and effort to maintain accuracy and ensure smooth operations. To improve data consistency, minimize manual workload, and streamline processes, the organization sought an integration solution that would automate key workflows and connect its systems more efficiently.
THE SOLUTION
SSIS Integration Toolkit for:
Vertical Lift utilized KingswaySoft’s SSIS Integration Toolkit to design and implement an advanced integration solution connecting Microsoft Dynamics 365 to the client’s customized ERP system. The workflows were configured to run at three-minute intervals, ensuring that critical data such as partner records, food preferences, and delivery addresses were consistently accurate and up to date.
The integration also included sophisticated monitoring capabilities, allowing administrators to identify and resolve potential issues quickly. By automating previously manual processes and enabling reliable data updates, the solution allowed San Francisco-Marin Food Bank to focus on their mission while improving operational effectiveness.
THE RESULTS
The integration implemented by Vertical Lift, utilizing KingswaySoft's SSIS Integration Toolkit for Dynamics 365, brought significant improvements to the San Francisco-Marin Food Bank's operations. By automating data workflows and enhancing data consistency, the solution enabled the organization to scale its operations effectively while continuing to provide essential resources to underserved communities.
Over two years of deployment, the system maintained exceptional performance with no critical issues, demonstrating its reliability, scalability, and stability. Furthermore, the food bank's distributor network grew substantially, now supporting up to three times the original number of distributors, effectively increasing their service capacity.
Delivered Improvements:
Accurate food deliveries
Less manual intervention
Unified data standards
3-minute data sync
Get in Touch
If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!