I have been using the 2.6 Beta and really love all of the functionality and would love to use it rather than an Access Database for Automation.There is one thing that I am having an issue with though that is holding up the transition.
I have for example an excel file with multiple pivot tables on separate sheets all done thorough linked queries to an oracle database. After reading everything and trying out different methods I cannot find anyway for the automatic in TDA to first run SQL to look for the latest DDL of my table, then if DDL date is greater than SYSDATE - 1 open up excel and refresh the linked queries, close excel and ideally save the file.
I know this gets into VBA territory but really this functionality would be key and could completely remove Access from running all of this VBA to open excel, save report, etc. It would be huge if it where possible for the automater to do the above and come back and upload the file to a FTP.
Maybe I am missing something but with the current beta I do not see that functionality to refresh the linked queries or check to see the table DDL and then continue with the script.