Resources

Case Study

Financial Group Streamlines Loan Origination with Robotic Process Automation

Aldergrove Financial Group is a community-based credit union in Frazier Valley, British Columbia that provides personal and business banking solutions to its 20,000 members. Formed in 1954 under the original name of Otter Farmers’ Institute Credit Union, Aldergrove has since merged with the Matsqui Credit Union and expanded to five branches. Aldergrove is committed to providing personal,...
Automation
Case Study

Automate Eliminates Custom Visual Basic Code for InfraSource

InfraSource Services is a fully integrated company providing construction services in gas and electric transmission, gas and electric distribution, telecommunications, and water and wastewater systems. The organization consists of several distinct operating companies strategically located throughout the United States. InfraSource is a single source provider of infrastructure construction services....
Automation
Case Study

Automating Crystal Reports with Automate Saves 20 Hours per Week for Appliance Distributor

For wholesale appliance distributor Echelon Home Products, generating and distributing reports for four different business divisions used to require at least 20 hours of weekly Crystal Reports work as well as wreak havoc among employees every Monday because of an all-day report-related network slowdown. That changed in 2008 when Echelon plugged into Automate, the robotic process automation (RPA)...
Automation
Case Study

Pacific Toxicology Laboratories Saves Time with Automate

Pacific Toxicology Laboratories (PacTox), located in Chatsworth, California, is a privately owned company that performs five distinct lab functions under one roof—drug testing, biological monitoring, medical surveillance, therapeutic drug monitoring, and forensic toxicology. PacTox's competitive advantage is its unique ability to provide integrated biological testing services. Clients include...
Automation
Article

Use Conditional Logic in Sequel Data Access to Convert Data into Meaningful Information

By Mike Stegeman on Thu, 03/30/2017
Let’s face it, the amount of data that we have is only continuing to grow, which will become harder to manage and understand. Per IDC Research, 90 percent of data in the world today was created in the last two years, and in 2016, we entered the zettabyte era. A huge challenge for everyone is finding the best way to convert all their data into meaningful information. But that can be tricky.  If...
IBM i Business Intelligence
Code-free Database Automation
Article

Code-Free Database Automation

Tue, 03/28/2017
Watch the recorded webinar to learn how to automate tedious database interaction tasks like data entry, reading incoming data files, and more.
Automation
Article

Enhance Your Reporting with Sequel Date Functions

By Heath Kath on Fri, 01/06/2017
Sequel makes it easy to work with your date fields, from converting the numeric or character field into a true date data type field to performing date calculations. Continue reading to learn how to convert non-date data type fields.
IBM i Business Intelligence
Article

How-To: Analyze Year-End Data Quickly with Flexible Client Tables

By Heath Kath on Thu, 12/01/2016
Year-end reporting is coming… Are you ready? Do you know your options? Are you prepared to collect all of the data you need to see how your company fared for the year? You’re in luck, because Sequel Client Tables make year-end reporting a breeze. Drill down into the level of information you need for your reports. Compare data across multiple years to spot trends and add context. And highlight...
IBM i Business Intelligence
Article

Database 101: Why You Can Rely on IBM i

Fri, 08/19/2016
IBM i is the perfect environment for data access and reporting. Read this article to learn how you can better utilize your Power Systems databases.
IBM i Business Intelligence
Article

How Banks Leverage Big Data for Big Value

Fri, 08/19/2016
Technology professionals in the banking industry face a wide range of concerns due to the nature of the data stored within their systems. The potential reward in stealing or compromising financial data makes these organizations a prime target for cybercrime, while stringent industry regulations require security to be extremely tight at all times. Is it possible to strike a balance between defensive, regulatory, and data access needs and still provide access to data for analytics without compromising the security of the entire system? The truth is that many organizations in the financial sector have deployed analytics technology while being able to keep their security tight, and are benefiting from it.
IBM i Business Intelligence