Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →Connect live data from any source to any application
No data movement required
Enable live data access between the data sources and applications powering your business with standards-based connectors for ODBC, JDBC, and more — plugged directly into your tools.
Try them freeWhy CData Drivers & Data Connectors
![icon](../drivers/_img/icons/i_connect.png)
Connect to every application
Use the same SQL-based connectivity to access hundreds of data sources and applications.
![icon](../drivers/_img/icons/i_universal.png)
Access your data, your way ​
CData supports every major driver and adaptor technology, including ODBC, JDBC, ADO.NET, Python, Excel, SSIS, and more.
![icon](../drivers/_img/icons/i_performance.png)
Benefit from unmatched performance
Get blazing-fast access to data for BI, reporting, and data integration with highly optimized read/write performance.
![icon](../drivers/_img/icons/i_enterprise.png)
Get enterprise-level connectivity ​​
Over 7,000 of the world's largest enterprises rely on CData's tried-and-true connectivity tools, which boast features like dynamic metadata, caching, replication, remoting, and query pushdown.
Available data source connectors
Connect your BI, Analytics, ETL, & custom applications with any SaaS, NoSQL, or Big Data source.
![Access Icon](/ui/img/drivers/icon-access.png)
![Act CRM Icon](/ui/img/drivers/icon-actcrm.png)
![Act-On Icon](/ui/img/drivers/icon-acton.png)
![Active Directory Icon](/ui/img/drivers/icon-activedirectory.png)
![ActiveCampaign Icon](/ui/img/drivers/icon-activecampaign.png)
![Acumatica Icon](/ui/img/drivers/icon-acumatica.png)
![Adobe Analytics Icon](/ui/img/drivers/icon-adobeanalytics.png)
![Adobe Commerce Icon](/ui/img/drivers/icon-adobecommerce.png)
![ADP Icon](/ui/img/drivers/icon-adp.png)
![Airtable Icon](/ui/img/drivers/icon-airtable.png)
![AlloyDB Icon](/ui/img/drivers/icon-alloydb.png)
![Amazon Athena Icon](/ui/img/drivers/icon-athena.png)
![Amazon DynamoDB Icon](/ui/img/drivers/icon-dynamodb.png)
![Amazon Marketplace Icon](/ui/img/drivers/icon-amazonmarketplace.png)
![Amazon S3 Icon](/ui/img/drivers/icon-amazons3.png)
![Asana Icon](/ui/img/drivers/icon-asana.png)
![Authorize.Net Icon](/ui/img/drivers/icon-authorizedotnet.png)
![Avalara AvaTax Icon](/ui/img/drivers/icon-avalara.png)
![Avro Icon](/ui/img/drivers/icon-avro.png)
![Azure Active Directory Icon](/ui/img/drivers/icon-azureactivedirectory.png)
![Azure Analysis Services Icon](/ui/img/drivers/icon-azureanalysisservices.png)
![Azure Data Catalog Icon](/ui/img/drivers/icon-azuredatacatalog.png)
![Azure Data Lake Storage Icon](/ui/img/drivers/icon-azuredatalake.png)
![Azure DevOps Icon](/ui/img/drivers/icon-azuredevops.png)
![Azure Synapse Icon](/ui/img/drivers/icon-azuresynapse.png)
![Azure Table Icon](/ui/img/drivers/icon-azure.png)
![Basecamp Icon](/ui/img/drivers/icon-basecamp.png)
![BigCommerce Icon](/ui/img/drivers/icon-bigcommerce.png)
![BigQuery Icon](/ui/img/drivers/icon-bigquery.png)
![Bing Ads Icon](/ui/img/drivers/icon-bingads.png)
![Bing Search Icon](/ui/img/drivers/icon-bingsearch.png)
![Blackbaud FE NXT Icon](/ui/img/drivers/icon-blackbaudfenxt.png)
![Box Icon](/ui/img/drivers/icon-box.png)
![Bugzilla Icon](/ui/img/drivers/icon-bugzilla.png)
![Bullhorn CRM Icon](/ui/img/drivers/icon-bullhorncrm.png)
![Cassandra Icon](/ui/img/drivers/icon-cassandra.png)
![Certinia Icon](/ui/img/drivers/icon-certinia.png)
![Cloudant Icon](/ui/img/drivers/icon-cloudant.png)
![CockroachDB Icon](/ui/img/drivers/icon-cockroachdb.png)
![Confluence Icon](/ui/img/drivers/icon-confluence.png)
![Cosmos DB Icon](/ui/img/drivers/icon-cosmosdb.png)
![Couchbase Icon](/ui/img/drivers/icon-couchbase.png)
![CouchDB Icon](/ui/img/drivers/icon-couchdb.png)
![CSV Icon](/ui/img/drivers/icon-csv.png)
![Databricks Icon](/ui/img/drivers/icon-databricks.png)
![DB2 Icon](/ui/img/drivers/icon-db2.png)
![DocuSign Icon](/ui/img/drivers/icon-docusign.png)
![Dropbox Icon](/ui/img/drivers/icon-dropbox.png)
![Dynamics 365 Icon](/ui/img/drivers/icon-dynamics365.png)
![Dynamics 365 Business Central Icon](/ui/img/drivers/icon-d365businesscentral.png)
![Dynamics CRM Icon](/ui/img/drivers/icon-dynamicscrm.png)
![Dynamics GP Icon](/ui/img/drivers/icon-dynamicsgp.png)
![Dynamics NAV Icon](/ui/img/drivers/icon-dynamicsnav.png)
![eBay Icon](/ui/img/drivers/icon-ebay.png)
![eBay Analytics Icon](/ui/img/drivers/icon-ebayanalytics.png)
![Elasticsearch Icon](/ui/img/drivers/icon-elasticsearch.png)
![Email Icon](/ui/img/drivers/icon-email.png)
![EnterpriseDB Icon](/ui/img/drivers/icon-enterprisedb.png)
![Epicor Kinetic Icon](/ui/img/drivers/icon-epicorkinetic.png)
![Exact Online Icon](/ui/img/drivers/icon-exact.png)
![Excel Icon](/ui/img/drivers/icon-excel.png)
![Excel Online Icon](/ui/img/drivers/icon-excelonline.png)
![Facebook Icon](/ui/img/drivers/icon-facebook.png)
![Facebook Ads Icon](/ui/img/drivers/icon-facebookads.png)
![FHIR Icon](/ui/img/drivers/icon-fhir.png)
![FreshBooks Icon](/ui/img/drivers/icon-freshbooks.png)
![Freshdesk Icon](/ui/img/drivers/icon-freshdesk.png)
![FTP Icon](/ui/img/drivers/icon-ftp.png)
![GitHub Icon](/ui/img/drivers/icon-github.png)
![Gmail Icon](/ui/img/drivers/icon-gmail.png)
![Google Ad Manager Icon](/ui/img/drivers/icon-dfp.png)
![Google Ads Icon](/ui/img/drivers/icon-adwords.png)
![Google Analytics Icon](/ui/img/drivers/icon-ganalytics.png)
![Google Calendar Icon](/ui/img/drivers/icon-googlecalendar.png)
![Google Campaign Manager Icon](/ui/img/drivers/icon-doubleclick.png)
![Google Cloud Storage Icon](/ui/img/drivers/icon-googlecloudstorage.png)
![Google Contacts Icon](/ui/img/drivers/icon-googlecontacts.png)
![Google Data Catalog Icon](/ui/img/drivers/icon-googledatacatalog.png)
![Google Directory Icon](/ui/img/drivers/icon-googledirectory.png)
![Google Drive Icon](/ui/img/drivers/icon-googledrive.png)
![Google Search Icon](/ui/img/drivers/icon-googlesearch.png)
![Google Sheets Icon](/ui/img/drivers/icon-gsheets.png)
![Google Spanner Icon](/ui/img/drivers/icon-googlespanner.png)
![GraphQL Icon](/ui/img/drivers/icon-graphql.png)
![Greenplum Icon](/ui/img/drivers/icon-greenplum.png)
![HarperDB Icon](/ui/img/drivers/icon-harperdb.png)
![HBase Icon](/ui/img/drivers/icon-hbase.png)
![HCL Domino Icon](/ui/img/drivers/icon-domino.png)
![HDFS Icon](/ui/img/drivers/icon-hdfs.png)
![Highrise Icon](/ui/img/drivers/icon-highrise.png)
![Hive Icon](/ui/img/drivers/icon-hive.png)
![HubSpot Icon](/ui/img/drivers/icon-hubspot.png)
![IBM Cloud Data Engine Icon](/ui/img/drivers/icon-ibmclouddataengine.png)
![IBM Cloud Object Storage Icon](/ui/img/drivers/icon-ibmcloudobjectstorage.png)
![IBM Informix Icon](/ui/img/drivers/icon-ibminformix.png)
![Impala Icon](/ui/img/drivers/icon-impala.png)
![Instagram Icon](/ui/img/drivers/icon-instagram.png)
![JDBC-ODBC Bridge Icon](/ui/img/drivers/icon-bridge.png)
![Jira Icon](/ui/img/drivers/icon-jira.png)
![Jira Service Desk Icon](/ui/img/drivers/icon-jiraservicedesk.png)
![JSON Icon](/ui/img/drivers/icon-json.png)
![Kafka Icon](/ui/img/drivers/icon-kafka.png)
![Kintone Icon](/ui/img/drivers/icon-kintone.png)
![LDAP Icon](/ui/img/drivers/icon-ldap.png)
![LinkedIn Icon](/ui/img/drivers/icon-linkedin.png)
![LinkedIn Ads Icon](/ui/img/drivers/icon-linkedinads.png)
![MailChimp Icon](/ui/img/drivers/icon-mailchimp.png)
![MariaDB Icon](/ui/img/drivers/icon-mariadb.png)
![Marketo Icon](/ui/img/drivers/icon-marketo.png)
![MarkLogic Icon](/ui/img/drivers/icon-marklogic.png)
![Microsoft Dataverse Icon](/ui/img/drivers/icon-dataverse.png)
![Microsoft Entra ID Icon](/ui/img/drivers/icon-microsoftentraid.png)
![Microsoft Exchange Icon](/ui/img/drivers/icon-exchange.png)
![Microsoft OneDrive Icon](/ui/img/drivers/icon-onedrive.png)
![Microsoft Planner Icon](/ui/img/drivers/icon-msplanner.png)
![Microsoft Project Icon](/ui/img/drivers/icon-msproject.png)
![Microsoft Teams Icon](/ui/img/drivers/icon-msteams.png)
![Monday.com Icon](/ui/img/drivers/icon-monday.png)
![MongoDB Icon](/ui/img/drivers/icon-mongodb.png)
![MYOB AccountRight Icon](/ui/img/drivers/icon-myobaccountright.png)
![MySQL Icon](/ui/img/drivers/icon-mysql.png)
![nCino Icon](/ui/img/drivers/icon-ncino.png)
![Neo4J Icon](/ui/img/drivers/icon-neo4j.png)
![NetSuite Icon](/ui/img/drivers/icon-netsuite.png)
![OData Icon](/ui/img/drivers/icon-odata.png)
![Odoo Icon](/ui/img/drivers/icon-odoo.png)
![Office 365 Icon](/ui/img/drivers/icon-office365.png)
![OneNote Icon](/ui/img/drivers/icon-onenote.png)
![Oracle Icon](/ui/img/drivers/icon-oracledb.png)
![Oracle Eloqua Icon](/ui/img/drivers/icon-eloqua.png)
![Oracle Financials Cloud Icon](/ui/img/drivers/icon-oracleerp.png)
![Oracle HCM Cloud Icon](/ui/img/drivers/icon-oraclehcm.png)
![Oracle Sales Icon](/ui/img/drivers/icon-oraclesalescloud.png)
![Oracle SCM Icon](/ui/img/drivers/icon-oraclescm.png)
![Oracle Service Cloud Icon](/ui/img/drivers/icon-oracleservicecloud.png)
![Outreach.io Icon](/ui/img/drivers/icon-outreach.png)
![Parquet Icon](/ui/img/drivers/icon-parquet.png)
![Paylocity Icon](/ui/img/drivers/icon-paylocity.png)
![PayPal Icon](/ui/img/drivers/icon-paypal.png)
![Phoenix Icon](/ui/img/drivers/icon-phoenix.png)
![Pinterest Icon](/ui/img/drivers/icon-pinterest.png)
![Pipedrive Icon](/ui/img/drivers/icon-pipedrive.png)
![PostgreSQL Icon](/ui/img/drivers/icon-postgresql.png)
![Power BI XMLA Icon](/ui/img/drivers/icon-powerbixmla.png)
![Presto Icon](/ui/img/drivers/icon-presto.png)
![Quickbase Icon](/ui/img/drivers/icon-quickbase.png)
![QuickBooks Icon](/ui/img/drivers/icon-quickbooks.png)
![QuickBooks Online Icon](/ui/img/drivers/icon-qbonline.png)
![QuickBooks POS Icon](/ui/img/drivers/icon-qbpos.png)
![Raisers Edge NXT Icon](/ui/img/drivers/icon-raisersedgenxt.png)
![Reckon Icon](/ui/img/drivers/icon-reckon.png)
![Reckon Accounts Hosted Icon](/ui/img/drivers/icon-reckonaccountshosted.png)
![Redis Icon](/ui/img/drivers/icon-redis.png)
![Redshift Icon](/ui/img/drivers/icon-redshift.png)
![REST Icon](/ui/img/drivers/icon-rest.png)
![RSS Icon](/ui/img/drivers/icon-rss.png)
![Sage 200 Icon](/ui/img/drivers/icon-sage200.png)
![Sage 300 Icon](/ui/img/drivers/icon-sage300.png)
![Sage 50 UK Icon](/ui/img/drivers/icon-sageuk.png)
![Sage Cloud Accounting Icon](/ui/img/drivers/icon-sagecloudaccounting.png)
![Sage Intacct Icon](/ui/img/drivers/icon-intacct.png)
![Salesforce Icon](/ui/img/drivers/icon-salesforce.png)
![Salesforce Marketing Icon](/ui/img/drivers/icon-salesforcemarketing.png)
![Salesforce Marketing Cloud Account Engagement Icon](/ui/img/drivers/icon-salesforcemcae.png)
![Salesforce Pardot Icon](/ui/img/drivers/icon-pardot.png)
![Salesloft Icon](/ui/img/drivers/icon-salesloft.png)
![SAP Icon](/ui/img/drivers/icon-sap.png)
![SAP Ariba Procurement Icon](/ui/img/drivers/icon-saparibaprocurement.png)
![SAP Ariba Source Icon](/ui/img/drivers/icon-saparibasource.png)
![SAP Business One Icon](/ui/img/drivers/icon-sapbusinessone.png)
![SAP BusinessObjects BI Icon](/ui/img/drivers/icon-sapbusinessobjectsbi.png)
![SAP ByDesign Icon](/ui/img/drivers/icon-sapbydesign.png)
![SAP Concur Icon](/ui/img/drivers/icon-concur.png)
![SAP Fieldglass Icon](/ui/img/drivers/icon-sapfieldglass.png)
![SAP HANA Icon](/ui/img/drivers/icon-saphana.png)
![SAP HANA XS Advanced Icon](/ui/img/drivers/icon-saphanaxsa.png)
![SAP Hybris C4C Icon](/ui/img/drivers/icon-saphybris.png)
![SAP Netweaver Gateway Icon](/ui/img/drivers/icon-sapgateway.png)
![SAP SuccessFactors Icon](/ui/img/drivers/icon-sapsuccessfactors.png)
![SAS Data Sets Icon](/ui/img/drivers/icon-sasdatasets.png)
![SAS xpt Icon](/ui/img/drivers/icon-sasxpt.png)
![SendGrid Icon](/ui/img/drivers/icon-sendgrid.png)
![ServiceNow Icon](/ui/img/drivers/icon-servicenow.png)
![SFTP Icon](/ui/img/drivers/icon-sftp.png)
![SharePoint Icon](/ui/img/drivers/icon-sharepoint.png)
![SharePoint Excel Services Icon](/ui/img/drivers/icon-excelservices.png)
![ShipStation Icon](/ui/img/drivers/icon-shipstation.png)
![Shopify Icon](/ui/img/drivers/icon-shopify.png)
![SingleStore Icon](/ui/img/drivers/icon-singlestore.png)
![Slack Icon](/ui/img/drivers/icon-slack.png)
![Smartsheet Icon](/ui/img/drivers/icon-smartsheet.png)
![Snapchat Ads Icon](/ui/img/drivers/icon-snapchatads.png)
![Snowflake Icon](/ui/img/drivers/icon-snowflake.png)
![Spark Icon](/ui/img/drivers/icon-spark.png)
![Splunk Icon](/ui/img/drivers/icon-splunk.png)
![SQL Analysis Services Icon](/ui/img/drivers/icon-ssas.png)
![SQL Server Icon](/ui/img/drivers/icon-sql.png)
![SQLite Icon](/ui/img/drivers/icon-sqlite.png)
![Square Icon](/ui/img/drivers/icon-square.png)
![Streak Icon](/ui/img/drivers/icon-streak.png)
![Stripe Icon](/ui/img/drivers/icon-stripe.png)
![Sugar CRM Icon](/ui/img/drivers/icon-sugarcrm.png)
![SuiteCRM Icon](/ui/img/drivers/icon-suitecrm.png)
![SurveyMonkey Icon](/ui/img/drivers/icon-surveymonkey.png)
![Sybase Icon](/ui/img/drivers/icon-sybase.png)
![Sybase IQ Icon](/ui/img/drivers/icon-sybaseiq.png)
![Tableau CRM Analytics Icon](/ui/img/drivers/icon-tableaucrm.png)
![Tally Icon](/ui/img/drivers/icon-tally.png)
![TaxJar Icon](/ui/img/drivers/icon-taxjar.png)
![Teradata Icon](/ui/img/drivers/icon-teradata.png)
![Tier1 Icon](/ui/img/drivers/icon-tier1.png)
![TigerGraph Icon](/ui/img/drivers/icon-tigergraph.png)
![Trello Icon](/ui/img/drivers/icon-trello.png)
![Trino Icon](/ui/img/drivers/icon-trino.png)
![TSheets Icon](/ui/img/drivers/icon-tsheets.png)
![Twilio Icon](/ui/img/drivers/icon-twilio.png)
![Twitter Icon](/ui/img/drivers/icon-twitter.png)
![Twitter Ads Icon](/ui/img/drivers/icon-twitterads.png)
![Veeva Icon](/ui/img/drivers/icon-veeva.png)
![Veeva CRM Icon](/ui/img/drivers/icon-veevacrm.png)
![Wave Financial Icon](/ui/img/drivers/icon-wavefinancial.png)
![WooCommerce Icon](/ui/img/drivers/icon-woocommerce.png)
![WordPress Icon](/ui/img/drivers/icon-wordpress.png)
![Workday Icon](/ui/img/drivers/icon-workday.png)
![xBase Icon](/ui/img/drivers/icon-xbase.png)
![Xero Icon](/ui/img/drivers/icon-xero.png)
![Xero WorkflowMax Icon](/ui/img/drivers/icon-workflowmax.png)
![XML Icon](/ui/img/drivers/icon-xml.png)
![YouTube Analytics Icon](/ui/img/drivers/icon-youtubeanalytics.png)
![Zendesk Icon](/ui/img/drivers/icon-zendesk.png)
![Zoho Books Icon](/ui/img/drivers/icon-zohobooks.png)
![Zoho Creator Icon](/ui/img/drivers/icon-zohocreator.png)
![Zoho CRM Icon](/ui/img/drivers/icon-zohocrm.png)
![Zoho Inventory Icon](/ui/img/drivers/icon-zohoinventory.png)
![Zoho Projects Icon](/ui/img/drivers/icon-zohoprojects.png)
![Zuora Icon](/ui/img/drivers/icon-zuora.png)
![API Driver Icon](/ui/img/drivers/icon-apidriver.png)
(API Driver)
Data connectors vs. data virtualization for the cloud
With CData, you have the option of plugging data drivers directly into your apps for live access, or connecting them within a central cloud platform for data virtualization.
Data drivers & connectors
CData Drivers and Connectors offer direct, live connectivity between applications and data sources.
Features include:
- Support for hundreds of cloud and on-premises data sources
- Extends any application that supports common data interfaces like ODBC, JDBC, ADO.NET, etc.
- Direct point-to-point data connectivity
- Fully-embeddable and available for commercial distribution
Best for:
- One specific connection point
- On-prem or hybrid tech stack
Data virtualization for the cloud
CData Connect Cloud gives you the same powerful connectivity, plus the governance, security, and management features critical for scaling enterprises and cloud-native organizations.
Features include:
- Supports any cloud or hybrid cloud-accessible app or service
- Integrates with any on-prem application, as well as popular cloud applications and clients.
- Enables IT to configure once and connect from multiple applications from within one central platform
- Zero-maintenance data connectivity, with data source updates managed transparently
Best for:
- Many connection points
- Cloud-native (SaaS) tech stack
CData Drivers streamline reporting, data integration, and data management
Santa Clara University Connects to Workday to Visualize Historical Student Data
“It was going to be a real problem — pulling all this data out into Excel files, then having to join, manipulate, combine them. I'm sure if anybody works in data, you know that that process is prone to error. It would have been an unenviable process.”
— Conor Roycroft
Director of Institutional Research, Santa Clara University
Read case study
![Santa Clara UNiversity logo](/drivers/_img/casestudy/logo_santa-clara.png)
BJ's Wholesale Club Improves Employee Retention by Over 10% with CData
“CData has definitely made our lives easier, because now we have 1,500 leaders in the field that we need to disseminate data to. And we do that through Tableau today. Getting that data from Workday to those users easily wouldn't be possible without CData.”
— Chris Arnold
BJ's Wholesale Club Senior Director of Analytics, Clubs & Online
Read case study
![BJ's Wholesale Club logo](/drivers/_img/casestudy/logo_bjs.png)
Office Depot Leans on CData to 'Lift & Shift' Critical Data and Enable Analytics Integration
“In a very short amount of time we had the drivers installed, working, and building our analytics cubes on a daily basis. We installed the driver, we pointed the cubes at Snowflake using the driver, and we were up and going.”
— Terry Campbell
Office Depot Sr. IT Manager
Read case study
![Office Depot logo](/drivers/_img/casestudy/logo_officedepot.png)
Technical features
Connect any application to any data source
Broad access to hundreds of enterprise data sources, including every accounting or collaboration tool, CRM, ERP, marketing automation platform, API, database, or data warehouse that matters to you.
Enable self-service data analytics and integration
Rapid data insights and agility, with frictionless access to operational data to support data scientists, business analysts, reporting, low-code developers, and other non-technical users.
Free IT resources from building & maintaining custom integrations.
Eliminate architectural complexity. Stop coding integrations against one-off API and continuously maintaining every single integration. Standards-based drivers provide a logical data layer of abstraction that shields you from the complexity of data access.
Deliver next generation connected applications.
Simplify integration and speed solution delivery. CData Drivers eliminate the time and expense of integrating disparate systems allowing developers to simplify architectural complexity and build connected applications more quickly.
Easily customizable and configurable
The data model exposed by CData Drivers 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.
Certified compatibility*
CData Drivers and data connectors undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.
*Please visit our knowledge base to access how-to articles.
Embedded SQL engine
All CData Drivers include a highly evolved client-side query execution engine with full support for SQL-92 operations that are not available at the data source. The drivers seamlessly handle converting SQL queries into an optimized set of instructions for each data source. Any data manipulation that cannot be pushed to the data source is handled transparently via the embedded engine.
Read/write operations (CRUD support)
Whenever possible, drivers include full support for read and write operations with each data source. Stored procedures are made available for data sources where APIs operations are not easily modeled around table updates.
Pushdown, batch, & bulk operation
Pushdown query optimization pushes SQL operations down to the server whenever possible, increasing performance. High-performance features include streaming forward cursors for performance and BatchAPI for efficient INSERT/UPDATES.
Collaborative query processing
CData Drivers enhance the capabilities of each data source with additional client-side processing when needed to enable analytic summaries of data, such as SUM, AVG, MAX, MIN, etc.
Comprehensive metadata discovery
Full support for metadata provides extensive schema discovery capabilities. Explore tables, columns, keys, and more based on user identity.
String, date, numeric SQL functions
All CData Drivers include a library of 50+ functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
Enterprise-class, secure connectivity
Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
Frequently asked questions
Common questions about data connectors
What are data connectors?
Data connectors are software middlemen that act as bridges between different data sources and data destinations. They ferry information between various systems, allowing them to talk to each other and share data seamlessly. Connectors simplify the process of integrating data from multiple sources, saving time and effort compared to manual data extraction and transformation.
What is the difference between a connector and a driver?
Data connectors and drivers are both related to data access and movement, but there are some key differences.
A connector is a software library, tool, or platform that facilitates the programmatic access to systems provided by APIs. Connectors try to make it easier for IT teams, developers and other data consumers to access the data. Unlike a driver, a Data Connector tends to offer connectivity tailored to a specific client application or use case.
Drivers, on the other hand, help establish a common semantic layer that simplifies the ingestion, curation, and orchestration of siloed data. Drivers create a common database abstraction on top of applications and data, leveraging established driver interfaces like JDBC, ODBC, and ADO.NET to standardize how applications connect with data. Leveraging a traditional database metaphor to support integration, Drivers provide tables, views, and stored procedures, that map to resources and operations exposed by each source. By piggybacking on universal database driver standards, Drivers act as a real-time universal translator between data consumers (Data Governance, Data Prep, Data Integration, Master Data Management, AI & ML, Data Catalog, Data Warehousing, Data Science, BI, Analytics, and even developer technologies like Low-code integration) and all the applications and data sources used across an organization.
Instead of having to code integrations against one-off APIs and continuously stay up to date on every single API change, standards-based drivers, provide a layer of abstraction and protection from the constantly shifting elements. Drivers offer a tactical approach, augmenting existing integration, processing, and analytics tooling to support broad data access capabilities
Learn more: Drivers vs. Connectors: Diving Deeper into Standards-Based Connectivity.