Connector OracleDB

Data In

N/A

Data Out

CSV files in the out/tables folder.

Host (required)

Name of the server that hosts the database.

Port (required)

The port number you want to access. 

SID (required)

The Oracle System ID of the database.

User (required)

Account name. 

Password (required)

Account password.

Enabled (optional)required) 

Checked if SSH required to connect to the database. 

User (required)optional)

Username of SSH credentials.

Private SSH Key (required)optional)

Private SSH Key .

Warning: Currently Private Keys have new lines with  \n . Take the whole Private Key with the new line that turned into  \n , but insert it directly into the JSON (not into the form).

SSH Host (required)optional)

Name of SSH Host.

SSH Port (required)optional)

Port number of SSH credentials.

SSH User Password (required)optional)

The password of SSH credentials.

Query (required)

The database query to be executed.

Output File Name (required)

The CSV file name, where the result of the query is saved in CSV format.