InterBase 2020 is here! Learn more

RAD Studio 10.3.2 is now available! Learn more

Looking for Discounts? Visit our Special Offers page

Renew your Update Subscription license now Read more

Enterprise Connectors

Make Connecting to Any Application as Easy as Connecting to a Database

Move, integrate, and analyze data with ease utilizing our NEW FireDAC Enterprise Connectors, powered by CData. These unparalleled components allow you to integrate 130+ Enterprise applications, simplifying connectivity into a standard model using SQL.

Data today is more decentralized than ever, not to mention difficult to access with the average company running upwards of 20+ SaaS applications, and at least as many on-premise applications. Make better business decisions, eliminate headaches and increase time to productivity by organizing vast amounts of data in an actionable format fast and efficiently with these drivers.



  • RAD STUDIO ADD-ON, Extend Delphi & C++ Builder Apps with SaaS, NoSQL, & Big Data Connectivity. The fastest & easiest way to build data driven Apps. Enterprise Connectors require Delphi, C++Builder or RAD Studio 10.2 Professional or higher.
  • 130+ Sources & Growing, Largest number of supported data sources in the industry. Subscriptions differ by data source coverage.
  • Direct Real-Time Access, Direct real-time access to live data. No dependency on any cloud services or other intermediaries.
  • Royalty-Free Distribution, Subscriptions are licensed per-developer with RF distribution. Upon ending of subscription term distribution rights continue, but rights to build will expire.
CData Subscriptions

Features

Powerful Enterprise-class Development Features

Replication and Caching:

Easily copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands allow for intelligent incremental updates to cached data.

Functions Library:

A library of over 50 string, date, and numeric SQL functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

Client-Side Processing:

Enhance the data source's capabilities with additional client-side query processing to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

Customizable:

Customize the data model to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using editable human-readable schema files.

Secure Connectivity:

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

Developer Friendly:

Full Design-time support for data operations directly from RAD Studio.

Examples

Connecting to Any Application 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 TFDManager, TFDConnection, TFDQuery, etc.

FDConnection1.Name := 'SalesforceConnection';

FDConnection1.DriverName := 'CData.Fire.Salesforce';

with FDConnection1.Params as

TFDPhysCDataSalesforceConnectionDefParams do begin

...

end;

FDConnection1.Connected := true;

FDQuery1.Active := true;

FDQuery1.Open('select * from Account where Industry = ''Healthcare''');

SQL-92 Compliant Queries

The easiest way to build data-centric applications. Write standard SQL queries with support for joins, updates, aggregation, and more.

SELECT with Inner JOIN

SELECT Account.Id, Account.Name, Account.Fax,

Opportunity.AccountId, Opportunity.CloseDate

FROM Account

INNER JOIN Opportunity

ON Account.Id = Opportunity.AccountId

Aggregate Functions

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

Update Data

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