Office 365 FireDAC Components

The Office 365 Data Provider gives developers the power to easily connect Delphi & C++Builder Apps to Microsoft Office 365 data including Outlook Mail, Contact, Calendar, Files, and more!

  • Connect to Office 365 from Rad Studio Data Explorer.
  • Comprehensive support for CRUD (Create, Read, Update, and Delete) operations.
  • Integrate with Outlook Mail, Contact, Calendar, Files, and more!

  download   buy now

CData FireDAC Components for Office 365
 Included in FireDAC Subscriptions: 125+ Components for real-time data access.

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

Office 365 FireDAC Components Included in Enterprise & Enterprise PLUS Subscriptions

Get the Office 365 FireDAC Components together with 125+ 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 := 'Office365Connection';
FDConnection1.DriverName := 'CData.Fire.Office365';
with FDConnection1.Params as     
    TFDPhysCDataOffice365ConnectionDefParams do begin


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


Type SQL, Get Office 365

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


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


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


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

Powerful Enterprise features