• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Boise Cascade Gets ‘m-Powered’ with mrc Reporting Tool

    September 25, 2007 Alex Woodie

    The word came down from Boise Cascade’s management in May like a ton of pulp: Develop a sophisticated Web-based reporting system that interfaces with multiple host systems, and do it in three weeks. For the folks on BC’s application development team, that deadline seemed next to impossible to meet. However, despite being short a developer, the group persevered and managed to meet its deadline, with a little help from the mrc development tool, m-Power.

    Based in Boise, Idaho, Boise Cascade manufacturers a variety of wood products, including plywood, lumber, particleboard, paper, newsprint, and pulp. The company, which employs 10,000 people, also operates a fleet of trucks, vans, and trailers used to distribute its products and equipment around the country. While BC’s trucking division was successful, a competing trucking firm had surpassed it in one area: Web-based reporting. As a result, company management decided it needed a Web-based reporting system that was at least as good, if not better than its competitor’s.

    BC already had a load-tracking product, the i5/OS-based Add On Systems Web’n’Transit, which worked closely with the division’s IES dispatching system from Innovative Computing, which also runs on the AS/400. While it did a good job tracking the loads, Add On’s product didn’t offer the flexibility and capability to make customizations that BC needed, says Stan Brewer, an application development leader with BC.

    “We needed reporting abilities that allowed users to go in and select any report criteria they wanted, and pull up the specifics of these loads,” Brewer says. “We also needed to be able to report that via HTML or via Excel. The director, in particular, does everything in Excel. Those were really the two big requirements.”

    BC, like many large companies, prefers the safety of buying prepackaged products rather than developing stuff from scratch. With that said, the company had reached the limits that its prepackaged reporting product could provide to some of its users and customers. With the clock ticking, Brewer was pressured to find a reporting tool that was customizable, but that could also generate results quickly.

    Lynn Skinner, a developer working for Brewer, was the first to spot m-Power, a menu-driven development tool that generate Java servlets, XML, and HTML. The heritage of the product, which was introduced in 2004, is tightly tied to mrc-Productivity Series, the RPG-generating fourth-generation language (4GL) development tool that mrc has been developing for the IBM AS/400 line of computers for more than 20 years. Unlike mrc-Productivity Series, m-Power can be deployed from any number of platforms, including i5/OS, Windows, Unix, and Linux, and supports all the major databases, including DB2/400, Oracle, DB2 UDB, Microsoft SQL Server, and MySQL.

    The product looked promising, so Brewer contacted mrc, and a demo using generic data was set up. Then another demo was set up using the company’s data, and several meetings with BC manages were also set up. According to Brewer, in all those meetings and demos, mrc never failed to show up and impress the viewers with the ease of development using the tool. With a purchase price in the low tens of thousands of dollars–a steal compared to the big-name business intelligence product used in another BC division–Brewer got the sign-off, and was off and running with m-Power.

    After a week of training, an mrc developer arrived at BC’s Boise headquarters to help Brewer and Skinner with developing the actual reporting applications. After a full week of development work, the first Web-based reporting applications had been hammered out, and m-Power was serving up Java servlet-powered HTML pages that gave BC’s users the real-time access to the load data they needed.

    BC’s new application runs on a Windows box equipped with the open-source Tomcat Java application server (which mrc recommends running instead of WebSphere). The application generates highly optimized SQL statements that are executed on the AS/400-based dispatching application located in Boise. Those SQL statements are also executed against a Windows-based SQL Server database handling pulp deliveries based in BC’s DeRidder, Louisiana, pulp mill. All told, these two systems track between 500 and 600 trucks delivering a variety of products across the continent every day.

    The m-Power application joins the data from these two systems in real-time, and presents the results either graphically on a Web page, or textually in an Excel spreadsheet. In either case, users can drill down into the reports to get details on specific loads. Equipped with this information, salesmen, managers, and owner/operators working with BC can quickly get detailed information on the status of their deliveries.

    Brewer and company met the three-week deadline, gaining applause from people in management. “They are very, very pleased. I’ve received numerous positive feedback from every manager involved, saying that it’s just outstanding,” Brewer says.

    The trucking project was so successful that another BC division has started its own m-Power project. The transportation group, which is responsible for shipping BC’s products by rail and cargo containers, is starting to use m-Power to track deliveries that are dispatched from a mainframe-based application. In this case, m-Power is responsible for pulling data from millions of records in real time. By comparison, the trucking division’s m-Power implementation is “only” handling hundreds of thousands of records per day.

    Brewer was struck with the ease-of-use of the m-Power tool. “It’s extremely intuitive,” he says. “I did not have to learn Java to get this deployed. I’m an old RPG programmer, and all it requires is knowledge of your database. That was the big thing for me.”

    Brewer was also impressed with how easily it handled the SQL Server database. “The date formats on the SQL Server are totally different than anything we have on the AS/400. I didn’t have to create any conversion programs for all these various dates. With m-Power came all these conversion tools. I just loved that,” he says.

    The performance of m-Power also made an impression. Brewer has reservations about the impact that m-Power’s generated SQL statements might have on BC’s older AS/400 Model 720. Those fears turned out to be unfounded. “Even though it’s polling huge amounts of data from the AS/400, there’s no impact,” he says. The product reliably generates reports for about 60 users in under five seconds.

    The future is bright for m-Power at BC. Now that he has some experience with it, Brewer foresees the tool becoming a valuable part of the division’s initiative to modernize its legacy applications. First up? Some 5250 maintenance screens that may be better served as Web pages.

    Whatever the future may bring, Brewer always has the memory of those stressful three weeks in late spring, coming out of them successful, and helping the company compete. “It’s already made us a lot more efficient,” he says. “It’s accomplishing a lot here. It’s also providing management a lot of tools, where they’re getting the information they need much quicker. It’s just saving them a lot of headaches.”



                         Post this story to del.icio.us
                   Post this story to Digg
        Post this story to Slashdot

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags:

    Sponsored by
    UCG Technologies – Vault400

    Do the Math When Looking at IBM i Hosting for Cost Savings

    COVID-19 has accelerated certain business trends that were already gaining strength prior to the start of the pandemic. E-commerce, telehealth, and video conferencing are some of the most obvious examples. One example that may not be as obvious to the general public but has a profound impact on business is the shift in strategy of IBM i infrastructure from traditional, on-premises environments to some form of remote configuration. These remote configurations and all of their variations are broadly referred to in the community as IBM i hosting.

    “Hosting” in this context can mean different things to different people, and in general, hosting refers to one of two scenarios. In the first scenario, hosting can refer to a client owned machine that is housed in a co-location facility (commonly called a co-lo for short) where the data center provides traditional system administrator services, relieving the client of administrative and operational responsibilities. In the second scenario, hosting can refer to an MSP owned machine in which partition resources are provided to the client in an on-demand capacity. This scenario allows the client to completely outsource all aspects of Power Systems hardware and the IBM i operating system and database.

    The scenario that is best for each business depends on a number of factors and is largely up for debate. In most cases, pursuing hosting purely as a cost saving strategy is a dead end. Furthermore, when you consider all of the costs associated with maintaining and IBM i environment, it is typically not a cost-effective option for the small to midsize market. The most cost-effective approach for these organizations is often a combination of a client owned and maintained system (either on-prem or in a co-lo) with cloud backup and disaster-recovery-as-a-service. Only in some cases of larger enterprise companies can a hosting strategy start to become a potentially cost-effective option.

    However, cost savings is just one part of the story. As IBM i expertise becomes scarce and IT resources run tight, the only option for some firms may be to pursue hosting in some capacity. Whatever the driving force for pursing hosting may be, the key point is that it is not just simply an option for running your workload in a different location. There are many details to consider and it is to the best interest of the client to work with an experienced MSP in weighing the benefits and drawbacks of each option. As COVID-19 rolls on, time will tell if IBM i hosting strategies will follow the other strong business trends of the pandemic.

    When we say do the math in the title above, it literally means that you need to do the math for your particular scenario. It is not about us doing the math for you, making a case for either staying on premises or for moving to the cloud. There is not one answer, but just different levels of cost to be reckoned which yield different answers. Most IBM i shops have fairly static workloads, at least measured against the larger mix of stuff on the public clouds of the world. How do you measure the value of controlling your own IT fate? That will only be fully recognized at the moment when it is sorely missed the most.

    CONTINUE READING ARTICLE

    Please visit ucgtechnologies.com/IBM-POWER9-systems for more information.

    800.211.8798 | info@ucgtechnologies.com

    Article featured in IT Jungle on April 5, 2021

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    COMMON:  Join us at the annual 2008 conference, March 30 - April 3, in Nashville, Tennessee
    looksoftware:  Stop recoding with end-to-end modernization solutions
    NowWhatJobs.net:  NowWhatJobs.net is the resource for job transitions after age 40

    IT Jungle Store Top Book Picks

    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database Guide: List Price, $59.00
    The iSeries Pocket Developers' Guide: List Price, $59.00
    The iSeries Pocket SQL Guide: List Price, $59.00
    The iSeries Pocket Query Guide: List Price, $49.00
    The iSeries Pocket WebFacing Primer: List Price, $39.00
    Migrating to WebSphere Express for iSeries: List Price, $49.00
    iSeries Express Web Implementer's Guide: List Price, $59.00
    Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    WebFacing Application Design and Development Guide: List Price, $55.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    The All-Everything Machine: List Price, $29.95
    Chip Wars: List Price, $29.95

    A Little Application Humor, Thanks to Lawson Software Weird SQL UNION Results

    Leave a Reply Cancel reply

