SEQUEL
Business Intelligence for the System i
Whether you want to present System i information at
a PC workstation, in a graphical executive dashboard, over the Web,
or with more traditional host-based query and reporting capabilities, SEQUEL can deliver System i information almost any way you can imagine.
Thousands of sites around the world are using SEQUEL to "unlock"
information held in their System i databases. SEQUEL is used everywhere
from Fortune 100 companies to small organizations with just a few
employees. It's used across all industries: Finance, Manufacturing,
Transportation, Insurance, Agriculture, Health Care, Government,
Media, Education as well as Non-profit organizations. All these
sites have found that SEQUEL delivers information with the utmost
in performance and ease of use. SEQUEL goes far beyond the capabilities
of IBM's Query/400, SQL/400 or other products. It's not just another
query and reporting product, but a tool you can rely on to accomplish
all of your System i data access requirements.
SEQUEL Functions - Overview
From simple ad-hoc queries to executive dashboards to providing
information on the Web, SEQUEL can format and deliver System i data
almost any way imaginable. Without exception, SEQUEL is the quickest
and easiest way to access and present data on the System i!
Query and Reporting
- SEQUEL views and reports can be completed in a fraction
of the time of any other approach 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,
just like a pivot table. Tabling completes in seconds what normally
requires multiple queries or programs to accomplish.
- The ViewPoint Report Writer lets 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 users display, e-mail, graph, or download the
latest information by simply clicking a desktop icon.
- Run-time prompting lets users 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 let end users create views easily. JOIN
criteria, calculations, date field conversion and meaningful
field names may all be predefined so users can create views on
their own.
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. Output may be created as HTML, PDF, Excel or other
PC formats or as spooled files.
- Send broadcast e-mails with unique messages for each recipient,
such as invoices, statements or marketing announcements.
Business Analytics
- SEQUEL can summarize, cleanse and reformat data for OLAP 'cubes'
without extensive programming.
- SEQUEL drill-down capability lets users explore from 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.
6533 Flying Cloud Drive, 