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

Automate 7 Task Builder in Depth

Automate 7 Task Builder now supports multiple tasks within one Task Builder instance. While this has the obvious benefit of increasing the ease of use of editing and creating multiple tasks in one place we've taken it a step further and implemented a feature that many have asked for:
Article

How to Automate Backup & Restore Processes in Automate

In this article we will take a look at the importance of backing up Automate data in order to prevent data loss. We will also learn how to go about backing up remote Automate installations, performing automated backups and achieving data recovery in case data loss occurs despite the best of our efforts and precautions.
Article

Windows Azure Automation

Cloud computing, cloud storage, cloud database…we all have heard about the “cloud.” Cloud computing has gained tremendous visibility in recent years. According to research firm, Gartner, “By 2012, 80% of Fortune 1000 enterprises will be using some cloud computing services, 20% of business will own no IT assets.” In addition, small businesses are attracted to the small startup...
Article

Benefits of Web Server Management Console

Just like the desktop version of SMC, the Web SMC is a web-based interface for centralized management and administration, and allows you to graphically manage all elements of the Automate BPA Server including workflows, the Repository, users and agents. You can also access reports and calendars as well as configuring system settings and options.
Article

Using the Dashboard to Drive Your Business Performance

Today’s growing information and communication technology is altering how companies operate and move forward in a global environment. Because of the real-time nature of information being transmitted, organizations need a way to easily track up-to-the minute performance and operational statistics in order to make effective business decisions more rapidly.
Article

Working with Agent Groups in BPA Server

An Agent Group is a distinct Automate BPA Server object that contains one or more Agents within a logical group. They can be used as workflow objects in place of individual Agents to distribute conditions and tasks to multiple machines across an enterprise. The use of Agent Groups can be more convenient in situations where multiple agents need to be selected for automated...
Article

Data Store Migration Utility

Data migration is the process of transferring data from one hardware or software configuration to another. It can be a standard yet crucial element of IT operations, allowing organizations the ability to maintain the integrity of important data while moving forward to face constantly changing technologies. The downside being that data migration is often times consuming and causes major disruptions as a result of downtime or application performance problems.
Article

Automate BPA Server Cross-Platform Automation

Introduction Increasing numbers of businesses require solutions to help unify their disparate computing platforms to better improve productivity. The upcoming BPA Server version 7.1.0.0 upgrade will enable organizations to create these kinds of solutions by including support for direct execution across multi-platforms. This new functionality broadens the spectrum of Automate...
Article

Automate BPA Server Agent Deployment

Automate BPA Server works hand-in-hand with Automate Agents in order to execute workflows and perform tasks across a network environment. The Agent's main purpose is to perform triggering, workflow, and task execution, either locally or on a remote machine.