chnzchnz
asked on
I have an access database and I want to synchronise it with quickbooks
I have an access database and I want to synchronise it with quickbooks- how would i even start doing this?
It is a customized database that tracks name, address, postal address, phone number, mobile, email address. I use it to give curtesy calls to clients after a job and email newsletters out. Also I send a gift out to clients after 3 months.
It is a customized database that tracks name, address, postal address, phone number, mobile, email address. I use it to give curtesy calls to clients after a job and email newsletters out. Also I send a gift out to clients after 3 months.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RE: Quickbooks Connector - I was under the distinct impression that QB didn't allow direct connections, and that the only methods to get to the data was either through the SDK or through Export/Import methods. It seems the folks at that website have some idea they can get to the data, which would be neat but dangerous. I was also under the impression that the data in the Sybase database was encrypted, and that the encryption/decryption routines were not available to the public.
But I could be wrong, as I've never really gotten too far into the subject.
But I could be wrong, as I've never really gotten too far into the subject.
I've heard that the SDK is really slow. Anyone have experience with the SDK?
I've worked with the SDK quite a bit. It is difficult to understand unless you're well versed in OOP techniques, and it can be slow depending on the amount of data you request. Also, not all data is available through the SDK, and you're pretty much at the mercy of QB in regards to what is available. My understanding is that QB provides access ONLY through the SDK so that they can maintain data integrity - that is, you cannot add a Transaction unless you supply an Account, for example.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<It's the easiest of all the extrnal methods to learn and use, in my opinion. >
I'd certainly agree with that. The only real drawback is that you must depend on the folks who build QODBC to integrate the new items when they're released by QB; if you work directly with the SDK, you can do that yourself as soon as they come out.
I'd certainly agree with that. The only real drawback is that you must depend on the folks who build QODBC to integrate the new items when they're released by QB; if you work directly with the SDK, you can do that yourself as soon as they come out.
Yes, it looks like the SDK is your best route. But as pointed out earlier, you do not get access to all the data in QB (like payroll)...which might not be a bad thing. It looks like QB Connector allows full access to all data. Also, QB Enterprise is expensive.
You can purchase QODBC without purchasing Enterprise. The version of QODBC that ships with Enterprise is a read-only version; you must purchase the full version if you wish to write back to the QB database.
QB Connector doesn't seem to be available at this time - if it is, I couldn't find a download link to it at the website provided. Even so, I'm not sure I'd trust something that hasn't been updated in 6+ months enough to provide it access to my financial data.
QB Connector doesn't seem to be available at this time - if it is, I couldn't find a download link to it at the website provided. Even so, I'm not sure I'd trust something that hasn't been updated in 6+ months enough to provide it access to my financial data.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Quickbooks Connector is a fully functional API for reading and writing QuickBooks data files by using standard SQL queries directly to the database.
http://www.quickbooksconnector.com/