• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Coglin Mill And Help/Systems Tag Team For Analytics

    April 23, 2012 Dan Burger

    It’s fair to say business analytics on the IBM i platform has a more serious business attitude compared to some of the lightweight activities that get lumped into this category on less robust systems. And you’ve probably heard the complaints about insufficient analytical capabilities that do little or nothing to solve real business problems. The failure of deployments to achieve the hoped for objectives shakes the confidence of CEOs contemplating business intelligence projects at all levels.

    It also raises questions about the wisdom of taking data from the IBM i platform and feeding databases on other platforms when the decision to do the analytics on the IBM i box could often be the better choice. Strategies guided by a lack of information–or an abundance of misinformation–about IBM i have been known to lead companies down a crooked path.

    Stepping into this arena where nothing less than quantifiable business benefits are expected are two IBM i ISVs, who are combining efforts to provide what they think organizations need to crunch data more effectively than ever before.

    Coglin Mill brings the data warehouse and data mart expertise while Help Systems adds the graphical query tool. Together, the companies claim they can “optimize business intelligence for organizations seeking to optimize DB2 for i.” Both Coglin Mill’s RODIN and Help Systems’ SEQUEL have referential histories in IBM i shops, although it’s unknown how often they have been paired for purpose the two firms are now promoting. It’s much more likely they have been deployed independent of one another.

    For those who favor the RPG and DB2/400 method of creating data extracts, transformations, and change data capture (CDC) routines in production IBM i databases, RODIN was made to do just that. It also has extract, transform and load capabilities with graphical representation of mappings, business rules and transformations and is integrated with the native IBM i environment, which gives it a key performance differentiator compared to other ETL tools.

    In shops where folks with biases toward setting up business intelligence projects on other platforms, this kind of comparison and this kind of thinking is often dismissed or it is never even put into a discussion by those most familiar with the IBM i environment but unfamiliar with business analytical potential on the box.

    RODIN sources data from local and remote DB2 for i tables, DB2 databases on other platforms, and Oracle, SQL Server, MySQL, and other databases; it also has built-in change data capture capabilities lets users identify and load new and changed data.

    SEQUEL is paired up with RODIN because of its strengths in data access, visualization, and analysis. It handles ad hoc queries, is the basis of executive dashboards and executive information systems, and has multi-platform database access and reporting, while bringing data to desktops, laptops, web browsers, and mobile devices. It is a multi-purpose utility that excels at executing queries and generating reports from DB2/400 as well as other relational databases.

    Alan Jordan, executive vice president at Coglin Mill, characterized one of the value propositions of the bundled software package is “a secure, reliable and auditable solution for supporting the business analytics process. . . . Instead of having to deal with data from disparate systems, in mismatched formats, with all sorts of usability and data quality issues; SEQUEL developers will be . . . able to produce any desired report. SEQUEL provides the dashboards and various views that perform with RODIN’s data warehouse on-demand. Our automated BI integration platform complements the business intelligence environment and improves the rapid development and predictability of accurate information, and the efficient delivery of reports, resulting in savings in time and costs.”

    One other thing for those of you who are in a hardware buying cycle, the IBM i Solution Edition machines offers a discounted price on Power Systems boxes preconfigured with RODIN software. You can find information on the Solution Edition boxes at this IBM website.

    RELATED STORIES

    Help/Systems Widens the Robot’s Reach

    Help/Systems Makes ABSTRACT Accessible Within RDP

    RODIN Admitted to IBM i Solution Edition Program

    Help/Systems Leads New Entries Into IBM i Solution Edition Program

    Help/Systems Streamlines IFS Backups with Robot/SAVE 12

    Coglin Mill’s ETL Makes Data Warehousing on IBM i More Attractive

    Help/Systems Buys Database Monitoring Tool from Innovatum

    Help/Systems Updates Job Scheduler GUI

    Coglin Mill Keeps Pace With BI, Data Warehousing Demands



                         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
    LaserVault

    Integrate Virtual Tape to Automate Your Backups And Strengthen Your Ability To Recover From Cyber Attacks And Disasters

    With most IT departments stretched thin, finding something that can quickly free up IT time is definitely a bonus. That’s why it’s important to stop and take a look at integrating virtual tape into your backup and recovery. Virtual tape is one of those technologies where once you have it, you’ll wonder why you didn’t do it sooner. See a demo and get a $50 gift card.

    But what is it about using virtual tape that makes it so worthwhile? Why is it that so many IBM i shops are already using or considering using virtual tape for all or part of their backup and recovery systems?

    Virtual tape and virtual tape libraries offer a way to both simplify and strengthen backup and recovery operations. By incorporating virtual tape technology, automation of backups becomes possible resulting in hundreds of hours saved annually for IT departments and personnel.

    “We needed to find a replacement that would lower the maintenance cost and reduce complexity of our backup and recovery functions without a major disruption to our operations.” David Fray, Director of Enterprise Systems, ABC Financial

    LaserVault ViTL is a virtual tape and tape library solution developed specifically for use with IBM Power Systems (from AS/400 to iSeries to Power 9s). With ViTL you can:

    • Replace physical tape and tape libraries and eliminate associated delays
    • Automate backup operations, including the ability to purge or archive backups
    • Remotely manage your backups – no need to be onsite with your server
    • Save backups to a dedupe appliance and the cloud
    • Recover your data at lightspeed greatly improving your ability to recover from cyberattacks
    • And so much more

    Sign-up now to see a ViTL online demo and get a $50 Amazon e-gift card when the demo is complete as our way of saying thanks for your time. Plus when you sign-up you’ll receive a free facts comparison sheet on using virtual tape vs tape so you can compare the functionality for yourself.

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Admin Alert: Planning An i 6.1 Upgrade A ‘New’ Infor Proclaims Need for Speed

    Leave a Reply Cancel reply

Volume 21, Number 16 -- April 23, 2012
THIS ISSUE SPONSORED BY:

ProData Computer Services
Infor
Maxava
IntelliChief
WorksRight Software

Table of Contents

  • AWS/400: Amazon Builds An AS/400-oid Cloud
  • IBM Loses Money On Hardware In Q1
  • Summit Partners Acquires Control Of Help/Systems–Again
  • Mad Dog 21/21: Drivers Of The Purple Sage
  • Third Party’s A Charm For JDE Maintenance Contracts
  • IT Spending Projections Crimped For 2012
  • IBM Sells Retail Systems Biz To Rival Toshiba For $850 Million
  • IBM Rochester Gets A Piece Of the PureSystems Action
  • What’s Your Digital Personality?
  • Coglin Mill And Help/Systems Tag Team For Analytics

Content archive

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

Recent Posts

  • IBM Mulls Using DataMigrator as Cloud Warehouse Pipeline
  • PowerTech AV Automatically Detects Ransomware Activity
  • Infor Puts CM3 Project On Hold
  • Four Hundred Monitor, June 29
  • IBM i PTF Guide, Volume 24, Number 26
  • Guild Mortgage Takes The 20-Year Option For Modernization
  • IBM i Licensing, Part 3: Can The Hardware Bundle Be Cheaper Than A Smartphone?
  • Guru: The Finer Points of Exit Points
  • Big Blue Tweaks IBM i Pricing Ahead Of Subscription Model
  • We Still Want IBM i On The Impending Power E1050

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.