
SCHEDULE AND AUTOMATE YOUR SQL QUERIES
Simple and fast with AutoSQL
Scheduling and automating your SQL queries can save you a lot of time. How often do you run the same query, save the result to Excel and send it by mail to the person needing it?
From SQL query to Excel attachment
Most databases support scheduling of queries, but often this is very technical and you need specific authorizations. With AutoSQL 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.
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. Some of the most interesting:
- Use {result:10} to include HTML result in the email body
- Use {date}, {rows} and other place holders
- Use Excel templates to pre-format your output
- Write different queries to different sheets in the same Excel workbook
- Choose to send the result by email, or only based on a certain amount of records
- …
Daily used with many different databases
AutoSQL works with all major databases that support ODBC like Microsoft SQL server, MySQL, Oracle and PostgreSQL. Customer use AutoSQL with many different databases on a daily basis:
- Microsoft SQL Server
- MySQL
- Oracle
- Microsoft Access
- PostgreSQL
- MySQL
- SAP HANA
Installation/Activation Instruction is Included in the folder!
Torrent Contain:
Size: 2.97MB