Updated on 2024-07-17 GMT+08:00

Creating an Oracle Connector

  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.

    Parameter

    Description

    Name

    Enter the connector instance name, Oracle_test.

    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. Select Default in this practice.

    • 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.

    Host IP Address

    Enter the IP address of the database.

    Port

    Enter the port number for connecting to the database.

    Database Name

    Enter the name of the database to be connected.

    Pdb Database Name

    Enter the name of the PDB database to be connected.

    Encoding Format

    Enter the encoding format of the database.

    Timeout (s)

    Enter the timeout for connecting to the database.

    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.

  5. After the test is successful, click OK to save the connector.