• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Swedish Manufacturer Plans A New Path Forward

    December 2, 2020 Alex Woodie

    The Swedish manufacturing company Dahrentrad knew its S/36-era production planning solution was getting a bit long in the tooth. The question was, what should the company do about it? Migration and modernization were weighed as the two primary options, but which was the better path?

    A subsidiary of LWW Group, Dahrentrad specializes in producing copper and aluminum wiring used in electrical motors, pumps, transformers, and other industrial and automotive components. The 75-year-old company runs factories in Sweden, Germany, and Poland.

    The company relied on an old but reliable business application that utilized 5250 greenscreen interfaces, according to Mats Lidström, a senior solutions architect with the Swedish consulting firm Apper Systems AB.

    “It’s a very stable system that had been used for many years, but they felt they needed to do something,” Lidström said during a presentation at the virtual COMMON Europe Congress (vCEC) event two weeks ago. “They came to the point where they had to decide, should we do a big replacement and bring in a new standard system? Or should they modernize the application that they have.”

    Apper Systems had assisted the company with maintaining its existing ERP system, which used a mix of S/36-era RPGII and RPGIII code, but (thankfully) ran on more modern hardware from IBM. So the consultants were familiar with the system.

    But for this new endeavor, Lidström embarked upon a very thorough study of the company, its requirements, its existing business processes, and how those processes map to software functionality (or whether they’re done manually). Based on the results of that current state analysis, Lidström and representatives from Dahrentrad would put together a plan and submit it to the company’s board for approval.

    An important part of this analysis was to pinpoint not only the current processes, but to identify what processes are not currently supported, and may be needed in the future, Lidström said. That was a key element of the decision to either ditch the old system for something new or modernize the system to meet business requirements.

    Production Planning

    This exercise resulted in the identification of the production planning system as a possible weak link. This was just part of the overall application, but the team found glaring inefficiencies that could cause real problems to the company down the line.

    “When we looked into the current processes, they described that they had three guys who were handling the production planning,” said Lidström, who was named an IBM Champion for IBM i earlier this year. “They did that based on a number of screens. They did it based on their knowledge. They did it based on things they had in Excel sheets and papers and so forth, which made them quite vulnerable.”

    Apper Systems conducted a current state analysis to determine where Dahrentrad was with its business applications.

    However, the analysis also found that implementing a new ERP implementation was likely too risky an endeavor for Dahrentrad. In that part of the world, SAP is the go-to ERP provider for manufacturers of this size, and S/4 Hana is the preferred solution rolling off the software production lines in Walldorf, Germany. But a multi-million-dollar ERP implementation that takes 12 to 18 months, apparently, did not entice the folks at Dahrentrad.

    While there were holes in the current system, there are also sizable benefits to continue using it, Lidström said. “For many of these considerations . . . they saw they had a very good application,” he said. “They saw that, instead of making a very big project to replace everything, it was better to focus on that production planning part of the application and see how that could be made more automated and efficient.”

    So Lidström and three colleagues at Apper Systems, along with folks from Dahrentrad, set out to define what a better production planning system would look like for the wire manufacturer. They held a brainstorm session where they discussed what the new application would do and how it would fit into the existing system.

    Data modeling, i.e. describing what the new data would look like and how it would be referenced, was also part of the planning. “It was not complete of course. We added things afterwards,” Lidström said. But basic modeling was important for determining how many database tables, programs, and screens needed to be created.

    Development and Implementation

    After scoping out the size of the project, they submitted it to the board, and it was approved. Lidström and his team then began planning for the development work itself, which would be a three-week project.

    Instead of the old waterfall development method, Apper is a big believer in using more iterative processes, whereby changes in the work are to be expected. That allowed more flexibility in the development process, he said.

    “We use an iterative way of working with the customer, which means we don’t need to have all the details ready before we can start,” Lidström said. “Of course you have to balance that. You have to be sure that you don’t have so many new requirements coming in, because then the project will grow and it will be very hard to live up to the estimates that you gave in the beginning.”

    Dahrentrad’s new demand planning system provides a visual representation of its wire manufacturing machines and operations.

    Apper had four men working on the project. One of the Apper team members would concentrate on writing new business logic using free-format ILE RPG and embedded SQL, one of them would focus on APIs and REST-based web services, and another would focus on front-end user interface development using the React JavaScript library. Lidström was the architect and led development along with his counterpart at Dahrentrad.

    In addition to scoping out the project and developing the software, the Apper team would help implement it. To that end, it provided unit testing to ensure all the components worked. It also assisted Dahrentrad with quality assurance testing, which was a challenge because of the 24/7 nature of the company.

    IBM i Deployment

    The fact that the new production planning system could be deployed on IBM i was a real benefit to the company.

    The ability to run the new demand planning system on its existing IBM i server was a big benefit to Dahrentrad.

    “We informed the customer about what the IBM i operating system and the Power platform is today,” Lidström said. “They had an old application on a modern platform. So instead of replacing everything and building it on another platform than IBM i and Power, we did it utilizing all the new functionalities that exist in the language and possibilities that exist of the database.”

    The Apper team brought a range of other technologies to bear on the project. It used JSON as the data interchange format for the REST APIs that it was exposing to the outside world. Internally, it used the Apache Web Server, the Webservice utility, and CGI, “which is a very fast way of producing Web services and a very fast, less overhead [way] compared with other ways,” Lidström said.

    It used other open source packages, too. It used the Web services utilities from Rainer Ross, and other tools from Scott Klement, as well as the aforementioned HTTP Server (the one from Apache). At the end of the day, Apper could have been built the entire application using nothing but open source, but it just wouldn’t have been the same.

    “All of this of course you could do with other open source-based options that exist on the platform,” Lidström said. “But we decided to base it on ILE and RPG because we had that knowledge. We knew that that could simplify the way to integrate from the existing applications, and it would also simplify with the web services, to integrate from other technologies into this solution that we built.”

    When it was all said and done, Apper delivered a new production planning system that met Dahrentrad’s requirements. Employees could interact with the system using GUIs on Web browsers, as well as from mobile devices, in several different languages. They can quickly change their view into production planning, just as easily as they could with a pre-built ERP system from a name-brand vendor.

    There are also benefits for the machine operators, who now use tablets instead of paper-based forms. That gives them more insight into the flow of work on the factory floor. “We can adjust the timing of how the production runs and how the orders are aligned and the forecast,” Lidström said.

    Dahrentrad went live with the new system in January, and it has been in production ever since. “It has been a very successful project,” Lidström said. “It helped them enormously.”

    Lidström’s complete vCEC2020 presentation is available from the COMMON Europe website.

    RELATED STORIES

    How IBM i Fits Into the Evolving ERP Market

    Frank Soltis Discusses A Possible Future for Single-Level Storage

    New IBM Champions Reflect on Their Journeys

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: 5250, ERP, IBM i, ILE, ILE RPG, JSON, REST API, RPG, RPGII, RPGIII, S/36, SQL, vCEC2020

    Sponsored by
    UCG Technologies

    Best Practices for Doing IBM i Cloud Backup & DRaaS Right

    In the technology business for 30+ years including more than a decade in cloud backup and disaster recovery, we’ve learned a few things along the way. Here are best practices to follow – and land mines to avoid.

    1. RELIABILITY. Up to 71% of restores from tape contain failures.
    • BEST PRACTICE: Use disk-to-disk technology for backups.

    With disk-to-disk technology, your backup data resides on disk drives, proven to be far more reliable than tapes. When your backup completes, you know the data is secure and accessible on the disk drive. With tapes you never really know if your data is usable until you try to restore it, at which point it’s too late.

    1. BREADTH OF OFFERING. Choice in product and service offerings meet your business’ needs.
    • BEST PRACTICE: Don’t settle for less than what you need.

    Vendor offerings vary widely. Some are designed primarily for consumers and others for enterprise data centers. Choose a solution that scales and offers the features you need to provide the level of service you expect. De-duplication and delta-block technologies will improve performance, reduce your data footprint and save you money. Find out if their de-duplication offering is at the file level or the block level. Make sure the solution can back up servers, PCs, and laptops as well your applications.

    1. SECURITY. 60% of organizations using tapes don’t encrypt their backups.
    • BEST PRACTICE: End-to-end encryption with no “back door.”

    Using encryption with tape makes backups run slowly and often takes too long to fit within a backup window. As a result, most people simply turn encryption off, creating a security risk. Even with the physical safety of disk-to-disk backup, encryption is essential. Look for 256-bit AES. Find a solution that encrypts your data during transmission and storage. Make certain there isn’t a “back door” that would let someone else view your data.

    1. ACCESSIBILITY. Companies waste thousands of hours waiting on tapes.
    • BEST PRACTICE: Ensure that you can get your data back with minimal delay.

    You should have direct access to your backups, with no time spent on physical transport (no trucks, no warehouses). Restores should take minutes, not hours or days. Set yourself up to work with your data, not wait for it. Make sure your solution provider can meet your Return-to-Operations (RTO) and Recovery Point Objectives (RPO) which determine how quickly you can recover your data and maintain business continuity. Inquire about onsite and offsite replication that provide both improved performance and a solid disaster recovery strategy.

    1. CYBER SECURITY. More than 80 percent of U.S. companies have been successfully hacked, according to a Duke University/CFO Magazine Global Business Outlook Survey.
    • BEST PRACTICE: Regular cyber security training and phishing tests for all employees using company email are essential to your organization.

    Your end-users are the weak link in your network security. Today, your employees are frequently exposed to advanced phishing attacks. Trend Micro reported that 91% of successful data breaches started with a spear-phishing attack. Be sure your vendor of choice includes cyber security training as part of their backup and DR package.

    1. SCALABILITY. Some backup systems can’t scale readily.
    • BEST PRACTICE: Invest in a data protection architecture that can grow with your business.

    You should be able to back up your data no matter how large it grows. Starting small? Look for an option that handles your backups automatically. Then, as you grow, gives you tools to manage complex environments. Look for “changes-only” and compression technologies to speed backups and save space. And insist on bandwidth throttling to balance traffic and ensure network availability for your other business applications. Make sure that their solution offerings rely on common technology to scale easily as your business––and data––grow.

    1. COST-EFFECTIVENESS
    • BEST PRACTICE: Calculate the true total cost of tape-based back up.

    A 2019 Server OS Reliability Survey found that one hour of downtime costs at least $100K for 98% of companies to over $5 million for 34% of surveyed companies. When you do the math, the dollars make sense: Go with disk-to-disk. Unlike tape, there are close to zero handling costs—no rush deliveries, loading, accessing, locating, or repeated steps. And there’s one benefit you can’t factor directly: Reputation. Reliability and security can make an incalculable difference with just one avoided breach or failure.

    1. COMPLIANCE. Most companies have problems satisfying privacy, security, and data retention regulations.
    • BEST PRACTICE: Choose a data protection partner who has deep know-how about compliance, and the technology to ensure it.
    1. Disaster Recovery. Most companies lack a comprehensive, tested plan for disasters.
    • BEST PRACTICE: Find a vendor that delivers a complete DR solution.

    You can’t say your data protection is complete until you have a disaster recovery plan that is itself complete and tested. Your backup vendor should have both the product mix and professional services team to help you prepare for a worst-case scenario. Make sure they can help configure your backups so you rebound quickly. Best bet: A vendor who can train you to deal with disasters confidently, based on your company’s actual configuration.

    1. EASE OF USE. Some companies don’t —or can’t—manage their backups from one place.
    • BEST PRACTICE: Get control and reporting you can use anywhere, with ease. Managing your backup environment should be simple, and the software you use should eliminate any guesswork that could lead to lost data. You should know at all times if your data is protected across your entire network—including remote offices—by simply looking at a dashboard. The software should be simple to configure using wizards, yet powerful enough to meet your specific needs with customizable views, job propagation, and roles-based security.
    1. OPERATING SYSTEM AND PLATFORM SUPPORT. Most backup vendors support a limited range of OS, server types, and applications.
    • BEST PRACTICE: Look for broad and deep technology that supports your complete environment. Your backup solution should accommodate your environment, not vice versa.
    1. CUSTOMER SUPPORT. Backup vendors’ product support varies widely.
    • BEST PRACTICE: Find a vendor whose support is passionate, maybe even slightly obsessed. Customer support should be one of your vendor’s main selling points. You shouldn’t have to wonder if they’ll be there to help when you need them most. Do they offer phone support or email only, and who exactly are you talking to when you call that 800 number? Find a vendor that will treat your data as if it were their own.
    1. REPUTATION. Does your backup vendor have a quality reputation and the financial resources to stay in business for the long haul?
    • BEST PRACTICE: Find a vendor with strong financial backing and customer references. There are a lot of vendors that have come and gone. When you consider a service provider, look for one that has strong financial backing, a solid business plan and the ability to be in business as long as your data needs to be stored. Ask for customer references and case studies as their customers are the best validation you can get.

     

    Visit VAULT400.com/proposal to receive a FREE analysis and proposal

    DOWNLOAD SOLUTIONS BRIEF:
    Best Practices for IBM i Cloud Backup & Recovery

    DURING THIS UNPRECEDENTED TIME, DON’T WAIT FOR YOUR BUSINESS
    TO SUFFER A DISASTER TO TAKE ACTION.

    Serving the US, Canada, & Latin America

    VAULT400 Cloud Backup & DRaaS is an IBM Server Proven Solution.

    800.211.8798 | info@ucgtechnologies.com| ucgtechnologies.com/cloud

    To the First Responders serving on the front-lines during the COVID-19 pandemic,
    we extend our heartfelt gratitude.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Testing: The Secret Weapon Of DR Success Open Source The Path To Software Riches For IBM i

    Leave a Reply Cancel reply

