FireDAC Components

Rapidly create and deploy powerful Delphi & C++ Builder Apps

  • Feature-rich high-performance Data Access Components
  • SQL-92 Compliant data accesst
  • Dynamic Schema / Meta-data Discovery
  • Unicode enabled 32/64-bit support
Firedac Logo inside a computer desktop


The FireDAC connectors have been deprecated as of July 2023 and will be discontinued in June 2024. ODBC is the recommended alternative for Delphi and C++ Builder applications. You can see an example of how to use ODBC in RAD Studio here: Viewing Salesforce Data in RAD Studio Data Explorer.

Low-Code FireDAC Data Integration

Easily build applications that read and write live data from popular on-premise & cloud data sources with RAD Studio

Custom Code Icon

RAD Studio Add On

The fastest & easiest way to build data driven Apps. More than 200 FireDAC Connectors for Delphi & C++ Builder.

Enterprise-Class Design Icon

Enterprise-Class Design

Built with the same reliability, scalability, performance & security powering leading data integration solutions.

Data-Centric Architecture Icon

Data-Centric Architecture

A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more.

Secure Connectivity Icon

Secure Connectivity

Standard Enterprise-class security features such as TLS/SSL encryption for client-server communications.

FireDAC Components

High-performance FireDAC components for NoSQL, Big Data, & SaaS Integration.


