Resources
Article

How to Quickly and Dynamically Summarize Your Data with Client Tables

Mon, 06/27/2016
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...
IBM i Business Intelligence
Article

Getting the Most Out of DB2

By Heath Kath on Mon, 06/27/2016
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...
IBM i Business Intelligence
Article

HANDS OFF! Saying Goodbye to Manual Data Access

Mon, 06/27/2016
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...
IBM i Business Intelligence
Article

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

Mon, 06/27/2016
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 ...
IBM i Business Intelligence
Article

The IBM i Partitioning Paradox: Defined

Mon, 06/27/2016
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.
IBM i Business Intelligence
Article

SECURITY DASHBOARDS: How IT Can Use Data to Lower Risk

Mon, 06/27/2016
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...
IBM i Business Intelligence
Article

Discover Automate's New Capabilities for Office 365

Wed, 08/03/2011
With the eagerly anticipated release of Microsoft’s cloud-based service, Office 365, on June 28, Network Automation immediately set to work on ensuring the current Microsoft Office automation facilities in Automate were enhanced to provide its customers with equivalent automation capabilities.
Automation
Article

AutoMate Bridges the Gap Between Disparate Applications

Tue, 03/08/2011
Automate from Fortra provides application security, streamlined communication including sending emails and text messages to IT regarding successful or failed tasks, error handling, and flexibility and versatility via its highly coveted development interface (no programming or scripting needed).
Automation
Article

mySQL and the SQL Query Action

Mon, 11/20/2006
Automate can easily interact with a mySQL server and its associated databases through the SQL Query and SQL Stored Procedure actions. The document explains how to setup a mySQL data source connection through Automate that can be used to run queries against a mySQL database.
Automation
Article

Debugging Tasks

Fri, 05/05/2006
We'll explore some of the techniques you can use to debug tasks in the Automate Task Builder. Several features available in Automate 6.1 can help make this an easier process.
Automation