SEQUEL

Business Intelligence Software for the System i

Whether you want to present System i information at a PC, in an executive dashboard, over the Web, or using traditional host-based query and reporting, SEQUEL business intelligence software delivers the System i information you need in more ways than you can imagine.

Thousands of sites around the world rely on SEQUEL business intelligence software to "unlock" the information in their System i databases. Companies of all sizes use SEQUEL, from large international corporations to small organizations with just a few employees. It’s used in virtually all industries, including finance, manufacturing, transportation, insurance, agriculture, health care, government, media, education, as well as by non-profit organizations. Each different industry finds that SEQUEL delivers the System i information they need easily, efficiently, and quickly. SEQUEL goes far beyond the capabilities of other query products. It's not just another query and reporting tool; it’s a solution you can count on to meet all your System i data access and analysis needs.

---

SEQUEL Functions - Overview

From simple ad hoc queries to executive dashboards to providing information on the Web, SEQUEL delivers System i data in the format that works best for you. Without exception, SEQUEL is the fastest and easiest way to access your System i data.

Query and Reporting

• SEQUEL views and reports complete in a fraction of the time it takes with other query tools available on the System i.
  
  
• SEQUEL ViewPoint provides a Windows-based, graphical interface that helps both technical and non-technical users design views quickly.
  
  
• SEQUEL Tabling automatically summarizes data by categories, similar to a pivot table. Tabling completes in seconds what normally might require multiple queries or programs to accomplish.
  
  
• The ViewPoint Report Writer helps you design reports quickly using Wizards and drag-and-drop functions on a graphical report design layout.
  
  
• The Client Reporting Option lets you design reports containing formatted text and graphics for PC printer output.

End User Access

• Shortcuts let you display, e-mail, graph, or download the latest information simply by clicking a desktop icon.
  
  
• Run-time prompting lets you run a standard view with different selection parameters.
  
  
• ViewPoint's graphical, drag-and-drop design interface makes ad hoc requests a snap.
  
  
• AutoJoin and Templates help you create views easily. Predefine JOIN criteria, calculations, date field conversion, and meaningful field names so anyone can create views on their own, without assistance from IT.

Data Distribution on the Web, Network or by E-mail

• Run secure interactive requests on the Web (or display spooled files) with the SEQUEL Web Interface. i5/OS security restricts general access, and SEQUEL record-level security restricts specific subsets of data to certain users.
  
  
• Distribute output in many different formats to servers or e-mail recipients. SEQUEL converts System i data into most popular file formats, including HTML, PDF, Excel, and other PC formats, or spooled files.
  
  
• Send broadcast e-mails, such as invoices, statements or marketing announcements, with unique messages for each recipient.

Business Analytics

• Summarize, cleanse, and reformat data for OLAP 'cubes' without extensive programming.
  
  
• Dynamic drill-down lets you explore data from a high-level summary to detailed information.

Programmer Productivity

• SEQUEL’s extensive character and numeric operations let you transform DB2 data to almost any conceivable format.
  
  
• UPDATE, DELETE, INSERT, and EXECUTE functions let you cleanse and reformat DB2 data without having to write a program.