Versions Compared
compared with
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.
- User should know of connectivity errors, or malformed queries/output identifier.
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 style circle
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