Microsoft CDS Integration Guides and Tutorials

A list of guides and tutorials for connecting to and working with live Microsoft CDS data.

CData Software connectivity tools provide access to live Microsoft CDS data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Microsoft CDS data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Microsoft CDS in Alteryx Designer
Amazon QuickSightCloud HubBuild Interactive Dashboards from Microsoft CDS in Amazon QuickSight
Aqua Data StudioJDBCConnect to Microsoft CDS in Aqua Data Studio
BirstJDBCBuild Visualizations of Microsoft CDS in Birst
BIRTJDBCDesign BIRT Reports on Microsoft CDS
Clear AnalyticsODBCBuild Charts with Microsoft CDS in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with Microsoft CDS in DBxtra
DomoODBCCreate Datasets from Microsoft CDS in Domo Workbench
Dundas BIODBCBuild Dashboards with Microsoft CDS in Dundas BI
FineReportJDBCFeed Microsoft CDS into FineReport
Google Data StudioCloud HubCreate Reports from Microsoft CDS in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Microsoft CDS
JasperServerJDBCCreate Microsoft CDS Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Microsoft CDS in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Microsoft CDS in JReport Designer
KNIMEJDBCEnable the Microsoft CDS JDBC Driver in KNIME
LINQPadADO.NETWorking with Microsoft CDS in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Microsoft CDS
Power BI OnlineCloud HubVisualize Live Microsoft CDS in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Microsoft CDS
MicroStrategyJDBCUse the CData JDBC Driver for Microsoft CDS in MicroStrategy
OBIEEJDBCMicrosoft CDS Reporting in OBIEE with the Microsoft CDS JDBC Driver
Pentaho Report DesignerJDBCIntegrate Microsoft CDS in the Pentaho Report Designer
QlikViewODBCConnect to and Query Microsoft CDS in QlikView over ODBC
RJDBCAnalyze Microsoft CDS in R
RapidMiner JDBCConnect to Microsoft CDS in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft CDS
SAP Crystal ReportsJDBCPublish Reports with Microsoft CDS in Crystal Reports
SAP LumiraAPI ServerConsume Microsoft CDS OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for Microsoft CDS in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live Microsoft CDS in Sisense
Spago BIJDBCConnect to Microsoft CDS in SpagoBI
TableauODBCVisualize Microsoft CDS in Tableau
Tableau OnlineCloud HubBuild Microsoft CDS Visualizations in Tableau Online
Tableau ServerODBCPublish and Share Microsoft CDS Dashboards with Tableau Server
TIBCO SpotfireADO.NETVisualize Microsoft CDS in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Microsoft CDS from Spotfire Server
VisioODBCLink Visio Shapes to Microsoft CDS

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Microsoft CDS Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Microsoft CDS Replication to Amazon S3
Apache CassandraCData SyncAutomated Continuous Microsoft CDS Replication to Apache Cassandra
AWS GlueJDBCConnect to Microsoft CDS in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Microsoft CDS to SQL Server
CloverDXJDBCConnect to Microsoft CDS in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous Microsoft CDS Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous Microsoft CDS Replication to IBM DB2
FoxProODBCWork with Microsoft CDS in FoxPro
Google BigQueryCData SyncAutomated Continuous Microsoft CDS Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Microsoft CDS Replication to Google Cloud SQL
Google Data FusionJDBCPipe Microsoft CDS in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Microsoft CDS for Use in Salesforce Connect
Informatica CloudJDBCIntegrate Microsoft CDS in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Microsoft CDS
Jaspersoft ETLJDBCConnect to Microsoft CDS in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Microsoft CDS Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Microsoft CDS Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Microsoft CDS
MongoDBCData SyncAutomated Continuous Microsoft CDS Replication to MongoDB
MySQLCData SyncAutomated Continuous Microsoft CDS Replication to MySQL
Oracle Data IntegratorJDBCETL Microsoft CDS in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Microsoft CDS Replication to Oracle
PostgreSQLCData SyncAutomated Continuous Microsoft CDS Replication to PostgreSQL
Replicate to CSVPowerShellReplicate Microsoft CDS to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous Microsoft CDS Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Microsoft CDS Replication to SQL Server
SQLiteCData SyncAutomated Continuous Microsoft CDS Replication to SQLite
TalendJDBCConnect to Microsoft CDS and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Microsoft CDS in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Microsoft CDS
.NET QueryBuilderODBCRapidly Develop Microsoft CDS-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with Microsoft CDS
Apache SparkJDBCWork with Microsoft CDS in Apache Spark Using SQL
Microsoft Azure Logic AppsAPI ServerTrigger Microsoft CDS IFTTT Flows in Azure App Service
ColdFusionJDBCQuery Microsoft CDS in ColdFusion
DevExpressADO.NETDataBind Microsoft CDS to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Microsoft CDS with Entity Framework 6
EF - LINQADO.NETLINQ to Microsoft CDS
EF - MVCADO.NETBuild MVC Applications with Connectivity to Microsoft CDS
Filemaker ProJDBCBidirectional Access to Microsoft CDS from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Microsoft CDS on Linux
Google Apps ScriptCloud HubConnect to Microsoft CDS in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Microsoft CDS Entities in Java
IntelliJJDBCConnect to Microsoft CDS in IntelliJ
JBossJDBCConnect to Microsoft CDS from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Microsoft CDS using JDBI
JRubyJDBCConnect to Microsoft CDS in JRuby
NodeJSAPI ServerQuery Microsoft CDS from Node.js
NodeJSCloud HubQuery Microsoft CDS as a MySQL Database in Node.js
PHPCloud HubAccess Microsoft CDS in PHP through the Cloud Hub
PHPODBCNatively Connect to Microsoft CDS in PHP
PowerShellPowerShellPipe Microsoft CDS to CSV in PowerShell
PowerBuilderADO.NETConnect to Microsoft CDS from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Microsoft CDS in PyCharm
PythonODBCConnect to Microsoft CDS in Python on Linux/UNIX
RubyODBCConnect to Microsoft CDS in Ruby
SAP UI5API ServerIntegrate Real-Time Access to Microsoft CDS in SAPUI5 MVC Apps
TomcatJDBCConfigure the CData JDBC Driver for Microsoft CDS in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Microsoft CDS
WebLogicJDBCConnect to Microsoft CDS from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top