CODEWITHSUNDEEP
sdkquickbooksqbfcqbxml
chuck
chuck

Reputation: 21

Quickbooks Export GL Information - Advice SDK, QBFC, QBxml

We are looking at providing Quickbooks integration into a BI tool we have developed that analyses a third party system. (we've never used Quickbooks before)

The basic requirements are to export the GL information by GL Account, Amount, Customer, date, transaction type etc and load this information into a SQL DB.

This product will be installed on potentially thousands of customers from many different businesses with various versions of Quickbooks both desktop and online etc...

I'm wondering given licensing considerations and other issues what would be the best way forward and what problems you might foresee.(I'm foreseeing many :))

Options I'm aware of:

Use qbXML Use QBFC Use Third Party tools ODBC wrapper tools.

Any advice would be awesome.

Thanks

Upvotes: 2

Views: 992

Answers (1)

Scott T
Scott T

Reputation: 99

Let me start by saying I work for one of the third party companies mentioned below so make what you will of my bias.

QuickBooks is a fairly specialized application and if it is not the core of your product I would recommend using one of the third party tools. They are all royalty free and for the price range $300 - $700, they offer considerable value in the support and ease of use they provide.

The easiest to use will be the RSSBus QuickBooks ADO.NET provider or QODBC (ODBC wrapper around QuickBooks) or since they present QuickBooks as a relational database, which is the easiest for a new developer to grasp and work with. Since you intend to load this information into a SQL db anyway, you further benefit from their work in modelling QuickBooks data as tables.

QODBC: http://www.qodbc.com/schema.htm RSSBus QucikBooks ADO.NET Provider: http://rssbus.com/ado/quickbooks/

Upvotes: 0

Related Questions