CData Software - Knowledge Base
Recent Articles
-
Build Dashboards with Microsoft Teams Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Teams data in DBxtra.
-
Automated Continuous JSON Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable JSON replication to Google Cloud SQL.
-
Access Live Guru Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Guru data through MCP integration.
-
Bind Live Basecamp Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Basecamp data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Getting Started with the CData ODBC Driver for ChartMogul
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ChartMogul.
-
Integrating Codex with MessageBird 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.
-
Publish Crystal Reports on DocuSign Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date DocuSign data.
-
Automated Continuous LeadDesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable LeadDesk replication to AlloyDB.
-
Publish Crystal Reports on FHIR Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FHIR data.
-
Replicate Google Translate Data from PowerShell
Write a quick PowerShell script to query Google Translate data. Use connectivity to the live data to replicate Google Translate data to SQL Server.
-
Create Phoenix-Connected Applications in Appsmith
Connect to Phoenix Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Phoenix data.
-
Automated Continuous Teamwork Replication to MySQL
Use CData Sync for automated, continuous, customizable Teamwork replication to MySQL.
-
Excel Spreadsheet Automation on Coda Data with the QUERY Formula
Pull data from Coda, automate spreadsheets, and more with the QUERY formula.
-
Build AI Agents with DocuSign Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live DocuSign data through CData Connect AI.
-
Automated Continuous Sugar CRM Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sugar CRM replication to MongoDB.
-
Manage Strava Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Strava.
-
Visualize Zoho Projects Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Projects data.
-
Connect SAP HANA to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP HANA with IBM WebSphere for seamless data integration and connectivity.
-
Build Data Flows from Parallel to SQL Server using SSIS
Easily back up Parallel data to SQL Server using the SSIS components for Parallel.
-
Access Live Hive Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Hive data from your Excel spreadsheets.
-
Query Shippo Data as a MySQL Database in Node.js
Execute MySQL queries against Shippo data from Node.js.
-
Prepare, Blend, and Analyze Testmonitor Data in Alteryx Designer (ODBC)
Build workflows to access live Testmonitor data for self-service data analytics.
-
Analyze MongoDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MongoDB data with the CData JDBC Driver for MongoDB.
-
Connect to Reply.io in SpagoBI
Create reports featuring live Reply.io data in SpagoBI Studio. Host Reply.io reports on SpagoBI Server.
-
Automated Continuous xBase Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable xBase replication to Apache Cassandra.
-
Connect EmailOctopus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live EmailOctopus data using the CData Python MCP Server.
-
How to connect Amazon QuickSight to Act-On Data
Create a connection to Act-On data in CData Connect AI and insert Act-On data into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate MailChimp Data to Multiple Databases
Replicate MailChimp data to disparate databases with a point-and-click configuration.
-
Process & Analyze ConvertKit Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ConvertKit Data.
-
Connect to Dynamics CRM from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Dynamics CRM data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating LangGraph with SAP ByDesign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SAP ByDesign data within automated workflows.
-
Autopilot Reporting in OBIEE with the Autopilot JDBC Driver
Deploy the Autopilot JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Google Cloud Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to SQLite.
-
Access Paddle Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Paddle data from HeidiSQL.
-
Object-Relational Mapping (ORM) with Front 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 Front data into a Java-based ORM framework, Hibernate.
-
Automated Continuous LinkedIn Ads Replication to Vertica
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Vertica.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for PhantomBuster
Provide connectivity to PhantomBuster data through an SAP BusinessObjects universe.
-
Connect to Paymo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Paymo data in Google Apps Script.
-
Connect to Telegram Data from PowerBuilder via JDBC
This article demonstrates how to access Telegram data from PowerBuilder using the Telegram JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Tavily Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Tavily data for you.
-
Analyze Live ConstantContact Data in SAS Viya
Use CData Connect AI to connect to ConstantContact data from SAS Viya and deploy self-service analytics using live ConstantContact data.
-
Import Real-Time Microsoft Entra ID Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Microsoft Entra ID data in ColdFusion.
-
Connecting GenSpark with Zoho CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zoho CRM data without any replication or custom integration required.
-
Connect to and Query SAP Netweaver Gateway Data in QlikView over ODBC
Create data visualizations with SAP Netweaver Gateway data in QlikView.
-
Add Box Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Box with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Demio Data from PowerBuilder via JDBC
This article demonstrates how to access Demio data from PowerBuilder using the Demio JDBC Driver.
-
Automated Continuous Square Replication to MySQL
Use CData Sync for automated, continuous, customizable Square replication to MySQL.
-
Integrate Clari Data in the Pentaho Report Designer
Publish reports based on Clari data in the Pentaho BI tool.
-
Integrate Google Analytics with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Analytics with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Analytics data.
-
Visualize HubDB Data in TIBCO Spotfire through ADO.NET
Integrate HubDB data into dashboards in TIBCO Spotfire.
-
How to connect to Moosend Data from IntelliJ
Integrate connectivity to Moosend data with wizards in IntelliJ.
-
Connect to Shippo Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shippo data using standard SQL.
-
Connect to Figshare Data in RazorSQL
Connect to Figshare from wizards and query Figshare data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Jumpseller Replication to Databricks
Use CData Sync for automated, continuous, customizable Jumpseller replication to Databricks.
-
Query Dynamics CRM Data in DataGrip
Create a Data Source for Dynamics CRM in DataGrip and use SQL to query live Dynamics CRM data.
-
How to Access Live SageHR Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SageHR enables you to integrate SageHR data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live MailChimp Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live MailChimp data without replication.
-
View Reports on Real-Time Tavily Data in Power BI Report Server
Use the CData ODBC Driver for Tavily to visualize Tavily data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Databricks Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Databricks data from your Excel spreadsheets.
-
Build MVC Applications with Connectivity to ServiceNow Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ServiceNow from an ASP.NET MVC application.
-
Connecting Agentforce with Amazon Marketplace Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Amazon Marketplace data for you.
-
Create JotForm Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time JotForm data access from reports, embedded analytics, and more.
-
DataBind Charts to Trello Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Trello data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build SendPulse-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SendPulse data and build SendPulse-connected web apps with Axios.
-
Integrate Live BambooHR Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live BambooHR data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Semantic Layer Views for Greenplum Data in APOS Live Data Gateway
Use the CData Connector for Greenplum in APOS Live Data Gateway to build Semantic Layer Views for Greenplum data.
-
Connect to SAS Data Sets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAS Data Sets data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Visualize Auth0 Data in TIBCO Spotfire through ADO.NET
Integrate Auth0 data into dashboards in TIBCO Spotfire.
-
A PostgreSQL Interface for Active Directory Data using the CData ODBC Driver
Use the SQL Gateway and Active Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous eBay Replication to AlloyDB
Use CData Sync for automated, continuous, customizable eBay replication to AlloyDB.
-
DataBind Charts to Highrise Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Highrise data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create a Data Access Object for Webex Data using JDBI
A brief overview of creating a SQL Object API for Webex data in JDBI.
-
Automated Continuous ClickTime Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickTime replication to Apache Cassandra.
-
Automated Continuous Google Translate Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Translate replication to SQLite.
-
Connect to HubSpot Data in CloverDX (formerly CloverETL)
Transfer HubSpot data using the visual workflow in the CloverDX data integration tool.
-
Integrating GitHub Copilot with Smartsheet 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.
-
How to connect to BenchmarkEmail Data with Squirrel SQL client
Connect to BenchmarkEmail data and execute queries in the Squirrel SQL Client.
-
Visualize Adobe Experience Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Experience Manager data.
-
How to Connect to Live Freshservice Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Freshservice data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Excel
Create an ODBC connection to Excel in Informatica and browse and transfer Excel data.
-
Replicate Multiple ZohoExpense Accounts
Replicate multiple ZohoExpense accounts to one or many databases.
-
Query Zoho Inventory Data as a MySQL Database in Node.js
Execute MySQL queries against Zoho Inventory data from Node.js.
-
Connect to SQL Server Data in CloverDX (formerly CloverETL)
Transfer SQL Server data using the visual workflow in the CloverDX data integration tool.
-
Integrate Neo4J Data into Power Automate Desktop using CData Connect
CData Connect for Neo4J Data enables you to integrate Neo4J data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Oracle Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Oracle replication to Apache Kafka.
-
Integrating Dynamics NAV Data in Talend Cloud Data Management Platform
Connect Dynamics NAV Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Dynamics NAV.
-
Model, Search, and Visualize Live SharePoint Data in ThoughtSpot
Use CData Connect AI to connect to live SharePoint data for modeling, searching, and visualizing.
-
Integrate Theia IDE with Live Impala Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Impala data from within the development environment.
-
Access Live Google Ad Manager Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Ad Manager data from your Google Sheets.
-
Connect to and Query Pushbullet Data in QlikView over ODBC
Create data visualizations with Pushbullet data in QlikView.
-
Integrate Dify with Live SAP Hybris C4C Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live SAP Hybris C4C data.
-
Create Optimizely-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Optimizely Data from OutSystems and build custom enterprise apps using live Optimizely data.
-
Query Live Toggl Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Toggl data through a conversational interface.
-
Connect to Microsoft Exchange Data in RapidMiner
Integrate Microsoft Exchange data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Box-Connected Nintex Workflows
Use CData Connect AI to connect to Box Data from Nintex Workflow Cloud and build custom workflows using live Box data.
-
Build AI Agents with Facebook Ads Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Facebook Ads data through CData Connect AI.
-
How to Create Power BI Visual Reports with Real-Time Okta Data
Use CData Power BI Connectors to visualize Okta data in Power BI.
-
Visualize Avro Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Avro data.
-
Connect to Mixpanel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Mixpanel as an External Source in Dremio.
-
Build Automated Zoom-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoom data and build automated workflows in Zapier.