Book description
Abstract
Business Intelligence (BI) is a broad term that relates to applications that analyze data to understand and act on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the user.
At the core of any BI solution are user query and reporting tools that provide intuitive access to data supporting a spectrum of users from executives to “power users,” from spreadsheet aficionados to the external Internet consumer.
IBM® DB2® Web Query for i offers a set of modernized tools for a more robust, extensible, and productive reporting solution than the popular IBM Query for System i® tool (also known as IBM Query/400). IBM DB2 Web Query for i preserves investments in the reports that are developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. But, it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.
The DB2 Web Query for i product is a web-based query and report writing product that offers enhanced capabilities over the IBM Query for iSeries product (also commonly known as Query/400). IBM DB2 Web Query for i includes Query for iSeries technology to assist customers in their transition to DB2 Web Query. It offers a more modernized, Java based solution for a more robust, extensible, and productive reporting solution.
DB2 Web Query provides the ability to query or build reports
against data that is stored in DB2 for i (or Microsoft SQL Server)
databases through browser-based user interface
technologies:
Build reports with ease through the web-based, ribbon-like
InfoAssist tool that leverages a common look and feel that can
extend the number of personnel that can generate their own
reports.
Simplify the management of reports by significantly reducing the
number of report definitions that are required through the use of
parameter driven reports.
Deliver data to users in many different formats, including
directly into spreadsheets, or in boardroom-quality PDF format, or
viewed from the browser in HTML.
Leverage advanced reporting functions, such as matrix reporting,
ranking, color coding, drill-down, and font customization to
enhance the visualization of DB2 data.
DB2 Web Query offers features to import Query/400 definitions and
enhance their look and functions. By using it, you can add
OLAP-like slicing and dicing to the reports or view reports in
disconnected mode for users on the go.
This IBM Redbooks® publication provides a broad understanding of what can be done with the DB2 Web Query product. This publication is a companion of DB2 Web Query Tutorials, SG24-8378, which has a group of self-explanatory tutorials to help you get up to speed quickly.
Table of contents
- Front cover
- Notices
- Preface
- Chapter 1. The cycle of Business Intelligence and IBM DB2 Web Query for i
-
Chapter 2. Working with IBM DB2 Web Query for i
- 2.1 Videos and important websites
- 2.2 Simple reports
- 2.3 Date functions in reports
- 2.4 Various report features and formatting
- 2.5 Charting
- 2.6 Filters
- 2.7 Drilling down
- 2.8 Documents and dashboards
- 2.9 Mobile
- 2.10 Scheduling and distribution of reports
- 2.11 Wizard
- 2.12 Services
- 2.13 IBM i Compliance and Reporting Tool
- Chapter 3. Installation and server operations
- Chapter 4. Defining metadata
-
Chapter 5. Date and time functions
- 5.1 The importance of dates in reporting
-
5.2 Handling legacy dates
- 5.2.1 Modernizing your database
- 5.2.2 Using DB2 Web Query for i functions to convert to smart dates
- 5.2.3 Using SQL functions and views to convert dates
- 5.2.4 Using a date dimension table
- 5.2.5 Comparing the legacy date conversion techniques
- 5.2.6 Example: Converting date fields in the Oracle JD Edwards World application
- 5.2.7 Converting other common legacy date formats
- 5.3 Using dates and date components
- 5.4 DB2 Web Query for i date built-in functions
- 5.5 Example: Dynamic Date Range report
- 5.6 Date and time system variables
- 5.7 Date format
- Chapter 6. IBM DB2 Web Query for i Security Center
-
Chapter 7. Accessing additional data sources
- 7.1 Connecting to DB2 for Linux, UNIX, or Windows or z/OS
- 7.2 Using the adapter for Microsoft SQL Server
- 7.3 Using the adapter for MySQL
- 7.4 Using the adapter for PostgreSQL
- 7.5 Using the generic adapter for JDBC
-
7.6 Using adapters for JD Edwards
- 7.6.1 Areas to consider when connecting to a JD Edwards database
- 7.6.2 Using a JD Edwards adapter to connect to a remote JD Edwards database
- 7.6.3 JD Edwards dictionary files that are needed on local system to access remote JD Edwards databases
- 7.6.4 Using the adapter for JD Edwards World
- 7.6.5 Using the adapter for JD Edwards EnterpriseOne
- Chapter 8. Managing data with DataMigrator
-
Chapter 9. Integrating web data into your custom application
- 9.1 Initial setup
- 9.2 Using the extension
- 9.3 Report parameter considerations
- 9.4 Authentication methods
- 9.5 Dynamic Run Time Environment support
- 9.6 Restrictions
-
9.7 Properties file and options
- 9.7.1 Server
- 9.7.2 Port
- 9.7.3 Basic authentication
- 9.7.4 User and password
- 9.7.5 Browse mode
- 9.7.6 Cache timeout
- 9.7.7 Token timeout
- 9.7.8 Template heading
- 9.7.9 Template footing
- 9.7.10 Parameter prompt limit
- 9.7.11 Result schema
- 9.7.12 Enable statistics
- 9.7.13 Debug mode
- 9.7.14 Parameter prompt
- 9.7.15 About link
- 9.7.16 WQRAX_USER fex
- 9.7.17 Timeout redirect URL
- 9.7.18 Email output
- 9.7.19 SMTP server
- 9.7.20 Sender
- Appendix A. DB2 Web Query for i amper variables
- Back cover
Product information
- Title: IBM DB2 Web Query for i: The Nuts and Bolts
- Author(s):
- Release date: May 2017
- Publisher(s): IBM Redbooks
- ISBN: 9780738442488
You might also like
book
IBM DB2 Web Query for i Version 2.1 Implementation Guide
Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes …
book
IBM Db2 Mirror for i Getting Started
IBM® Db2® Mirror for i provides a new solution for continuous availability for an IBM i …
book
Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS
The IBM System i family, which encompasses the IBM AS/400, eServer iSeries, eServer i5, and System …
book
DB2 for Linux on iSeries: Implementation Guide
This IBM Redbooks publication discusses DB2 UDB for Linux on iSeries. We provide the installation and …