IBM Db2 Web Query for i DataMigrator ETL Extension (DataMigrator for i) is a member of the IBM Db2 Web Query product family that provides a simple way to create and manage data flows and process flows. DataMigrator for i uses a graphical user interface (GUI) to help you create and manage data flows and process flows.
This user's guide covers IBM Db2 Web Query for i DataMigrator ETL Extension, also called DataMigrator for i, a member of the IBM Db2 Web Query product family. DataMigrator provides an Extract, Transform, and Load (ETL) solution that runs on IBM i, used to build, populate and maintain database tables from one or more data sources into target tables in another database. It is ordered as product 5733WQM and is packaged and distributed with Db2 Web Query for i product 5733WQX, enabled using option 8 (#5108) of 5733WQX.
The document walks through setup and configuration, including prerequisites, installing the DM license key, restarting Web Query with the ENDWEBQRY and STRWEBQRY commands, creating a workspace and installing and configuring the DMC. It then describes creating a simple data flow, defining synonyms, adding data targets, running and saving flows, a deeper look at data flows with joins, transformations and validation, and finally creating process flows with procedures and conditions. The Data Management Console (DMC) is a Windows application available as part of the Developer Workbench option of Db2 Web Query.
| Product number | 5733WQM |
|---|---|
| Packaging | Option 8 (#5108) of Db2 Web Query for i product 5733WQX |
| Prerequisite | One of the four Editions: Express, Scheduler, RunTime User, or Standard Edition |
| Trial period | 70 days |
| Required edition for non-Db2 databases | Standard Edition |
| Main components | Data Management Console (DMC) and DataMigrator Server |
| DMC platform | Windows application, available with the Developer Workbench option of Db2 Web Query |
| Included adapters | Microsoft SQL Server, Postgres, and MySQL, plus a generic JDBC driver |
| Home Page interface | Port 12331 |
It is the IBM Db2 Web Query for i DataMigrator ETL Extension, which provides an Extract, Transform, and Load (ETL) solution that runs on IBM i and moves data from data sources into target tables.
It can be run without license keys under the normal IBM i Licensed Program Products trial period, which is 70 days.
End and restart Db2 Web Query using the CL commands ENDWEBQRY and STRWEBQRY, then use WRKWEBQRY to wait for the ports to become active.
Every Data Flow is driven by a Process Flow, which controls how the Data Flow runs; explicit Process Flows are useful for running multiple data flows at once.