Learn more
 

Ready to get started?

Learn more:

XML Connectivity Solutions

In this article

Related articles

XML Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live XML 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 XML 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 XML in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from XML Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to XML in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze XML Data in Databricks (AWS)
BirstJDBCBuild Visualizations of XML in Birst
BIRTJDBCDesign BIRT Reports on XML
Clear AnalyticsODBCBuild Charts with XML in Clear Analytics
DBxtraODBCBuild Dashboards with XML in DBxtra
DomoODBCCreate Datasets from XML in Domo Workbench
Dundas BIODBCBuild Dashboards with XML in Dundas BI
Excel (on Mac OS)ODBCWork with XML Data in MS Excel on Mac OS X
FineReportJDBCFeed XML into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with XML
Infragistics RevealConnect ServerAnalyze XML Data in Infragistics Reval
JasperServerJDBCCreate XML Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to XML in Jaspersoft Studio
JReport DesignerJDBCIntegrate with XML in JReport Designer
KlipfolioConnect ServerCreate XML-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the XML JDBC Driver in KNIME
LINQPadADO.NETWorking with XML in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from XML
MicroStrategyConnect ServerConnect to Live XML Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for XML in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for XML in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for XML in MicroStrategy Web
OBIEEJDBCXML Reporting in OBIEE with the XML JDBC Driver
pandasPythonUse pandas to Visualize XML in Python
Pentaho Report DesignerJDBCIntegrate XML in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time XML
Power BI ServiceConnect ServerVisualize Live XML Data in the Power BI Service
Power PivotConnect ServerAccess XML Data in Microsoft Power Pivot
Power QueryConnect ServerAccess XML Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from XML Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query XML in QlikView over ODBC
RJDBCAnalyze XML in R (JDBC)
RODBCAnalyze XML in R (ODBC)
RapidMinerJDBCConnect to XML in RapidMiner
RedashConnect ServerBuild XML-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze XML Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for XML
SAP Crystal ReportsJDBCPublish Reports with XML in Crystal Reports
SASODBCUse the CData ODBC Driver for XML in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for XML in SAS JMP
SisenseJDBCVisualize Live XML in Sisense
Spago BIJDBCConnect to XML in SpagoBI
TableauTableauVisualize XML in Tableau Desktop
Tableau CloudConnect ServerBuild XML Visualizations in Tableau Cloud
Tableau ServerTableauPublish XML-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize XML in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize XML Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on XML from Spotfire Server
VisioODBCLink Visio Shapes to XML

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous XML Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous XML Replication to Amazon S3
Apache AirflowJDBCBridge XML Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with XML using Apache Camel
Apache CassandraCData SyncAutomated Continuous XML Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous XML Replication to Apache Kafka
Apache NiFiJDBCBridge XML Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with XML Data in Apache NiFi
Azure Data LakeCData SyncAutomated Continuous XML Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous XML Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate XML to SQL Server
CloverDXJDBCConnect to XML in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous XML Replication to Couchbase
CSVCData SyncAutomated Continuous XML Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous XML Replication to Databricks
FoxProODBCWork with XML in FoxPro
Google AlloyDBCData SyncAutomated Continuous XML Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous XML Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous XML Replication to Google Cloud SQL
Google Data FusionJDBCBuild XML-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate XML for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to XML in HULFT Integrate
IBM DB2CData SyncAutomated Continuous XML Replication to IBM DB2
Informatica CloudJDBCIntegrate XML in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for XML
Jaspersoft ETLJDBCConnect to XML in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous XML Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous XML Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to XML
Microsoft Power AutomateConnect ServerBuild XML-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous XML Replication to MongoDB
MySQLCData SyncAutomated Continuous XML Replication to MySQL
Oracle Data IntegratorJDBCETL XML in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous XML Replication to Oracle
petlPythonExtract, Transform, and Load XML in Python
PostgreSQLCData SyncAutomated Continuous XML Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate XML to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous XML Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous XML Replication to SingleStore
SnapLogicJDBCIntegrate XML with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous XML Replication to Snowflake
SQL ServerCData SyncAutomated Continuous XML Replication to SQL Server
SQL Server Linked ServerConnect ServerConnect to XML Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous XML Replication to SQLite
TalendJDBCConnect to XML and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to XML in UiPath Studio
VerticaCData SyncAutomated Continuous XML Replication to a Vertica Database

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate XML with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for XML (JDBC)
DenodoJDBCCreate A Data Source for XML in Denodo Platform
DremioJDBCConnect to XML as an External Source in Dremio
MySQL Federated TablesODBCConnect to XML as Federated Tables in MySQL
Oracle DatabaseODBCAccess XML as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for XML
Salesforce ConnectConnect ServerEdit and Search XML External Objects in Salesforce Connect
SQL Server Linked ServersODBCConnect to XML as a Linked Server
SQL Server PolyBaseODBCConnect to XML as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live XML Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to XML
.NET QueryBuilderODBCRapidly Develop XML-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with XML
Apache SparkJDBCWork with XML in Apache Spark Using SQL
AppSheetConnect ServerCreate XML-Connected Business Apps in AppSheet
C++BuilderODBCDataBind Controls to XML Data in C++Builder
ColdFusionJDBCQuery XML in ColdFusion Using JDBC
ColdFusionODBCQuery XML in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on XML
DelphiODBCDataBind Controls to XML Data in Delphi
DevExpressADO.NETDataBind XML to the DevExpress Data Grid
EF - Code FirstADO.NETAccess XML with Entity Framework 6
EF - LINQADO.NETLINQ to XML
EF - MVCADO.NETBuild MVC Applications with Connectivity to XML
Filemaker ProODBCBidirectional Access to XML from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to XML from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with XML on Linux
Google Apps ScriptConnect ServerConnect to XML Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with XML Entities in Java
IntelliJJDBCConnect to XML in IntelliJ
JBossJDBCConnect to XML from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for XML using JDBI
JRubyJDBCConnect to XML in JRuby
Microsoft Power AppsConnect ServerIntegrate Live XML Data into Custom Business Apps Built in Power Apps
NodeJSConnect ServerQuery XML Data in Node.js (via Connect Server)
NodeJSODBCQuery XML through ODBC in Node.js
PHPConnect ServerAccess XML in PHP through Connect Server
PHPODBCNatively Connect to XML in PHP
PowerBuilderADO.NETConnect to XML from PowerBuilder
PowerShellPowerShellPipe XML to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for XML in PyCharm
PythonODBCConnect to XML in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with XML Data
RubyODBCConnect to XML in Ruby
RunMyProcessConnect ServerConnect to XML Data in RunMyProcess
RunMyProcess DSECJDBCConnect to XML in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to XML in SAPUI5 MVC Apps
ServoyJDBCBuild XML-Connected Apps in Servoy
Spring BootJDBCAccess Live XML Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access XML in Python
TomcatJDBCConfigure the CData JDBC Driver for XML in a Connection Pool in Tomcat
UnqorkConnect ServerCreate XML-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for XML
WebLogicJDBCConnect to XML from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport XML Data into Apache Solr
DB ArtisanJDBCManage XML in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to XML in DBArtisan
DBeaverJDBCConnect to XML in DBeaver
DbVisualizerJDBCConnect to XML in DBVisualizer
Informatica Enterprise Data CatalogJDBCAdd XML to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery XML Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery XML in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate XML Data with QuerySurge
RazorSQLJDBCConnect to XML in RazorSQL
SQuirreLJDBCConnect to XML in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess XML in Anypoint Using SQL
Nintex Workflow CloudConnect ServerBuild XML-Connected Workflows in Nintex
Power AutomateConnect ServerIntegrate XML Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to XML through SSIS
SSIS ImportSSISImport XML Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing XML Records from SQL Server

Back to top