Running the ETL process

  • 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:

Microsoft SQL Server Express Installation

SQL Configuration

Setting up the Sage ODBC connections (adding a company)

Setting the connection details (Sage 50 & SQL Server)

Installing and Configuring pi

Troubleshooting your Sage 50 installation