• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • IBM Updates DB2 Web Query Business Intelligence Tool

    July 28, 2008 Alex Woodie

    IBM last week announced two additions to DB2 Web Query, the graphical business intelligence tool for generating and viewing reports and queries on the i operating system (formerly i5/OS). In September, IBM will deliver a new tool called Report Broker, which automatically distributes reports, and a new software development kit (SDK), which will enable customers and ISVs to integrate DB2 Web Query with existing applications.

    DB2 Web Query is a special version of Information Builder‘s WebFOCUS software that IBM announced in March 2007 and delivered that September. The software, which enables users to write queries for the DB2 for i (DB2/400) database and view the results in a Web environment through the included Report Assistant, Graph Assistant, and Power Painter components, is intended to replace the green screen Query for iSeries (Query/400) product while providing an on-ramp to more sophisticated business intelligence projects such as online analytical processing (OLAP), data warehousing, and data mining.

    In the first version of DB2 Web Query, IBM offered customers several optional add-on products. These included the OLAP Module for drill-down and multidimensional database reporting; Active Reports for accessing reports while disconnected from the server; and a Developer Workbench for creating more advanced reports and dashboards. IBM also added a “run time user enablement” option to the product earlier this year following complaints over its initial pricing structure, but that’s not really a product feature.

    While these add-ons provide customers with useful functionality, one of the big gaps in the product’s lineup was an automated report distribution tool. IBM will rectify this with the delivery of the Report Broker add-on almost exactly a year following the initial availability of DB2 Web Query.

    Report Broker, which ranges in price from $3,200 to $48,000 depending on the server’s software tier, will allow users to automatically e-mail, save, or print reports based on several criteria. Through the integrated graphical job scheduler, users can set DB2 Query Reports to run on a set schedule, with a daily, weekly, or monthly cycle; blackout days are also available to prevent the reports from being distributed. Alternatively, reports can be set to run based on a certain event, such the notification of end-of-day processing.

    Report Broker also supports distribution lists, enabling users to quickly assign recipients of DB2 Web Query reports and define the format (PDF, XLS, HTML, PPT, XML, etc). It also supports a “burst” feature that lets users break big reports into smaller pieces that can be distributed separately based on the value of a sort field. For example, a regional sales report can be broken up and distributed to the various managers, each of whom receives only the portion of the report their work is associated with.

    The new DB2 Web Query SDK is designed to help users integrate reports into existing applications, and for creating new applications that integrate with DB2 Web Query reports. Using the tool, customers and ISVs can embed reports–including text, dashboards, graphs, and charts–directly into their line of business applications. This is accomplished through a series of Web services interfaces that enable users to access and manipulate DB2 Web Query reports. Web services interfaces are available for the following actions: user authentication; working with report domains; retrieving report parameters and executing reports; checking for or executing report drill-downs; opening or retrieving a list of report domains; and working with Report Broker job scheduler (i.e. kicking off a distribution activity from an i OS application event).

    External data can also be incorporated into applications built with the DB2 Web Query SDK, which costs $10,000 per server.

    Both the SDK and the Report Broker ship September 19. For more information, view the United States Software Announcement 208-175, or visit the DB2 Web Query page at www-03.ibm.com/systems/i/software/db2/webquery/index.html.

    RELATED STORIES

    IBM Makes DB2 Web Query More Affordable

    IBM Prepares to Launch DB2 Web Query for System i

    More Details Emerge on Query/400’s Java-Based Replacement

    IBM to Distribute Info Builders’ iSeries BI Tools



                         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: Tags: mtfh_rc, Volume 17, Number 29 -- July 28, 2008

    Sponsored by
    UCG Technologies

    CYBER-ATTACKS ON THE RISE. PROTECT WITH THE TRIPLE PLAY.

    COVID-19 has not only caused a global pandemic, but has sparked a “cyber pandemic” as well.

    “Cybersecurity experts predict that in 2021, there will be a cyber-attack incident every 11 seconds. This is nearly twice what it was in 2019 (every 19 seconds), and four times the rate five years ago (every 40 seconds in 2016). It is expected that cybercrime will cost the global economy $6.1 trillion annually, making it the third-largest economy in the world, right behind those of the United States and China.”1

    Protecting an organization’s data is not a single-faceted approach, and companies need to do everything they can to both proactively prevent an attempted attack and reactively respond to a successful attack.

    UCG Technologies’ VAULT400 subscription defends IBM i and Intel systems against cyber-attacks through comprehensive protection with the Triple Play Protection – Cloud Backup, DRaaS, & Enterprise Cybersecurity Training.

    Cyber-attacks become more sophisticated every day. The dramatic rise of the remote workforce has accelerated this trend as cyber criminals aggressively target company employees with online social engineering attacks. It is crucial that employees have proper training on what NOT to click on. Cyber threats and social engineering are constantly evolving and UCG’s Enterprise Cybersecurity Training (powered by KnowBe4) is designed to educate employees on the current cutting-edge cyber-attacks and how to reduce and eliminate them.

    A company is only as strong as its weakest link and prevention is just part of the story. Organizations need to have a quick response and actionable plan to implement should their data become compromised. This is the role of cloud backup and disaster-recovery-as-a-service (DRaaS).

    Data is a company’s most valuable asset. UCG’s VAULT400 Cloud Backup provides 256-bit encrypted backups to two (2) remote locations for safe retrieval should a cyber-attack occur. This is a necessary component of any protection strategy. Whether a single click on a malicious link brings down the Windows environment or an infected SQL server feeds the IBM i, once the data is compromised, there is no going back unless you have your data readily available.

    Recovery is not a trivial task, especially when you factor in the time sensitive nature of restoring from an active attack. This leads to the third play of the Triple Play Protection – DRaaS.  Companies have myriad concerns once an attack is realized and a managed service disaster recovery allows employees to keep focus on running the business in a crisis state.

    The combination of training employees with secure backup and disaster recovery offers companies the best chance at avoiding financial disruption in an age of stronger, more frequent cyber-attacks.

    Reach out to UCG Technologies to discuss your company’s security needs and develop a data protection plan that fits you best.

    ucgtechnologies.com/triple-play

     800.211.8798 | info@ucgtechnologies.com

     

    1. https://theconversation.com/cyberattacks-are-on-the-rise-amid-work-from-home-how-to-protect-your-business-151268

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Using LTO 3 Tapes In an LTO 2 Drive Tell Me About Your Exports

    Leave a Reply Cancel reply

