1 Reply Latest reply: Jan 17, 2014 8:51 AM by sb92075 RSS

Options to load data into Oracle from Greenplum ?

jjouett Newbie
Currently Being Moderated

I've done some initial investigation, but I haven't found any real-world examples of options for loading data from Greenplum into Oracle.  GoldenGate isn't an option due to product costs.  Does anyone have suggestions for options to perform frequent ETL transfers of data from Greenplum to Oracle?

 

Thanks in advance

  • 1. Re: Options to load data into Oracle from Greenplum ?
    sb92075 Guru
    Currently Being Moderated

    jjouett wrote:

     

    I've done some initial investigation, but I haven't found any real-world examples of options for loading data from Greenplum into Oracle.  GoldenGate isn't an option due to product costs.  Does anyone have suggestions for options to perform frequent ETL transfers of data from Greenplum to Oracle?

     

    Thanks in advance

     

    PERL can interoperate against both Greeplum & Oracle database from within the same program.

     

    I don't know if you are able to create a DATABASE LINK from Oracle to Greenplum

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points