Oracle
​Oracle database is a multi-model database management system by Oracle Corporation. It can be hosted on-premise or in a private cloud.
For your Oracle database account, YAP ensures the following actions:
Create row
Update row
Find row
Delete row
Count row
Run custom SQL action
Before setup, please check that you have granted to YAP the permission to send notification to your Oracle database account. For this, sign in to Oracle database and authorize the permissions requested by YAP.
The Oracle database connector allows querying in an external Oracle database database.
Field | Type | Description |
Connection name | Required | Give this Oracle connection a unique name that identifies which Oracle instance it is connected to. |
On-premise secure agent | Optional | Choose an on-premise agent if your database is running in a network that does not allow direct connection. Before attempting to connect, make sure you have an active on-premise agent. Refer to the On-premise agent guide for more information. |
Database host | Required | URL of your hosted server. |
Database port | Optional | Port number that your server is running on, typically 1521. |
Username | Required | Username to connect to Oracle. |
Password | Optional | Password to connect to Oracle. |
SID/Service name | Required | SID or Service name of your Oracle database instance you wish to connect to. |
For more details, take a look at Oracle Database Documentation.
Questions? We're always happy to help with any issues you might have! Send us an email to [email protected] or request the demo with our sales team.