TFH Volume: 17 Issue: 29

This Issue Sponsored By

    Table of Contents

    • IBM Reaches Out to Midmarket Business Partners
    • Sundry July Power Systems Announcements
    • IBM Updates DB2 Web Query Business Intelligence Tool
    • As I See It: Babes in Broadband
    • SAP Shuts Down TomorrowNow Support Biz
    • Reader Feedback on What the Heck Is the Midrange, Anyway?
    • Gartner Predicts Half of Users Dissatisfied with IT Pace by 2013
    • IBM Ultrium Media Pricing: Told You This Story Wasn’t Done
    • Middleware Makers Are Sued Over Server Patents
    • Mike Borman Lands the CEO Job at Avocent

    Content archive

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

    Recent Posts

    • Doing The Texas Two Step From Power9 To Power10
    • PHP’s Legacy Problem
    • Guru: For IBM i Newcomers, An Access Client Solutions Primer
    • IBM i 7.1 Extended Out To 2024 And Up To The IBM Cloud
    • Some Practical Advice On That HMC-Power9 Impedance Mismatch
    • IBM Extends Dynamic Capacity Pricing Scheme To Its Cloud
    • Here’s What You Should Do About The IBM i Skills Shortage
    • Matillion Founder Recounts Midrange Roots
    • Four Hundred Monitor, February 24
    • IBM i PTF Guide, Volume 23, Number 8

    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.