TFH Volume: 30 Issue: 77

This Issue Sponsored By

  • Profound Logic Software
  • UCG Technologies
  • Blair Technology Solutions
  • TL Ashford
  • Raz-Lee Security

Table of Contents

  • Open Source The Path To Software Riches For IBM i
  • Swedish Manufacturer Plans A New Path Forward
  • Testing: The Secret Weapon Of DR Success
  • Four Hundred Monitor, December 2
  • IBM i PTF Guide, Volume 22, Number 48

Content archive

  • The Four Hundred
  • Four Hundred Stuff
  • Four Hundred Guru

Recent Posts

  • Need An RPG Programmer? Nalashaa May Have You Covered
  • Every Day Has To Be Earth Day
  • Guru: Compare Pieces Of Source Members
  • As I See It: Ambivalence
  • IBM i PTF Guide, Volume 23, Number 16
  • Query Supervisor Gives Database Engineers New Power
  • IBM Unveils New and Improved IBM i Services
  • 3 Takeaways from the 2021 PowerTech Security Report
  • Four Hundred Monitor, April 14
  • IBM i PTF Guide, Volume 23, Number 15

Subscribe

To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

Pages

  • About Us
  • Contact
  • Contributors
  • Four Hundred Monitor
  • IBM i PTF Guide
  • Media Kit
  • Subscribe

Search

Copyright © 2021 IT Jungle

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.