Five Vendors with Querying and Reporting Products for Data Warehousing
There are several vendors that provide querying and reporting tools you might want to consider using with your data warehouse. Here are five that are worth considering.
Business Objects (SAP)
Business Objects, now an SAP company, provides a suite of products for query and reporting. Specifically, they provide
WebIntelligence: Also known as WebI; a web-based solution for ad-hoc querying, reporting, and analysis
Crystal Reports: Formerly from Seagate Software, a tool for report creation and distribution
Both of these tools operate against the Business Objects semantic layer, known as a Universe, which maps business terms to their technical match within the data warehouse. Allowing for broader user adoption by minimizing the need for technical knowledge of how things are stored and organized within the data warehouse.
Cognos, now an IBM company, provides a suite of products for querying and reporting:
Query Studio: A web-based solution for ad-hoc querying
Report Studio: A web-based tool for report creation, query aggregation, and distribution
Both of these tools operate against the Cognos semantic layer defined within the design tool, known as Framework Manager, that maps business terms to their technical match within the data warehouse. Cognos’s semantic layer allows for broader user adoption by minimizing the need for technical knowledge of how things are stored and organized within the data warehouse.
The older Cognos technology also includes Impromptu, which was a Microsoft Windows–based tool that Query Studio and Report Studio have replaced.
Information Builders produces the Focus family of reporting and querying products, which has its roots in the mainframe Focus system. WebFOCUS enables you to produce an ad-hoc query or managed reporting environment on a broad range of database management systems.
Microsoft provides a suite of data warehousing products, including products for reporting, although they don’t currently provide a competitive query tool. The SQL Server product line incorporates SQL Server Reporting Services (SSRS), which provides a sophisticated server-side reporting tool. Because SSRS is a server-side technology, companies can deploy these reports for visualization purposes within Microsoft Excel and Microsoft SharePoint, as well as other integrated productivity tools.
Oracle has not only built its own tools over the years, but has also acquired Hyperion (which had acquired Brio). Therefore, Oracle has a number of query and reporting tools to assist people in the area of data warehousing:
Oracle Business Intelligence Publisher: A reporting solution for authoring, managing, and delivering highly formatted documents, such as operational reports, electronic funds transfer documents, government PDF forms, shipping labels, checks, and sales and marketing letters
Oracle Business Intelligence Suite, Enterprise Edition Plus: A comprehensive business intelligence platform, formerly Siebel Analytics, which provides querying and reporting functionality across distributed data sources, including data warehouses