• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Coglin Mill Keeps Pace With BI, Data Warehousing Demands

    May 26, 2009 Dan Burger

    When IBM introduced the AS/400 in 1988, it was clearly ahead of its time with regard to its report and query capabilities. But business intelligence has advanced while IBM depended on Query/400 for too long. IBM stepped forward with DB2 Web Query, the replacement for Query/400, and ISVs such as Coglin Mill–with RODIN, its ETL software–have also stepped up to advance database technology.

    The major enhancement in Release 6 of RODIN is the capability to capture data in real time. In the previous releases, the change capture functionality was limited to running in batch mode and most users scheduled it at the end of the day. The real time data change capture allows changes all day, everyday.

    The data captures can be done from either local or remote journals, which is not new functionality for RODIN Release 6, but it’s important to the capability of the product, particularly because remote systems are more frequently a part of business intelligence projects. Users can specify the tables that need to have changes captured and have those associated with the appropriate journal.

    As those entries hit the journal receivers, they are picked up and put into capture tables. RODIN allows multiple types of capture. There are captures that include before and after images, and captures that record all inserts, deletes, and other changes.

    RODIN is described as an extract, transform, and load (ETL) product that’s used to feed data into a data warehouse or data mart. It is often used to sort through transactional data when there are huge volumes being processed each day, but is even more useful with non-transactional data.

    Examples of transactional data include line items such as invoices, cash receipts, purchase orders–items that are dated or time stamped. Accessing changes is done by comparing run dates–comparing end-of-day today with end-of-day yesterday, for instance.

    Non-transactional data are things like customers, products, and stores–data that is not associated with a point in time and seldom contains a transaction date or time stamp. However, there may be a time stamp noting something like a customer phone number changed on a specific date.

    While discussing RODIN with Alan Jordan, vice president at Coglin Mill, he described a situation he recently experienced with a potential new client who has an extraordinary data table containing 1.5 billion rows. It is transactional data, so new records get written every day, but the data has no index, and because of the sheer volume of data that is churning through the system, the company doesn’t really want to take on the task of creating an index.

    “That’s an example of where automated change data capture would be very advantageous on a transactional table,” Jordan says. “Because if 10,000 rows get changed, then those 10,000 journal entries will get processed rather than the entire 1.5 billion. The benefit of real-time changes is that at the end of the day, when the data warehouse gets loaded, the data is already collected and doesn’t require going to the journals to get it.”

    Although this scenario is applicable to a large enterprise, Jordan says new product enhancements and a modular pricing plan has brought BI and data warehousing to the small to mid size organizations as well.

    This is primarily an ease of use issue.

    Usually as performance increases and more functionality is added, any software product becomes more complex to use. RODIN Release 6 has improved the management of multiple data sources.

    “Almost all of our customers want to pull some data from SQL Server databases and have data coming from other sources,” Jordan says. “And it is almost always remote rather than local.”

    With this in mind, Coglin Mill designed RODIN to provide a consistent view and management features whether the user is working with SQL Server, Oracle, or DB2 tables.

    IBM has shared information with some ISVs that enables their software to enhance DB2 Web Query. “In the case of Coglin Mill,” says Rick Bause, Power Systems PR manager, “we shared with them how they could automatically populate DB2 Web Query metadata with their ETL tool called RODIN. Their tool is an IBM i-specific data warehouse builder, so as part of pulling data from the data sources and populating/loading a DB2 for an i-based data warehouse, they can also automatically popluate/refresh DB2 Web Query metadata. This is a nice piece of integration when using RODIN in a DB2 Web Query environment.”

    A Webinar that includes the RODIN integration with IBM DB2 Web Query is scheduled for June 2. Coglin Mill and several other IBM partners with DB2 products relating to business intelligence and data warehouses will be included. To register for this event, titled “Jump start implementations with DB2 Web Query ecosystem solutions,” see www-03.ibm.com/systems/i/software/db2/webquery/db2_webinars.html.

    Pricing options for RODIN Release 6 are based on the server for an enterprise-level application that includes all functions; or for smaller organizations that do not require full functionality, RODIN is priced on the number of modules purchased. For more information, visit the company’s Web site at www.coglinmill.com.

    RELATED STORIES

    Coglin Mill Debuts Lower Cost Versions of ETL Tools

    Data Warehouses: Know One When You See One?

    IBM Updates DB2 Web Query Business Intelligence Tool



                         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
    WorksRight Software

    Do you need area code information?
    Do you need ZIP Code information?
    Do you need ZIP+4 information?
    Do you need city name information?
    Do you need county information?
    Do you need a nearest dealer locator system?

    We can HELP! We have affordable AS/400 software and data to do all of the above. Whether you need a simple city name retrieval system or a sophisticated CASS postal coding system, we have it for you!

    The ZIP/CITY system is based on 5-digit ZIP Codes. You can retrieve city names, state names, county names, area codes, time zones, latitude, longitude, and more just by knowing the ZIP Code. We supply information on all the latest area code changes. A nearest dealer locator function is also included. ZIP/CITY includes software, data, monthly updates, and unlimited support. The cost is $495 per year.

    PER/ZIP4 is a sophisticated CASS certified postal coding system for assigning ZIP Codes, ZIP+4, carrier route, and delivery point codes. PER/ZIP4 also provides county names and FIPS codes. PER/ZIP4 can be used interactively, in batch, and with callable programs. PER/ZIP4 includes software, data, monthly updates, and unlimited support. The cost is $3,900 for the first year, and $1,950 for renewal.

    Just call us and we’ll arrange for 30 days FREE use of either ZIP/CITY or PER/ZIP4.

    WorksRight Software, Inc.
    Phone: 601-856-8337
    Fax: 601-856-9432
    Email: software@worksright.com
    Website: www.worksright.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Sponsored Links

    ARCAD Software:  FREE Webinar - Managing ILE Development, June 3
    Halcyon Software:  Webinar: How to Survive in IT with a reduced headcount, June 4
    looksoftware:  Why Service-Enable? Attend a FREE webinar

    IT Jungle Store Top Book Picks

    Easy Steps to Internet Programming for AS/400, iSeries, and System i: List Price, $49.95
    The iSeries Express Web Implementer's Guide: List Price, $49.95
    The System i RPG & RPG IV Tutorial and Lab Exercises: List Price, $59.95
    The System i Pocket RPG & RPG IV Guide: List Price, $69.95
    The iSeries Pocket Database 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
    Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
    Getting Started with WebSphere Express for iSeries: List Price, $49.00
    Can the AS/400 Survive IBM?: List Price, $49.00
    Chip Wars: List Price, $29.95

    Profound Logic Aims to Simplify Menu Navigation with Atrium IBM Makes the Case for Power Systems SSDs

    Leave a Reply Cancel reply

