QuickBooks FireDAC Components

Complete read-write access to QuickBooks enables developers to search (Customers, Transactions, Invoices, Sales Receipts, etc.), update items, edit customers, and more, from Delphi and C++Builder Apps.

  • Connect to QuickBooks from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Integrate with QuickBooks Customers, Transactions, Invoices, Sales Receipts, Reports, and more!

  download   buy now

CData FireDAC Components for QuickBooks
 Included in FireDAC Subscriptions: 90+ Components for real-time data access.

Extend Delphi & C++Builder Apps with unrivaled data connectivity!

QuickBooks FireDAC Components Included in Enterprise & Enterprise PLUS Subscriptions


Get the QuickBooks FireDAC Components together with 90+ additional components for SaaS, NoSQL, and Big Data integration! Our components offer the fastest & easiest way to build data driven Apps.


Learn More  



FireDAC Components in Action

Connecting to Any Data Source is as Easy as Connecting to a Database



Standard FireDAC Components


Just like connecting with a typical RDBMS like MySQL. or SQL Server. Use standard FireDAC components like TDFManager, TDFConnection, TDFQuery, etc.


FDConnection1.Name := 'QuickBooksConnection';
FDConnection1.DriverName := 'CData.Fire.QuickBooks';
with FDConnection1.Params as     
    TFDPhysCDataQuickBooksConnectionDefParams do begin

    ...
end;


FDConnection1.Connected := true;
FDQuery1.Active := true;
FDQuery1.Open('select * from Customers');

...

Type SQL, Get QuickBooks


The easiest way to build data-centric applications. Write standard SQL queries to interact with QuickBooks, just like working with any RDBMS. Supports joins, updates, aggregation, and more.

SELECT WITH INNER JOIN

SELECT Customers.Id, Customers.Name, Customers.Fax,     
  Opportunity.AccountId, Opportunity.CloseDate
FROM Customers
INNER JOIN Opportunity
  ON Customers.Id = Opportunity.AccountId

AGGREGATE FUNCTIONS

SELECT Name, AVG(AnnualRevenue) FROM Customers GROUP BY Name

CRUD OPERATIONS

UPDATE Customers SET Name='John' WHERE Id = @myId



Powerful Enterprise features







 
 
Downloads