Oracle Database Agent

Overview

An Oracle Database agent encapsulates the connection details to a single Oracle Database instance.

Operational Considerations

An incorrectly configured Oracle Database agent will affect every Operation attached to it. When configuring this agent, it is important to keep in mind:

Which tables the user being authenticated with has access to and what tables are available under its schema.
Connection timeout limits of the target Oracle Database instance.

Usages

The Oracle Database agent is used by the following Operations:

Database Execute Query operation
Database Query Changes operation

Configuration

In addition to the common agent configuration settings shared by all agents, the Oracle Database agent requires the following by way configuration:

Name	Description
Connection String	The ODP.net oracle data connection string used to connect to the target Oracle Database instance. e.g. `Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER_NAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICE_NAME>)));User Id=<USERNAME>; Password=<PASSWORD>;` The default port is 1521

Name

Description

Connection String

The ODP.net oracle data connection string used to connect to the target Oracle Database instance.

e.g. Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER_NAME>)(PORT=<PORT>)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICE_NAME>)));User Id=<USERNAME>; Password=<PASSWORD>;

The default port is 1521

Agent Oracle Database

Previous article: Rest API Agent

Next article: LDAP Directory Agent

Is this article helpful for you?

Replies 0
Oldest first
- Newest first
- Oldest first

Customer support service by UserEcho