Once the connections have been set up successfully, you can run the Sage50_ETL.exe file by double clicking. This will copy the Sage 50 data across into the SQL Server database and give you a notification when complete
The duration of the process varies dependent on the volume of data and the hardware infrastructure
If there are any errors, they will be shown on screen and also an error log file is created in the same directory called: Sage50DataErrorsLog.txt
Please see the troubleshooting section for help with potential errors.
Setting up a scheduled ETL process
Using the Windows Task Scheduler, the Sage50_ETL.exe can be scheduled to run at a frequency of your choosing or ran manually. Please consider the length of the process when setting the frequency of your schedule
Within the preconfigured dashboard there is a category called Data Update that provides information on when the data was last updated
Please take a look at the following sections for more information:
Setting up the Sage ODBC connections (adding a company)