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


Low-Code FireDAC Data Integration

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

RAD Studio Add On

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

Enterprise-Class Design

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

Data-Centric Architecture

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

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.



Contact Us
1010data
Access
Act CRM
Active Directory
Act-On
Acumatica
Adobe Analytics
Contact Us
ADP
Google Ads
Alfresco
Amazon Marketplace
Amazon S3
Athena
Authorize.Net
AWS Management
Azure Table
Azure Management
Basecamp
BigCommerce
BigQuery
Bing Ads
Bing Search
Blackbaud FE NXT
Box
Bugzilla
Contact Us
Bullhorn CRM
Cassandra
Cloudant
SAP Concur
Cosmos DB
Couchbase
CSV
Dynamics 365 Business Central
Dynamics 365 FinOp
Dynamics 365 Sales
Contact Us
DB2
Google Ad Manager
DigitalOcean
DocuSign
Google Campaign Manager
Dropbox
Contact Us
Dynamics AX
Dynamics CRM
Dynamics GP
Dynamics NAV
Amazon DynamoDB
eBay
EDGAR Online
Salesforce Einstein
Elasticsearch
Oracle Eloqua
Email
Epicor ERP
Evernote
Exact Online
Excel
Excel Online
Excel Services
Microsoft Exchange
FedEx
FreshBooks
FTP
Google Analytics
Contact Us
GitHub
Gmail
Google Calendar
Google Contacts
Google Directory
Google Drive
Google Search
Google Spanner
Greenplum
Google Sheets
HBase
Highrise
Hive
HPCC Systems
HubSpot
IBM Cloud SQL Query
Impala
Sage Intacct
Jira
JSON
Kintone
LDAP
Magento
MailChimp
MariaDB
Marketo
MarkLogic
Microsoft CDS
MongoDB
Microsoft Planner
Microsoft Project
Microsoft Teams
MYOB AccountRight
NetSuite
OData
Odoo
Office 365
OFX
OneNote
Open Exchange Rates
Oracle
Oracle Sales Cloud
Salesforce Pardot
PayPal
Phoenix
QuickBooks Online
QuickBooks POS
Quandl
QuickBooks
Reckon
Redis
Redshift
REST
RSS
Contact Us
Sage US
Sage Cloud Accounting
Sage 50 UK
Salesforce
Salesforce Marketing
SAP
SAP Business One
SAP Business One DI
SAP ByDesign
SAP Fieldglass
SAP Netweaver Gateway
SAP HANA
SAP Hybris C4C
SAP SuccessFactors
SendGrid
ServiceNow
SFTP
SharePoint
Shopify
Smartsheet
Snowflake
Spark
Splunk
Square
SQL Analysis Services
Streak
Stripe
Sugar CRM
SuiteCRM
SurveyMonkey
Sybase
Sybase IQ
Teradata
Trello
Twilio
UPS
USPS
Veeva
Veeva CRM
Wasabi
WooCommerce
WordPress
Xero WorkflowMax
xBase
Xero
XML
YouTube
YouTube Analytics
Zendesk
Zoho CRM

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