Building work files, temp files, and extracts can be unproductive, add extraneous processing, and creates too many copies of (unsecure?) data. In this session we will talk about simplifying and automating processes to eliminate custom extract programs. We'll cover tools like DataMigrator, why the data warehouse might make sense, and streamlining creation of PDFs or Excel files outputs w/o having to reverse engineer spool files.
Learning Objectives:
- Learn about simplifying and automating data transformations and replication.
- Understand how Db2 Web Query can eliminate many extra steps currently in place to get data into a spreadsheet or visualization tool.
- Learn about an IBM i based ETL tool that you probably haven't heard of.