Volume 7, Number 36 -- September 25, 2007
THIS ISSUE SPONSORED BY:

Aldon
Bytware
Profound Logic Software
HiT Software
COMMON

Table of Contents

  • BCD’s WebSmart PHP Goes GA
  • Boise Cascade Gets ‘m-Powered’ with mrc Reporting Tool
  • Red Oak Simulates World’s Fastest Human Terminal Operator
  • Echo Cuts Waste with SPLTOOL Investment
  • Arcad Delivers Free Emulator, Tester for WDSc
  • CCSS Concentrates on European Expansion
  • Gaylord Picks’ i5/OS System for National Harbor Convention Center
  • Clearview Boosts 5250 Screen Navigation for Smartphones
  • ICS Updates FormSprint
  • B&L Releases Cost Estimating Wizard

Content archive

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

Recent Posts

  • When Cloud Meets DevOps on IBM i
  • JD Edwards Roadmap Reveals Decisions To Be Made
  • IBM Completes Migration of Knowledge Center to IBM Documentation
  • Four Hundred Monitor, April 7
  • Crazy Idea Number 615: Variable Priced Power Systems Partitions
  • Do The Math When Looking at IBM i Hosting For Cost Savings
  • Guru: Web Services, DATA-INTO and DATA-GEN, Part 1
  • Oracle Versus Rimini Slogs On In Second Decade
  • HCI Is The Dominant Converged System, Probably For Good
  • Skytap To Expand IBM i Cloud Offering

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.