Resources

Article
Article

How Mobile Data Access Improves Business Operations

Mon, 06/27/2016
It seems nearly everyone in certain parts of the world now has a smartphone, tablet, or both, and these devices aren't just for fun and games. Organizations are putting devices to work in the drive to streamline processes, gain insight into operations, and ensure continuity.
IBM i Business Intelligence
Article
Article

SEQUEL Users Go Mobile

Mon, 06/27/2016
SEQUEL Users Go Mobile Mobile devices (iPad, iPhone, PC Tablets) are now in the hands of over 89% of corporate professionals. Whether companies are buying them for their employees or the employee has decided to invest in one on their own, the fact remains that mobile data access is no longer a luxury; it’s becoming a requirement. The right data access solution for a mobile device allows the user...
IBM i Business Intelligence
Article
Article

How to Quickly and Dynamically Summarize Your Data with Client Tables

Mon, 06/27/2016
A SEQUEL Client Table is an interactive solution for dynamic Desktop Online Analytical Processing (Desktop OLAP or DOLAP) and cube analysis. With a Client Table, it’s possible for you to build client/server views that allow end users to explore, summarize, and pivot large quantities of data quickly from IBM i and other databases. Once a Client Table is displayed, users can perform interactive...
IBM i Business Intelligence
Article
Article

Getting the Most Out of DB2

By Heath Kath on Mon, 06/27/2016
Used the right way, structured query language (SQL) can be an advantage for any organization's operations. Used the wrong way, it can be a headache for IT professionals. A majority of computing operations are dependent on the ability to access information from a database. That's where SQL queries come in. So the efficiency of SQL queries in DB2 can dramatically impact the tasks running on IBM i...
IBM i Business Intelligence
Article
Article

HANDS OFF! Saying Goodbye to Manual Data Access

Mon, 06/27/2016
Organizations today face an ever-expanding volume of information that must be analyzed and delivered to the right people. While the resulting business intelligence offers us insight into processes and customers, many companies still rely on practices and technology that aren’t suited for managing data on a large scale. As a December 2012 Financial Director article highlighted, 60 percent of those...
IBM i Business Intelligence
Article
Article

Working with Variables Part II: Taking SEQUEL Runtime Prompts to the Next Level

Mon, 06/27/2016
In an earlier article , we introduced prompted views as a way to enable end users by allowing them to retrieve data without the need for code. We discussed how this approach meets the needs of users while freeing time that database administrators might otherwise spend running countless similar queries. Finally, we showed you how to configure default values for your prompts and explained how to use...
IBM i Business Intelligence
Article
Article

The IBM i Partitioning Paradox: Defined

Mon, 06/27/2016
Managing big data requires making some big decisions: how to store, query, and report on the constantly increasing stream of data. Although the practice of ‘data at scale’ or table partitioning is popular on IBM i, it creates a partitioning paradox that often adds complications to efficiently querying data.
IBM i Business Intelligence
Article
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

Mon, 06/27/2016
Data security has been a prominent feature in recent technology headlines as the costs associated with data breaches continue to escalate. Business and IT leaders alike have become all too aware of the need to protect valuable information, but questions of how - and to what extent protection is needed- are common sticking points. The rule of least privilege has been a long-held strategy that...
IBM i Business Intelligence
Case Study
Case Study

Tipton Hospital and Sequel: A Great Team

IU Health Tipton Hospital found that the Return On Investment for Sequel was fast. “We’ve really cut down on printing—we cut our report volume in half and that means a nice savings. Sequel has saved us a lot of money. It’s also nice that it’s so easy to put the data into Excel.
IBM i Business Intelligence
Case Study
Case Study

Sequel Helps Stewart & Stevenson Keep Moving Forward

Much like the 24/7 support it provides to customers, Stewart & Stevenson has found around-the-clock service for data access and analysis with Sequel. Sequel helps support continuous operations by reading and converting different types of data.
IBM i Business Intelligence
Case Study
Case Study

Southwestern Motor Transport Relies on Sequel for Fast, Easy Information Analysis

“When we first saw Sequel, we knew we needed it right away and our use has just taken off. We are very excited about what Sequel has given us. We started using Sequel straight out of the box and we were up and running quickly. The time savings have been tremendous and Sequel has opened a whole new window for us.”
IBM i Business Intelligence