Installing and Configuring pi

Download & Install pi

You can find information on how to install pi here.

You can download the latest version from here.

Restoring the Sage 50 Pi Dashboard

  • Restore the Sage50_Repos.sql file into the pi Dashboard as per standard restore process

  • Default login credentials for the dashboard are:

    • Username: admin

    • Password: dashboard

  • If you have changed any of the default names or password throughout the process, you will need to click the ‘Dashboard Configuration’ icon at the top-right of the dashboard and then click the Settings tab

  • Update the Variable values that correspond to your inputs as these are used in the Data Connections

  • The defaults are:

    • DATABASE_SERVER: localhost



    • DATABASE_PASSWORD: dashboard

    • DATABASE_PORT: 1433

Once these settings have been saved and the dashboard has been refreshed, the dashboard should be up and running.

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)

Running the ETL process

Troubleshooting your Sage 50 installation