isimSoftware Query Automation Software

Scheduling and automating your SQL queries

With isimSoftware Query Automation Software any user can schedule any database query and automate it to export to Excel, save it to the network or send it as an email attachment.

Type caption here

Setup an ODBC connection to any database supporting it and write your SQL query

Schedule it to run at any time or any interval

Unique Styles

Write your query result to the network or local drive in Excel, CSV or HTML format

Unlimited Sites

Send the results by mail. Make it conditional by doing this only if there are results

Use templates, placeholders and options

Using templates, place holders and other options you can fully customize the automation and scheduling of your SQL queries.

Support many different databases

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

MySQL

Oracle

Microsoft Access

PostgreSQL

MySQL

…

Download Query Automation Software

Please use the links below to download the latest version of Query Automation Software.

The first time you run Query Automation Software the License information Windows pops up.

By clicking on ‘Request Trial‘ you will receive a 30 day license key. You do need an internet connection for this. 

If you want to continue using Query Automation Software after your 30 day trail period please purchase a license through the form. Ordering a license means:

    A one time purchase, no re-occuring cost. The license has no expiration date.

    Each license gives the right to use the software on 1 computer or server. It is not bound to a specific computer.  After making the payment, the license will be send directly be email. You can paste the license code in the license information window to activate your copy of Query Automation Software. 

Schedule a query in 3 steps - Learn how to setup an ODBC connection, a SQL query and schedule it to send a daily email with the results attached. 

Putting query results in the email body - Use place holder in your mail message to dynamically include query results, number of rows, dates, etc. 

Writing different queries to same Excel file - Setup Query Automation Software to write different query results to different sheets in the same Excel file 

Using an Excel template for advanced formatting - Output the query result into an existing Excel file to pre define formatting or refresh a complete dashboard. 

Mail settings for Office 365 and Gmail Set up Query Automation Software to mail using an Office 365 or Gmail account to enable your Query Automation Software action lists to send emails with results. 

Automating a daily SQL query - Use Windows Task scheduler to run your automated query on a daily basis 

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.