Automating DB2 for i Data Distribution/Replication with IBM's DataMigrator ETL - Doug Mack

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.

Doug Mack

DB2 for i Analytics Consultant at IBM

Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States. 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.

Doug is a regular speaker at customer events including COMMON, IBM Technical Conferences and Executive Briefings, and has written many articles and white papers on the attributes of DB2 for i for analytics.

You can follow Doug on Twitter @mckdrmoly or via his blog at db2webqueryi.blogspot.com