• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

GUI based SQL table dump/extract?

RichieZ

RichieZ

Diamond Member
Can anybody recommend an easy to use data extract tool that works in 32bit windows environment.

Target users: Primarily business users who are not very technical but have basic SQL knowledge.

Use case:
Data export from Oracle staging table, extracting data for email marketing campaigns.

Output file type:
(*) quoted CSV or tab separated files
(*) file must be output in UTF8 as we supposed non-English languages

Expected volume:
Up to 10MM rows

We can pay for this tool, but it seems like a simple ask that there should be something free out there.
 
I know that the microsoft sql severs come with a tool that does exactly what you are describing, it would surprise me if oracle didn't provide a similar tool.
 
as far as I can tell oracle does, but its not user friendly.

What I ended up doing was setting up Kettle but pre-defining the workflow and the specifics of the output file. Now all users have to do is to put in their SQL query.

See:
http://kettle.pentaho.org/
 
I just coded a utility recently in Visual Studio to perform this same task. It only took half a day (4 hours) and does the data extract to CSV files for each table. You specify however many and what tables to extract from a data source. It then works on 4 tables at once using multithreading. The rest of the tables are kept in a queue until a thread is done to take on the next table. Works very very fast.
 
Last edited:
those are interesting solutions, but given the volume of data we are talking about it wasn't feasible in the end. Kettle is an open source ETL tool and such exports data MUCH faster than a regular select statement, I am getting upwards of 5000 rows/sec
 
Cogman said:
I know that the microsoft sql severs come with a tool that does exactly what you are describing, it would surprise me if oracle didn't provide a similar tool.
Click to expand...

Oracle does, but charges you per-core to use it.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top