Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: New to Kettle need to know whether we can load data from oracle 9i to mysql.

  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Default New to Kettle need to know whether we can load data from oracle 9i to mysql.

    I need to do daily incremental load is it possible,Please answer

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Normally yes... Oracle 9i is supported, MySQL is usually supported (if the version is more or less recent).

    Only problem I see is that Oracle is not very handy to for incremental extracts. If data is being inserted while the extract is performed you may end up with missing data in your extract between 2 runs. But that would be for every ETL tool, not just PDI

    Regards,
    Sven

  3. #3
    Join Date
    Jul 2007
    Posts
    8

    Default

    Oracle does support transaction isolation level SERIALIZABLE but it is not the default.

    Regards

    Felix

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    I doubt anyone uses serializable for OLTP systems

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.