Help/Systems SEQUEL Software PowerTech Skybot Software ShowCase Bytware CCSS InterMapper Safestone AutoMate

True Data Empowerment

SEQUEL

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, email, 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 Email

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 email recipients. SEQUEL converts System i data into HTML, PDF, Excel, and other PC formats, or spooled files.
  • Send broadcast emails, such as invoices, statements or marketing announcements, with unique messages for each recipient.

Business Analytics

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.

Programmer Productivity

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.

See the "Discover the Power of SEQUEL" and "Solve 9 Common Business Problems with SEQUEL" On-Demand Webinars.

User Access

SEQUEL is designed for all levels of users—executives and other non-technical users just click a desktop icon to display, email, or download SEQUEL results from the System i. For complete flexibility, SEQUEL offers a number of ways to access information.

View Design

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.

Tabling

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.

Reporting

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.

Drill-Down

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.

Dashboards

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.

Special Functions

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.

Multi-Platform Support

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.

Security

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 email 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.

ESEND

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 email or FTP SEQUEL view results in a variety of PC file formats. ESEND offers a wide range of email 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.

Robot/SCHEDULE

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 HelpSystems. 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.

Need Help?

Talk to Us
In the U.S. and Canada, call 1-800-328-1000 and ask for Sales.
Elsewhere in the world, contact your local international office.