A plugin that can efficiently export data from Oracle to be used as a source in Hydrator. Oracle 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 Oracle.
User Stories
As a Hydrator User I want to export data from Oracle to be used in my hydrator Pipeline.
As a Hydrator User I want a Oracle Export plugin that exports data efficiently using existing existing Oracle tools.
As a Hydrator User I want the export data capability of the Oracle 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 Oracle Instance
User should be able to specify location of EXP Utility.
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.