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 support@youngapp.co or request the demo with our sales team.