​Oracle database is a multi-model database management system by Oracle Corporation. It can be hosted on-premise or in a private cloud.
Supported actions
For your Oracle database account, YAP ensures the following actions:
Create row
Update row
Find row
Delete row
Count row
Run custom SQL action
Setup requirements
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.
Connection
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.