Targeting Oracle with Triggers Agent

Overview

This guide explains how to configure Oracle as a target database.

Target Configuration

Database Requirements

Oracle Database (version 10g or higher)
User with appropriate write permissions
Sufficient storage space for target tables

Setup via Web UI

Hostname / IP Address: DNS record or IP Address of your server;
Port: Optional, defaults to 1521;
Database name: Name of your database;
Username: Username with read/write access to the tables;
Password: Password belonging to the given username;
Max connections count: Maximum number of connections the pool can instantiate.

Custom host credentials

This can be also set via Rest API by specifying customHostCredentials param.

Connection type: (optional, defaults to SID) Connection type used to connect to Oracle. Available types are: SID or SERVICE_NAME.

Specific configuration

This agent has no specific configuration properties.

Setup via Rest APIs

Here following an example of calling the CoreHub’s Rest API via curl to setup the connection for this Agent.

curl --location --request PUT 'http://core-hub-ip-address:1717/pipelines/{pipelineId}/agents/{agentId}/config/credentials' \
--header 'Content-Type: application/json' \
--header 'Authorization: ••••••' \
--data '{
        "hostCredentials": {
        "connectionName": "myAgentNickName",
        "host": "host-address",
        "port": 1521,
        "databaseName": "db_name",
        "username": "",
        "password": "",
        "maxConnectionsCount": 100,
        "enableTls": true,
        "certificatePath": "/myPath/cert.pem"
      },
      "customHostCredentials": {
        "connectionType": "SID"
      }
}'

Data Type Mappings

The Triggers agent supports all Oracle native data types, ensuring:

Complete data type compatibility
Accurate data representation
Reliable data synchronization