Sequel Data Access

Enterprise Data Access Software for IBM i

Easy Data Access for All

Empower IT, business users, and decision makers with easy access to data from Db2 for i and remote databases like Microsoft SQL Server, Oracle, and others using the query builder tool in Sequel Viewpoint.

Enterprise Dashboards and Reporting

Design and present actionable data visually using the Sequel Viewpoint GUI or secure, mobile-friendly dashboards. Graphs and gauges make data easy to digest for better business intelligence. Automated reports keep it relevant without overtaxing IT.

Business Application Integration

Incorporate data from any IBM i applications business users access every day, like HarrisData, MEDHOST, TMW, Island Pacific, and in-house applications. Make it easy for them to work with their data by exporting to Microsoft Excel.

Easily Replace Outdated BI Tools

Using an outdated business intelligence solution like Query/400 or an unsupported product like DB2 Web Query for i can put limitations on your data.

Flexible Deployment Options with Minimal IT Involvement

Sequel offers a variety of ways to deploy objects to suit the needs of different teams. Finance can export spreadsheets to Excel, execs can create dashboards, and operations can get a report emailed to them every morning – all without the need for IT to spend hours writing customized programs.

Looking for Easy Integration with Excel?

Business users love Microsoft Excel, and Sequel makes it easy to access, analyze, and deliver data in Excel. With Sequel, you can:

• Use Excel as a data source
• Access data in Excel with the Viewpoint Excel Add-In
• View data results on demand directly in Excel
• Automate the delivery of data results in Excel via a scheduled job
• Download to Excel from almost every panel in Sequel Data Access

Key Data Access Features

Three intuitive interfaces

Access your data the way you prefer. Create queries using the green screen, point-and-click GUI (Sequel Viewpoint), or an intuitive browser interface (Sequel Web Interface)—from anywhere. Alternately, access views directly in Microsoft Excel.

Remote database access

Get the whole story by pulling data from different sources. With Sequel, you’re not limited to only data from your central Power Systems servers. Get real-time data access to remote, multi-platform databases (DB2, SQL, etc.).

Modern data analytics

Executive dashboards and modern reporting options turn data into useful information for decision makers and business users. Drill-down lets business users analyze data more effectively by moving from summary information to detailed data in just a few clicks.

Easy drill-down

Dig deeper into your data to find the answers you need. Dynamic drill-down allows you to quickly analyze database information with a single summarized view and choose your own path to drill deeper, while application drill-down offers you control over the paths users take to drill into the data.

Executive dashboards and custom reporting

Visually display key performance indicators in executive dashboards for at-a-glance performance assessment. Use the Sequel Report Writer Design Wizard to create sophisticated custom reports that can easily be printed or shared across your organization.

Easy query (view) creation

If you dread query creation, Sequel can brighten your dreary query attitude. Access data from the IBM i with Sequel queries, called views. Gather data, perform operations, and drill down for further insights directly into your views.

Customizable pivot and client tables

Make connections and spot trends in your data. Pivot tables help you manipulate data to show the full picture. Client tables allow you to dynamically pivot for drill-down, reporting, and analysis. Customizable, user-friendly, and easy to share, Sequel tables help you make business decisions more quickly.

Mobile data access

Take IBM i data access into the mobile world. Access your data and dashboards directly from a web browser on your laptop, tablet, or smartphone. It’s easy to view, print, drill down, and more—when and where you need it.