Article
Introducing Sequel Script Views
Fri, 01/20/2017
New to Sequel Script Views? Learn the basics!
Article
How-To: Convert Queries from Query/400
By Heath Kath on Thu, 01/19/2017
Follow this step-by-step guide to get started converting queries from Query/400 to Sequel.
Article
Enhance Your Reporting with Sequel Date Functions
By Heath Kath on Fri, 01/06/2017
Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
Article
Anydate: Go Back to the Future
Fri, 01/06/2017
Take time into your own hands. Discover the benefits of testing future dates, rerunning past reports, and more with date simulation software.
Article
How-To: Analyze Year-End Data Quickly with Flexible Client Tables
By Heath Kath on Thu, 12/01/2016
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
Dashboards: How to Make the Most of Your Data
By Mike Stegeman on Thu, 11/17/2016
Data is evolving. Can your organization make sense of it? Find out how dashboards will help.
Article
Dirty Data: One of the Largest Hidden Costs of Doing Business
By Alan Jordan on Fri, 09/16/2016
Poor data quality is more common than you think—and the consequences can be devastating. By implementing SEQUEL Data Warehouse, you can solve your data problems, improve your data quality, and avoid a data disaster.
Article
How-To: Format, Visualize, and Deliver Data in Dashboards Quickly and Easily
Fri, 09/16/2016
Looking for quick tips for building Sequel dashboards? Look no further. Read the how-to for best practices on formatting, visualizing, and delivering data.
Article
Increase Productivity with Sequel View Builder
By Mike Stegeman on Thu, 08/25/2016
Business success hinges on sharing relevant information with the people who need it. When members of your organization can make informed decisions, productivity increases and problems can be solved more creatively.
With Sequel Data Access, more business users within your organization can see these benefits on an even greater scale.
Not using Sequel yet? Learn more >
Using Sequel? Keep...
Article
Database 101: Why You Can Rely on IBM i
Fri, 08/19/2016
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
Fri, 08/19/2016
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
Top 10 Ways Sequel Makes Your Life Easier
Fri, 08/19/2016
Text
No matter what industry you’re in, accessing and presenting your data is incredibly important. Your business users’ ability to make informed decisions shouldn’t be limited by your data access tool or their...
Article
Add Power to SEQUEL Scripts with Logic
Mon, 08/01/2016
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
Mon, 06/27/2016
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
Mon, 06/27/2016
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
By Heath Kath on Mon, 06/27/2016
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...
Article
Sequel Tips and Tricks: Enhance Your IBM i Queries
By Mike Stegeman on Mon, 06/27/2016
Get more out of your IBM i queries (and help your users help themselves).