The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Wednesday, April 26 • 4:00pm - 5:00pm
373: RPG and External Database Integration

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Chances are that your organization may have the need for RPG applications to share and exchange data with databases other than DB2. Maybe your order management or ecommerce system is on a web server running SQL Server, PostgreSQL or MySQL/MariaDB. Or maybe you need to create SQLite files to expose data to a mobile application.

In today’s world you may be replicating data files and uploading and downloading data on a scheduled basis. Wouldn’t it be a better idea to use the data real-time where it lives instead of making multiple copies? Using live data also greatly improves performance when communicating between multiple systems.

This session will provide an introduction to how you can utilize RPG and open-source technology to interact in real-time with other databases. No more syncing or importing/exporting data on a scheduled basis. Use live data where it lives without replication.

Attend this session to learn how to cross the divide and immediately extend you RPG applications into the open database database world. No matter what external database platform you want to talk to, you’ll benefit from this session.

Learning Objectives:
1. Learn the benefits of Integrating external databases with RPG
2. Learn the development pattern for integrating external databases with RPG
3. Adopt and utilize the provided RPG examples right away in your own shop

avatar for Richard Schoen

Richard Schoen

President, Mobigogo LLC
Richard has over 30 years of software development, system integration, document management and process automation experience on all system platforms including IBM i, Windows, Linux and Mac. Richard started RJS Software Systems in 1990 and served as President and CTO until the company... Read More →

Wednesday April 26, 2023 4:00pm - 5:00pm MDT
Governors Square 17
  Programming - RPG
  • Session Level Intermediate
  • Audience Any RPG, CL or Open-Source developer looking to expand their usage of RPG and CL to quickly integrate the ability to take advantage of external databases to use live data where it lives.