Access Icon
Access
Act CRM Icon
Act CRM
Act-On Icon
Act-On
Active Directory Icon
Active Directory
ActiveCampaign Icon
ActiveCampaign
Acumatica Icon
Acumatica
Adobe Analytics Icon
Adobe Analytics
Adobe Commerce Icon
Adobe Commerce
ADP Icon
ADP
Airtable Icon
Airtable
AlloyDB Icon
AlloyDB
Amazon Athena Icon
Amazon Athena
Amazon DynamoDB Icon
Amazon DynamoDB
Amazon Marketplace Icon
Amazon Marketplace
Amazon S3 Icon
Amazon S3
Asana Icon
Asana
Authorize.Net Icon
Authorize.Net
Avalara AvaTax Icon
Avalara AvaTax
Avro Icon
Avro
Azure Active Directory Icon
Azure Active Directory
Azure Analysis Services Icon
Azure Analysis Services
Azure Data Catalog Icon
Azure Data Catalog
Azure Data Lake Storage Icon
Azure Data Lake Storage
Azure DevOps Icon
Azure DevOps
Azure Table Icon
Azure Table
Basecamp Icon
Basecamp
BigCommerce Icon
BigCommerce
BigQuery Icon
BigQuery
Bing Ads Icon
Bing Ads
Bing Search Icon
Bing Search
Blackbaud FE NXT Icon
Blackbaud FE NXT
Box Icon
Box
Bugzilla Icon
Bugzilla
Bullhorn CRM Icon
Bullhorn CRM
Cassandra Icon
Cassandra
Certinia Icon
Certinia
Cloudant Icon
Cloudant
CockroachDB Icon
CockroachDB
Confluence Icon
Confluence
Cosmos DB Icon
Cosmos DB
Couchbase Icon
Couchbase
CouchDB Icon
CouchDB
CSV Icon
CSV
Databricks Icon
Databricks
DB2 Icon
DB2
DocuSign Icon
DocuSign
Dropbox Icon
Dropbox
Dynamics 365 Icon
Dynamics 365
Dynamics 365 Business Central Icon
Dynamics 365 Business Central
Dynamics CRM Icon
Dynamics CRM
Dynamics GP Icon
Dynamics GP
Dynamics NAV Icon
Dynamics NAV
eBay Icon
eBay
eBay Analytics Icon
eBay Analytics
Elasticsearch Icon
Elasticsearch
Email Icon
Email
Epicor Kinetic Icon
Epicor Kinetic
Exact Online Icon
Exact Online
Excel Icon
Excel
Excel Online Icon
Excel Online
Facebook Ads Icon
Facebook Ads
FHIR Icon
FHIR
FreshBooks Icon
FreshBooks
Freshdesk Icon
Freshdesk
FTP Icon
FTP
GitHub Icon
GitHub
Gmail Icon
Gmail
Google Ad Manager Icon
Google Ad Manager
Google Ads Icon
Google Ads
Google Analytics Icon
Google Analytics
Google Calendar Icon
Google Calendar
Google Campaign Manager Icon
Google Campaign Manager
Google Cloud Storage Icon
Google Cloud Storage
Google Contacts Icon
Google Contacts
Google Data Catalog Icon
Google Data Catalog
Google Directory Icon
Google Directory
Google Drive Icon
Google Drive
Google Search Icon
Google Search
Google Sheets Icon
Google Sheets
Google Spanner Icon
Google Spanner
GraphQL Icon
GraphQL
Greenplum Icon
Greenplum
HBase Icon
HBase
HCL Domino Icon
HCL Domino
HDFS Icon
HDFS
Highrise Icon
Highrise
Hive Icon
Hive
HubSpot Icon
HubSpot
IBM Cloud Data Engine Icon
IBM Cloud Data Engine
IBM Cloud Object Storage Icon
IBM Cloud Object Storage
IBM Informix Icon
IBM Informix
Impala Icon
Impala
Jira Icon
Jira
Jira Service Desk Icon
Jira Service Desk
JSON Icon
JSON
Kintone Icon
Kintone
LDAP Icon
LDAP
LinkedIn Ads Icon
LinkedIn Ads
MailChimp Icon
MailChimp
MariaDB Icon
MariaDB
Marketo Icon
Marketo
MarkLogic Icon
MarkLogic
Microsoft Dataverse Icon
Microsoft Dataverse
Microsoft Exchange Icon
Microsoft Exchange
Microsoft OneDrive Icon
Microsoft OneDrive
Microsoft Planner Icon
Microsoft Planner
Microsoft Project Icon
Microsoft Project
Microsoft Teams Icon
Microsoft Teams
Monday.com Icon
Monday.com
MongoDB Icon
MongoDB
MYOB AccountRight Icon
MYOB AccountRight
nCino Icon
nCino
Neo4J Icon
Neo4J
NetSuite Icon
NetSuite
OData Icon
OData
Odoo Icon
Odoo
Office 365 Icon
Office 365
OneNote Icon
OneNote
Oracle Icon
Oracle
Oracle Eloqua Icon
Oracle Eloqua
Oracle Financials Cloud Icon
Oracle Financials Cloud
Oracle HCM Cloud Icon
Oracle HCM Cloud
Oracle Sales Icon
Oracle Sales
Oracle SCM Icon
Oracle SCM
Oracle Service Cloud Icon
Oracle Service Cloud
Outreach.io Icon
Outreach.io
Parquet Icon
Parquet
Paylocity Icon
Paylocity
PayPal Icon
PayPal
Phoenix Icon
Phoenix
Pipedrive Icon
Pipedrive
Power BI XMLA Icon
Power BI XMLA
Presto Icon
Presto
Quickbase Icon
Quickbase
QuickBooks Icon
QuickBooks
QuickBooks Online Icon
QuickBooks Online
QuickBooks POS Icon
QuickBooks POS
Raisers Edge NXT Icon
Raisers Edge NXT
Reckon Icon
Reckon
Reckon Accounts Hosted Icon
Reckon Accounts Hosted
Redis Icon
Redis
Redshift Icon
Redshift
REST Icon
REST
RSS Icon
RSS
Sage 200 Icon
Sage 200
Sage 300 Icon
Sage 300
Sage 50 UK Icon
Sage 50 UK
Sage Cloud Accounting Icon
Sage Cloud Accounting
Sage Intacct Icon
Sage Intacct
Salesforce Icon
Salesforce
Salesforce Marketing Icon
Salesforce Marketing
Salesforce Pardot Icon
Salesforce Pardot
Salesloft Icon
Salesloft
SAP Icon
SAP
SAP Business One Icon
SAP Business One
SAP BusinessObjects BI Icon
SAP BusinessObjects BI
SAP ByDesign Icon
SAP ByDesign
SAP Concur Icon
SAP Concur
SAP Fieldglass Icon
SAP Fieldglass
SAP HANA Icon
SAP HANA
SAP HANA XS Advanced Icon
SAP HANA XS Advanced
SAP Hybris C4C Icon
SAP Hybris C4C
SAP Netweaver Gateway Icon
SAP Netweaver Gateway
SAP SuccessFactors Icon
SAP SuccessFactors
SAS Data Sets Icon
SAS Data Sets
SAS xpt Icon
SAS xpt
SendGrid Icon
SendGrid
ServiceNow Icon
ServiceNow
SFTP Icon
SFTP
SharePoint Icon
SharePoint
SharePoint Excel Services Icon
SharePoint Excel Services
ShipStation Icon
ShipStation
Shopify Icon
Shopify
Smartsheet Icon
Smartsheet
Snowflake Icon
Snowflake
Spark Icon
Spark
Splunk Icon
Splunk
Square Icon
Square
Streak Icon
Streak
Stripe Icon
Stripe
Sugar CRM Icon
Sugar CRM
SuiteCRM Icon
SuiteCRM
SurveyMonkey Icon
SurveyMonkey
Sybase Icon
Sybase
Sybase IQ Icon
Sybase IQ
Tableau CRM Analytics Icon
Tableau CRM Analytics
Tally Icon
Tally
TaxJar Icon
TaxJar
Teradata Icon
Teradata
Tier1 Icon
Tier1
Trello Icon
Trello
TSheets Icon
TSheets
Twilio Icon
Twilio
Twitter Ads Icon
Twitter Ads
Veeva Icon
Veeva
Veeva CRM Icon
Veeva CRM
Wave Financial Icon
Wave Financial
WooCommerce Icon
WooCommerce
WordPress Icon
WordPress
Workday Icon
Workday
xBase Icon
xBase
Xero Icon
Xero
Xero WorkflowMax Icon
Xero WorkflowMax
XML Icon
XML
YouTube Analytics Icon
YouTube Analytics
Zendesk Icon
Zendesk
Zoho Books Icon
Zoho Books
Zoho Creator Icon
Zoho Creator
Zoho CRM Icon
Zoho CRM
Zoho Inventory Icon
Zoho Inventory
Zoho Projects Icon
Zoho Projects
Zuora Icon
Zuora
API Driver Icon
… Dozens More
(API Driver)




