Updated on 2023-07-26 GMT+08:00

Connecting to an Oracle Data Source

Overview

ROMA Connect can use the Oracle database as a data source for data integration tasks or data API creation. Before using the Oracle data source, you need to connect it to ROMA Connect.

Prerequisites

Each connected data source must belong to an integration application. Before connecting a data source, ensure that an integration application is available. Otherwise, create an integration application first.

Procedure

  1. Log in to the ROMA Connect console. On the Instances page, click View Console next to a specific instance.
  2. In the navigation pane on the left, choose Data Sources. In the upper right corner of the page, click Access Data Source.
  3. On the Default tab page, select Oracle and click Next.
  4. Configure the data source connection information.
    Table 1 Data source connection information

    Parameter

    Description

    Name

    Enter a data source name. It is recommended that you enter a name based on naming rules to facilitate search.

    Integration Application

    Select the integration application to which the data source belongs.

    Description

    Enter the descriptive information.

    Real-Time Synchronization

    Determine whether to enable real-time synchronization for the database. Set this parameter to Enable if Oracle is used as the source data source of a composite integration task.

    CDC Mode

    This parameter is mandatory only if Real-Time Synchronization is set to Enable.

    Select the CDC mode for the database.

    • XStream: The CDC function of the Oracle database in XStream mode is used.
    • LogMiner: The CDC function of the Oracle database in LogMiner mode is used.

    Outbound Server

    This parameter is mandatory only if CDC Mode is set to XStream.

    Enter the name of the outbound server, which must be the same as that set in Configuring Oracle CDC (XStream).

    Database Mode

    This parameter is mandatory only if CDC Mode is set to LogMiner.

    Enter the name of the schemas where the data table to be synchronized is located. If this parameter is not specified the database username is used by default.

    Pluggable Database

    This parameter is mandatory only if Real-Time Synchronization is set to Enable.

    Enter the name of the PDB where the data table to be synchronized is located.

    Connection Mode

    Select a database connection mode.

    • Default: The system automatically concatenates data source connection character strings based on your configured data.
    • Multi-address: You can enter the IP addresses and port numbers of multiple databases. The system automatically concatenates data source connection character strings based on your configured data.
    • Professional: You need to enter the data source connection string manually.

    Connection Address

    This parameter is mandatory only if Connection Mode is set to Default.

    Enter the IP address and port number for connecting the database.

    Database Name

    This parameter is mandatory only if Connection Mode is set to Default.

    Enter the name of the database to be connected.

    Database Address List

    This parameter is mandatory only if Connection Mode is set to Multi-address.

    Enter the connection address and port number of the distributed database system. Click Add Address to add multiple addresses and port numbers.

    Service Name

    This parameter is mandatory only if Connection Mode is set to Multi-address.

    Enter the service name of the distributed database system.

    Connection String

    This parameter is mandatory only if Connection Mode is set to Professional.

    Enter a JDBC connection string of the Oracle database, for example, jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST={hostname})(PORT={port}))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME={servicename}))).

    • {hostname} indicates the IP address for connecting to the database.
    • {port} indicates the port of the database.
    • {servicename} indicates the service name of the Oracle database to be connected.

    Username

    Enter the username used to connect to the database.

    Password

    Enter the password used to connect to the database.

    For a common data integration task, the connection configuration of the Oracle data source is similar to that of the MySQL data source. For details, see Connecting to a MySQL Data Source.

    For a composite task, the following is an example of connecting to an Oracle data source which is not a CDB database and the CDC mode is LogMiner.

    Figure 1 Oracle data source configuration example
  5. Click Check Connectivity to check the connectivity between ROMA Connect and the data source.
    • If the test result is Data source connected successfully, go to the next step.
    • If the test result is Failed to connect to the data source, check the data source status and connection parameters, and click Recheck until the connection is successful.
  6. Click Create.