IBM DB2 Web Query for i

Learn more

Business Intelligence

• Why IBM i for BI (278KB)

Customer successes

• South Carolina Student Loan modernizes business intelligence capabilities with IBM DB2 Web Query for i (209KB)

---

Highlights

• Modernize Query for IBM® iSeries® (Query/400) reports with browser-based tools
• Hide complexity of accessing data from end users through metadata layer and parameterized reports
• Improve performance of queries by leveraging advanced IBM DB2® for i query optimization features
• Reduce IT support efforts with single server-based installation and maintenance

Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes of understanding and acting 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 end user.

At the core of any business intelligence solution are end user query and reporting tools that provide intuitive access to data supporting a spectrum of end 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 Query for System i (also known as Query/400) tool. DB2 Web Query for i preserves investments in the reports 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 offer significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.

DB2 Web Query provides the ability to query or build reports against data stored in DB2 for i (or Microsoft® SQL Server®) databases through browser-based user interface technologies. Build new 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 required through the use of parameter driven reports. Deliver data to end 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.

Add the OLAP (On-Line Analytical Processing) feature to interact with the data through slicing and dicing and drill-down capabilities. For the end user on the go, choose the Active Reports feature to allow reporting without having to be connected to the server. Build simple dashboards with the optional DB2 Web Query Developer Workbench. Use the Developer Workbench to hide the complexities of the database (for example, join logic) from end users through metadata. Automate report execution and distribution with the DB2 Web Query Report Broker product. Integrate DB2 Web Query reports into applications with a Software Development Toolkit.