Embarcadero Logo
0

CData Enterprise Connectors

Easily Connect to Any Application with 100+ Enterprise Connectors

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 100+ 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.

Addon
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.

Sources
100+ Sources & Growing

Largest number of supported data sources in the industry. Subscriptions differ by data source coverage.

Realtime
Direct Real-Time Access

Direct real-time access to live data. No dependency on any cloud services or other intermediaries.

Royality Free
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.

Subscriptions

Developers Love Using Drivers for SaaS Integration

We liked that any engineers with RDBMS/SQL knowledge could use the CData Drivers without having to learn anything new. Being able to use standard SQL instead of APIs is awesome!

-- Takayuki Kobayashi, Manager, Fujitsu

Starting is as easy as 1..2..3!Download directly into the IDE using the GetIt package manager

  1. Download Trial from GetIt
  2. Open Samples
  3. Code!
Radimage

Available in RAD Studio 10.2 or above - Contact Sales to learn more

Component DetailsPowerful Enterprise-class Development Features

  • Developer Friendly: Full Design-time support for data operations directly from RAD Studio.
  • Replication and Caching: Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.
  • String, Date, Numeric SQL Functions: The components include a library of over 50 functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
  • Collaborative Query Processing: Our components enhance the data source's capabilities 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 DAC 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

ExamplesConnecting 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

Supported Applications

  • Available in Enterprise
  • Available in Enterprise+
  • * Coming soon

Accounting

  • Exact Online
  • FreshBooks Accounting
  • Intacct
  • Microsoft Dynamics GP
  • QuickBooks Desktop
  • QuickBooks Online
  • QuickBooks Point of Sale
  • Reckon
  • SAP Concur *
  • Sage 50 UK
  • Xero Accounting

CRM & Marketing

  • Act CRM
  • Bing Ads
  • DoubleClick Campaign Manager
  • DoubleClick For Publishers
  • Dynamics 365 Sales
  • Google AdWords
  • Google Analytics
  • Highrise CRM
  • HubSpot
  • Magento
  • MailChimp
  • Marketo
  • Microsoft Dynamics CRM
  • NetSuite CRM & ERP
  • Oracle Marketing Cloud
  • Oracle Sales Cloud
  • SAP Hybris C4C
  • Salesforce & Force.com
  • Salesforce Marketing Cloud *
  • SendGrid
  • Sugar CRM
  • SuiteCRM
  • YouTube
  • YouTube Analytics
  • Zoho CRM

ERP & Collaboration

  • Basecamp
  • Dynamics 365 Business Central
  • Dynamics 365 Finance & Operations
  • Dynamics 365 Sales
  • Google Directory
  • Jira
  • Magento
  • Microsoft Dynamics GP
  • Microsoft Dynamics NAV
  • Microsoft Excel Online
  • Microsoft Project
  • Microsoft SharePoint
  • NetSuite CRM & ERP
  • Office 365
  • SAP Business One
  • SAP ERP
  • ServiceNow
  • SharePoint Excel Services
  • Smartsheet.com
  • Splunk
  • SurveyMonkey
  • Zendesk *

NoSQL & Big Data

  • Amazon Athena
  • Amazon DynamoDB
  • Amazon Redshift
  • Apache Cassandra
  • Apache HBase
  • Apache Hadoop Hive
  • Apache Spark SQL
  • Azure Cosmos DB
  • Azure Table
  • Couchbase Server
  • Elasticsearch
  • Google BigQuery
  • HPCC Systems
  • IBM Cloudant NoSQL DB
  • Microsoft Access
  • Microsoft Active Directory
  • MongoDB
  • Redis
  • SQL Server Analysis Services *
  • xBase

eCommerce/Finance

  • Authorize.Net
  • E*TRADE
  • OFX Financial Accounts
  • Open Exchange Rates
  • PayPal
  • Quandl
  • Shopify
  • Square
  • Stripe
  • eBay

Docs & Files

  • CSV/TSV Files
  • Google Sheets
  • Microsoft Excel
  • Microsoft Excel Online
  • SharePoint Excel Services
  • XML Files

Networking & Auth

  • Email
  • FTP Servers
  • JSON Services
  • LDAP Directory Services
  • OData Services
  • OFX Financial Accounts
  • REST
  • RSS Feeds

Social Networking

  • Facebook
  • Instagram *
  • LinkedIn
  • Salesforce Chatter
  • Slack
  • Twitter

REST Services

  • JSON Services
  • OData Services
  • REST

and more…

  • Azure Management
  • Bing Search
  • Gmail
  • Google Calendar
  • Google Contacts
  • Google Search
  • kintone
  • Microsoft Exchange
  • Salesforce Einstein Analytics
  • Twilio
  • Available in Enterprise
  • Available in Enterprise+
  • * Coming soon

Get your subscription todaySubscription packages based on data source coverage.

Enterprise

60+

SOURCES

Virtually identical to the Enterprise+ Subscription, with a subset of available data sources

Buy Now

ENTERPRISE PLUS

100+

SOURCES

Comprehensive access to all FireDAC Drivers. Includes Additional Enterprise Sources

Buy Now
  1. Easy install from inside the IDE via the GetIt Package Manager
  2. Subscription key unlocks licensed functions.
  3. Technical Support from CData.

Click here to see information on User License Agreement and Support