Define a connection and query, specificy required output and schedule it
Setup an ODBC connection to any database supporting it and write your SQL query.
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
Schedule it to run at any time or any interval using Windows build in scheduling engine
When your SQL query returns results, you can write it to Excel or CSV, but also email it directly to your audience. Use all kind of place holders to dynamically write the email text.
AutoSQL works with all major databases that support ODBC like Microsoft SQL server, MySQL, Oracle, PostgreSQL, IBM DB2, MS Access, SAP HANA and many more...
When you want to update your Excel dashboard with SQL data, you can let AutoSQL fill a template Excel file. The final result can be put on the network or mailed directly to the business users.
Watch some of the video's below to learn how to use AutoSQL for this first time or about specific features
Download the latest version of AutoSQL and start your 30-day free trial. The trial is fully functional for 30 days, so you can test your use case without limits
Learn how to use AutoSQL to automate and schedule any SQL query. Setup a connection to any database, provide a SQL query and schedule it to send a daily email with the results attached.
This video shows you have to setup AutoSQL and schedule your first SQL query.
Advanced formatting with Excel templates
Example with MySQL database
Example with MS Access
We are used in more than 35 different countries, with all kinds of different databases.
Jon Morgan – Digital Process Manager
Woodlands Hills Wine Company
