Welcome!

Industrial IoT Authors: Elizabeth White, Stackify Blog, Yeshim Deniz, SmartBear Blog, Liz McMillan

Related Topics: Industrial IoT

Industrial IoT: Case Study

Dayton Parts Simplifies Data Distribution with Automated File Transfer

Six-Day Process Reduced to Three Hours with Automated Data Translation and File Transfer

As a manufacturer and distributor of thousands of parts for light and heavy-duty trucks, Dayton Parts' primary focus is on their customers. They know that sending personalized price sheets to their valued customers on a regular basis is good business. This detailed personal attention continues to produce new and loyal customers. As the customer base grew, the amount of effort to create and distribute the personalized price sheets began to affect productivity. Dayton Parts realized they needed to automate their file transfer process, so they started the search for an application that would streamline the distribution process.


"Now with GoAnywhere Director the system can run the complete automated transfer process in just 3 hours, versus 6 days!”
Rusty Foust – Project Manager at Dayton Parts


Steering in a New Direction - Automating File Transfers

IBM i (iSeries) servers handle inventory and processing at Dayton Parts. However, converting the inventory lists and pricing information from DB2 into the required Excel spreadsheets is not a normal server function. Instead, staff manually extracted the data and pasted it into email, which required close to 100 hours from several staff members over a 6-day period.

Dayton Parts knew they had to improve the efficiency and speed of this critical process. In order to reduce staff time, they would need full automation of the data translation from DB2 to Excel and the distribution of the price sheets via email. Marketing and IT worked together to find a solution that would accomplish these goals.

There were only a handful of solutions on the market that would install natively to IBM i (iSeries) servers. Most were complicated to use or didn't support the automation Dayton Parts required. Dayton Parts was excited to evaluate a browser-based, automated file transfer solution - GoAnywhere Director from Linoma Software.

A Smooth Ride - SQL Query and XML Translation

Dayton Parts had seen a demonstration using the SQL query options, XML translation, and the data mapping options inside GoAnywhere Director, but were interested to see if it would work in their unique environment. The implementation went smoothly and through the GoAnywhere Director browser-interface, a process was developed that queried the database, performed the calculations, created the Excel file and attached one or more price sheets per email.

“Now with GoAnywhere Director the system can run the complete automated transfer process in just 3 hours, versus 6 days!” exclaimed Rusty Foust – Project Manager at Dayton Parts. "We can also run a single ad-hoc customized price sheet at any time and it only takes a minute."

The time savings alone was instant gratification for Dayton Parts. The ease of use and functionality within Linoma's solution would more than meet their needs. GoAnywhere Director was a great fit as it ran natively on the IBM i, easily communicated with other platforms, required little user interaction, and performed very efficiently. Another key factor in their decision was the helpful support staff at Linoma Software who was able to quickly answer questions and provide assistance when needed.

Marketing Success

Distributing personalized price sheets to their customers is critical to Dayton Part’s marketing strategy and overall success in the competitive after-market for undercarriage parts for light and heavy-duty trucks. Dayton Parts has a new advantage with the powerful automated processing and file transfers performed by GoAnywhere Director.

Looking back on the project that started earlier this year, Rusty Foust concludes, “GoAnywhere Director is intuitive, well documented, extremely versatile and well supported. It’s a solid solution that dramatically improved and enhanced a critical process for us. It’s hard to believe how we used to send out the personalized price sheets when GoAnywhere Director makes it look so simple.”

More Stories By Dirk Zwart

Born in Canada and calling Nebraska home, Dirk primarily writes on the Technical side of the IT realm. Having written for years at Gateway Computer and as part of other large IT organizations, Dirk happily writes for Linoma Software. When not writing children's stories or stage scripts, you'll find Dirk out back in the vegetable garden or building yet another server for reasons unknown. Follow Dirk on Twitter, Facebook, or LinkedIn.

IoT & Smart Cities Stories
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for permission to conduct invasive surveillance of their customers. Organizations that are not transparent about how their systems gather data telemetry without offering shared data ownership risk product rejection, regu...
The best way to leverage your Cloud Expo presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering Cloud Expo and @ThingsExpo will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at Cloud Expo. Product announcements during our show provide your company with the most reach through our targeted audiences.
Bill Schmarzo, author of "Big Data: Understanding How Data Powers Big Business" and "Big Data MBA: Driving Business Strategies with Data Science," is responsible for setting the strategy and defining the Big Data service offerings and capabilities for EMC Global Services Big Data Practice. As the CTO for the Big Data Practice, he is responsible for working with organizations to help them identify where and how to start their big data journeys. He's written several white papers, is an avid blogge...
When talking IoT we often focus on the devices, the sensors, the hardware itself. The new smart appliances, the new smart or self-driving cars (which are amalgamations of many ‘things'). When we are looking at the world of IoT, we should take a step back, look at the big picture. What value are these devices providing. IoT is not about the devices, its about the data consumed and generated. The devices are tools, mechanisms, conduits. This paper discusses the considerations when dealing with the...
Machine learning has taken residence at our cities' cores and now we can finally have "smart cities." Cities are a collection of buildings made to provide the structure and safety necessary for people to function, create and survive. Buildings are a pool of ever-changing performance data from large automated systems such as heating and cooling to the people that live and work within them. Through machine learning, buildings can optimize performance, reduce costs, and improve occupant comfort by ...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
With 10 simultaneous tracks, keynotes, general sessions and targeted breakout classes, @CloudEXPO and DXWorldEXPO are two of the most important technology events of the year. Since its launch over eight years ago, @CloudEXPO and DXWorldEXPO have presented a rock star faculty as well as showcased hundreds of sponsors and exhibitors! In this blog post, we provide 7 tips on how, as part of our world-class faculty, you can deliver one of the most popular sessions at our events. But before reading...
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a m...
CloudEXPO New York 2018, colocated with DXWorldEXPO New York 2018 will be held November 11-13, 2018, in New York City and will bring together Cloud Computing, FinTech and Blockchain, Digital Transformation, Big Data, Internet of Things, DevOps, AI, Machine Learning and WebRTC to one location.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.