Learn more
 

WordPress Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live WordPress 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 WordPress 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 WordPress in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live WordPress Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from WordPress Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live WordPress data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to WordPress in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze WordPress Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel WordPress Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of WordPress in Birst
BIRTJDBCDesign BIRT Reports on WordPress
Clear AnalyticsODBCBuild Charts with WordPress in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze WordPress Data in Cognos Analytics
DBxtraODBCBuild Dashboards with WordPress in DBxtra
DomoODBCCreate Datasets from WordPress in Domo Workbench
Dundas BIODBCBuild Dashboards with WordPress in Dundas BI
Excel (on Mac OS)ODBCWork with WordPress Data in MS Excel on Mac OS X
FineReportJDBCFeed WordPress into FineReport
Google SheetsConnect CloudAccess Live WordPress Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with WordPress
Infragistics RevealConnect CloudAnalyze WordPress Data in Infragistics Reval
JasperServerJDBCCreate WordPress Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to WordPress in Jaspersoft Studio
JReport DesignerJDBCIntegrate with WordPress in JReport Designer
KlipfolioConnect CloudCreate WordPress-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the WordPress JDBC Driver in KNIME
LINQPadADO.NETWorking with WordPress in LINQPad
LookerConnect CloudAnalyze WordPress Data in Looker
Looker StudioConnect CloudCreate Reports from WordPress Data in Looker Studio
MetabaseConnect CloudCreate Interactive WordPress-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live WordPress Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live WordPress Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from WordPress
MicroStrategyConnect CloudConnect to Live WordPress Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for WordPress in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for WordPress in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for WordPress in MicroStrategy Web
Mode AnalyticsConnect CloudCreate WordPress-Connected Visualizations in Mode
OBIEEJDBCWordPress Reporting in OBIEE with the WordPress JDBC Driver
pandasPythonUse pandas to Visualize WordPress in Python
Pentaho Report DesignerJDBCIntegrate WordPress in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time WordPress
Power BI ServiceConnect CloudVisualize Live WordPress Data in the Power BI Service
Power PivotConnect CloudAccess WordPress Data in Microsoft Power Pivot
Power QueryConnect CloudAccess WordPress Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from WordPress Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query WordPress in QlikView over ODBC
RJDBCAnalyze WordPress in R (JDBC)
RODBCAnalyze WordPress in R (ODBC)
RapidMinerJDBCConnect to WordPress in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live WordPress Data in Redash
SAP Analytics CloudConnect CloudAnalyze WordPress Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for WordPress
SAP Crystal ReportsJDBCPublish Reports with WordPress in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with WordPress in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for WordPress in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for WordPress in SAS JMP
SAS ViyaConnect CloudAnalyze Live WordPress Data in SAS Viya
SisenseJDBCVisualize Live WordPress in Sisense
Spago BIJDBCConnect to WordPress in SpagoBI
TableauTableauVisualize WordPress in Tableau Desktop
TableauConnect CloudVisualize WordPress in Tableau Desktop (Connect Cloud)
Tableau CloudConnect CloudBuild WordPress Visualizations in Tableau Cloud
Tableau ServerTableauPublish WordPress-Connected Dashboards in Tableau Server
ThoughtSpotConnect CloudModel, Search, and Visualize Live WordPress Data in ThoughtSpot
TIBCO SpotfireADO.NETVisualize WordPress in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize WordPress Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on WordPress from Spotfire Server
VisioODBCLink Visio Shapes to WordPress
Zoho AnalyticsConnect CloudCreate WordPress-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


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

Back to top

Data Virtualization


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

Back to top

Software Development


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

Back to top

Data Management


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

Back to top

Workflow Automation


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

Back to top

Ready to get started?

Learn more:

WordPress Connectivity Solutions

In this article

Related articles