- System i Data Analysis
- Creating Queries
- Writing Reports
- Business Intelligence Tool
- Summarize Your Data
- Access Data Using a Browser
- Program, File, and Field Cross-Referencing
- Convert and Distribute Spooled Files
- Enterprise Data Analysis
- Customer Case Studies
- Blumenthal Print Works, Inc.
- Civil Service Employees Insurance Group
- Foodservice Resources and Solutions (FRS)
- Fremont Insurance Company
- Lansing School District
- Leonard's Express
- National Farmers Insurance
- Robbins Sports Surfaces
- Security Mutual Life Insurance Company
- Southwestern Motor Transport
- Stewart & Stevenson
- The Hammock Source
- Tony’s Fine Foods
- Live and On-Demand Webinars
- About Us
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.
SEQUEL helps you bring data to the desktop quickly.
Query and Reporting
SEQUEL views and reports complete in a fraction of the time of other query
tools available on the System i.
- SEQUEL ViewPoint provides a Windows-based, graphical interface that helps any user design views quickly.
- SEQUEL Tabling automatically summarizes data by categories, similar to a pivot table, to complete in seconds what could require multiple queries or programs.
- 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
SEQUEL users can access data, quickly and easily.
- Shortcuts display, e-mail, graph, or download the latest information.
- Run-time prompting lets users run a standard view using different selection parameters.
- SEQUEL ViewPoint's graphical, drag-and-drop design interface makes ad hoc requests a snap.
- Predefine JOIN criteria, calculations, date field conversion, and meaningful field names so anyone can create views.
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. The power of i5/OS security restricts general access, while SEQUEL record-level security restricts specific subsets of data to certain users.
- Distribute output in different formats to servers or e-mail recipients. SEQUEL converts System i data into 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.
Summarize, "cleanse", and reformat data for OnLine Analytical Processing (OLAP) "cubes" without extensive programming. Use dynamic drill-down to explore data from a high-level summary to detailed information.
SEQUEL’s extensive character and numeric operations let you transform DB2 data to almost any conceivable format. Its UPDATE, DELETE, INSERT, and EXECUTE functions let you "cleanse" and reformat DB2 data without having to write a program.
SEQUEL is designed for all levels of users—executives and other non-technical users just click a desktop icon to display, e-mail, or download SEQUEL results from the System i. For complete flexibility, SEQUEL offers a number of ways to access information.
A SEQUEL query is referred to as a view and it contains all of the selection criteria you need to access your System i data. SEQUEL makes it easy to design views using simple point-and-click operations. You can create ad hoc queries any time you need information from your System i database.
SEQUEL provides two table options—Host Tables and Client Tables—that you can use to summarize transaction data into spreadsheet-like tables. With SEQUEL’s tabling options, you can easily summarize the data you send to the desktop.
SEQUEL offers complete report flexibility to create graphical reports for System i printer output and PC printer output using System i data. You can create sophisticated reports in a fraction of the time normally required.
SEQUEL offers a number of different drill-down approaches to let you explore both System i data and the information contained in other applications or platforms, including dynamic drill-down that lets you analyze your System i database in ways you never thought possible.
SEQUEL dashboards provide a visual display of the information you use to make your business decisions. Everyone—from executives, to non-technical management, to end users—can create their own dashboards to display key performance indicators.
SEQUEL provides a number of timesaving functions that help you accomplish tasks that used to take multiple query steps, or couldn’t be done without a special program. You can use your System i data as useful business intelligence information—quickly and easily.
SEQUEL supports real-time data access for remote, multi-platform databases. This gives you unprecedented data analysis functions for DB2, Microsoft SQL Server, ORACLE, MySQL, and others. SEQUEL’s easy-to-use interface makes powerful capabilities, like drill down data analysis, reporting, and executive dashboards available for cross-platform use. You can even drill-down from the data results on one platform to the results on another.
SEQUEL makes it easy everyone to access information on the System i. But, SEQUEL also gives you full control of what information is made available and to whom. You can control and monitor SEQUEL activity using i5/OS Security, Record-Level Security, the Exclusion/Inclusion Dictionary, and Usage History and Auditing.
SEQUEL Web Interface
The SEQUEL Web Interface provides fast, secure Web access to your System i data.
You can combine the power of SEQUEL and the SEQUEL Web Interface to develop comprehensive, browser-based business intelligence systems. Start with simple queries and then add run-time prompts, drill-down hyperlinks, and graphics. You can even reformat your DB2 data as Extensible Markup Language (XML) and Extensible Stylesheet Language (XSL) output to incorporate advanced formatting in your results. When you use the SEQUEL Web Interface with SEQUEL or ESEND, you can even distribute spooled files by e-mail directly from your browser.
The SEQUEL Web Interface is a great way to provide better access to information anywhere without the time, effort, and expense of other solutions.
When you team ESEND with SEQUEL, you can send your SEQUEL view results to users anywhere. The SEQUEL output commands work with ESEND so that you can e-mail or FTP SEQUEL view results in a variety of PC file formats. ESEND offers a wide range of e-mail distribution options for reports and files, spooled file archival, and output queue forwarding capabilities for the System i, at a fraction of the cost of competitive solution.
When you want to automate your SEQUEL jobs on the System i, you won’t find a better solution than Robot/SCHEDULE, the job scheduler and batch management system, from Help/Systems. SEQUEL’s easy-to-use interface to Robot/SCHEDULE allows you to access Robot/SCHEDULE job settings and submit SEQUEL output as batch jobs.
With Robot/SCHEDULE, you can schedule tasks on multiple PCs and servers, making sure your SEQUEL data is available whenever and wherever it’s needed. Robot/SCHEDULE offers exception scheduling, cross-system reactive jobs, fiscal calendars, complete job schedule automation, and countless other scheduling features that work together to handle your SEQUEL processing needs.