Learn more
 
SQL Server
 

SQL Server Drivers & Connectors
for Data Integration

Easy-to-use Drivers with Direct Mode access to Microsoft SQL Server databases. Easily integrate SQL Server data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon SQL Server Logo


Other Database Technologies

Other Database Drivers



Connect to Microsoft SQL Server Data from Anywhere!

Easily access live Microsoft SQL Server data from BI, Analytics, Reporting, ETL, & Custom Apps.







SQL Server Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time SQL Server data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to SQL Server data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations


Alteryx Designer: Prepare, Blend, and Analyze SQL Server in Alteryx Designer (ODBC) Aqua Data Studio: Connect to SQL Server in Aqua Data Studio AWS Databricks: Process & Analyze SQL Server Data in Databricks (AWS) Birst: Build Visualizations of SQL Server in Birst BIRT: Design BIRT Reports on SQL Server Clear Analytics: Build Charts with SQL Server in Clear Analytics DBxtra: Build Dashboards with SQL Server in DBxtra Domo: Create Datasets from SQL Server in Domo Workbench Dundas BI: Build Dashboards with SQL Server in Dundas BI Excel (on Mac OS): Work with SQL Server Data in MS Excel on Mac OS X FineReport: Feed SQL Server into FineReport IBM Cognos BI: Create Data Visualizations in Cognos BI with SQL Server JasperServer: Create SQL Server Reports on JasperReports Server Jaspersoft BI Suite: Connect to SQL Server in Jaspersoft Studio JReport Designer: Integrate with SQL Server in JReport Designer KNIME: Enable the SQL Server JDBC Driver in KNIME MicroStrategy: Use the CData JDBC Driver for SQL Server in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for SQL Server in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for SQL Server in MicroStrategy Web OBIEE: SQL Server Reporting in OBIEE with the SQL Server JDBC Driver Pentaho Report Designer: Integrate SQL Server in the Pentaho Report Designer Power Pivot: Access SQL Server Data in Microsoft Power Pivot QlikView: Connect to and Query SQL Server in QlikView over ODBC R: Analyze SQL Server in R (JDBC) R: Analyze SQL Server in R (ODBC) RapidMiner: Connect to SQL Server in RapidMiner Redash: Query, Visualize, and Share live SQL Server Data in Redash SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for SQL Server SAP Crystal Reports: Publish Reports with SQL Server in Crystal Reports (JDBC) SAP Crystal Reports: Publish Reports with SQL Server in Crystal Reports (Connect Cloud) SAS JMP: Use the CData ODBC Driver for SQL Server in SAS JMP Sisense: Visualize Live SQL Server in Sisense Spago BI: Connect to SQL Server in SpagoBI TIBCO Spotfire: Visualize SQL Server Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on SQL Server from Spotfire Server Visio: Link Visio Shapes to SQL Server

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with SQL Server connectivity to ETL/ELT tools for SQL Server data integration — our SQL Server integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with SQL Server to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations


Airbyte: Connect to SQL Server Data in Airbyte ELT Pipelines Amazon Redshift: Automated Continuous SQL Server Replication to Amazon Redshift Amazon S3: Automated Continuous SQL Server Replication to Amazon S3 Apache Airflow: Bridge SQL Server Connectivity with Apache Airflow Apache Camel: Integrate with SQL Server using Apache Camel Apache Cassandra: Automated Continuous SQL Server Replication to Apache Cassandra Apache Kafka: Automated Continuous SQL Server Replication to Apache Kafka Apache NiFi: Bridge SQL Server Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with SQL Server Data in Apache NiFi Azure Data Lake: Automated Continuous SQL Server Replication to Azure Data Lake Azure Synapse: Automated Continuous SQL Server Replication to Azure Synapse CloverDX: Connect to SQL Server in CloverDX (formerly CloverETL) Couchbase: Automated Continuous SQL Server Replication to Couchbase CSV: Automated Continuous SQL Server Replication to Local Delimited Files Databricks: Automated Continuous SQL Server Replication to Databricks ETL Validator: How to Work with SQL Server in ETL Validator FoxPro: Work with SQL Server in FoxPro Google AlloyDB: Automated Continuous SQL Server Replication to Google AlloyDB Google BigQuery: Automated Continuous SQL Server Replication to Google BigQuery Google Cloud SQL: Automated Continuous SQL Server Replication to Google Cloud SQL Google Data Fusion: Build SQL Server-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate SQL Server for Use in Salesforce Connect HULFT Integrate: Connect to SQL Server in HULFT Integrate IBM DB2: Automated Continuous SQL Server Replication to IBM DB2 Informatica Cloud: Integrate SQL Server in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for SQL Server Jaspersoft ETL: Connect to SQL Server in Jaspersoft Studio Microsoft Access: Automated Continuous SQL Server Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous SQL Server Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to SQL Server Microsoft Power Automate: Build SQL Server-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous SQL Server Replication to MongoDB Oracle Data Integrator: ETL SQL Server in Oracle Data Integrator Oracle Database: Automated Continuous SQL Server Replication to Oracle SAP HANA: Automated Continuous SQL Server Replication to SAP HANA SingleStore: Automated Continuous SQL Server Replication to SingleStore SnapLogic: Integrate SQL Server with External Services using SnapLogic (JDBC) SnapLogic: Integration with SQL Server Data in SnapLogic (Connect Cloud) Snowflake: Automated Continuous SQL Server Replication to Snowflake SQLite: Automated Continuous SQL Server Replication to SQLite Talend: Connect to SQL Server and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to SQL Server in UiPath Studio Vertica: Automated Continuous SQL Server Replication to a Vertica Database Zapier: Build Automated SQL Server-Connected Workflows in Zapier

