December 4 and 5

Don’t miss the Virtual Conference, the best way to keep your knowledge up-to-date without having to leave your office. Better yet, it’s free, so it is training that fits into every budget.

Register and stay tuned for further session announcements.

Session List 

Open Source Applied – Justin Reock, OpenLogic by Perforce

This isn’t your typical case study, this is the reality of open source: One hundred percent of organizations use varying degrees of OSS, yet we still focus on one particular package or layer when it comes to sharing best practices. The reality is, when we get stuck, it’s the configuration and operational interrelationships between packages that matter.

This session takes open source support data across multiple organizations to examine three different scenarios that represent the most common issues we see today (in fact, 80% of the cases we see are due to configuration and package interrelationship issues). Justin Reock covers e-commerce, mobile PaaS, and high performance computing examples to illustrate top problems and solutions for stack selection, infrastructure implementation, and production troubleshooting.

If you use or are planning to use Apache web server, ActiveMQ, CentOS, Docker, Kubernetes, Nginx, OpenSSL, Puppet, or PHP, these stories cover how most organizations use them. Even if you’re not using these specific packages, the information presented here also applies to other technologies.


Stop Over-Crunching Data: Use Powerful SQL Capabilities to Eliminate Use or Work Files and QTEMP – Rob Bestgen, IBM

There are many times where intermediate steps are required to get data into a shape for usage by some other application or consumption by an end user. Creating summary files to address rolling up data into date “buckets.” Un-tangling data to get it into formats that can be consumable by reporting tools. Even “chained” queries where you need to run a query to generate a temp file, then run another one to get to your end goal creates a process that is overly crunching data due to limitations in the tool. Building one-off extracts can be time consuming and can create issues with productivity, performance, and security of data. Overly using QTEAM in an SQL data access world can also be problematic. In this session, we’ll cover tips and techniques of avoiding over crunching of data to meet data preparation or untangling requirements using the power of SQL (Common table expressions, Cross Lateral Join, OLAP Functions, and ETL) to avoid over crunching!


Intro to Well-Designed REST API’s — Stephanie Rabbani, Seiden Group

When should I use an API? What are the benefits of writing APIs?

This talk will cover when to use Web APIs to access your data, as well as some tips on how to write a Web API that is flexible and designed to last.

Using code examples in multiple languages, I will share lessons recently learned from working on a large integration project with Salesforce.


Is Your Code Testable? — Barbara Morris, IBM

Being able to test your code in an automated way gives you more freedom to modify and enhance your code. It also allows you to participate in Dev Ops.

This session discusses some of the ways you can write your code to be more testable, and some strategies for making your existing code more testable.


AI and IBM i — Jesse Gorzinski, IBM

The emerging realm of AI and Machine Learning can bring seemingly-limitless opportunity for your enterprise (and perhaps even mankind). How can you leverage these new technologies from IBM i?This session will provide an overview of what technologies you can be using from your IBM i today. We will cover various AI/ML packages available to run on the system, as well as the cloud-based capability of IBM Watson. After all, IBM i has always been a data-centric platform. Surely, Db2 for i houses mission-critical and intensely valuable data. Coupling AI and ML with this data can bring an unprecedented amount of innovation.


Authority Collection in 7.3 & 7.4: Locking Down Security for Sensitive Data, Files and Objects – Thom Haze, IBM

This presentation will introduce a new capability in the 7.3 release called Authority Collection and also cover the exciting changes in the 7.4 release.  Authority collection is new support designed to assist the security administrator and application provider in locking down object level security.  This support will help ensure that object authority is set to the most secure value while still allowing an application to run successfully.  This presentation is a must see for security administrators and application developers.


What’s New in DB2 – Scott Forstie, IBM

Scott Forstie, the Db2 for i Business Architect will present the enhancements added to Db2 for i and ACS in 4Q/2019. Join this session to learn all about the new features delivered to IBM i 7.3 and 7.4.


Sponsor: How to Modernize Your Query/400 Queries Convert Query/400 to SQL the easy way—with Sequel

IBM i has become a database server for many organizations over the years. But if you’re still using Query/400 (a.k.a. IBM Query for i) to deliver reports, your end users and decision makers are left scratching their heads as they stare at all that data on a green screen.

And nothing screams “outdated, old technology, or legacy” louder than a green screen.

Experienced IBM i pros may love the green screen, but there’s no reason for the rest of the business to see how the sausage gets made. New IT recruits and non-technical users need visual data in dashboards and easy export options, like to Microsoft Excel.

Luckily, Sequel software makes your transition to modern data access and analysis simple. Don’t miss this live webinar with IBM i business intelligence experts. You’ll learn:

  • Top reasons leading organizations are modernizing now
  • Two ways to quickly convert Query/400 to SQL with Sequel
  • Export tips for taking data from DB2 and other databases into Excel

If modernization is on your IT to-do list for 2020, it’s time to dump Query/400 and convert those old queries into SQL with Sequel.