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.
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 JOINSELECT Account.Id, Account.Name, Account.Fax,
Opportunity.AccountId, Opportunity.CloseDate
FROM Account
INNER JOIN Opportunity
ON Account.Id = Opportunity.AccountId
SELECT Name, AVG(AnnualRevenue) FROM Account GROUP BY Name
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
- FTP Servers
- JSON
- LDAP
- OData
- OFX
- REST
- RSS Feeds
- SFTP
Social Networking
- Salesforce Chatter
- Slack
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-DataEasy install
Subscription key unlocks licensed functions.
Technical Support from CData.
click here to see information on CData's User License Agreement and Support
