Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →
SQL Server Integration Guides and Tutorials
A list of guides and tutorials for connecting to and working with live SQL Server data.
CData Software's connectivity tools enable users to connect directly to live SQL Server data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live SQL Server data.
Integration Use-Cases
Click below to jump to articles related to specific integration use-case.
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (CData Sync, AWS Glue, Oracle Data Integrator, etc.)
- Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
- Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
- Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
- Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)
Business Intelligence & Analytics
ETL & Replication
Data Virtualization
| Product | Technology | Article Title |
|---|---|---|
| Access Linked Tables | ODBC | Update SQL Server with a Microsoft Access Linked Table |
| APOS Live Data Gateway | JDBC | Build Semantic Layer Views for SQL Server (JDBC) |
| APOS Live Data Gateway | Connect Cloud | Build Semantic Layer Views for SQL Server Data (Connect Cloud) |
| Denodo | JDBC | Create A Data Source for SQL Server in Denodo Platform |
| Dremio | JDBC | Connect to SQL Server as an External Source in Dremio |
| PostgreSQL FDW | JDBC | A PostgreSQL Interface for SQL Server |
| Salesforce Connect | Connect Cloud | Edit and Search SQL Server External Objects in Salesforce Connect |
| Salesforce External Services | Connect Cloud | Connect to SQL Server through External Services in Salesforce |
| TIBCO Data Virtualization | TIBCO DV | Access Live SQL Server Data in TIBCO Data Virtualization |
Software Development
Data Management
| Product | Technology | Article Title |
|---|---|---|
| Apache Solr | JDBC | Import SQL Server Data into Apache Solr |
| Coginiti Pro | JDBC | Access Live SQL Server Data in Coginiti Pro |
| DataGrip | JDBC | Qeury SQL Server Data in DataGrip |
| DB Artisan | JDBC | Manage SQL Server in DBArtisan as a JDBC Source |
| DB Artisan | ODBC | Connect to SQL Server in DBArtisan |
| DBeaver | JDBC | Connect to SQL Server in DBeaver |
| DbVisualizer | JDBC | Connect to SQL Server in DBVisualizer |
| Informatica Enterprise Data Catalog | JDBC | Add SQL Server to Informatica Enterprise Data Catalog |
| QuerySurge | JDBC | Validate SQL Server Data with QuerySurge |
| RazorSQL | JDBC | Connect to SQL Server in RazorSQL |
| SQuirreL | JDBC | Connect to SQL Server in Squirrel SQL Client |
Workflow Automation
| Product | Technology | Article Title |
|---|
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers