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 |
N/A |
|
Data Out |
CSV files in the |
Learn more: about the folder structure please go to this article.
Parameters
DB
|
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
|
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
|
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. |
No Comments