Downloads
DISCLAIMER: Use the files posted below at your own risk. I am not responsible for any damage that may inadvertently occur when you use these files.
Data Getter: A Microsoft Excel macro file that simplifies pulling data from databases into Excel. Works with Oracle, SQL Server and Access databases. Enables you to send output to one file or to many files. Enables running multiple queries each to a different output file if desired, or outputs multiple queries to one file. Opensource. Easily customized to query different databases. Tested in Excel 2003 and Excel 2007 on Windows XP and Vista.
I’d like to hear from you if you download and try out data getter. And if you extend Data Getter to work with more databases, please let me know and I will post your enhancements here!
SELECT Runner: The poor man’s Real Application Testing. See my blog entry explaining use of these. Two shell scripts are needed, make_files.ksh and process_logs.ksh.
Download make_files.ksh.
Download process_logs.ksh.
Download Excel Macro for parsing SQL Developer report file into sql files.
