...
| Child pages (Children Display) |
|---|
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 follow the below process 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.
· Please note that if you cannot see the version available, this can be downloaded 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.
...
· Please note – The data path can be found in the About screen within Sage 50
o 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 the above process if you require to add multiple companies.
Setting the connection details (Sage 50 & SQL Server)
...