COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Back To Schedule
Tuesday, October 16 • 5:15pm - 6:15pm
28AD POWER PICK: Stop Building Data Extracts for BI Analytics!

Log in to save this to your schedule, view media, leave feedback and see who's attending!

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

This is Session ID:180273

avatar for Doug Mack

Doug Mack

Consultant LAB Services, 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... Read More →

Tuesday October 16, 2018 5:15pm - 6:15pm EDT
Grand Ballroom 5