AUTOMATE YOUR SQL QUERIES

Simple and fast with AutoSQL

A lot of people run the same query every day, save the results and mail it to someone to take action. AutoSQL helps you to automate this process. Just specify your ODBC connection, query, output definition and mail options once. Schedule your SQL query to run at any time in the background. 

SQL query automation made easy!

Specify
a query and ODBC connection

Schedule
SQL query

Export
results to Excel or CSV

Send
results through email

How AutoSQL works

  • Use the AutoSQL GUI to create a new task list
  • Add a new action
  • Choose an ODBC connection and specify a SQL query
  • Determine where the output needs to be saved, either in Excel or CSV format
  • Choose to send the result by email, or only based on a certain amount of records
  • Link the output file or send it directly as an attachment
When you have defined all actions that need to be scheduled together, save your task list. Now copy the background execution command to the clipboard and schedule it using eg Windows Task Scheduler.

ODBC & SQL

AutoSQL works with all databases that support ODBC. There is specific version to run with 32 and 64 bit drivers. AutoSQL has been tested with

  • Microsoft Access
  • Microsoft SQL
  • Oracle
  • PostgresSQL
  • MySQL
  • SAP HANA
  • Many more…

Output options

  • Output path
  • Can be both local or network
  • Use {date} place holder in filename
  • Excel or CSV
  • Specify sheet and cell to use with Excel
  • Use Excel template to define formatting
  • Detailed specification of CSV format
  • Append or overwrite
  • Print or disable header

E-mail options

After the execution of a query, you can choose to send an email.

  • Send only email when more than X records (e.g. don’t send anything when there are no results)
  • Use place holders for number of rows, date, output path and the query to use in the subject and message
  • Optionally attached the output file and ZIP it if required

AutoSQL is used all around the world, some examples

Watch how you can use AutoSQL

Download the trial version and check out our tutorials on how to schedule a query in 3 easy steps or
how to export a SQL query to Excel and pre-define formatting.

Or watch the video below to see how easy it is to schedule a SQL query and mail the results every week:

More videos:

Is your database system not covered in the videos? Don’t worry, almost all databases work with ODBC and can be used with AutoSQL.

Download 30 day trial

You can download AutoSQL and request a 30 day trial license to see if AutoSQL can help you make your life easier!