Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction 

A plugin that can efficiently export data from DB2 to be used as a source in Hydrator.  DB2 includes command line tools to export data  that can be utilized to perform this task.  

 

Use-case
A Hydrator User would like to incorporate DB2 data into a pipeline using a source plugin that does not require a JDBC connection to perform the export from DB2.

User Stories

  • As a Hydrator User I want to export data from DB2 to be used in my hydrator Pipeline.
  • As a Hydrator User I want a DB2 plugin that exports data efficiently using existing DB2 tools. 
  • As a Hydrator User I want the export data capability of the DB2 plugin to be based on a sql query that I issue.  
  • User should be able to specify credentials.
  • User should be able to specify DB2 Instance
  • User should be able to specify either DB2Move or DB2 CLI.
  • User should be able to specify location of DB2Move Utility or path to CLI.   
  • User should be able to specify type of output.
  • User should be able to specify location of output files.  

Example

 

Implementation Tips

  • DB2 Inclues the DB2 Command Line Utility that can be used to export date: DB2 Docs
  • Sample Export Query: db2 export to myfile.ixf of ixf messages msgs.txt select * from staff
  • DB2 Includes the DB2Move utility which can operate at a lower granularity to bulk export tables of data: DB2 Docs

Design 

Design:

 

 

Table of Contents

Table of Contents
stylecircle

Checklist

  •  User stories documented 
  •  User stories reviewed 
  •  Design documented 
  •  Design reviewed 
  •  Feature merged 
  •  Examples and guides 
  •  Integration tests 
  •  Documentation for feature 
  •  Short video demonstrating the feature