Using Oracle Data Integrator Open Tools

Source: Internet
Author: User
Change data can be generated at any time, so new changes need to be kept in sync. There are two ways to accomplish this task.

  • The first approach can be achieved through planning. For example, create a schedule that performs a synchronization interface every half hour. This can synchronize the change data to the target every half hour. This method requires attention to the scheduled repetition interval, to ensure that the last call has been completed before repeated calls, and can generally be used for periodic synchronization requirements.
  • The second approach is to create a package that uses the CDC-related tools provided by ODI to poll the journal and invoke the synchronization interface once a change has been made. This method can meet the demand of high real-time. 1. Create the Package

    Designer->projects-> "project name"->first Folder->packages, right click to select "New package", define a name such as:

    2. Set Diagram 2.1 odiwaitforlogdata

    Add a tool for CDC in the diagram: Odiwaitforlogdata, as shown in the properties:

    The Web_customer property is configured to poll the journal table every 1 seconds until 1 changes are found.

    2.2 Adding mappings

    Drag the map to the right of the diagram, as shown in the properties:

    2.2 Odisleep

    Add a tool for CDC in the diagram: Odisleep, with the following properties:

    Wait 1 seconds to continue polling.

    3. Implementation Package

    After performing the package operation, it will be found that the package is always executing and is in the odiwaiteforlogdata step, such as:

    The source table inserts data, SQL such as:

    In operator, you will find that the data synchronization is complete and go to the next poll:

    Of course, if you delete or update a piece of data in the source table, the target table is also deleted or updated synchronously.

Using Oracle Data Integrator Open Tools

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.