ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Connector OracleDB

Oracle Database (OracleDB) is a widely-used relational database management system (RDBMS) developed by Oracle Corporation. It provides a robust and scalable platform for storing, managing, and retrieving data in a structured manner. OracleDB is a powerful connector due to its ability to handle large volumes of data efficiently, enabling better customer insights, targeted marketing, and enhanced decision-making processes.

Data In/Data Out

Data In


Data Out

CSV files in the out/tables folder.

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




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.


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.



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.