Workflow & Automation Tools


Connect to SQL Server from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to SQL Server data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations


Developer Tools & Technologies


The easiest way to integrate with SQL Server from anywhere. Our SQL Server drivers offer a data-centric model for SQL Server that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations


AWS Lambda: Access Live SQL Server Data in AWS Lambda Axios: Build SQL Server-Connected Web Apps with Axios and CData Connect Cloud .NET QueryBuilder: Rapidly Develop SQL Server-Driven Apps with Active Query Builder Apache Spark: Work with SQL Server in Apache Spark Using SQL C++Builder: DataBind Controls to SQL Server Data in C++Builder ColdFusion: Query SQL Server in ColdFusion Using JDBC ColdFusion: Query SQL Server in ColdFusion Using ODBC Delphi: DataBind Controls to SQL Server Data in Delphi Filemaker Pro: Bidirectional Access to SQL Server from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to SQL Server from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with SQL Server on Linux Hibernate: Object-Relational Mapping (ORM) with SQL Server Entities in Java IntelliJ: Connect to SQL Server in IntelliJ JBoss: Connect to SQL Server from a Connection Pool in JBoss JDBI: Create a Data Access Object for SQL Server using JDBI Jitterbit: Integrate with Live SQL Server Data in Jitterbit JRuby: Connect to SQL Server in JRuby Mendix: Build SQL Server-Connected Apps in Mendix (JDBC) OutSystems: Create SQL Server-Connected Enterprise Applications in OutSystems PyCharm: Using the CData ODBC Driver for SQL Server in PyCharm Python: Connect to SQL Server in Python on Linux/UNIX RunMyProcess DSEC: Connect to SQL Server in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to SQL Server in SAPUI5 MVC Apps Servoy: Build SQL Server-Connected Apps in Servoy Spring Boot: Access Live SQL Server Data in Spring Boot Apps Tomcat: Configure the CData JDBC Driver for SQL Server in a Connection Pool in Tomcat Unqork: Create SQL Server-Connected Applications in Unqork WebLogic: Connect to SQL Server from a Connection Pool in WebLogic


When Only the Best SQL Server Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked SQL Server Driver Questions

Learn more about SQL Server drivers & connectors for data and analytics integration


Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with SQL Server, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData SQL Server driver offers full-featured SQL Server data connectivity. The CData SQL Server drivers support extensive SQL Server integration, providing access to all of the SQL Server data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all SQL Server data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

The SQL Server drivers and connectors offer comprehensive access to SQL Server data. Our SQL Server driver exposes static and dynamic data and metadata, providing universal access to SQL Server data for any enterprise analytics or data mangement use. To explore the SQL Server driver data model, please review the edition-specific SQL Server driver documentation.

Using the CData SQL Server drivers and connectors, SQL Server can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live SQL Server data connectivity. Explore some of the more popular SQL Server data integrations online.

Additionally, since SQL Server supported by CData Connect Cloud, we enable all kinds of new SQL Server cloud integrations.

SQL Server Analytics and SQL Server Cloud BI integration is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify SQL Server data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

SQL Server data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate SQL Server data any database or data warehouse, and maintain parity between systems with automated incremental SQL Server replication. In addition, our SQL Server drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. The best way to integrate SQL Server with Excel is by using the CData Connect Cloud Excel Add-In. The SQL Server Excel Add-In provides easy SQL Server integration directly from Microsoft Excel Desktop, Mac, or Web (Excel 365). Simply configure your connection to SQL Server from the easy-to-use cloud interface, and access SQL Server just like you would another native Excel data source.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below:

Product documentation
Get support