Oracle

Introduction

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.
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.
Last modified 1yr ago