Oracle Export Action

The Oracle Export action plugin is available in the Hub.

Plugin version: 1.7.0

Export data from Oracle to HDFS or local file system. The plugin uses Oracle’s command line tools to export data. The data exported from this tool can then be used in Hydrator pipelines. For example, you want to export Oracle data onto HDFS or local file system using an action plugin that exports Oracle data using the Oracle bulk export tool as opposed to using JDBC.

Configuration

Property	Macro Enabled?	Description

Property	Macro Enabled?	Description
Oracle Server Hostname	Yes	Required. Hostname of the remote Oracle Host.
Oracle Server Port	Yes	Optional. Port to use to SSH to the remote Oracle Host. Default is 22.
Oracle Server Username	Yes	Required. Username to use to connect to the remote Oracle Host via SSH.
Authentication Mechanism	Yes	Required. Mechanism to perform the secure shell action. Acceptable values are Private Key, Password.
Oracle Server Password	Yes	Optional. Password to use to connect to the remote Oracle Host via SSH. This will be ignored when 'Private Key' is used as the authentication mechanism.
Oracle Server Private Key	Yes	Optional. The private key to be used to perform the secure shell action. This will be ignored when 'Password' is used as the authentication mechanism.
Private Key Passphrase	Yes	Optional. Passphrase used to decrypt the provided private key in "privateKey". This will be ignored when 'Password' is used as the authentication mechanism.
Username to connect to Oracle DB	Yes	Required. Username to connect to the Oracle database.
Password to connect to Oracle DB	Yes	Required. Password to connect the Oracle database.
Path of the ORACLE_HOME	Yes	Required. Absolute path of the `ORACLE_HOME` environment variable on the Oracle server host. This will be used to run the Oracle Spool utility.
SID	Yes	Required. Oracle System ID(SID). This is used to uniquely identify a particular database on the system.
Query to be executed for export	Yes	Required. Query to be executed to export. For example: `select * from test where name='cask'`;
Full path of the temporary SQL script file to be created	Yes	Optional. Full path of the local temporary SQL script file which needs to be created. It will be removed once the SQL command is executed. Default is /tmp/tmpHydrator.sql. If 'commandToRun' input is used, then filename has to be as same as in 'commandToRun'.
Oracle command to export the data	Yes	Optional. Oracle command to be executed on the Oracle host. When not provided, plugin will create the command based on the input values provided in 'dbUsername', 'dbPassword', 'oracleHome', 'oracleSID', 'queryToExecute' and 'tmpSQLScriptDirectory'. Format should be `oracleHome/bin/sqlplus -s dbUsername/dbPassword@oracleSID @tmpSQLScriptFile`
Path where output file to be exported	Yes	Required. HDFS or local file system path where output file will be exported.
Format	Yes	Required. Format of the output file. Acceptable values are CSV, TSV, PSV.