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.
- learn about simplifying and
automating data transformations
- Understand how Db2 Web
Query can eliminate many extra
steps currently in place to get data
into a spreadsheet or visualization
- Learn about an IBM i based ETL tool that you probably haven’t heard of.