Case Studies SMC Electric Supply Creates Seamless Workflows between Disparate Data Silos with Informer Dashboards

Edit This Case Study Record

	SMC Electric Supply Creates Seamless Workflows between Disparate Data Silos with Informer Dashboards

SMC Electric Supply Creates Seamless Workflows between Disparate Data Silos with Informer Dashboards

Technology Category	Application Infrastructure & Middleware - Data Visualization Functional Applications - Enterprise Resource Planning Systems (ERP)
Applicable Functions	Business Operation Sales & Marketing Warehouse & Inventory Management
Use Cases	Inventory Management Predictive Maintenance Supply Chain Visibility
Services	System Integration Training
Challenge	SMC is a private, family-owned corporation headquartered in Springfield, Missouri with 14 locations in Missouri and Kansas. The company distributes the industry’s top automation, data comm, electrical, industrial, pneumatics, safety and security products, typically used in manufacturing facilities, from over 250 manufacturers. When Jesse Owsley, software program manager at SMC joined the company, he quickly realized that reporting capabilities within the organization were very limited and not sufficient for business needs. SMC had multiple databases that held important data. Their business had limited reporting abilities. Staff was either making do with native application reporting, using SQL Management Studio or having an IT staff member write custom reports for users. SMC needed to enable workflows across their multiple systems including Progress/NextGen ERP, document management, proof of delivery, and CRM. It was important to tightly monitor and track orders, inventory and payables as data moved between departments. Hundreds of thousands of records must be managed and exception reporting is very important. Because the data was in disparate systems, it was challenging to efficiently spot exceptions or data discrepancies in real time that could evolve into bigger problems. For example, SMC uses Tour de Force as their CRM. Customer and product data in their ERP is highly dynamic and making changes in the ERP would easily cause discrepancies in the CRM because Tour de Force was expecting the data in a certain way. “This caused issues with user adoption and confidence in the CRM data,” said Owsley. Prior to Informer, Jesse created a spreadsheet to keep track of outlying information as he found it. This was an incredibly tedious and manual process. Accounts Payable staff at SMC were also using spreadsheets to reconcile invoices and purchase orders containing prices charged, freight, product information, etc. Prior to Informer, clerical staff had to call Buyers and manually compare spreadsheets to reconcile data, another manually tedious workflow. Read More
About Customer	SMC Electric Supply is a private, family-owned corporation headquartered in Springfield, Missouri, with 14 locations across Missouri and Kansas. The company specializes in distributing top-tier automation, data communication, electrical, industrial, pneumatics, safety, and security products, primarily used in manufacturing facilities. SMC sources its products from over 250 manufacturers, ensuring a wide range of high-quality offerings. The company is committed to providing exceptional service and maintaining strong relationships with its clients. SMC's workforce includes a dedicated team of professionals who manage various aspects of the business, from sales and customer service to technical support and logistics. The company places a strong emphasis on innovation and efficiency, continually seeking ways to improve its operations and better serve its customers. With a focus on leveraging technology to streamline processes and enhance data management, SMC aims to stay ahead in the competitive distribution industry. The company's commitment to excellence and customer satisfaction has made it a trusted partner for many businesses in the manufacturing sector. Read More
Solution	Owsley and other staff at SMC knew they needed an easier, more efficient way of accessing and managing data and workflows across the separate data sources. After a free trial, SMC soon implemented Informer and were up and running in a few days. “Including the time it took to spin up a server, install Informer, connect to the initial data sources and to do the first application training sessions via telephone, I had less than 8 man hours invested in getting my first production reports which I continue to use to this day,” said Owsley. “Setup was my number one concern, but it was very straightforward. I’m not a technical person, but I could do most of the setup and mappings myself.” Jesse recently upgraded to Informer 5 and is generating Dashboards that have created seamless workflows across the business. By connecting to the various data silos, Informer enables SMC to compare data from diverse business systems in one place. The visuals blend real-time data from multiple systems onto dynamic dashboards where he can then easily drill into underlying data in the source systems. SMC staff now can access and manage data without IT intervention. End users use Informer to run their own ad-hoc reports and Dashboards to then distribute to many others. Managers, vendors, and other staff members can view report PDFs or even Live Excel spreadsheets with Informer data, all without ever having to access the software itself. “Now SMC only needs to maintain one ERP license because they provide the access to data that the staff needs through Informer. We are saving on ERP licenses and with just that, Informer can pay for itself. Our configuration and security environment is much more manageable,” said Owsley. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Visualization

Functional Applications - Enterprise Resource Planning Systems (ERP)

Applicable Functions

Business Operation

Sales & Marketing

Warehouse & Inventory Management

Use Cases

Inventory Management

Predictive Maintenance

Supply Chain Visibility

Services

System Integration

Training

Challenge

