2 Replies Latest reply: May 15, 2014 10:15 AM by econ664 _ RSS

    SQL Writeback

    econ664 _

      Is DataPump capable of SQL writeback? I don't see any options to query ODBC connections in the Export dialog. Is there some other well-established workaround like calling a batch file post-process that can execute a SQL statement? How do the veterans handle something like this?

       

      Thanks,

        • SQL Writeback
          Olly Bond

          Hello econ,

           

          Yes, DataPump can export to SQL Server using OLEdb (as far as I recall).  You can run a batch file in the post process script in DataPump - but DataPump can also be called by SQL Server Integration Studio, so if you're more familiar with developing in SQL Server then it might be easier to work from there. Have a look at the API for DataPump for more options.

           

          Best wishes,

           

          Olly