IBM Db2 Web Query for i DataMigrator ETL Extension User's Guide

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.


IBM Db2 Web Query for i DataMigrator ETL Extension User's Guide - cover page
Brand
IBM
Category
Other software
Document type
User Manual
Language
English
Pages
78
File format
PDF
File size
8.9 MB
Published
30 November, 2023
Updated
30 November, 2023
MD5 checksum
84E0135C34E1B7BC01FF3026588BC303

About this manual

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.

What's inside

  • Introduction
  • Product Description
  • Product Overview
  • Setup
  • Server Configuration
  • Create a Workspace
  • Install and Configure the DMC
  • Verify the QWQCENT library
  • Creating A Simple Data Flow
  • Defining synonyms (Data Sources)

Specifications

Product number5733WQM
PackagingOption 8 (#5108) of Db2 Web Query for i product 5733WQX
PrerequisiteOne of the four Editions: Express, Scheduler, RunTime User, or Standard Edition
Trial period70 days
Required edition for non-Db2 databasesStandard Edition
Main componentsData Management Console (DMC) and DataMigrator Server
DMC platformWindows application, available with the Developer Workbench option of Db2 Web Query
Included adaptersMicrosoft SQL Server, Postgres, and MySQL, plus a generic JDBC driver
Home Page interfacePort 12331

Frequently asked questions

What is DataMigrator for i?

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.

How long can DataMigrator be used without a license key?

It can be run without license keys under the normal IBM i Licensed Program Products trial period, which is 70 days.

How do I restart Db2 Web Query?

End and restart Db2 Web Query using the CL commands ENDWEBQRY and STRWEBQRY, then use WRKWEBQRY to wait for the ports to become active.

What is a Process Flow?

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.

Download PDF (8.9 MB)

More IBM Manuals


View all IBM manuals →