Open the Sage50_Connections.exe file and enter the details (following the prompts) for the SQL Server you have just set up and the login details of the Sage 50 user you would like the process to use
On first setup just select “Y” when asked if overwriting settings
After typing each piece of information, press ENTER
If any of the credentials are not correct – invalid usernames or passwords – an error will be shown. The process can just be repeated to correct any errors
Once the credentials are successful, this will create a file in the same directory called PiConnections.db – this is an encrypted file that stores the credentials you have entered and is used by the ETL process
If the credentials change or need updating just re-run the file and enter them again selecting “Y” when asked
Please take a look at the following sections for more information:
Setting up the Sage ODBC connections (adding a company)