IBM i Access Client Solutions for Data Access - Birgitta Hauser & Greg Schmidt

How to extend the SQL power of ACS using Sequel software

The front door into IBM i, IBM i Access Client Solutions (ACS) consolidates many of the most commonly used tasks for managing IBM i into one location. Nearly half of 2021 IBM i Marketplace Survey respondents reported that they relied on ACS to help adapt to the realities of working from home.

But ACS is more than a tool for monitoring your IBM i. It is also central to how you access IBM i data. If you’re one of the many organizations already using ACS or are considering implementing it, you need to make sure you’re running your SQL scripts efficiently and effectively!

Join this live webinar where Birgitta Hauser, world-renowned database expert, joins the business intelligence experts from HelpSystems to share several ACS tips and tricks, including:

How to effectively run SQL scripts in ACS
How to set up preferences for formatting commands and output
How to export SQL statement results to Microsoft Excel
How to use the SQL Content Assist
How to extend the power of ACS using Sequel Data Access software

This session includes live demonstrations of ACS as well as Sequel Data Access software. We’ll also leave time for Q&A with the experts.

Birgitta Hauser

Independent Consultant

Birgitta Hauser graduated with a business economics diploma and started programming on the AS/400 in 1992. She is an experienced RPG programmer as well as a database and software engineer, focusing on IBM i application and database modernization. Today, she is an independent consultant on application and database modernization on IBM i and Db2 for i.

Birgitta also works in education as a trainer for RPG and SQL developers. Since 2002, she has been a frequent speaker at COMMON user groups meetings and other IBM i and Power conferences in Germany, other European countries, the United States, and Canada. In addition, she is co-author of two IBM Redbooks and has also authored several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru, and IBM DeveloperWorks.

She received the John Earl Speaker Scholarship Award in 2015, the Al Barsa Memorial Scholarship Award in 2018, and was named an IBM Champion in 2021.

Greg Schmidt

Senior Technical Solutions Consultant

Fortra

Greg Schmidt is a 20+ year veteran in data, document, forms, and process automation. Specializing in document automation and business intelligence, Greg has helped hundreds of companies automate their data and document processes and streamline their cumbersome business processes through strategic technologies and planning. Providing best-practice guidance forimplementation and solution expansion within a company are his top priorities.

Greg also has over a decade's worth of experience in IBM i report and data distribution and robotic process automation technology.