Enterprise Connectors with CData

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 180+ 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.
180+ 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.
Note: External app distribution requires a separate OEM agreement with CData. For OEM licensing options, contact CData sales.

Component Details
Examples

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

Supported Applications

Available in EC Professional
Available in EC Universal
* Coming soon

Accounting

Blackbaud FE NXT
Exact Online
FreshBooks
Freshdesk
MYOB AccountRight
Microsoft Dynamics GP
QuickBooks Desktop
QuickBooks Online
QuickBooks Point of Sale
Reckon
SAP Concur
Sage 50 UK
Sage Business Cloud Accounting
Sage Intacct
TSheets *
Xero Accounting
Zoho Books

CRM & Marketing

Act-On
Act CRM
Adobe Analytics
Bing Ads
Dynamics 365 Sales
Facebook Ads
Google Ad Manager
Google Ads
Google Analytics
Google Campaign Manager
Highrise CRM
HubSpot
Magento
MailChimp
Marketo
Microsoft Dynamics CRM
NetSuite CRM & ERP
Oracle Eloqua
Oracle Sales Cloud
SAP Hybris C4C
Salesforce & Force.com
Salesforce Marketing Cloud
Salesforce Pardot
SendGrid
Sugar CRM
SuiteCRM
Twitter Ads *
YouTube
YouTube Analytics
Zoho CRM

ERP & Collaboration

AWS Data Management
Acumatica ERP
Alfresco
Basecamp
BugZilla
DigitalOcean
DocuSign
Dynamics 365 Business Central
Dynamics 365 Finance & Ops
Dynamics 365 Sales
Epicor ERP
Evernote
FinancialForce *
Google Directory
Jira
Jira Service Desk *
Magento
Microsoft Dynamics GP
Microsoft Dynamics NAV
Microsoft Excel Online
Microsoft Exchange
Microsoft Office 365
Microsoft OneNote
Microsoft Planner
Microsoft Project
Microsoft SharePoint
Microsoft Teams
NetSuite CRM & ERP
Odoo ERP
SAP Business ByDesign
SAP Business One
SAP Business One DI
SAP NetWeaver
SAP SuccessFactors
ServiceNow
SharePoint Excel Services
Smartsheet
Splunk
SurveyMonkey
Tally ERP *
Trello
WordPress
Xero WorkflowMax
Zendesk

NoSQL & Big Data

Active Directory
Amazon Athena
Amazon DynamoDB
Amazon Redshift
Apache Cassandra
Apache HBase
Apache HDFS *
Apache Hive
Apache Parquet *
Apache Phoenix
Apache Spark SQL
Azure Analysis Services *
Azure Cosmos DB
Azure Data Catalog *
Azure Data Lake Storage *
Azure Table Storage
CockroachDB *
Couchbase
Elasticsearch
Google BigQuery
Google Data Catalog *
Google Spanner
HPCC Systems
IBM Cloud SQL Query
IBM Cloudant
MariaDB
MarkLogic
Microsoft Access
MongoDB
Oracle Database
Pivotal GreenPlum
Presto
Redis
SAP HANA
SAP HANA XS Advanced *
Snowflake
Sybase
Sybase IQ
Teradata
xBase

eCommerce/Finance

Amazon Marketplace
Authorize.Net
BigCommerce
Blackbaud FE NXT
EDGAR Online
FedEx
OFX
Open Exchange Rates
PayPal
Quandl
Shopify
Square
Stripe
UPS
USPS
WooCommerce
X-Cart *
eBay

Docs & Files

Apache HDFS *
Apache Parquet *
CSV/TSV Files
Google Sheets
Microsoft Excel
Microsoft Excel Online
SharePoint Excel Services
XML Files

Networking & Auth

Email
FTP Servers
JSON
LDAP
OData
OFX
REST
RSS Feeds
SFTP

Social Networking

Facebook
Instagram
LinkedIn
Pinterest
Salesforce Chatter
Slack
Twitter

REST Services

JSON
OData
REST

and more…

Alfresco
Amazon S3
Azure Data Management
Bing Search
Box
Dropbox
Gmail
Google Calendar
Google Contacts
Google Drive
Google Search

IBM Cloud Object Storage *
Kintone
Microsoft Common Data Service
Microsoft OneDrive
SAP Fieldglass
Salesforce Einstein Analytics
Twilio
Veeva Vault
Wasabi Object Storage

Enterprise Connectors Subscriptions

Professional

90+ Sources

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

Included in All Delphi, C++Builder and RAD Studio Enterprise and Architect Editions*

* 10.3 or higher

UNIVERSAL

180+ Sources

Comprehensive access to all FireDAC Drivers. Includes Additional Enterprise Sources

Download and Buy from C-Data

Easy install

Subscription key unlocks licensed functions.

Technical Support from CData.

click here to see information on CData's User License Agreement and Support

CData Enterprise Connectors

Easily Connect to Any Application with 180+ Enterprise Connectors