IBM Db2 Web Query for i

    HOT OFF THE PRESS: New Db2 Web Query Version 2.4.0 

           Learn about What's New in 2.4.0 Webinar (registration required)

           For more details, refer to the New Features Guide (Click HERE) 

IBM's Db2 Web Query for i family of products provide end-to-end analytics solutions integrated with IBM i. The product suite includes query/400 modernization facilities, easy to learn report and dashboard building tools, and an integrated ETL (Extract, Transformation, and Load) product to automate data cleansing and consolidation. Some of the features of the Web Query family include:

• Import or consolidate antiquated Query/400 Reports into modern Business Intelligence applications.
• Leverage powerful report types that let users drill down, and around interactively with the data.
• Deliver data to users in many different formats, including spreadsheets, PDF, HTML, or powerful web visualizations.
• Automate report execution and distribution with job scheduling and email integration functions.
• Enable BI as part of the day to day process by integrating reports into line-of-business applications through the ability to embed report execution calls directly from traditional 5250 or web-based applications.

Business Advantages: Db2 Web Query for i data sheet

Quick Start to Value: Db2 Web Query EZ-Install

Get started quickly with the Web Query EZ-Install package that includes the full suite of products and 100’s of sample reports. Use the included tutorials to get up to speed with how to build simple parameterized reports all the way to highly interactive visualization dashboards.

Choose from Multiple Editions

Express Edition is the entry level edition containing web-based report authoring while supporting all the output types (spreadsheet, PDF, HTML Analytical Documents, PowerPoint, and more). Move up to Scheduler Edition to add automated report execution and distribution. Push data out to consumers through email or send the output to a network drive.

Automate Data Prepping and Integration

Db2 Web Query DataMigrator ETL Extension provides extract, transformation, replication, and load capabilities integrated into Web Query and running within IBM i. Simplify data movement and transformations to support your analytics applications.

Start Small and Build UP to Enterprise Capabilites

RunTime User Edition adds a runtime only user licensing option based on IBM i Group Profiles to support potentially thousands of runtime users. Standard Edition is the most robust, enterprise package including all the functions of Express, Scheduler and RunTime User Editions plus access to non-Db2 databases and application integration capabilities, supporting thousands of users. 

Designer

•  Building Reports
• Building Charts and Visualizations

• Formatting Charts
• Assembling Pages from Existing Content

EZ-Report

• Create Fast Report over SQL Statement with EZ-Report

Reports

• Margin by product category (00:04:04)
• Quantity sold by stores (00:04:03)

• Sales metrics year to date (00:03:41)
• Yearly product metrics (00:05:29)

Charts

• Bar – highest margin products (00:04:30)
• Choropleth map – sales by state (00:03:11)
• Heatmap – average margin product by country (00:03:51)
• Line – product revenue by month – sized by discount (00:02:48)
• Pie matrix – quantity by region (00:05:55)
• Proportional symbol map – sales by store (00:01:55)

• Scatter – profit and COGs for products (animation) (00:05:06)
• Scatter matrix – profit versus COGs (00:05:17)
• Stacked bar – sales by month and product category (00:02:19)
• Stacked bar – units sold by stores versus web (animation) (00:02:57)
• Treemap – revenue and average margin for models (00:04:12)

• Sales by region dashboard (00:10:15)

Visualizations

• Analytical dashboard (00:06:49)
• Executive dashboard (00:04:14)

• Sales by country and product (00:04:16)
• Store and product profits over time (00:03:36)