OraDump-to-Excel is a program to export data from Oracle dump files into Microsoft Excel spreadsheets. Each Oracle table becomes a worksheet, each record becomes a row. The program does direct reading from the dump, so Oracle installation is not required. Command line support allows to script, automate and schedule the conversion process.

Features All versions of Oracle dump files are supported (both EXP and EXPDP) Microsoft Excel 2016/2013/2010/2007/2000/5.0 supported as output formats Direct support for MS Excel 2007/2010 .xlsx format (no middleware is necessary) Encrypted dump files are supported Data can be split into multiple MS Excel spreadsheets to avoid limitations of the format Converts parallel export Oracle dump files Option to convert individual tables Stores conversion settings into profile Command line support Quick Launch Easy-to-use wizard-style interface Full install/uninstall support The product can be customized according to customer requirements Unlimited 24/7 support service 1-year subscription for updates Limitations Does not support compressed dump files Does not convert columns having user-defined types Demo version converts only 50 records per table

Requirements

• Supported OS: Windows XP(SP2 or SP3)/Vista/7/8/10, Server 2003/2008/2012/2016, Linux with WINE
• Microsoft Excel/Office or Access Runtime installation

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description file (.od2x) with left mouse button. This will cause OraDump-to-Excel launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

How to process parallel export Oracle dump files

To speed up exporting data into dump Oracle allows export operation to be executed by multiple threads that are working at the same time. Each thread generates output in its own file, so the result of the parallel export job is a set of files. OraDump-to-Excel can extract data from the first file of that set only. To read the entire data it is necessary to merge all file of parallel export into one with ormerge.exe tool that can be found in the installation folder. It is a console utility that accepts the following arguments:

ordmerge.exe <dumpfile#1> <dumpfile#2> ... <dumpfile#N> <resulting file>

Then OraDump-to-Excel should be run against the resulting file.

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It will allow you to convert only 50 records for each database table. Test the quality of the demo and come back to place an order if satisfied with the results.