X-Cart Integration Guides and Tutorials

Ready to get started?

Learn more:

X-Cart Connectivity Solutions


A list of guides and tutorials for connecting to and working with live X-Cart data.

CData Software connectivity tools provide access to live X-Cart 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 X-Cart 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 X-Cart in Alteryx Designer
Amazon QuickSightCData ConnectBuild Interactive Dashboards from X-Cart in Amazon QuickSight
Aqua Data StudioJDBCConnect to X-Cart in Aqua Data Studio
BirstJDBCBuild Visualizations of X-Cart in Birst
BIRTJDBCDesign BIRT Reports on X-Cart
Clear AnalyticsODBCBuild Charts with X-Cart in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with X-Cart in DBxtra
DomoODBCCreate Datasets from X-Cart in Domo Workbench
Dundas BIODBCBuild Dashboards with X-Cart in Dundas BI
FineReportJDBCFeed X-Cart into FineReport
Google Data StudioCData ConnectCreate Reports from X-Cart in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with X-Cart
JasperServerJDBCCreate X-Cart Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to X-Cart in Jaspersoft Studio
JReport DesignerJDBCIntegrate with X-Cart in JReport Designer
KlipfolioCData ConnectCreate X-Cart-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the X-Cart JDBC Driver in KNIME
LINQPadADO.NETWorking with X-Cart in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time X-Cart
Power BI OnlineCData ConnectVisualize Live X-Cart in the Power BI Service
MetabaseCData ConnectCreate Interactive X-Cart-Connected Metabase Dashboards
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from X-Cart
MicroStrategyJDBCUse the CData JDBC Driver for X-Cart in MicroStrategy
OBIEEJDBCX-Cart Reporting in OBIEE with the X-Cart JDBC Driver
pandasPythonUse pandas to Visualize X-Cart in Python
Pentaho Report DesignerJDBCIntegrate X-Cart in the Pentaho Report Designer
QlikViewODBCConnect to and Query X-Cart in QlikView over ODBC
RJDBCAnalyze X-Cart in R
RapidMinerJDBCConnect to X-Cart in RapidMiner
RedashCData ConnectBuild X-Cart-Connected Dashboards in Redash
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for X-Cart
SAP Crystal ReportsJDBCPublish Reports with X-Cart in Crystal Reports
SAP LumiraAPI ServerConsume X-Cart OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for X-Cart in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live X-Cart in Sisense
Spago BIJDBCConnect to X-Cart in SpagoBI
TableauTableauVisualize X-Cart in Tableau Desktop
Tableau OnlineCData ConnectBuild X-Cart Visualizations in Tableau Online
Tableau ServerTableauPublish X-Cart-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize X-Cart in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on X-Cart from Spotfire Server
VisioODBCLink Visio Shapes to X-Cart

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous X-Cart Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous X-Cart Replication to Amazon S3
Apache CamelJDBCIntegrate with X-Cart using Apache Camel
Apache CassandraCData SyncAutomated Continuous X-Cart Replication to Apache Cassandra
Apache NiFiJDBCBridge X-Cart Connectivity with Apache NiFi
AWS GlueJDBCConnect to X-Cart in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate X-Cart to SQL Server
CloverDXJDBCConnect to X-Cart in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous X-Cart Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous X-Cart Replication to Databricks
IBM DB2CData SyncAutomated Continuous X-Cart Replication to IBM DB2
FoxProODBCWork with X-Cart in FoxPro
Google BigQueryCData SyncAutomated Continuous X-Cart Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous X-Cart Replication to Google Cloud SQL
Google Data FusionJDBCBuild X-Cart-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate X-Cart for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to X-Cart in HULFT Integrate
Informatica CloudJDBCIntegrate X-Cart in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for X-Cart
Jaspersoft ETLJDBCConnect to X-Cart in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous X-Cart Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous X-Cart Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to X-Cart
MongoDBCData SyncAutomated Continuous X-Cart Replication to MongoDB
MySQLCData SyncAutomated Continuous X-Cart Replication to MySQL
Oracle Data IntegratorJDBCETL X-Cart in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous X-Cart Replication to Oracle
petlPythonExtract, Transform, and Load X-Cart in Python
PostgreSQLCData SyncAutomated Continuous X-Cart Replication to PostgreSQL
Replicate to CSVPowerShellReplicate X-Cart to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous X-Cart Replication to Snowflake
SQL ServerCData SyncAutomated Continuous X-Cart Replication to SQL Server
SQLiteCData SyncAutomated Continuous X-Cart Replication to SQLite
TalendJDBCConnect to X-Cart and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to X-Cart in UiPath Studio
VerticaCData SyncAutomated Continuous X-Cart Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top