Oracle Database Agent
An Oracle Database agent encapsulates the connection details to a single Oracle Database instance.
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.
The Oracle Database agent is used by the following Operations:
- Database Execute Query operation
- Database Query Changes operation
In addition to the common agent configuration settings shared by all agents, the Oracle Database agent requires the following by way configuration:
The ODP.net oracle data connection string used to connect to the target Oracle Database instance.
The default port is 1521
Customer support service by UserEcho