Help Center/ ROMA Connect/ Best Practices/ Synchronizing Data from MySQL to Oracle as Scheduled/ Creating a Composite Application with a Template
Updated on 2024-07-17 GMT+08:00
View PDF

Creating a Composite Application with a Template

  1. Log in to the new ROMA Connect console.
  2. In the navigation pane on the left, choose Asset. Search for Oracle, select the template for scheduled synchronization from MySQL to Oracle, and click Apply.

    The field types in the MySQL table are the same as those in the Oracle table.

    Crete fields aa and bb in the MySQL table and fields TEST_INTEGER and TEST_VARCHAR in the Oracle table for data synchronization.

    Figure 1 Synchronizing data from MySQL to Oracle as scheduled
  3. On the application orchestration page, configure the timer, MySQL, and Oracle connectors.
    1. Configure the timer.
      1. Unit: Minute
      2. Interval: 1 (execute once every minute)
      3. Executed At (Second): 0 (execute at the start of every minute)
      4. Time Zone: GMT
      5. Task Mode: Parallel
      6. Execute Once at Once: No
      Figure 2 Configuring the timer

    2. Configuring MySQL.
      1. Click Account and Select MySql_test.
      2. Select Obtain Record for Action.
      3. Configure the parameters. Select the name of the table for synchronization, select fields aa and bb, and retain the default values for other parameters.
        Figure 3 Configuring MySQL
    3. Retain the default configurations of the iterator.
    4. Configure Oracle.
      1. Click Account and Select Oracle_test.
      2. Select Obtain Record for Action.
      3. Configure the parameters. Enter the target table name, select fields TEST_INTEGER and TEST_VARCHAR, and set the values to ${500885|payload.aa} and ${500885|payload.bb}. 500885 is the node ID of the iterator. Retain the default values for other parameters.
        Figure 4 Configuring Oracle
  4. Click Save in the upper right corner.
  5. In the dialog box displayed, enter the name and description of the composite application, and click Yes.
  6. In the upper right corner, click Start.
  7. In the dialog box displayed, select the region, project, and ROMA Connect instance, and click OK to start the composite application.