Powerful Enterprise-class Development Features

Full-featured and consistent SQL access to any supported data source through FireDAC



  • Seamless RAD Studio Integration

    Feature-rich high-performance Data Access Components that extend Delphi & C++Builder Apps with SaaS, NoSQL, & Big Data connectivity.

  • Pure FireDAC Components

    Based on FireDAC Universal Data Access for developing applications for multiple devices, connected to enterprise databases.

  • Replication and Caching

    Our replication and caching commands make it easy to copy data to local and cloud data store as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incemental updates to cached data.

  • String, Date, Numeric SQL Functions

    The driver includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Developer Friendly

    Full Design-time support for data operations directly from RAD Studio. Work with live data diectly from the IDE Data Explorer and FireDAC explorer.

  • Collaborative Query Processing

    Our drivers enhance the data source's capabiilities by additional client side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Easily Customizable and Configurable

    The data model exposed by our FireDAC Components can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.

  • Enterprise-class Secure Connectivity

    Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

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. User standard FireDAC components like TDFManager, TDFConnection, TDFQuery.

                    									FDConnection1.Name := 'code.product Connection';
                    									FDConnection1.DriverName := 'CData.Fire.code.product';
                    									with FDConnection1.Params as
                    									    TFDPhysCData code.product ConnectionDefParams do begin

                    									    ...
                    									end;

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

                    									...
                 

SQL-92 Compliant Queries


Write standard SQL queries with support for joins, updates, aggregation, and more. Our drivers compensate for features lacking in the source.

SELECT WITH INNER JOIN

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

AGGREGATE FUNCTIONS

								SELECT Name, AVG(AnnualRevenue) FROM code.table GROUP BY Name
                  

CRUD OPERATIONS

								UPDATE code.table SET Name='John' WHERE Id = @myId