Database agnostic table/view export software?

Question

Trying to search for a more elegant/overall solution to our common/basic data export tasks

I am convinced that there must be software out there that allows me to:

• Define and persist a "setup" (definition of file format, delimiters, encoding, column names etc) from a GUI
• Run on a schedule/from command line
• Work on both Oracle and MSSql

However, I haven't found it yet... any tips?

Answer 1

what about using groovy to export the data to xml files.

see http://groovy.codehaus.org/Convert+SQL+Result+To+XML

for the gui thing, Oracle's SQL Developer can connect to Oracle, MySQL, SQL Server, MS Access and Sybase

Answer 2

The search ended in using products from http://sqlmanager.net.

They have products that covers the described needs, except that there are separate products for i.e. MSSQL and Oracle