Data Warehousing and Multimedia Information
Ensure That Your Implementations Are Unique
Ten Questions to Consider When You’re Selecting User Tools

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 (IBM)

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

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

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

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

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
The Relationship between Dashboards, Scorecards, and Other Parts of Business Intelligence
Data Extraction, Movement, and Loading for Data Warehouse Deluxe
Tips for Data Warehousing Consultants
Do You Need Data Warehousing Consultants?
How to Catalogue Existing Extract Files
Advertisement

Inside Dummies.com