Automate the extract refresh

Previous Next

Once published to DataSelf Web Server, the extracts can be refreshed in several ways.

  1. Manually, from Desktop or Web Server
  2. Scheduled for set times within DataSelf Web Server
  3. Triggered in DataSelf Web Server from a batch file.



Existing extracts should already have the refresh process established. Overwriting the existing data source with modifications will not affect the refresh process.


Publishing a new extract data source usually necesitates automating the data refresh process.

A batch file is recommended. It pushes the refresh command to DataSelf Web Server. As such, it can be added to the SQL data refresh schedule, to follow immediately after a successful SQL data refresh. Especially with larger databases where the refresh window may be time-limited, the coordination of the SQL data refresh with the Web Server extracts refreshes is valuable.


Find your current refresh method


Look in the steps of the scheduling software that is running the ETL SQL refresh process (usually SQL Server Agent Job or Windows Task Scheduler). Typically, the last step(s) will be an exe or a bat file that triggers the DataSelf Web Server to refresh its extract(s).


If not, look in the Web Server's Schedules menu to see if there are "Extract Refresh" Task types with Tasks greater than zero.



Previous      Next