W19AA: Automating Db2 for i Data Distribution/Replication

W19AA: Automating Db2 for i Data Distribution/Replication

Automating Db2 for i Data Distribution/Replication with IBM's DataMigrator ETL

Speaker: Doug Mack
Price: Free courtesy of Information Builders
August 15, 2019 at 11:00 AM CDT

Moving or consolidating data in a multiple IBM i server environment, or an environment involving different databases and server platforms, can be complex and expensive. Even consolidating data from multiple libraries on a single server can be challenging. Building one-off customized data extracts can consume an I/T shop’s programming staff. In this session you’ll learn about how to leverage an Extract, Transformation and Load (ETL) tool to automate moving and transforming data involving Db2 for i databases. DataMigrator is a little known tool to do: near real time data replication, consolidate data from multiple (heterogeneous) databases into an enterprise data repository, or even migrate data from non-Db2 databases into Db2 for i. IBM’s DataMigrator is an IBM i integrated, SQL based, ETL tool that simplifies not only data movement, but complex data transformations as well.

About the Speaker

Doug Mack is a DB2 for i Analytics Consultant in IBM’s Systems Lab Services organization. Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design, skills transfer, and implementation guidance services worldwide.

8/15/2019 11:00 AM - 12:00 PM
Registration is closed.
My registration status: Not registered

Sign In