CData Software - Knowledge Base
Recent Articles
-
Access Live Harvest Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Harvest data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build AI/ML Models with Live Google Ad Manager Data using Dataiku
Connect Google Ad Manager Data with Dataiku using the CData JDBC Driver for Google Ad Manager.
-
Integrating GitHub Copilot with GitHub 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.
-
Automated Continuous CockroachDB Replication to Oracle
Use CData Sync for automated, continuous, customizable CockroachDB replication to Oracle.
-
Replicate FormSite Data in Heroku for Use in Salesforce Connect
Replicate FormSite data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Explore Geographical Relationships in LeadDesk Data with Power Map
Create data visualizations with LeadDesk data in Power Map.
-
Migrating data from Phoenix to Google BigQuery using CData SSIS Components.
Easily push Phoenix data to Google BigQuery using the CData SSIS Tasks for Phoenix and Google BigQuery.
-
Build a Simple VCL Application for Parallel Data
How to build a simple VCL Application to view Parallel data in RAD Studio using the CData ODBC Driver for Parallel.
-
Automated Continuous Oracle Sales Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQLite.
-
Integrate Live Excel Online Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Excel Online data from within the IDE.
-
Access Live PolarTeamPro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PolarTeamPro data into the statistical analysis tools available in SAS JMP. This article shows how to use PolarTeamPro data in the Graph Builder and Query Builder.
-
Analyze Freshdesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshdesk data with the CData JDBC Driver for Freshdesk.
-
Access Live Hive 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 Hive data through MCP integration.
-
How to Connect to Live Testmonitor Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Testmonitor data for you.
-
Build a PostgreSQL Interface for Perplexity Data using the CData JDBC Driver
Use the Remoting features of the Perplexity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live CockroachDB 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 CockroachDB data through MCP integration.
-
Visualize Power BI XMLA Data in Sisense
Create an ElastiCube in Sisense app with access to Power BI XMLA data.
-
Build Avro-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Avro Data from Zoho Analytics and import live Avro data.
-
Manage Bright Data Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bright Data.
-
Create Monday.com-Connected Applications in Appsmith
Connect to Monday.com Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Monday.com data.
-
Integrate Devin with Live FreshBooks 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 FreshBooks data.
-
Use Dash to Build to Web Apps on Stack Exchange Data
Create Python applications that use pandas and Dash to build Stack Exchange-connected web apps.
-
Integrating Claude Code with Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Klaviyo data within assisted coding and automated development workflows.
-
Build Charts with Zoom Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoom data in Clear Analytics.
-
Analyze SAP HANA XS Advanced Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP HANA XS Advanced data in Microsoft R Open.
-
How to Connect to Live HubDB 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 HubDB data for you.
-
Automated Continuous Azure Synapse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SQL Server.
-
Use the CData Software JDBC Driver for Asana in MicroStrategy Desktop
Connect to Asana data in MicroStrategy Desktop using the CData Software JDBC Driver for Asana.
-
Validate Dynamics 365 Data with QuerySurge
Access and validate Dynamics 365 data in QuerySurge using the CData JDBC Driver.
-
Connect to RSS Feeds in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for RSS Feeds and connect to RSS feeds in Akorbi Digital RunMyProcess.
-
Configure the CData JDBC Driver for BigQuery in a Connection Pool in Tomcat
Connect to BigQuery data from a connection pool in Tomcat.
-
Automate Parquet Data Replication to SAP HANA
Use CData Sync to customize and automate Parquet data replication to SAP HANA.
-
How to Connect Dynamics CRM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Dynamics CRM data in real time using natural language.
-
Access AlloyDB Data 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 AlloyDB data.
-
View Reports on Real-Time SAS Data Sets Data in Power BI Report Server
Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Contentful Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Contentful data to a JSON file on disk.
-
Create Jira-Connected Nintex Workflows
Use CData Connect AI to connect to Jira Data from Nintex Workflow Cloud and build custom workflows using live Jira data.
-
Connect to Helpscout Data from PowerBuilder via ADO.NET
This article demonstrates how to access Helpscout data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build MVC Applications with Connectivity to SAP HANA XS Advanced Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA XS Advanced from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Oracle Eloqua 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 Oracle Eloqua data into a Java-based ORM framework, Hibernate.
-
How to update Bitbucket from Excel
This article explains how to transfer data from Excel to Bitbucket using the Excel Add-In for Bitbucket.
-
Build AI Agents with Jumpseller 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 Jumpseller data through CData Connect AI.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LeadDesk
Provide connectivity to LeadDesk data through an SAP BusinessObjects universe.
-
Replicate Microsoft Ads Data to Multiple Databases
Replicate Microsoft Ads data to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in Dropbox Data with Power Map
Create data visualizations with Dropbox data in Power Map.
-
Connect and Query Live Power BI XMLA Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Power BI XMLA data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Dify with Live IBM Cloud Object Storage 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 IBM Cloud Object Storage data.
-
Excel Spreadsheet Automation on Paddle Data with the QUERY Formula
Pull data from Paddle, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Google Directory Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Directory replication to PostgreSQL.
-
Connect to LaunchDarkly Data in DBArtisan
Use wizards in DBArtisan to configure LaunchDarkly data as a data source.
-
How to Access Spark Data Using Entity Framework
This article shows how to access Spark data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Query Bannerbear Data in QlikView over ODBC
Create data visualizations with Bannerbear data in QlikView.
-
Analyze Twilio Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twilio data and visualize live Twilio data in Infragistics Reveal.
-
Connect AfterShip Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AfterShip data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Crystal Reports on Teamgate Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamgate data.
-
Query SAP Ariba Source Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Ariba Source entities in PHP by modeling them as objects.
-
Enable the SAS xpt JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAS xpt data.
-
Working with Codat Data in LINQPad
Execute LINQ queries to Codat data in LINQPad.
-
Access Amazon S3 Data from MySQL in PHP
Connect to Amazon S3 through the standard MySQL libraries in PHP.
-
Query DocuSign Data as a SQL Server Database in Node.js
Execute SQL Server queries against DocuSign data from Node.js.
-
Query Live Adobe Target 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 Adobe Target data through a conversational interface.
-
Connect to Live Freshservice Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshservice in CData Connect AI and connect to your Freshservice data from PostgreSQL.
-
Create Data Visualizations Based On SAP ByDesign Data in Mode
Use CData Connect AI to connect to SAP ByDesign Data from Mode and build visualizations using live SAP ByDesign data.
-
Create Power BI Reports on Real-Time Printify Data
Use the CData ODBC Driver for Printify to visualize Printify data in Power BI Desktop.
-
Create Datasets from Twilio in Domo Workbench and Build Visualizations of Twilio Data in Domo
Use the CData Software ODBC Driver for Twilio to create datasets from Twilio data in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with Pushbullet Data in Clear Analytics
Create dynamic charts and perform analytics based on Pushbullet data in Clear Analytics.
-
DataBind Controls to Jira Data in C++Builder
DataBind to Jira data in C++Builder with standard components and controls.
-
Automated Continuous Outreach.io Replication to MySQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to MySQL.
-
Bind Live Teradata Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Teradata data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Object-Relational Mapping (ORM) with Rebilly 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 Rebilly data into a Java-based ORM framework, Hibernate.
-
Integrating Dataiku with Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Splunk data.
-
Operational Reporting on Odoo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Odoo data.
-
Publish ZeroBounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZeroBounce data.
-
Connect Dotmailer to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dotmailer with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Open WebUI with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Sheets data from within the chat interface.
-
Getting Started with the CData JDBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SFTP.
-
Automate Guru Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Guru data from PowerShell? This article demonstrates how to utilize the Guru Cmdlets for tasks like connecting to Guru data, automating operations, downloading data, and more.
-
Getting Started with the CData Power BI Connector for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Open WebUI with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Splunk data from within the chat interface.
-
Integrate Dify with Live BambooHR 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 BambooHR data.
-
Use the CData ODBC Driver for LeadDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LeadDesk to connect to LeadDesk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LeadDesk data in Excel.
-
Access Opsgenie Data from MySQL in Amazon QuickSight
Connect to Opsgenie and build visualizations of Opsgenie data using a MySQL Connection in Amazon QuickSight.
-
Write a Simple Go Application to work with PayPal Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to PayPal data.
-
How to Build an ETL App for Retently Data in Python with CData
Create ETL applications and real-time data pipelines for Retently data in Python with petl.
-
Using the CData Software ODBC Driver for SFTP in PyCharm
Connect to SFTP as an ODBC data source in PyCharm using the CData Software ODBC Driver for SFTP.
-
Access Live Anaplan Data in AWS Lambda
Connect to live Anaplan data in AWS Lambda using the CData JDBC Driver.
-
Connect to Oracle Eloqua Reporting Data in Aqua Data Studio
Access Oracle Eloqua Reporting data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live SuiteCRM 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 SuiteCRM data without replication.
-
Connecting Pipedream with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP Hybris C4C data in real time.
-
How to import Templated Data into Apache Solr
Use the CData Software JDBC Driver for Templated in Data Import Handler and create an automated import of Templated data to Apache Solr Enterprise Search platform.
-
Provide OData Services of Paddle Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Paddle data by developing a WCF Service Application.
-
Use the CData Software JDBC Driver for Strava in MicroStrategy Desktop
Connect to Strava data in MicroStrategy Desktop using the CData Software JDBC Driver for Strava.
-
Connect to Everhour Data in Ruby
Connect to Everhour data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Goose with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP SuccessFactors data from within the local AI agent.
-
Integrate Live Demio Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Demio data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Analyze Highrise Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Highrise data with the CData JDBC Driver for Highrise.
-
How to connect to Google Drive Data with Squirrel SQL client
Connect to Google Drive data and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on IBM Informix Data
Create Python applications that use pandas and Dash to build IBM Informix-connected web apps.
-
Integrate Xero Data into Power Automate Desktop using CData Connect
CData Connect for Xero Data enables you to integrate Xero data into workflows built using Microsoft Power Automate Desktop.
-
Know Your LLM Series: Claude
Explore Anthropic Claude model family and learn how to pair it with CData Connect AI to securely enable natural-language, governed access to enterprise data.