Software solution: DB2 Web Query for i
IBM's DB2 Web Query for i provides capabilities to query or build reports against data stored in DB2 for i and other databases through browser based user interface technologies. Build new reports with ease through the intuitive InfoAssist graphical report builder. Simplify the management of reports by leveraging parameterized reporting to reduce the number of reports that require maintenance. 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.
DB2 Web Query is designed to enable you to modernize your existing Query/400 environment. Leverage OLAP reports to provide data slicing and dicing and trend analysis. A single OLAP report could replace many Query/400 reports required to delve into the data to answer questions from the analyst. View reports visually with the over 100 supported graphs and charts. Place several reports on a single view for an executive level dashboard. Support users on the go with the automated report distribution and mobile computing support.
DB2 Web Query accesses data in DB2 for i through a native adapter, allowing it to take full advantage of the sophisticated query optimization technology that IBM has been investing in for over a decade. Build reports seamlessly from local or remote DB2 for i databases, or even Microsoft SQLServer databases with the optional SQLServer adapter.
Key to any true BI tool is a meta data layer that shields report authors and end users from the complexities of the back end database while providing consistency of data definitions across the enterprise, eliminating ambiguity and distrust of the data in reports. The meta data layer positions DB2 Web query as way more than just a graphical reporting tool by extending the number of personnel that are capable of building reports and eliminating the dependency on that one person who is the database expert!
Bundled software: DB2 Web Query Editions
DB2 Web Query Editions are simple to order bundles of software, that provide a foundation for core DB2 Web Query functions for either getting started (Express) or rolling out the business intelligence application across your enterprise.
DB2 Web Query Express Edition provides an entry level software bundle that includes report authoring tools, Query/400 import function, and analytic reporting options for a small number of users. With the Express Edition you can generate high quality PDF reports for external consumption, or provide OLAP reports for analysts interested in understanding trends or finding exceptions in the data to uncover what’s driving results. In addition, you can leverage the spreadsheet pivot table support and ability to integrate ad-hoc reporting directly into Microsoft Excel spreadsheets. For those with smartphones who need to analyze data while on the road, the Active Technologies provide analytics for the users disconnected from the server.
DB2 Web Query Standard Edition combines all of the Express features plus more, providing a robust offering that can support up to thousands of users. With Standard Edition, ample user licenses are included to support a typical roll out of developers and administrators, report authors, and a virtually unlimited number of run-time users and report consumers.
With Standard Edition, you can build more sophisticated dashboards for executives monitoring key performance indicators. Use Standard Edition to create an enterprise report distribution model with abilities to schedule report execution and distribution through e-mail or save the reports for later viewing.
Optionally leverage the data adapter for Microsoft SQLServer included in Standard Edition to be able to build reports including data from any of those databases in your network.
The facilities required to execute DB2 Web Query functions from a customized application is also included in Standard Edition. Many clients will value the ability to create a URL interface to execute parameterized reports and surface that URL in an existing or new web-based application, thereby integrating the reporting functions into line of business applications.
Software solution: DB2 Web Query DataMigrator ETL Extension
DB2 Web Query DataMigrator ETL Extension (i.e. DataMigrator) provides extract, transformation, and load (ETL) capabilities integrated with DB2 Web Query and DB2 for i.
Users looking to isolate their query workloads from production environments, or needing to automate the consolidation of data from a variety of data sources will be interested in this solution.
DataMigrator allows you to automate the process of extracting data from any DB2 Web Query supported source database, the process of transforming or cleansing the data and loading the data into an optimized DB2 for i reporting repository. Depending on the design and use of that repository, the industry refers to this as an operational data store, data mart, or data warehouse.
While leveraging the same graphical look and feel of DB2 Web Query, there are also integration points with DB2 Web Query. For instance, synchronize meta data defined either in DataMigrator or DB2 Web Query.
Defining the ETL process is done through the creation of a data flow. A data flow defines where the data comes from, how it should be transformed, and into what files the resulting data should be loaded. After it is defined, a data flow can be run immediately or scheduled to run once or on a recurring basis. Multiple data flows can optionally be controlled by one or more process flows, which orchestrate when and how the data flows run.