Showcase Query for the IBM System i5 (iSeries)

Get the Information You Need—Fast

With ShowCase Query, people in all areas of your organization can access the information they need on their own, so your IT staff can focus on more strategic projects.

ShowCase Query is part of the ShowCase Suite from SPSS, the leading business intelligence solution for companies using the IBM® System i5™ (eServer® iSeries™) computing platform.

ShowCase Query helps users build SQL statements easily and manage queries efficiently. It enables your managers and staff to:

Run both scheduled and ad hoc queries
Streamline the building and execution of SQL statements
View data in ways that help them understand conditions more clearly
Support responsive, informed decision making

To create a complete reporting solution, use ShowCase Query in combination with ShowCase ReportWriter™ to create reports with customized formatting for greater visual impact. Then, to provide secure, central management of queries and reports and browser-based access to reports, enterprise-wide add ShowCase Enterprise Reporting.

The fully integrated ShowCase Warehouse Manager™ helps you protect database security and optimize system resources, as you use the ShowCase Suite.

Automatically Populate Spreadsheet Programs

Spreadsheet programs are a basic management tool, but having your staff re-key data into individual workbooks not only takes time, it’s also likely to lead to errors. ShowCase Query enables users to export data directly to Microsoft® Excel™ or Lotus® 1-2-3®. For greater time savings, you can refresh results each time a workbook is opened while preserving embedded formulas, macros, and formatting by using the ShowCase Query “add-in” features.

Stay in Control with ShowCase Warehouse Manager

Manage queries and other important tasks easily through ShowCase Warehouse Manager. Database administrators can:

Define and manage database security, aliases, and user profiles and privileges
Secure data by user or group of users
Set job priorities to optimize system resources
Monitor system usage for improved performance and optimal data access

Streamline Information Distribution with Enterprise Reporting

With this component of the ShowCase Suite, your organization can create a central, secure, searchable repository for queries and reports. You can store new and existing queries and reports in this repository and share query and report definitions among many users.

Business users can schedule reports or run them as needed. You can automate the scheduling and distribution of routine reports, optimizing both system and staff resources. You can also schedule alerts and notifications, so report “consumers” know when information they need has been updated. Learn more about Enterprise Reporting.

Read more about system requirements for the ShowCase Suite.

To learn more about how you can benefit from the ShowCase Suite, contact an SPSS sales representative.

Contact SPSS Sales

ShowCase® Query™

Get the Information You Need—Fast

Automatically Populate Spreadsheet Programs

Stay in Control with ShowCase Warehouse Manager

Streamline Information Distribution with Enterprise Reporting