Resources

On-Demand Webinar

Deploy Robot Automation Dashboards with Sequel

Sequel Data Access isn’t just for compiling sales numbers or creating easy-to-read dashboards. It’s perfectly equipped to compile real-time performance indicators using a detailed operations history from your Robot products.  Track results from Robot Schedule, Robot Save, and Robot Console through automated, graphical dashboards, such as: Number of Robot Schedule jobs run, completion statuses,...
On-Demand Webinar

Deliver on Your Big Data with BIG Data Access

Are you finding that you have too much data? Concerned about how accessing your big data could impact your system performance? Wondering if there is a query tool that can access the multi-partition files you’re expanding to? Get the information you need, quickly and accurately. View this free webinar to see how Sequel can access data to help you measure, monitor, and manage your big data easily...
On-Demand Webinar

DB2 for IBM i Performance Tools

Get tips from Kent Milligan, Senior DB2 Consultant at IBM, to help you analyze and tune DB2 for IBM i SQL requests. The ability to identify and resolve performance issues is a critical skill when running reports and queries that use SQL to access DB2 for i. This session helps you start developing your skills and introduces you to the graphical toolset that DB2 for i provides, at no additional...
On-Demand Webinar

Database 101 on IBM i

The IBM i is an extremely complex integrated system, and many users struggle to understand its capabilities. In this on-demand webinar, we show you how to use the features of IBM i and how to use it to access databases.
On-Demand Webinar

Automate Data Capture with Sequel

Many businesses use Sequel to generate electronic reports, dashboards, and other business output they can use to analyze critical business information in real time. Often these data sources contain metrics that are updated on-the-fly, such as shop floor order status information or customer order and shipment data. How nice would it be if you could not only capture real-time data from your Sequel...
On-Demand Webinar

60 Minutes to ROI with SEQUEL

Quick installation, simple setup, and easy data access means you can start pulling reports from your IBM i server within an hour of setup. In this webinar, Senior Data Access Consultant Heath Kath shows you how to see ROI from Sequel immediately.
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
Article

Database 101: Why You Can Rely on IBM i

IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
Article

How Banks Leverage Big Data for Big Value

Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
Article

Add Power to SEQUEL Scripts with Logic

SEQUEL Scripting is a process that allows users to run multiple SEQUEL and system commands together. Scripts allow for much of the same capability of Command Language Programs (CLP) without the need for programming knowledge or a compiling of the objects.
Article

The Partitioning Paradox Solved

There is rarely a dull moment for IBM i administrators, as their operating environments continuously absorb and distribute new data. While this trend certainly keeps teams engaged, it also triggers fears that current protocols may not be enough to meet the challenges of tomorrow. First and foremost, there is often some doubt as to whether storage plans will be able to scale to manage the sheer...
Article

Easily Accessing Data on Remote Databases with SEQUEL

With SEQUEL you can retrieve information not just from your local IBM i, but also on other IBM i’s, SQL servers, Oracle, MySQL, and other remote databases. Once you have the remote host definition defined you are ready to convert data on other platforms into meaningful information right from your local IBM i. The ability to design views with SEQUEL SQL and translate them on the fly to native SQL...
Article

Get Started with Remote Database Access

Many organizations are expanding to use multiple platforms in their IT environments. There are many reasons for this: it can be due to company acquisitions or application vendor platform shifts, or when a department requires a certain software package with features that require a different platform. For example, many Customer Relationship Management (CRM) tools employed by sales teams reside on a...