SMC is a private, family-owned corporation headquartered in Springfield, Missouri with 14 locations in Missouri and Kansas. The company distributes the industry’s top automation, data comm, electrical, industrial, pneumatics, safety and security products, typically used in manufacturing facilities, from over 250 manufacturers. When Jesse Owsley, software program manager at SMC joined the company, he quickly realized that reporting capabilities within the organization were very limited and not sufficient for business needs. SMC had multiple databases that held important data. Their business had limited reporting abilities. Staff was either making do with native application reporting, using SQL Management Studio or having an IT staff member write custom reports for users. SMC needed to enable workflows across their multiple systems including Progress/NextGen ERP, document management, proof of delivery, and CRM. It was important to tightly monitor and track orders, inventory and payables as data moved between departments. Hundreds of thousands of records must be managed and exception reporting is very important. Because the data was in disparate systems, it was challenging to efficiently spot exceptions or data discrepancies in real time that could evolve into bigger problems. For example, SMC uses Tour de Force as their CRM. Customer and product data in their ERP is highly dynamic and making changes in the ERP would easily cause discrepancies in the CRM because Tour de Force was expecting the data in a certain way. “This caused issues with user adoption and confidence in the CRM data,” said Owsley. Prior to Informer, Jesse created a spreadsheet to keep track of outlying information as he found it. This was an incredibly tedious and manual process. Accounts Payable staff at SMC were also using spreadsheets to reconcile invoices and purchase orders containing prices charged, freight, product information, etc. Prior to Informer, clerical staff had to call Buyers and manually compare spreadsheets to reconcile data, another manually tedious workflow.

About Customer

SMC Electric Supply is a private, family-owned corporation headquartered in Springfield, Missouri, with 14 locations across Missouri and Kansas. The company specializes in distributing top-tier automation, data communication, electrical, industrial, pneumatics, safety, and security products, primarily used in manufacturing facilities. SMC sources its products from over 250 manufacturers, ensuring a wide range of high-quality offerings. The company is committed to providing exceptional service and maintaining strong relationships with its clients. SMC's workforce includes a dedicated team of professionals who manage various aspects of the business, from sales and customer service to technical support and logistics. The company places a strong emphasis on innovation and efficiency, continually seeking ways to improve its operations and better serve its customers. With a focus on leveraging technology to streamline processes and enhance data management, SMC aims to stay ahead in the competitive distribution industry. The company's commitment to excellence and customer satisfaction has made it a trusted partner for many businesses in the manufacturing sector.

Solution

Owsley and other staff at SMC knew they needed an easier, more efficient way of accessing and managing data and workflows across the separate data sources. After a free trial, SMC soon implemented Informer and were up and running in a few days. “Including the time it took to spin up a server, install Informer, connect to the initial data sources and to do the first application training sessions via telephone, I had less than 8 man hours invested in getting my first production reports which I continue to use to this day,” said Owsley. “Setup was my number one concern, but it was very straightforward. I’m not a technical person, but I could do most of the setup and mappings myself.” Jesse recently upgraded to Informer 5 and is generating Dashboards that have created seamless workflows across the business. By connecting to the various data silos, Informer enables SMC to compare data from diverse business systems in one place. The visuals blend real-time data from multiple systems onto dynamic dashboards where he can then easily drill into underlying data in the source systems. SMC staff now can access and manage data without IT intervention. End users use Informer to run their own ad-hoc reports and Dashboards to then distribute to many others. Managers, vendors, and other staff members can view report PDFs or even Live Excel spreadsheets with Informer data, all without ever having to access the software itself. “Now SMC only needs to maintain one ERP license because they provide the access to data that the staff needs through Informer. We are saving on ERP licenses and with just that, Informer can pay for itself. Our configuration and security environment is much more manageable,” said Owsley.

Impact #1	SMC staff now can access and manage data without IT intervention. End users use Informer to run their own ad-hoc reports and Dashboards to then distribute to many others. Managers, vendors, and other staff members can view report PDFs or even Live Excel spreadsheets with Informer data, all without ever having to access the software itself.
Impact #2	By creating an Informer Dashboard that shows all unfulfilled orders by location on a Google Map, SMC is now able to track orders that come in from the eCommerce system and sync that information with data in the ERP. Now they can manage client relationships using real-time data and put prospect and customer insights at their fingertips.
Impact #3	By setting up Informer Dashboards that both Accounts Payable and Buyers could look at, Jesse dramatically improved the workflow between the two departments, enabling them to track and reconcile data from the ERP. Informer also pulls data from their document management system onto the same Dashboards which streamlines communication from Buyers.

Impact #1

SMC staff now can access and manage data without IT intervention. End users use Informer to run their own ad-hoc reports and Dashboards to then distribute to many others. Managers, vendors, and other staff members can view report PDFs or even Live Excel spreadsheets with Informer data, all without ever having to access the software itself.

Impact #2

By creating an Informer Dashboard that shows all unfulfilled orders by location on a Google Map, SMC is now able to track orders that come in from the eCommerce system and sync that information with data in the ERP. Now they can manage client relationships using real-time data and put prospect and customer insights at their fingertips.

Impact #3

By setting up Informer Dashboards that both Accounts Payable and Buyers could look at, Jesse dramatically improved the workflow between the two departments, enabling them to track and reconcile data from the ERP. Informer also pulls data from their document management system onto the same Dashboards which streamlines communication from Buyers.

Benefit #1	SMC only needs to maintain one ERP license, saving on ERP licenses.
Benefit #2	Less than 8 man hours invested in getting the first production reports.
Benefit #3	Informer can pay for itself through savings on ERP licenses.

Benefit #1

SMC only needs to maintain one ERP license, saving on ERP licenses.

Benefit #2

Less than 8 man hours invested in getting the first production reports.

Benefit #3

Informer can pay for itself through savings on ERP licenses.

Download PDF Version

Overview

SMC Electric Supply Creates Seamless Workflows between Disparate Data Silos with Informer Dashboards

Operational Impact

Quantitative Benefit