not quite sure where to start with this one so some guidance would be greatly appreciated.
every day at midnight my server reloads data into the dashbaord. one table within the dashboard has 2 fields sourced from the data loads and one input field. i need to get that table to another machine someway. the way I was thinking have a trigger to export the input table to csv to a shared folder that is already set up and used to transport data from the source machine.
1. where can i set a trigger to set of what ever method decided upon
2. is it possible to automate the export of a table before a reload?
a. maybe put the ecport in a partial reload triggered 10 mins before the reload. is it possible to have a full reload at one time and a partial at another?