CData Software - Knowledge Base
Recent Articles
-
Connect to PayPal Data in NetBeans
Connect to PayPal data in NetBeans with the data source configuration wizard.
-
How to use SQLAlchemy ORM to access PolarTeamPro Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PolarTeamPro data.
-
Access Live GitHub Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GitHub data from your Excel spreadsheets.
-
Connect to Presto Data in Ruby
Connect to Presto data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to ZohoPeople Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZohoPeople data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to create HubSpot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for HubSpot data in MySQL .
-
Create Oracle Eloqua Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Oracle Eloqua data access from reports, embedded analytics, and more.
-
Connect to Google Search Results from a Connection Pool in Jetty
The Google Search JDBC Driver supports connection pooling: This article shows how to connect faster to Google Search results from Web apps in Jetty.
-
Build Google Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Ads data and build visualizations in Tableau Cloud.
-
How to Connect Oracle Financials Cloud 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 Oracle Financials Cloud data in real time using natural language.
-
Stream Adobe Experience Manager Data into Apache Kafka Topics
Access and stream Adobe Experience Manager data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Printify Replication to SingleStore
Use CData Sync for automated, continuous, customizable Printify replication to SingleStore.
-
Search External Moosend Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Moosend data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Moosend Data objects that you can access from apps and the dashboard.
-
Creating Act-On-Connected Applications in Unqork
You can use CData Connect AI to feed Act-On data to Unqork and build custom business apps.
-
Integrating LangGraph with PingOne Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on PingOne data within automated workflows.
-
Build Apps with Live Moosend Data Using the Low-Code Development Platform of Mendix
Connect Moosend data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Connect Flowise AI Agents to Live Coda Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Coda data without replication.
-
Write a Simple Go Application to work with SQL Server Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SQL Server data.
-
Connect to Exact Online Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Exact Online to connect to Exact Online data and execute queries in PowerBuilder.
-
How to Connect to Live Excel Online Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Excel Online data through natural language.
-
Integrating Claude Code CLI with Testmonitor 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.
-
DataBind Controls to Sage Intacct Data in Delphi
DataBind to Sage Intacct data in Delphi with standard data access components and controls.
-
Visualize QuickBooks Online Data in TIBCO Spotfire through ADO.NET
Integrate QuickBooks Online data into dashboards in TIBCO Spotfire.
-
Stream Brex Data into Apache Kafka Topics
Access and stream Brex data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Operational Reporting on Zoho Projects Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoho Projects data.
-
Build Agents in Relevance AI with Access to Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on FTP data within intelligent agent workflows.
-
Connecting Moonlit Workflow with Shortcut Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Shortcut data in real time.
-
Consume ServiceNow OData Feeds in PowerBuilder
This article demonstrates how to consume ServiceNow data as OData feeds from PowerBuilder using the API Server.
-
Write a Simple Go Application to work with MailerLite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to MailerLite data.
-
Build Pipelines with Live FTP Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to FTP from Google Cloud Data Fusion, enabling the integration of live FTP data into the building and management of effective data pipelines.
-
Automated Continuous iContact Replication to Databricks
Use CData Sync for automated, continuous, customizable iContact replication to Databricks.
-
How to Use a Microsoft Access Database to Update Basecamp Data in Real Time
Update Basecamp data by creating a linked table in Microsoft Access with the CData Basecamp ODBC Driver.
-
Easily Integrate Paymo Data in Lazarus Pascal IDE
Learn how to easily integrate live Paymo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Jumpseller Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Jumpseller data and build visualizations in Tableau.
-
Consume Reckon Accounts Hosted OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Reckon Accounts Hosted feeds that reflect any changes in SAP Lumira.
-
How to Connect to Live Zoom 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 Zoom data without replication.
-
Natively Connect to OneNote Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to OneNote data. Leverage the native support for ODBC in PHP.
-
Interact with Live iContact Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live iContact data.
-
Connect to and Visualize Live Gong Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gong data.
-
Prepare, Blend, and Analyze Brex Data in Alteryx Designer (ODBC)
Build workflows to access live Brex data for self-service data analytics.
-
Create Datasets from Redis in Domo Workbench and Build Visualizations of Redis Data in Domo
Use the CData Software ODBC Driver for Redis to create datasets from Redis data in Domo Workbench and then build visualizations in the Domo service.
-
Analyze JSON Services in Looker
Use CData Connect AI to connect to JSON Services from Looker and build custom apps using live JSON services.
-
Create Datasets from Jodoo in Domo Workbench and Build Visualizations of Jodoo Data in Domo
Use the CData Software ODBC Driver for Jodoo to create datasets from Jodoo data in Domo Workbench and then build visualizations in the Domo service.
-
Build Apollo-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Apollo Data from Zoho Analytics and import live Apollo data.
-
Create Reports with Impala Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Impala data.
-
Use Manus AI to Talk to Your Cosmos DB Data 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 Cosmos DB data.
-
Connect to ZohoExpense Data in Google Apps Script via Connect AI
Use CData Connect AI to access ZohoExpense data in Google Apps Script.
-
Google Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Analytics data through CData Connect AI using different applications and tools.
-
Build Amazon Athena-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Athena Data from Zoho Analytics and import live Amazon Athena data.
-
How to work with AdRoll Data in Apache Spark using SQL
Access and process AdRoll Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Customer.io Data in Pentaho Data Integration
Build ETL pipelines based on Customer.io data in the Pentaho Data Integration tool.
-
Connect to Gmail Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Gmail Data and connect to Gmail data in Akorbi Digital RunMyProcess.
-
Build a PostgreSQL Interface for Pipedrive Data using the CData JDBC Driver
Use the Remoting features of the Pipedrive JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to & Open Google Drive Data in Microsoft Excel
This article uses the CData ODBC driver for Google Drive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData Python Connector for Microsoft Entra ID
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Entra ID data.
-
Use the CData Software JDBC Driver for ClickTime in MicroStrategy
Connect to ClickTime data in MicroStrategy Developer using the CData Software JDBC Driver for ClickTime.
-
Connect to EmailOctopus Data in JRuby
Create a simple JRuby app with access to live EmailOctopus data.
-
How to Connect to Helpscout Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Helpscout data. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData SSIS Components for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Blackbaud FE NXT.
-
Query Live ADP Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ADP data directly from the development environment.
-
Connect to Mistral AI Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Mistral AI.
-
Getting Started with the CData SSIS Components for XML
Complete guide to installing, licensing, and connecting with the CData SSIS Components for XML.
-
How to Connect to Oracle Eloqua Reporting Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Eloqua Reporting data. Leverage the pyodbc module for ODBC in Python.
-
Query SAP HANA XS Advanced Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SAP HANA XS Advanced data from Node.js.
-
Visualize Lakebase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Lakebase data.
-
Configuring Oracle Autonomous Database as a CData Sync Destination
A basic guide to configuring Oracle Autonomous Database as a destination for enterprise replication in CData Sync.
-
Explore Geographical Relationships in iContact Data with Power Map
Create data visualizations with iContact data in Power Map.
-
Build Excel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Excel data and build web apps with connectivity to live Excel data.
-
How to Access Live Facebook Ads Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook Ads enables you to integrate Facebook Ads data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Redshift Data in Excel 365 Online (Excel for the web)
Connect to Redshift data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for Pipedrive in MicroStrategy Desktop
Connect to Pipedrive data in MicroStrategy Desktop using the CData Software ODBC Driver for Pipedrive.
-
Automated Continuous Vercel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Vercel replication to Amazon S3.
-
How to Connect to Live CapsuleCRM Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your CapsuleCRM data through natural language.
-
How to Easily Query Templated Data in OpenOffice Base
Connect to Templated data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Publish Salesforce CRM Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesforce CRM Analytics data.
-
Getting Started with the CData Connect AI Python SDK for Google Forms
Install the CData Connect AI Python SDK to read live Google Forms data with standard DB-API 2.0 Python code.
-
Connect to BigCommerce Data in ACL Analytics
Connect to BigCommerce data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to BigCommerce data.
-
Connect to Shopify Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Shopify data using standard SQL.
-
Build MVC Applications with Connectivity to ZohoExpense Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ZohoExpense from an ASP.NET MVC application.
-
Connect to Omnisend Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Omnisend data in Airbyte.
-
Edit and Search External Zendesk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Zendesk data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Zendesk Data objects that you can access from apps and the dashboard.
-
How to Access Blackbaud FE NXT Data Using Entity Framework
This article shows how to access Blackbaud FE NXT data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Eventbrite-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Eventbrite data.
-
Integrating Claude Code with Mailgun Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Mailgun data within assisted coding and automated development workflows.
-
Integrate Stack Exchange Data in the Pentaho Report Designer
Publish reports based on Stack Exchange data in the Pentaho BI tool.
-
Use Databricks Agent Bricks to Talk to Your ADP Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your ADP data for you.
-
Use JayDeBeApi to access Google Forms Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Forms data.
-
How to Seamlessly Import LeadDesk Data into IBM SPSS Modeler
Integrate LeadDesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Automated Workflows with Live Microsoft Ads Data in Workato
Use CData Connect AI to connect to live Microsoft Ads data and build automated workflows in Workato.
-
Automated Continuous Zuora Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zuora replication to Google BigQuery.
-
How to Connect to Live Raisers Edge NXT 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 Raisers Edge NXT data for you.
-
Easily Integrate Greenplum Data in Lazarus Pascal IDE
Learn how to easily integrate live Greenplum data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use JayDeBeApi to access Amplitude Data in Python
Use standard Python scripting and the development environment of your choice to access live Amplitude data.
-
Choosing the Best Method to Connect ZohoExpense to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoExpense data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Migrating data from Square to Snowflake using CData SSIS Components.
Easily push Square data to Snowflake using the CData SSIS Tasks for Square and Snowflake.
-
Connect to FreshBooks Data from a Connection Pool in Jetty
The FreshBooks JDBC Driver supports connection pooling: This article shows how to connect faster to FreshBooks data from Web apps in Jetty.
-
Replicate Microsoft Teams Data to Multiple Databases via the CData Sync CLI
Replicate Microsoft Teams data to disparate databases with a single configuration.
-
How to Connect to Live GraphQL Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live GraphQL data securely in real time.
-
Access HelloSign Data from MySQL in PHP
Connect to HelloSign through the standard MySQL libraries in PHP.
-
Automated Continuous Vercel Replication to SingleStore
Use CData Sync for automated, continuous, customizable Vercel replication to SingleStore.