Flexible, simple, modern data access tool
Simplified 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. With its intuitive query builder tool, users can create custom queries without writing complex SQL, enabling faster insights and reduced reliance on IT support.
Enterprise Dashboards and Reporting
Create and deliver dynamic dashboards and interactive reports using the Sequel Business Intelligence graphical interface. Display key metrics using charts, graphs, and gauges for easy consumption and real-time business intelligence. Reports can be scheduled and automatically distributed via email in Microsoft Excel or PDF format.
Business Application Integration
Connect directly to data within IBM i all your applications such as HarrisData, MEDHOST, TMW, Island Pacific, and custom-developed systems. Business users can quickly extract, analyze, and format data within Microsoft Excel, enabling them to work in a familiar environment while reducing manual data entry and improving productivity. With Sequel, your critical business data is just a few clicks away from being turned into actionable spreadsheets.
Modernize Your BI Strategy
Still relying on Query/400 or discontinued tools like DB2 Web Query for i? These legacy solutions limit your ability to access, analyze, and visualize data efficiently. Sequel provides a modern, scalable alternative—with tools to easily convert existing queries and reports. Gain advanced Microsoft Excel integration, enhanced performance, and the flexibility to scale your analytics across your organization.
Already a Sequel Customer? Check Out Our How-To Videos
Check out our library of short videos that demonstrate helpful tips on how to use the Sequel Data Access business intelligence software from Fortra. Simply scroll through the video library or perform a keyword search on the page to find your interest area. We also have plenty of live training sessions available for users of all experience levels.
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. Watch this short video for an overview of Sequel’s different deployment options.
Sequel Web Interface
Runtime Prompts
Microsoft Excel Plug-In
Dashboards
Scheduling Automation
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
Watch this webinar to learn more about Sequel's easy integration with Excel.
Key Data Access Features
System Requirements: IBM i 7.2 or higher
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. Learn more >
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. Learn more >
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. Learn more >
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. Learn more >
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. Learn more >
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. Learn more >
Sequel Data Access Application Integrations
Many organizations need to pull data from multiple business applications across multiple platforms every day. Without the right tools, querying these applications for the right information can be challenging and time-consuming.
Sequel integrates with business applications running on your IBM i and across platforms without the need for expensive customization. Use Sequel with enterprise resource planning (ERP) applications like HarrisData or transportation management software like TMW for quick, easy data access and analysis.
Sequel Data Access also integrates with other Fortra products such as Robot Schedule, Powertech Database Monitor for IBM i, and GoAnyware MFT so that customers can leverage their Fortra toolbox seamlessly.
Get Started
We’ll show you how data access software like Sequel makes it possible for you, your business users, and your executives to quickly, securely access important data—making business intelligence easier than ever.