Resources

Article
Article

Who Knew You Could Do THAT with SEQUEL Data Warehouse?

By Alan Jordan on Mon, 06/27/2016
While SEQUEL Data Warehouse is primarily a tool for building and managing data warehouses and data marts (along with the associated ETL), our customers are always finding innovative "off-label" uses. These are some of the common ones we've heard about. It's likely you will find more things to do with SEQUEL Data Warehouse , too. And every additional use you find within your organization increases...
IBM i Business Intelligence
Article
Article

Save Time by Modernizing Your Data

Mon, 06/27/2016
Many Query/400 users spend too much time trying to manage existing queries, from modifying old ones to searching for the right one just to get basic data. SEQUEL can make this process much faster and easier.
IBM i Business Intelligence
Article
Article

Save Changed Views Automatically with SEQUEL Versioning

Mon, 06/27/2016
Have you ever made a change to an IBM i object and then wished you could undo the change like with PC objects? This is a common mistake many business and IBM i professionals encounter on a regular basis, but SEQUEL now gives you a built-in solution.
IBM i Business Intelligence
Article
Article

Is the i Ready for the Three Vs of Big Data?

By Tom Huntington on Mon, 06/27/2016
The three Vs of big data are volume, velocity, and variety, but in order derive value from big data, IT departments need tools to store massive amounts of data (volume) and make sure it is always available for quick analysis (velocity).
Automation
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

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
How to go paperless with an electronic document management solution
Blog
Blog

Tips and Advice for Going Paperless in the Office

Mon, 06/27/2016
The dream of taking your company into a completely paperless world may feel daunting. But there are little things that can assist you in taking that big step toward your paperless goals, all while saving your business money and helping the environment. So where do you start?
Automation
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