Help Center/ ROMA Connect/ User Guide(new)/ Connectors/ Triggers/ Oracle
Updated on 2025-07-04 GMT+08:00
View PDF
Share

Oracle

The Oracle connector allows you to connect applications with the Oracle database, and manage data transmission.

  • Oracle is a relational database featuring high performance.
  • The default Oracle port number is 1521. The administrator can change the port number as required.

Creating an Oracle Connection

  1. Log in to the new ROMA Connect console.
  2. In the navigation pane on the left, choose Connector. On the page displayed, click New Connection.
  3. Select the Oracle connector.
  4. In the dialog box displayed, configure the connector and click Test connection. After the connection is successful, click OK.

    Parameter

    Description

    Name

    Enter the connector instance name.

    Region

    Select a region.

    Project

    Select a project.

    Instance

    Select an instance for subsequent connectivity verification.

    Connection and Security

    Select the connection mode for the database.

    • Default: The system automatically concatenates data source connection character strings based on configured data.
    • Professional: You need to specify the data source connection string manually.

    IP Address

    Required when Connection and Security is set to Default.

    Enter the IP address of the database.

    Port

    Required when Connection and Security is set to Default.

    Enter the port number to which the database is connected.

    Database Name

    Required when Connection and Security is set to Default.

    Enter the name of the database to be connected.

    PDB Database Name

    Required when Connection and Security is set to Default.

    Enter the name of the PDB database to be connected (in CDB mode).

    Encoding Format

    Required when Connection and Security is set to Default.

    Enter the encoding format of the database.

    Timeout

    Required when Connection and Security is set to Default.

    Enter the timeout interval for connecting to the database.

    Connection String

    Required when Connection and Security is set to Professional.

    Enter the JDBC connection string of the Oracle database, for example, jdbc:oracle:thin:@{hostname}:{port}:{dbname}.

    Username

    Enter the username used to connect to the database.

    Password

    Enter the password used to connect to the database.

    Description

    Enter the description of the connector to identify it.

Action

Capturing database changes: Monitors insert, delete, and query operations on specified Oracle tables.

To obtain database changes in real time, you need to enable LogMiner

Configuring Parameters

Table 1 Getting database changes

Parameter

Description

Table Name

Name of the data table to be obtained.

Database Operations

Select the change operation on the database.
Parent topic: Triggers