Easily build applications that read and write live data from popular on-premise & cloud data sources with RAD Studio
The fastest & easiest way to build data driven Apps. More than 200 FireDAC Connectors for Delphi & C++ Builder.
Built with the same reliability, scalability, performance & security powering leading data integration solutions.
A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more.
Standard Enterprise-class security features such as TLS/SSL encryption for client-server communications.
CDATA DRIVERS IN ACTION:
Feature-rich high-performance Data Access Components that extend Delphi & C++Builder Apps with SaaS, NoSQL, & Big Data connectivity.
Based on FireDAC Universal Data Access for developing applications for multiple devices, connected to enterprise databases.
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.
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.
Full Design-time support for data operations directly from RAD Studio. Work with live data diectly from the IDE Data Explorer and FireDAC explorer.
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.
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.
Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
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');
...
Write standard SQL queries with support for joins, updates, aggregation, and more. Our drivers compensate for features lacking in the source.
SELECT Events.Id, Events.Name, Events.Fax,
Opportunity.AccountId, Opportunity.CloseDate
FROM Events
INNER JOIN Opportunity
ON Events.Id = Opportunity.AccountId
SELECT Name, AVG(AnnualRevenue) FROM code.table GROUP BY Name
UPDATE code.table SET Name='John' WHERE Id = @myId
Our FireDAC Subscriptions offers comprehensive access to our FireDAC Driver technologies, giving FireDAC applications unprecedented connectivity with Applications, Databases, and Web APIs. Includes one year of free updates, upgrades, new releases, support, and connectivity with more than 200+ data sources.
