2 Replies Latest reply: Apr 28, 2014 9:13 PM by MikeN RSS

    GG file to DB

    902923

      Hi Experts,

       

      We have a below requirement for replicating data from file system to oracle database, its like , there is text file data , its needs to replicate  to oracle database , can we use goldengate for this requirement, for replicating data from file to oracle?

       

      please help

       

      Thanks in Advance

        • 1. Re: GG file to DB
          stevencallan

          You can use flat files for data loading, but GoldenGate isn't the best solution for this. Why not treat your files as external tables?

          • 2. Re: GG file to DB
            MikeN

            902923 wrote:

            We have a below requirement for replicating data from file system to oracle database, its like , there is text file data , its needs to replicate  to oracle database , can we use goldengate for this requirement, for replicating data from file to oracle?

             

            Or, sql*loader? GoldenGate is kind of a big (and expensive) hammer for such a small nail. Fwiw, I've implemented a simple proof-of-concept loading files into GG before, so it can be done (hint: via GG JMS capture & some Java glue code...), but it's not the best tool in the toolbox for the task.  See here for pointers to your other options:  http://www.oracle.com/technetwork/database/enterprise-edition/index-093639.html (sql*loader, external tables)