Setup an ODBC connection to any database supporting it and write your SQL query
Schedule it to run at any time or any interval
Write your query result to the network or local drive in Excel, CSV or HTML format
Send the results by mail. Make it conditional by doing this only if there are results
Using templates, place holders and other options you can fully customize the automation and scheduling of your SQL queries.
Query Automation Software works with all major databases that support ODBC like Microsoft SQL server, MySQL, Oracle and PostgreSQL. Customer use Query Automation Software with many different databases on a daily basis:
Microsoft SQL Server
Unlimited lifetime technical support
Free version upgrades within one year.
30 days moneyback.
Registration keys and passwords are delivered instantly to your e-mail after payment submission.
You get to use the app forever. This is a one-time purchase that includes one year of free upgrades.
If you ever lose your license key or your download password, we will provide a new one free of charge
Query automation is the process of removing the human interaction from executing SQL queries, storing the results in a specific format and distributing it to the end user. Data stored in a database can be retrieved using SQL queries. When executing queries, the results are returned by the database.
This process is normally triggered by an end user requesting the information through a front end application. In that case, part of the query automation is done by the application already, but the trigger is still from the user.
In other cases the end user doesn’t want to trigger the executing themselves, but have that automated as well. A scenario would be a SQL query which rarely has results, and the user wants to get notified if it does, for example by receiving an email with the results in an Excel attachment.
Automating the executing of SQL queries can be handled by any client tool which can be scheduled. Typical solutions are in place by the database vendor already. Like Microsoft SQL server has the SQL Server Agent and MySQL has the MySQL Event Scheduler. These solutions do require specific authorizations from your DBA as they run on the database server itself.
The advantage of using tools like Query Automation Software is that they run outside of the database itself and can be scheduled by anyone using the Windows Task Scheduler.
The next step in query automation is having the result stored in a specific format. Typically the required output format is CSV or Excel.
Not all tools have the ability to output to real Excel files or functionality is very limited. Query Automation Software does output to Excel and also has the ability to write to specific sheets, cells and using template.
Once the results are stored they need to be distributed to the end user. This can be done by saving it to a network location, Sharepoint or other place where the user will see it. Really pushing the result to the user could be done by sending it by mail.
Including the results in your email can be done by attaching the stored results, or directly showing them in the email body. The latter can be done by Query Automation Software and you have the ability to limit the number of rows, to prevent 1000’s of rows to end up in an email body.