Hi brucedenney and thanks for your response.
The reason I have asked the question is that I have a need to assimilate data from many types of accounting packages into one large database that can then be queried (and updated/changed).
I cannot go into too much detail at present, other than to say, I have a huge unknown here and that is: can this actually be done and if so how?
I guessed step one was asking the above question.
Hypothetically - A large company started buying up smaller companies. The larger company then ran the smaller companies autonomously but wanted to centralise the accounting systems (purely on the cash flow side) and have them all in similar databases for ease. So the smaller companies continued to run their account systems (stock/sales etc) but the new owner company then had a central handle on the cash position. ****** this is about as close a hypothesis as I can get.
What I can also say is that at present, I have limited, if any, knowledge of other "mainstream" accounting packages (including their existence even!), and would hope for some information on these through this question also.
I would hope the fact that we are "experts" and not salesmen would lead to some more informative answers (cross fingers).
Thanks again
Nick
Main Topics
Browse All Topics





by: brucedenneyPosted on 2009-07-28 at 03:39:55ID: 24959319
Are you wanting to read only data from the database like with Sage 50 ODBC or are you looking to write data into the database?
If you are looking to write data then SDK's are not the only solution. For Sage 50 the SDK is a huge cost every year but there are much less expensive and less complicated solutions.
Note that most Accounts systems, even if they use a standard database, will encrypt the data this is for 2 purposes, to prevent transactions being poorly written into the database and therby creating corrupt data and in order to provide security to the system and prevent people from simply reading the data.
On the Sage front, the latest rumours are that the MySql version will be released during the life of V2010 and not in September as originally thought.
I suspect that the information your are requesting is not going to address the underlying requirement.
Perhaps what you should be asking is accounting systems and the costs of being able to integrate to them and not get hung up on the type of database back end or the use of an SDK,
Unfortunately most of us here are "experts" and not salesmen so you might not get a lot of response.