Report Automation Tool
Report automation tool is built to execute sql scripts in batch.It processes after reading from an input folder and exporting reports to an output folder in excel format. It gives user the flexibility to configure input, output folder & database details before execution of batch process. Reports are generated with in-build excel properties such as bold header, header text set at center, freezing header and auto resizable columns. • Why Tool Is Needed
- The tool will automate report generation process and save user’s valuable time.
- The tool is capable of exporting huge records like 9 Lacs records within 8 minutes.
- The tool generates report with a better readable format by using many excel features such as auto resizing columns, freezing header in bold and header text at set at center.
- It is seen IDE’s like SQL Developer are not capable of exporting huge records when count is in terms of Lacs. This tool will overcome this issue.
- This will minimize errors that happen in manual exporting process.
- The tool is built for Oracle database, but can be enhanced to support other databases as well.
• Features In Details.
- Database detail, input and out folder are configurable. User has to configure database details, save sql queries in an input path and generate reports to an output path. All are configurable in properties file.
- Predefined report names for batch process. This tool supports to execute daily, weekly and monthly reports which can be configured inside a properties file.
- Generate reports with better readable format.
- Reports are exported with timestamp and sql query printed in the second tab.
• Technology Used java,Oracle