Sage Accounts: what is ODBC?
ODBC or Open Database Connectivity is a technical method of handling data between multiple programs. The good news is that it makes Management reporting that every bit easier and we have been working with several clients to enhance their management information.
We have successfully developed Management Information packs which integrate directly with Sage Accounts. Whereas in the past, numbers may have been keyed from a trial balance, which causes problems when those last minute changes occur.
The ODBC link between Sage Accounts and MS Excel has allowed us to take existing reporting structures and improve them by placing a link mechanism to Sage.
It can be used to analyse the following:
– Trial balance
– Debtors & Creditors
– Product Sales
– Costings
– Pricing
All data is simply refreshed from a toolbar within MS Excel, which automatically pulls through the data from Sage. Through a series of Macros and Mint reporting techniques, Management Information production is enhanced.
