Sequel - Business Intelligence for your IBM 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. 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 IBM System i.

Query and Reporting
  • Views & reports can be completed in a fraction of the time of any other approach available on the System i.
  • ViewPoint provides a Windows-based, graphical interface that helps both technical and non-technical users design views quickly.
  • 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 via Web, Network or Email
  • 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 FYI offers pivot tables, drill-anywhere and executive dashboards and can be deployed in a fraction of the time and cost associated with other business analytics solutions.
  • Summarize, cleanse and reformat data for OLAP 'cubes' without extensive programming.
  • Drill-down capability lets users explore from high-level summary to detailed information.

Programmer Productivity

  • 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.
  • The Abstract solution provides an integrated set of cross-referencing, documentation, and programming tools for the System i.

Send for further information, a free evaluation or onsite demonstration now!


Executive Dashboards display mouse driven business metrics


Drill-down options let you link SEQUEL views or link to other Windows- or Web-based applications.


Downloading System i data into PC-file formats is a snap!


New SEQUEL views are easy to create using the Design View interface.

 No time? Just CONTACT US and we will answer your requirement!