IBM Db2 Web Query for i

BREAKING NEWS:  Db2 Web Query Version 2.3.0 Arriving Soon!

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 query/report/dashboard building tools, and an integrated ETL (Extract, Transformation, and Load) product to automate data cleansing and consolidation. Some of the features of the Db2 Web Query family include:

• Import or consolidate antiquated Query/400 Reports into modern Business Intelligence applications.
• Leverage powerful report types that let end users drill down, and around interactively with the data.
• Deliver data to end users in many different formats, including spreadsheets, PDF, HTML or powerful web visualizations.
• Automate report execution and distribution with job scheduling and e-mail 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 Db2 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 via email or send the output to a network drive.

Automate Data Prepping and Integration

Db2 Web Query DataMigrator ETL Extension provides extract, transformation, and load (ETL) capabilities integrated with Db2 Web Query and Db2 for i. Simplify data movement and transformations to support your analytics applications. Leverage data preparation facilities to simplify extracts.

Start Small and Build UP to Enterprise Capabilites

RunTime User Edition adds a virtually unlimited run-time only user licensing option on top of what is offered in Express Edition. 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. 

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 vs. COGs for products (animation) (00:05:06)
• Scatter matrix – profit vs. COGs (00:05:17)
• Stacked bar – sales by month and product category (00:02:19)
• Stacked bar – units sold by stores vs. 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)