• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Investment In IBM i Leads To Innovation Award

    May 22, 2017 Dan Burger

    Running the company website on the IBM i is one of those ideas that demonstrates how people get in their own way by creating phantom obstacles. Without thinking much about it, the default website decision often is “put it on the Windows or Linux server.” Regrettably, the default setting doesn’t always yield the best results.

    Evidence to that effect is the work done by the Grand Rapids Association of Realtors. Migrating their website from a Windows server to their IBM i, on close examination, was a smart choice for several good reasons. Lower cost of operation, a content management system with closer integration to the back-end business system, and fewer and smaller obstacles than imagined made a lot of people happy.

    It also impressed a lot of people at IBM and COMMON. Those two organizations made the work done at the realtor association their pick for the annual Innovation Award, which is presented at the COMMON Annual Meeting and Exposition each spring.

    Realtors depend on websites to sell homes. Homebuyers depend on websites to search for homes. If either of these customers of IT services is unhappy, business suffers. If business suffers, the IT department will feel the pain.

    The GRAR website gets high marks for functionality, visual appeal, responsive design for rendering on all devices.

    Grand Rapids Association of Realtors has depended on an IBM midrange computer since the days of the System/38. The website went online in 1999 using IBM’s Net.Data, software for converting client/server applications into Web applications, running on the company’s AS/400. Several years later, management decided the website needed a new look and feel and it was turned over to an outside vendor. The website was moved to a Windows box, with a proprietary content management system that made website updates difficult and costly. It became a sore point with the association’s CEO.

    IT director Rick Bowman and application support specialist Larry Amond suggested the website be brought back in house to run on the IBM i using WordPress.

    “We had the proof of concept up and running in about a day,” Amond said in a telephone interview with IT Jungle last week, “including talking with RPG on the backend. We already had Zend Server running, so we downloaded WordPress to run there. We leveraged RPG business logic and DB2 and incorporated that into WordPress, using JavaScript and PHP.”

    The association’s business partner, Arbor Solutions, helped create the proof of concept and assisted with the development.

    Arbor Solutions and the Grand Rapids Association of Realtors have been business partners for 20 years, but a recent college graduate, Chris Schaefer, worked closely with Amond, a seasoned RPG developer, and together they accomplished about 95 percent of the site development work.

    “This was a learning experience,” Schaefer said. “Coming into the project I was familiar with JavaScript, PHP, and Bootstrap but only in practice. Customizing everything to work as a whole was an amazing challenge and very rewarding experience.”

    “We were pleasantly surprised how we were able to get WordPress up and running very simply. That was a big selling point,” Bowman added.

    The development utilized Bootstrap – an HTML, CSS, and JavaScript framework for developing responsive Web design – modified to a custom WordPress theme. This framework allowed the developers to create a highly functional, visually appealing, search platform that works across mobile and desktop devices.

    A combination of SQL in PHP and SQL embedded in RPG and DB2 stored procedures were used to create accounts, retrieve information, and save, update or remove searches.

    Users are able search the database using multiple property features as well as drawing a search area on a map. The search selections query the database using dynamically created SQL embedded in an RPG program and calls Google’s Mapping APIs. The coordinates are sent to a stored procedure, which performs all the calculations to find properties in the selected area. The search results are returned to a PHP program in a session table which is parsed out by a PHP script within a WordPress page. The results can also be pinned on a map.

    “We wanted to take advantage of the existing business logic that was stable with our DB2 on i environment and best utilize the skill sets of our staff and the staff of our business partner,” Amond said.

    The RPG programs are a story of evolution that begins with code generated from the Synon case tool. Over the years, it been maintained, massaged, modularlized and modernized using ILE and free-format syntax.

    “Our back office business logic has grown up since the Synon days,” Amond said. “We’ve brought very old code and technology to modern, even bleeding edge, code.”

    As for the website, Amond and Bowman acknowledged some skills were acquired from the days when they ran the Net.Data website on the Apache server in the late 1990s. Net.Data was not as polished in those days and there wasn’t a content management system in the equation. All changes had to go through the IT department. The new WordPress website saves time and money by allowing non-technical staff–marketing, sales, and management–to make modifications when needed.

    In the current situation, the two-person IT staff runs four WordPress sites: a development site, a beta (test) site, a members-only site, and the public-facing site. Each has a separate IP address and runs within Zend Server and the Apache Server.

    It all runs on Power7+ technology. The website, along with other business critical applications, are on a four-core (P05 tier) 8202-E4D Power System with eight internal 283 GB drives. On average, the site receives more than 400,000 unique property searches per month. These searches generate more than 91,500,000 monthly property matches and nearly 12,000,000 are viewed in detail by prospective home buyers.

    “When you compare the size of this small IBM Power System to the actual output of work it is doing from a Web traffic and search-results-returned perspective, it is extremely impressive,” Amond noted while adding, ‘”the project was scary, but we haven’t let that hold us back from learning new technologies and moving forward and trying to build something better.”

    RELATED STORIES

    COMMON Opening Session Highlights Excellence

    Open Source On IBM i: Let It Grow

    Watson Puts On A Show At COMMON

    Free Form RPG Scores IBM i Innovation Award

    App Dev Team Sees Innovation Rewarded

    IBM i Innovators To Gather In Minneapolis

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: COMMON, IBM i

    Sponsored by
    ARCAD Software

    [Webinar Series] Demystifying DevOps on the IBM i

    Join us for this 3-Part Roundtable Webinar Series, where ARCAD experts will demystify the move to Git and an automated process with options that work for everyone!

    This Series will be an engaging discussion on key DevOps topics as Git, Builds, Automation and much more.

    Part 1: IBM i & Git – Developer Tools (Thursday, January 26th, at 12:00PM ET / 9:00AM PT)

    During this 1st session, we will discuss Developer Tools and all the ways to use Git including iProject, Merlin, VS Code, ARCAD’s Centralized option and more.

    Part 2: Branching & Building (Thursday, February 9th, at 12:00PM ET / 9:00AM PT)

    During this 2nd session, we will discuss Feature/Release and Branch Management and building the branches with tools like Bob and ARCAD.

    Part 3: DevOps – Automated Workflow (Thursday, February 23rd, at 12:00PM ET / 9:00AM PT)

    During this 3rd session, we will discuss what can be automated in the IBM i DevOps process starting from the build to other steps in your workflow.  We’ll discuss pipeline tools like Jenkins and the new automation features of Git packages.

    Register NOW

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    WannaCry: What IBM i Pros Need To Know As I See It: Wake Up Call

    2 thoughts on “Investment In IBM i Leads To Innovation Award”

    • Michael White says:
      August 2, 2017 at 10:38 am

      Interesting article. I had a question, is there a profit from buying 8-core equipment, rather than 6-core equipment? Now 2017 and as400 will soon die maybe, but now it’s work everywhere. I am considering the option of expanding my powers from 2 8202 E4D models (https://datatechcomputer.com/ibm-pseries-servers/ibm-8202-e4d-pseries-aix-power7-server-epcl-6-core/ or https://datatechcomputer.com/ibm-pseries-servers/ibm-8202-e4d-pseries-aix-power7-server-epcm-8-core/). Thanks for the answer. If it possible to write on email mw.webmasters@gmail.com, i’ll be very gratefull. Double thanks.

      Reply
      • Abdule says:
        August 22, 2017 at 7:17 am

        Look at this one https://datatechcomputer.com/ibm-iseries-servers/ibm-8202-e4c-iseries-power7-server-epc6-5900-34900-cpw-6-core-p10/

        Reply

    Leave a Reply Cancel reply

TFH Volume: 27 Issue: 35

This Issue Sponsored By

  • T.L. Ashford
  • MITEC 20i7
  • WorksRight Software
  • Computer Keyes
  • Remain Software

Table of Contents

  • Say Sayonara To IBM i 7.1 Next Spring
  • Top Ten New IBM i RFEs
  • Guru: Confessions Of A Recovering RDi Outline Addict
  • As I See It: Wake Up Call
  • Investment In IBM i Leads To Innovation Award

Content archive

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

Recent Posts

  • N2i Gains Traction Among IBM i Newbies
  • Realizing The Promise Of Cross Platform Development With VS Code
  • 2023 IBM i Predictions, Part 3
  • Four Hundred Monitor, January 25
  • Join The 2023 IBM i Marketplace Survey Webinar Tomorrow
  • It Is Time To Have A Group Chat About AI
  • 2023 IBM i Predictions, Part 2
  • Multiple Vulnerabilities Pop Up In Navigator For i
  • Participate In The 2023 IBM i Marketplace Survey Discussion
  • IBM i PTF Guide, Volume 25, Number 4

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 © 2022 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.