CData Software - Knowledge Base
Recent Articles
-
Integrate with PostgreSQL Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy PostgreSQL data to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Search
Provide connectivity to Google Search results through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Close in MicroStrategy Desktop
Connect to Close data in MicroStrategy Desktop using the CData Software JDBC Driver for Close.
-
Query Google Calendar Data as a MySQL Database in Node.js
Execute MySQL queries against Google Calendar data from Node.js.
-
Build Guru-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Guru Data and create custom apps in Bubble.
-
How to work with ScrapingBee Data in Apache Spark using SQL
Access and process ScrapingBee Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous ConstantContact Replication to MongoDB
Use CData Sync for automated, continuous, customizable ConstantContact replication to MongoDB.
-
Connect to Cloudant Data from AWS Glue
Use CData Connect AI to gain access to live Cloudant data from your AWS Glue jobs.
-
Build a Singer.io Tap for Zoho Books With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Books data using the CData Python Connector.
-
Explore Geographical Relationships in Onfleet Data with Power Map
Create data visualizations with Onfleet data in Power Map.
-
Use the CData Software JDBC Driver for AlloyDB in MicroStrategy Desktop
Connect to AlloyDB data in MicroStrategy Desktop using the CData Software JDBC Driver for AlloyDB.
-
Connect BigQuery Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your BigQuery data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Visualize Live Marketo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Marketo data into custom reports in Power BI.
-
Analyze Live CockroachDB Data in SAS Viya
Use CData Connect AI to connect to CockroachDB data from SAS Viya and deploy self-service analytics using live CockroachDB data.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Web
Connect to Adobe Analytics data in MicroStrategy Web using the CData Software ODBC Driver for Adobe Analytics.
-
How to publish and share SAS xpt Data dashboards with Tableau Server
The CData ODBC driver for SAS xpt enables you integrate SAS xpt data into Tableau dashboards.
-
Use Azure AI Foundry to Talk to Your SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SQL Analysis Services data for you.
-
Validate SendPulse Data with QuerySurge
Access and validate SendPulse data in QuerySurge using the CData JDBC Driver.
-
How to import Billsby Data into Apache Solr
Use the CData Software JDBC Driver for Billsby in Data Import Handler and create an automated import of Billsby data to Apache Solr Enterprise Search platform.
-
Build Pipelines with Live Reckon Accounts Hosted Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Reckon Accounts Hosted from Google Cloud Data Fusion, enabling the integration of live Reckon Accounts Hosted data into the building and management of effective data pipelines.
-
Working with Webflow Data in LINQPad
Execute LINQ queries to Webflow data in LINQPad.
-
Connect to Cosmos DB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Cosmos DB data from Filemaker Pro on Mac.
-
Integrating Dataiku with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Facebook Ads data.
-
Automated Continuous Google Spanner Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Spanner replication to SQLite.
-
Use Claude to Talk to Your CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your CapsuleCRM data for you.
-
Automate SAS xpt Data Replication to Azure Synapse
Use CData Sync to customize and automate SAS xpt data replication to Azure Synapse.
-
Build Apps with Live VWO Data Using the Low-Code Development Platform of Mendix
Connect VWO data with Mendix to build apps using the CData API Driver for JDBC.
-
Rapidly Develop Zoho Books-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Zoho Books.
-
Load VWO Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load VWO data to a database.
-
Connect to Insightly Data in DBeaver
Use the CData ODBC Driver to connect to Insightly data in DBeaver.
-
Integrating Claude Code with Cosmos DB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cosmos DB data within assisted coding and automated development workflows.
-
Connect to Real-Time NASA Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use NASA data in Power Apps.
-
Create Informatica Mappings From/To an ODBC Data Source for Paddle
Create an ODBC connection to Paddle in Informatica and browse and transfer Paddle data.
-
Use the CData Software ODBC Driver for Oracle SCM in MicroStrategy Desktop
Connect to Oracle SCM data in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle SCM.
-
Automate Pipedrive Data Replication to Azure Data Lake
Use CData Sync to customize and automate Pipedrive data replication to Azure Data Lake.
-
Build AI/ML Models with Live MessageBird Data using Dataiku
Connect MessageBird Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Open WebUI with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Grafana data from within the chat interface.
-
Connect to Lakebase Data from PowerBuilder via JDBC
This article demonstrates how to access Lakebase data from PowerBuilder using the Lakebase JDBC Driver.
-
Connect to Redis Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Redis data in the Denodo Virtual DataPort Administrator.
-
Excel Spreadsheet Automation on ActiveCampaign Data with the QUERY Formula
Pull data from ActiveCampaign, automate spreadsheets, and more with the QUERY formula.
-
Connect to QuickBooks Time Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks Time data in DBeaver.
-
Visualize Live HubSpot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HubSpot data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Browserless Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Browserless data from Node.js.
-
Automated Continuous SAP Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP replication to Azure SQL Database.
-
Integrate with Zoho Projects Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Zoho Projects data in SnapLogic.
-
How to connect to Oracle Data from IntelliJ
Integrate connectivity to Oracle data with wizards in IntelliJ.
-
Create Dynamics NAV-Connected Business Apps in AppSheet
Connect to Dynamics NAV Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dynamics NAV data.
-
Build Semantic Layer Views for Toggl Data in APOS Live Data Gateway
Use the CData Connector for Toggl in APOS Live Data Gateway to build Semantic Layer Views for Toggl data.
-
Create SparkPost Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SparkPost from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to PhantomBuster Data from PowerBuilder via JDBC
This article demonstrates how to access PhantomBuster data from PowerBuilder using the PhantomBuster JDBC Driver.
-
Visualize BigQuery Data in TIBCO Spotfire through OData
Integrate BigQuery data into dashboards in TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with SAP Netweaver Gateway Data 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 SAP Netweaver Gateway data into a Java-based ORM framework, Hibernate.
-
Analyze Microsoft Exchange Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Microsoft Exchange data and visualize live Microsoft Exchange data in Infragistics Reveal.
-
Use CData Connect AI to Access ZohoMarketingHub Data in Microsoft Power Pivot
Use CData Connect AI to connect to live ZohoMarketingHub data in the Power Pivot business intelligence tool.
-
Create Dynamic Suadeo Grids Using the Infragistics XamDataGrid
Learn how you can connect Suadeo to Infragistics XamDataGrid to build dynamic grids.
-
Access Live Redshift Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Redshift data through MCP integration.
-
Build Cosmos DB-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Cosmos DB data.
-
How to Connect to Live Salesloft Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Salesloft data for you.
-
Integrate Devin with Live ZohoExpense Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live ZohoExpense data.
-
Analyze Live Microsoft Dataverse Data in SAS Viya
Use CData Connect AI to connect to Microsoft Dataverse data from SAS Viya and deploy self-service analytics using live Microsoft Dataverse data.
-
Model Power BI XMLA Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Power BI XMLA, enabling the direct import of real-time Power BI XMLA data.
-
Build a Singer.io Tap for Sugar CRM With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sugar CRM data using the CData Python Connector.
-
Query MYOB AccountRight Data in DataGrip
Create a Data Source for MYOB AccountRight in DataGrip and use SQL to query live MYOB AccountRight data.
-
How to Access Live Microsoft Dataverse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Microsoft Dataverse enables you to integrate Microsoft Dataverse data into workflows built using Microsoft Power Automate Desktop.
-
Validate Harvest Data with QuerySurge
Access and validate Harvest data in QuerySurge using the CData JDBC Driver.
-
Integrating LangChain with Bitbucket Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Bitbucket data within automated workflows.
-
Connect to SAS xpt Data in ACL Analytics
Connect to SAS xpt data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAS xpt data.
-
Create Informatica Mappings From/To a JDBC Data Source for Workable
Create Workable data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Reports with Stack Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stack Exchange data.
-
Feed HubDB Data into FineReport
How to set HubDB data as a JDBC data source in FineReport.
-
Replicate BenchmarkEmail Data in Heroku for Use in Salesforce Connect
Replicate BenchmarkEmail data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create ZohoInvoice-Connected Business Apps in AppSheet
Connect to ZohoInvoice Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ZohoInvoice data.
-
Query Contentful Data in DataGrip
Create a Data Source for Contentful in DataGrip and use SQL to query live Contentful data.
-
Connect to Microsoft Teams Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Teams data in Google Apps Script.
-
Connect to Teamgate Data in Aqua Data Studio
Access Teamgate data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to use SQLAlchemy ORM to access ClickTime Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ClickTime data.
-
How to connect to Codat Data from Spring Boot
Connect to Codat in a Spring Boot Application using the CData API Driver for JDBC
-
How to publish and share SharePoint Data dashboards with Tableau Server
The CData ODBC driver for SharePoint enables you integrate SharePoint data into Tableau dashboards.
-
Use ChatGPT to Talk to Your Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Google Campaign Manager 360 data for you.
-
Automated Continuous Perigon Replication to Snowflake
Use CData Sync for automated, continuous, customizable Perigon replication to Snowflake.
-
Build Azure Data Lake Storage Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Azure Data Lake Storage data and build visualizations in Tableau.
-
Consume Redis OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Redis feeds that reflect any changes in SAP Lumira.
-
DataBind Controls to ClickUp Data in Delphi
DataBind to ClickUp data in Delphi with standard data access components and controls.
-
Build Dashboards with Zoho Creator Data in Dundas BI
Create dynamic dashboards and perform analytics based on Zoho Creator data in Dundas BI.
-
Rapidly Develop MailerSend-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MailerSend.
-
Integrate LibreChat with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Xero data from within the chat interface.
-
Choosing the Best Method to Connect Sybase IQ to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sybase IQ data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Choosing the Best Method to Connect Helpscout to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Helpscout data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to SAP SuccessFactors LMS Data in DBeaver
Use the CData ODBC Driver to connect to SAP SuccessFactors LMS data in DBeaver.
-
Build Automated Slack-Connected Workflows in Zapier
Use CData Connect AI to connect to live Slack data and build automated workflows in Zapier.
-
Build SAP ByDesign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP ByDesign data and build visualizations in Tableau Cloud.
-
Replicate Adobe Analytics Data to Multiple Databases
Replicate Adobe Analytics data to disparate databases with a point-and-click configuration.
-
Create Avalara AvaTax-Connected Applications in Appsmith
Connect to Avalara AvaTax Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Avalara AvaTax data.
-
Create Freshteam Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Freshteam from PowerBI.com to create Power BI Dataflows with real-time data.
-
Interact with Live Trello Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Trello data.
-
Build Mode-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Mode Data from Zoho Analytics and import live Mode data.
-
Use the CData Software JDBC Driver for ActiveCampaign in MicroStrategy Desktop
Connect to ActiveCampaign data in MicroStrategy Desktop using the CData Software JDBC Driver for ActiveCampaign.
-
Integrating Claude Code CLI with eBay Analytics Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata - all without leaving the terminal.
-
Prepare, Blend, and Analyze ADP Data in Alteryx Designer (ODBC)
Build workflows to access live ADP data for self-service data analytics.
-
Automated Continuous WordPress Replication to Oracle
Use CData Sync for automated, continuous, customizable WordPress replication to Oracle.