Portfolio

Breaking down manufacturing data silos

Global vacuum producers streamline operations through manufacturing systems integration

egforit Software helped this international client break down manufacturing data silos through systems integration, resulting in lower IT costs, higher customer satisfaction, and increased process efficiency.

Executive brief

Empowering field workers with manufacturing data integration

Our client is a manufacturer and supplier of industrial vacuum and abatement technologies. The client’s high-tech products are shipped to customers worldwide, from industries as varied as pharmaceuticals, technology, and food. With our systems integration expertise, the client was able to break down manufacturing data silos and realise:

accurate data for field teams

better customer service

streamlined processes

lower integration platform costs

Curious about how to improve manufacturing efficiency with data integration? See the full story below.

The full story

The challenge

Outdated stock data was hampering field workers

As our client knows, producing a wide range of complex industrial goods for clients worldwide is not a simple task. The communication between production and operations must be flawless if the business is to succeed. Being aware of this, the company was looking to improve manufacturing efficiency by integrating its disparate systems.

 

One major bottleneck lay between their back-office systems and the technicians raising work orders in the field. Their central ERP software was SAP ECC, hosted on-premises, while their field workers used a custom-made application to raise orders. As there was no data sync between these systems, the field workers had to manually input stock and equipment data before visiting customers. The drawbacks of this situation were:

 

  • increased risk of errors from manual entry
  • disorganisation between field teams and operations
  • less time to focus on customer service

 

The company’s management knew that these issues were preventing field workers from providing the best service possible. They tasked the IT department with researching how to break down manufacturing data silos with minimum disruption to the business.

The solution

Using Azure to break down manufacturing data silos

The company had previously engaged our digital engineers to maintain, support, and develop their MuleSoft integrations. At this point the company was making a strategic shift away from MuleSoft in favour of Microsoft Azure. As Azure is one of our core specialisms, the company asked us to demonstrate that Azure could meet their requirements.

 

Our proposed solution was to integrate the on-premises SAP ECC with the web-based SQL Server application using Azure Logic Apps. These serverless applications allowed us to build automated workflows based on events or timers, between on-premises and the cloud.

 

After seeing the many low-code, best-practice, security-focused solutions we had developed with Azure in the past, the client was convinced. The low-code method also ensured that the client could adjust the integration with relatively little time and cost.

 

Our integration engineers designed and delivered the new integration solution in five days. At the same time we provided the IT department with consultancy on Azure resourcing, cost control, and continuous deployment mechanisms. When the manufacturing data integration solution was deployed, the client saw results immediately in terms of errors eliminated and hours saved.

The benefits

Low cost, high speed, strong ROI

Our manufacturing systems integration solution provided the desired data flow between the client’s operations and field teams. While prioritising data and access security, we successfully connected their on-premises system to the cloud.

 

From a business perspective, the benefits of using Azure to break down manufacturing data silos were:

 

  • lower costs compared with the previous integration solution
  • the option to grow field operations with no strain on the back office
  • the ability to serve customers better with accurate information
  • reduced man hours spent on manual data transfer

 

As a result of our successful delivery, the client has chosen egforit Software as its integration partner of choice. We are currently further equipping the company with new automation and integration capabilities within the Azure ecosystem. A bespoke Internet of Things (IoT) system and an Azure API management layer are among our upcoming projects to further improve manufacturing efficiency with data integration.

Accelerate your manufacturing

This client is one of hundreds of organisations that have managed to break down manufacturing data silos with our expertise. To find out how manufacturing systems integration will help your business, visit our integration solutions page.

Info

15th September 2020
Azure, integration, SAP, ERP, SQL Server

Privacy Preference Center

Necessary

Advertising

Analytics

Analytics cookies collect information that is used either in aggregate form to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you.

Google Analytics
The cookie _gcl_au is used by Google Analytics to understand user interaction with the website.

For example, in order for Google Analytics to determine that two distinct hits belong to the same user, a unique identifier, associated with that particular user, must be sent with each hit.

The analytics.js library accomplishes this via the Client ID field, a unique, randomly generated string that gets stored in the browsers cookies, so subsequent visits to the same site can be associated with the same user.

By default, analytics.js uses a single, first-party cookie named _ga to store the Client ID, but the cookie's name, domain, and expiration time can all be customized. Other cookies created by analytics.js include _gid, AMP_TOKEN and _gac_. These cookies store other randomly generated ids and campaign information about the user.

Google Analytics
_gcl_au, _gid, _ga, gtm_preview

Other

WordPress uses cookies for authentication. That means that in order to log in to our WordPress site, you must have cookies enabled in your browser.

There are two types of cookies set by WordPress.
1 — Session cookies — These are ‘strictly necessary’ cookies as WordPress will not be able to function without it.
2 — Comment cookies — These are not ‘strictly necessary’ cookies and are set when users leave a comment on a post.

Wordpress Session cookies:
Users are those people who have registered an account with the WordPress site.
wordpress_[hash]
wordpress_logged_in_[hash]
wordpress_test_cookie
wp-settings-{time}-[UID]

Wordpress comments:
Comments are usually turned off by default.
If by chance they are still active on a post, asides being turned off when spotted, data from these are not saved by egforit.
- When visitors comment on a post, they too get cookies stored on their computer. This is purely a convenience so that the visitor won’t need to re-type all their information again when they want to leave another comment. Three cookies are set for commenters:
comment_author_{HASH}
comment_author_email_{HASH}
comment_author_url_{HASH}

Wordpress,
comment_author_{HASH} comment_author_email_{HASH} comment_author_url_{HASH} wordpress_[hash] wordpress_logged_in_[hash] wordpress_test_cookie wp-settings-{time}-[UID]
-id-[app_id],-session-[add-id]

×