Resources

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

Don’t Be Exposed In *PUBLIC!

Security typically operates so that users who are not granted authority have no authority. IBM i security, however, has a unique concept known as *PUBLIC.
Article

Additional ViewPoint Administrator Functions

What does this function do? SEQUEL Field Level Authorization uses an exclusion/inclusion dictionary function that lets administrators provide authorization to libraries, files, and fields. The dictionary, which can be defined as exclusion or inclusion, is an additional filter applied on top of system object security limits. It does not replace system object authority but supplements it. Exclusion...
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

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

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