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.
Passwords should not be viewable in plain text from inside pipeline viewer or hydrator studio.
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