What kind of database does Sage 50 Accounts UK use for storing data? Is it still a flat file or have they upgraded to Microsoft SQL Server?
How can we access this file?
Thank you for the reply!
The data for the company you’re logged into can be found by clicking help > about > data directory.
Hey there, I navigated to data directory and that wasn't really helpful. I am trying to understand how the PO-invoice-receiving notes might be mapped or linked. I would like to know how the data is stored, what technique does this ERP use to link these documents and so on. Not having a database storage is tricky.
You cannot simply read or write the files directly as they are in a proprietary format.
If you are simply trying to report on the data then you would need to use the Report Designer tool. Note that technically you can use the ODBC driver directly e.g. in Excel, which is what Report Designer uses, but direct consumption of it is not officially supported and no documentation is provided.
If you want to write data you would need to look at SDO, our 3rd party SDK. Note that access to this requires membership of the 3rd party developer program.
There is also Sdata that provides an API that can be used to both read and write data and is free to access/use. However coverage is more limited than Report Designer or SDO so may or may not be suitable depending on your specific requirements.
Hope that helps.
Hi Jincy, did you ever resolve this? How many companies do you have in the group? I can help get the data into SQL server. Message if interested, thanks.
*Community Hub is the new name for Sage City