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.
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 Enterprise
- Available in Enterprise+
- * Coming soon
Accounting
- Blackbaud FE NXT
- Exact Online
- FreshBooks
- Intacct
- Microsoft Dynamics GP
- QuickBooks Desktop
- QuickBooks Online
- QuickBooks Point of Sale
- Reckon
- SAP Concur *
- Sage 50 UK
- Xero Accounting
CRM & Marketing
- Act-On
- 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
- Veeva Vault *
- YouTube
- YouTube Analytics
- Zoho CRM
ERP & Collaboration
- AWS Data Management *
- Acumatica ERP
- Basecamp
- DigitalOcean *
- Dynamics 365 Business Central
- Dynamics 365 Finance & Ops
- Dynamics 365 Sales
- Evernote *
- Google Directory
- Jira
- Magento
- Microsoft Dynamics GP
- Microsoft Dynamics NAV
- Microsoft Excel Online
- Microsoft Exchange
- Microsoft Office 365
- Microsoft Project
- Microsoft SharePoint
- NetSuite CRM & ERP
- Odoo ERP
- SAP Business One
- SAP NetWeaver
- ServiceNow
- SharePoint Excel Services
- Smartsheet
- Splunk
- SurveyMonkey
- WordPress *
- Zendesk
NoSQL & Big Data
- Active Directory
- Amazon Athena
- Amazon DynamoDB
- Amazon Redshift
- Apache Cassandra
- Apache HBase
- Apache Hadoop Hive
- Apache Spark SQL
- Azure Cosmos DB
- Azure Table Storage
- Couchbase
- Elasticsearch
- Google BigQuery
- Google Spanner *
- HPCC Systems
- IBM Cloud SQL *
- IBM Cloudant
- MariaDB
- MarkLogic *
- Microsoft Access
- MongoDB
- Oracle Database *
- Pivotal GreenPlum *
- Redis
- SQL Analysis Services *
- Snowflake *
- Sybase *
- Teradata *
- xBase
eCommerce/Finance
- Amazon Marketplace
- Authorize.Net
- Blackbaud FE NXT
- E*TRADE
- OFX
- 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
- FTP Servers
- JSON
- LDAP
- OData
- OFX
- REST
- RSS Feeds
- SFTP
Social Networking
- Salesforce Chatter
- Slack
REST Services
- JSON
- OData
- REST
and more…
- Azure Data Management
- Bing Search
- Box
- Dropbox
- Gmail
- Google Calendar
- Google Contacts
- Google Drive
- Google Search
- Kintone
- Salesforce Einstein Analytics
- Twilio
Enterprise Connectors Subscriptions
Enterprise
70+ Sources
Virtually identical to the Enterprise+ Subscription, with a subset of available data sources
Included in All Enterprise and Architect Editions
ENTERPRISE PLUS
130+ 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 User License Agreement and Support
