CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with WordPress using Tableau Bridge
The CData ODBC Driver for WordPress enables you to integrate live WordPress into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Splunk in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Splunk and connect to Splunk in Akorbi Digital RunMyProcess.
-
Access Live ServiceNow in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow from your Excel spreadsheets.
-
Connect to and Query Power BI XMLA in QlikView over ODBC
Create data visualizations with Power BI XMLA in QlikView.
-
Connect to SAP BusinessObjects BI in HULFT Integrate
Connect to SAP BusinessObjects BI as a JDBC data source in HULFT Integrate
-
Import Real-Time Microsoft Dataverse via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Dataverse (CDS) in ColdFusion.
-
Manage Salesforce Pardot in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Pardot.
-
How to work with Google Search Results in Apache Spark using SQL
Access and process Google Search Results in Apache Spark using the CData Software JDBC Driver.
-
Stream Wave Financial into Apache Kafka Topics
Access and stream Wave Financial in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect Flowise AI Agents to Live PostgreSQL via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live data without replication.
-
Access Live MarkLogic in AWS Lambda (with IntelliJ IDEA)
Connect to live MarkLogic in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous SAP Concur Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Concur replication to IBM DB2.
-
Create Dynamic Calendly Grids Using the Infragistics XamDataGrid
Learn how you can connect Calendly to Infragistics XamDataGrid to build dynamic grids.
-
Create Apps from Twilio in Qlik Sense Cloud
Use CData Connect AI to connect to Twilio and build apps from live Twilio in Qlik Sense Cloud.
-
Build Automated SAP BusinessObjects BI-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP BusinessObjects BI and build automated workflows in Zapier.
-
How to import WordPress into Apache Solr
Use the CData Software JDBC Driver for WordPress in Data Import Handler and create an automated import of WordPress to Apache Solr Enterprise Search platform.
-
Visualize WooCommerce in Tableau
The CData ODBC driver for WooCommerce enables you integrate WooCommerce into Tableau dashboards.
-
How to Connect DBeaver to Couchbase via a JDBC Driver
Manage Couchbase with visual tools in DBeaver like the query browser.
-
How to Access Live IBM Cloud Object Storage in Power Automate Desktop via ODBC
The CData ODBC Driver for IBM Cloud Object Storage enables you to integrate IBM Cloud Object Storage into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData JDBC Driver for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Projects.
-
How to Create Power BI Visual Reports with Real-Time Procore
Use CData Power BI Connectors to visualize Procore in Power BI.
-
Connect Sage Cloud Accounting to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sage Business Cloud Accounting using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Greenhouse Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Greenhouse data access from reports, embedded analytics, and more.
-
Integrate with Live Excel Online in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Excel Online from the MuleSoft Anypoint Platform to integrate live Microsoft Excel Online into custom reports and dashboards.
-
Connect to Google Analytics in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect Facebook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Amazon Marketplace as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon Marketplace as an External Source in Dremio.
-
Access Freshdesk in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Freshdesk.
-
Automated Continuous Azure Data Catalog Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Azure Data Catalog replication to Google Cloud SQL.
-
Operational Reporting on HDFS from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache HDFS.
-
Automated Continuous HBase Replication to SQL Server
Use CData Sync for automated, continuous, customizable HBase replication to SQL Server.
-
Process & Analyze Monday.com in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Monday.com .
-
Automated Continuous Google Campaign Manager 360 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to delimited files (CSV/TSV).
-
Build a Simple VCL Application for Zendesk
How to build a simple VCL Application to view Zendesk in RAD Studio using the CData ODBC Driver for Zendesk.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Analytics.
-
Create ShipStation-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ShipStation from OutSystems and build custom enterprise apps using live ShipStation.
-
Visualize Live SAP BusinessObjects BI in the Power BI Service
Use CData Connect AI to connect to live SAP BusinessObjects BI and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Vault CRM in DBxtra
Create dynamic dashboards and perform analytics based on Veeva Vault & Vault CRM in DBxtra.
-
How to load JSON data into Elasticsearch via Logstash
Introducing a simple method to load JSON data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Manus AI to Talk to Your Square via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Square.
-
Access Live SAP SuccessFactors LMS in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP SuccessFactors LMS in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Seamlessly Import TigerGraph Data into IBM SPSS Modeler
Integrate TigerGraph data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Visualize Square in TIBCO Spotfire through ADO.NET
Integrate Square into dashboards in TIBCO Spotfire.
-
Automate Bullhorn CRM Replication to Azure Synapse
Use CData Sync to customize and automate Bullhorn CRM replication to Azure Synapse.
-
Automated Continuous Google Contacts Replication to Microsoft Access
Use CData Sync for automated, continuous, customizable Google Contacts replication to Microsoft Access.
-
Connect to Acumatica from Crystal Reports
Use CData Connect AI to connect to and report on live Acumatica ERP from Crystal Reports.
-
Build Semantic Layer Views for Jira Service Management in APOS Live Data Gateway
Use the CData Connector for Jira Service Management in APOS Live Data Gateway to build Semantic Layer Views for Atlassian Jira Service Management.
-
LINQ to MarkLogic
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the MarkLogic Data Provider.
-
Automated Continuous Outreach.io Replication to SQL Server
Use CData Sync for automated, continuous, customizable Outreach.io replication to SQL Server.
-
Visualize Live Salesforce Pardot in the Power BI Service
Use CData Connect AI to connect to live Salesforce Pardot and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Quickbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Quickbase replication to Vertica.
-
Connect to Presto in Jaspersoft Studio
Execute SQL to remote Presto in Jaspersoft Studio.
-
How to import Cvent into Apache Solr
Use the CData Software JDBC Driver for Cvent in Data Import Handler and create an automated import of Cvent to Apache Solr Enterprise Search platform.
-
Import and Visualize Kintone in Power View
Create data visualizations based on Kintone in Excel.
-
Create SSAS Tabular Models from Google Contacts
How to build a SQL Server Analysis Service Tabular Model from Google Contacts using CData drivers.
-
Integrating LangChain with Oracle Eloqua via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Eloqua within automated workflows.
-
Use the CData Software ODBC Driver for Okta in MicroStrategy Web
Connect to Okta in MicroStrategy Web using the CData Software ODBC Driver for Okta.
-
Create Informatica Mappings From/To an ODBC Data Source for Parquet
Create an ODBC connection to Parquet in Informatica and browse and transfer Apache Parquet.
-
Connect to Kafka from a Connection Pool in JBoss
Integrate Apache Kafka into Java servlets: Use the Management Console in JBoss to install the Kafka JDBC Driver.
-
Access Live Azure Data Catalog in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Azure Data Catalog into the statistical analysis tools available in SAS JMP. This article shows how to use Azure Data Catalog in the Graph Builder and Query Builder.
-
Object-Relational Mapping (ORM) with Harvest Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Harvest into a Java-based ORM framework, Hibernate.
-
How to connect SharePoint with Jira through external lists
Provide Atlassian Jira to SharePoint users as an external list.
-
Use Microsoft Copilot Studio to talk to your WordPress via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your WordPress for you.
-
Create Dynamic Avalara AvaTax Grids Using the Infragistics XamDataGrid
Learn how you can connect Avalara AvaTax to Infragistics XamDataGrid to build dynamic grids.
-
Work with GraphQL in FoxPro
Load GraphQL into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Google Drive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Google Drive to connect to Google Drive from Web applications running on WebLogic.
-
Use ChatGPT to Talk to Your Slack via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Slack for you.
-
Access Live Zoho Projects in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Projects into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Projects in the Graph Builder and Query Builder.
-
Access Live Xero in AWS Lambda
Connect to live Xero Accounting in AWS Lambda using the CData JDBC Driver.
-
Build Semantic Layer Views for Impala in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Impala.
-
Connect to QuickBooks from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Desktop using standard SQL.
-
Query Google Drive using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Drive entities in PHP by modeling them as objects.
-
Integrate HubDB in Pentaho Data Integration
Build ETL pipelines based on HubDB in the Pentaho Data Integration tool.
-
Connect to SAP Hybris C4C in RazorSQL
Connect to SAP Hybris C4C from wizards and query SAP Hybris C4C from the GUI in the RazorSQL database management tool.
-
Enable the Salesforce JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesforce & Force.com.
-
Build Zuora-Powered Applications in Claude Code with CData Code Assist MCP
-