Midwest-based parts manufacturer, B&B Manufacturing, produces more than 27,000 different precision mechanical components and drive train parts. They sell their catalog using a network of distributors located throughout the U.S. and Canada. In an effort to provide their dealers with accurate inventory and pricing information and reduce the load on their internal team, B&B reached out to ATF for help building a custom API that would allow end users to access up-to-date information without the need for the B&B team to pull and send manual reports.
The Challenge
B&B inventory information was stored in an ERP SQL Server database and their pricing information was managed on an excel spreadsheet. We needed to build a custom database to track pricing information and build a custom API to read both the ERP inventory data and pricing data to provide the user with the correct combined data when an API request is made. Because the API request would be extracting data from B&B’s internal network, security was a top priority. The API was provisioned on a Microsoft Azure cloud infrastructure. We configured a secure pipeline between the cloud infrastructure and the ERP where the API requests were funnelled and a response sent back to the end user.
Services
• Custom ERP Integration
Project Highlights
Technology
Business and technology are challenging enough, why add unnecessary BS? Move on up to the front and drop us a line.
LET'S CHAT