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 |
---|---|---|
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 |
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:Â |
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 |
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.