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.