Volume 9, Number 21 -- May 26, 2009
THIS ISSUE SPONSORED BY:

ProData Computer Services
PowerTech
Seagull Software
Vision Solutions
ARCAD Software

Table of Contents

  • Halcyon Revs Up U.S. Channel Effort
  • Coglin Mill Keeps Pace With BI, Data Warehousing Demands
  • CNX Updates EXTJS-Based System i Modernization Framework
  • MegaXML Looks to Drive Expense Out of EDI
  • Veryant Supports DB2/400 with COBOL-Java IDE
  • ACI Taps UC4 for Cross-Platform Job Scheduling
  • $12 Billion Bank Picks i OS Core Banking System from Jack Henry
  • DB2 Connect Gets Better Support for Stored Procedures and Triggers
  • SolarWinds Raises $150 Million in IPO
  • Speedware Joins Microsoft AS/400 Program

Content archive

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

Recent Posts

  • How Committed Is Big Blue To The IBM Cloud?
  • Immutable Copies Are Only As Good As Your Validation
  • Guru: IBM i *USRPRF Security
  • ERP Transitions Loom for SAP on IBM i Customers
  • Inflation Pumps Up Global IT Spending, Supply Chain Deflates It
  • COMMON Set for First Annual Conference in Three Years
  • API Operations Management for Safe, Powerful, and High Performance APIs
  • What’s New in IBM i Services and Networking
  • Four Hundred Monitor, May 18
  • IBM i PTF Guide, Volume 24, Number 20

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.