How to set up a refresh schedule with an Excel file
Is it possible to publish an excel file as a snapshot, so a refresh schedule can be set up?
Snapshots can only connect and refresh to actual databases. If you want to use an Excel file to refresh here is how you can do this.
1) The same file must always be used on a network drive. Create a connection to this file. 2) Open up an automation script and add an Execute Script activity. 3) Enter select statement and choose to publish a dataset to Toad Intelligence Central. 4) Schedule automation sript to run on TIC server. A network drive will need to be used for the Excel file. Make sure and enter your AD credentials as SYSTEM will not be able to access the network drive.