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.

 

Created in 2020 by Google Inc.