SQL Server
 

Easy-to-use Drivers with Direct Mode access to Microsoft SQL Server databases.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



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 Amazon QuickSight: Build Interactive Dashboards from SQL Server in Amazon QuickSight Aqua Data Studio: Connect to SQL Server in Aqua Data Studio AWS Databricks: Process & Analyze SQL Server Data in Databricks (AWS) Azure Analysis Services: Model SQL Server Data Using Azure Analysis Services 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 Cognos Analytics (On-Prem): Analyze SQL Server Data in Cognos 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 Google Sheets: Access Live SQL Server in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with SQL Server Infragistics Reveal: Analyze SQL Server Data in Infragistics Reval 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 Klipfolio: Create SQL Server-Connected Visualizations in Klipfolio KNIME: Enable the SQL Server JDBC Driver in KNIME Looker: Analyze SQL Server in Looker Looker Studio: Create Reports from SQL Server in Looker Studio Metabase: Create Interactive SQL Server-Connected Metabase Dashboards Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula Microsoft Excel 365: Access Live SQL Server Data in Excel 365 MicroStrategy: Connect to Live SQL Server in MicroStrategy through Connect Cloud 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 Mode Analytics: Create SQL Server-Connected Visualizations in Mode OBIEE: SQL Server Reporting in OBIEE with the SQL Server JDBC Driver Pentaho Report Designer: Integrate SQL Server in the Pentaho Report Designer Power BI Service: Visualize Live SQL Server in the Power BI Service Qlik Cloud: Create Apps from SQL Server in Qlik Sense Cloud 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 SAP Analytics Cloud: Analyze SQL Server in SAP Analytics Cloud 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 SAS: Use the CData ODBC Driver for SQL Server in SAS for Real-Time Reporting and Analytics 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 Tableau Cloud: Build SQL Server Visualizations in Tableau Cloud TIBCO Spotfire Server: Operational Reporting on SQL Server from Spotfire Server Visio: Link Visio Shapes to SQL Server Zoho Analytics: Create SQL Server-Connect Dashboards in Zoho Analytics

ETL, Replication, & Warehousing


From drivers and adapters that extend your favorite ETL tools with SQL Server connectivity to ETL/ELT tools for replication — 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


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 NiFi: Bridge SQL Server Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with SQL Server Data in Apache NiFi AWS Glue: Connect to SQL Server in AWS Glue Jobs Azure Data Factory: Import SQL Server Data Using Azure Data Factory 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) Databricks: Automated Continuous SQL Server Replication to Databricks 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 HULFT Integrate: Connect to SQL Server in HULFT Integrate 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 Excel: Transfer Data from Excel to SQL Server Microsoft Power Automate: Build SQL Server-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL SQL Server in Oracle Data Integrator 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 Snowflake: Automated Continuous SQL Server Replication to Snowflake 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

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


MuleSoft Anypoint: Access SQL Server in Anypoint Using SQL Nintex Workflow Cloud: Build SQL Server-Connected Workflows in Nintex Power Automate: Integrate SQL Server into Power Automate Automated Tasks

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


.NET QueryBuilder: Rapidly Develop SQL Server-Driven Apps with Active Query Builder Apache Spark: Work with SQL Server in Apache Spark Using SQL AppSheet: Create SQL Server-Connected Business Apps in AppSheet Bubble.io: Build SQL Server-Connected Apps in Bubble Choreo: Build Custom Apps on SQL Server Data in Choreo ColdFusion: Query SQL Server in ColdFusion Using JDBC ColdFusion: Query SQL Server in ColdFusion Using ODBC 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 Google Apps Script: Connect to SQL Server in Google Apps Script 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 JRuby: Connect to SQL Server in JRuby Mendix: Build SQL Server-Connected Apps in Mendix Microsoft Power Apps: Integrate Live SQL Server into Custom Business Apps Built in Power Apps NodeJS: Query SQL Server in Node.js (via Connect Cloud) NodeJS: Query SQL Server through ODBC in Node.js OutSystems: Create SQL Server-Connected Enterprise Applications in OutSystems PHP: Natively Connect to SQL Server in PHP PyCharm: Using the CData ODBC Driver for SQL Server in PyCharm Python: Connect to SQL Server in Python on Linux/UNIX Ruby: Connect to SQL Server in Ruby RunMyProcess: Connect to SQL Server in RunMyProcess RunMyProcess DSEC: Connect to SQL Server in DigitalSuite Studio through RunMyProcess DSEC 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.





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:

Using the SQL Server Drivers