Best practice to invoke query: from Oracle to MySQL
Results 1 to 2 of 2

Thread: Best practice to invoke query: from Oracle to MySQL

  1. #1
    Join Date
    Jan 2014
    Posts
    2

    Lightbulb Best practice to invoke query: from Oracle to MySQL

    I am in the process of building a Java utility to Select data from Oracle and inserting to MySQL via Hibernate. Rather than scheduling a shell script to run every X interval. Is there any way to tap into Oracles CDC (Change Data Capture) to detect when the database updates to invoke my java util? Or better yet what would be the best method to select specific records and house them in mysql on a routin basis?

  2. #2
    Join Date
    Apr 2014
    Posts
    2
    If you don't have to do it in Java but can work in Eclipse, try IRI NextForm (DB Edition) to set a time-based query condition in the input phase of the job and direct the target rows into MySQL via its ODBC method. If the tables are massive though, write a similar query in the config file of IRI FACT (Fast Extract) for Oracle. Use IRI CoSort to filter, pre-sort, etc. and then bulk-load MySQL with a named-pipe output from CoSort.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •