Resources

Article

Who Knew You Could Do THAT with SEQUEL Data Warehouse?

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...
Article

Save Time by Modernizing Your Data

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.
Article

Save Changed Views Automatically with SEQUEL Versioning

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.
Article

Staying on IBM i Sounds Like Money in the Bank

As the end of 2013 draws near, many businesses have budgets on their minds. Most companies will run year-end numbers to determine the full scope of their investments, and analyze what sort of changes can be made to cut costs and increase profit margins. As the number crunching begins, it’s time to consider numerous variables, including those that fall under the IT department. Decisions made within...
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

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...
Article

SEQUEL Works with your Growing (BIG) Data

As you collect more information, your relational database files continue to grow and you’re faced with a challenging issue: how to handle all of that information efficiently and accurately, and how to overcome the obstacle of mining and delivering useful information without bogging down the system. Partition files are the solution to BIG DATA on IBM i because of: Improved manageability for...
Article

Separate Signal From Noise in Big Data

You don’t need a reminder of the strain big data will place on your IBM i storage environments in the coming months and years, but server workloads won’t be the only thing expanding. As CIOs navigate the transition from megabytes and gigabytes to terabytes and petabytes, their colleagues' business intelligence plans continue to grow more complex and ambitious as well. In the age of data-driven...
Article

Getting the Most Out of DB2

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...
Article

HANDS OFF! Saying Goodbye to Manual Data Access

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...