Setting up the Sage ODBC connections (adding a company)
Sage 50 allows multiple companies which is accounted for in the pi Sage 50 installer. To add more than 1 company, just repeat the process detailed below as often as required.
Search for ODBC in the windows task bar and select ODBC Data Sources (64 bit)
Once the dialog box opens, select the System DSN tab and click Add… to create a new ODBC
Then select the Sage driver that is the version relevant to Sage 50 you have installed and click Finish
If you cannot see the relevant version, you can download it from the Sage website for free. Search for ‘Sage 50 ODBC driver’
You will then be presented with options to add a Data Source Name (DSN) and a Data Path
Enter a name into the DSN (with no spaces) and add the Data Path for this company for Sage 50 and click OK
Please note – The data path can be found in the About screen within Sage 50
e.g. C:\Programdata\Sage\Accounts\2018\Company.002\ACCDATA
Now add the name used in the DSN to the PIDataSources.txt file (this is how the ETL knows which ODBC connection(s) to use) and save the file
Repeat these steps for each additional company that you need to add.
Please take a look at the following sections for more information:
Microsoft SQL Server Express Installation
NEWS: We are pleased to share that our March 24 dashboard release is now available to download, see HERE for more details