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.
Give this Oracle connection a unique name that identifies which Oracle instance it is connected to.
On-premise secure agent
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.
URL of your hosted server.
Port number that your server is running on, typically 1521.
Username to connect to Oracle.
Password to connect to Oracle.
SID or Service name of your Oracle database instance you wish to connect to.
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.