ePrivacy and GPDR Cookie Consent by Cookie Consent

Connector OracleDB

The Oracle connector enables connections to Oracle server data sources.

Data In/Data Out

Data In

N/A

Data Out

CSV files in the out/tables folder.

Learn more: about the folder structure please go to this article.  

Parameters

DB

ODB1.png

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.

 

SSH

new SSH.png

Enabled (required) 

Checked if SSH required to connect to the database. 

User (optional)

Username of SSH credentials.

Private SSH Key (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 (optional)

Name of SSH Host.

SSH Port (optional)

Port number of SSH credentials.

SSH User Password (optional)

The password of SSH credentials.

 

Table

ODB2.png

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.