Resources

Article

How Mobile Data Access Improves Business Operations

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

SEQUEL Users Go Mobile

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

How to Quickly and Dynamically Summarize Your Data with Client Tables

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

Robot Best Practices

Wondering about best practices for automating your IBM i processes with Robot systems management solutions? Take a look at this list and get off to a good start.
Article

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

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

The IBM i Partitioning Paradox: Defined

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

Tips and Advice for Going Paperless in the Office

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

Have You Met SAM?

Isn’t it time your job scheduling environment (and your IBM i) got the modern look it deserves? Give Schedule Activity Monitor a try for graphically monitoring your jobs on the go.
Article

Interfaces with Robot Schedule

If you’re using EnterpriseOne or SAP, it may be to take a closer look at the security and business process automation that Robot Schedule can offer these key applications on IBM i. We don’t talk enough about the integration we’ve done between Robot Schedule and EnterpriseOne (formerly JD Edwards, now owned by Oracle) and SAP.
Case Study

Fortra Meets IT Security Needs for Napa Recycling and Waste Services

Napa Recycling and Waste Services (NRWS) provides recycling and waste collection to businesses and residents in the City of Napa and southern unincorporated Napa County. The entire county, with 90 percent of its agricultural land devoted to viticulture, is home to more than three hundred wineries in the Napa Valley, and is one of the top wine producing areas of the United States. In addition, the...