CData Software - Knowledge Base
Recent Articles
-
Automated Continuous PayPal Replication to SQL Server
Use CData Sync for automated, continuous, customizable PayPal replication to SQL Server.
-
Easily Integrate Kintone Data in Lazarus Pascal IDE
Learn how to easily integrate live Kintone data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to ZohoDesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ZohoDesk data in Airbyte.
-
Connect to SAP HANA XS Advanced Data in HULFT Integrate
Connect to SAP HANA XS Advanced as a JDBC data source in HULFT Integrate
-
Connect to AdRoll Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for AdRoll data in the Denodo Virtual DataPort Administrator.
-
Create Informatica Mappings From/To a JDBC Data Source for MailChimp
Create MailChimp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automated BigCommerce Data Replication to Teradata
Use CData Sync to Customize and automate BigCommerce data replication to Teradata.
-
Build a Singer.io Tap for MailerLite With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MailerLite data using the CData Python Connector.
-
Create SSAS Tabular Models from Qualaroo Data
How to build a SQL Server Analysis Service Tabular Model from Qualaroo data using CData drivers.
-
Use the CData Software JDBC Driver for Samanage in MicroStrategy Web
Connect to Samanage data in MicroStrategy Web using the CData Software JDBC Driver for Samanage.
-
Connecting Moonlit Workflow with Dropbox 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 Dropbox data in real time.
-
Automated Continuous Cloudflare Replication to MongoDB
Use CData Sync for automated, continuous, customizable Cloudflare replication to MongoDB.
-
Publish Reports with Discourse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Discourse data.
-
Moving Data from Suadeo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Suadeo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData ODBC Driver for SharePoint from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to SharePoint data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SharePoint data in Excel.
-
Create Datasets from Act CRM in Domo Workbench and Build Visualizations of Act CRM Data in Domo
Use the CData Software ODBC Driver for Act CRM to create datasets from Act CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Use Biml to Build SSIS Tasks to Replicate Raisers Edge NXT Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Raisers Edge NXT data to SQL Server.
-
How to update Azure Synapse from Excel
This article explains how to transfer data from Excel to Azure Synapse using the Excel Add-In for Azure Synapse.
-
How to Connect to Live Teradata 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 Teradata data through natural language.
-
Access Office 365 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 Office 365 data.
-
How to Access Live Jira Assets Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Jira Assets enables you to integrate Jira Assets data into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for Monday.com
Create Monday.com data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Figshare-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Figshare data without replication.
-
How to work with Onfleet Data in Apache Spark using SQL
Access and process Onfleet Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Zoho Inventory Data in NetBeans
Connect to Zoho Inventory data in NetBeans with the data source configuration wizard.
-
Connect and Query Live SFTP Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SFTP data into Databricks and enable direct, live querying and analysis without replication.
-
Publish Crystal Reports on SAP Concur Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Concur data.
-
Build Semantic Layer Views for Gumroad Data in APOS Live Data Gateway
Use the CData Connector for Gumroad in APOS Live Data Gateway to build Semantic Layer Views for Gumroad data.
-
How to connect to CSV Data from Spring Boot
Connect to CSV in a Spring Boot Application using the CData JDBC Driver for CSV
-
Build HubDB-Connected Apps in Choreo
Use CData Connect AI to connect to HubDB Data from Choreo and build custom apps using live HubDB data.
-
Model, Search, and Visualize Live Vault CRM Data in ThoughtSpot
Use CData Connect AI to connect to live Vault CRM data for modeling, searching, and visualizing.
-
Automated Continuous Simplesat Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Simplesat replication to delimited files (CSV/TSV).
-
Build a Simple VCL Application for Wistia Data
How to build a simple VCL Application to view Wistia data in RAD Studio using the CData ODBC Driver for Wistia.
-
Connect to Hive Data in Google Apps Script via Connect AI
Use CData Connect AI to access Hive data in Google Apps Script.
-
Connect to MessageBird Data in RazorSQL
Connect to MessageBird from wizards and query MessageBird data from the GUI in the RazorSQL database management tool.
-
Connect to PayPal Data from HeidiSQL
Use CData Connect AI to connect to and query live PayPal data from HeidiSQL.
-
Wistia Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Wistia facts in real time.
-
How to import WooCommerce Data into Apache Solr
Use the CData Software JDBC Driver for WooCommerce in Data Import Handler and create an automated import of WooCommerce data to Apache Solr Enterprise Search platform.
-
Connect to MailerSend Data in HULFT Integrate
Connect to MailerSend as a JDBC data source in HULFT Integrate
-
Create Data Visualizations Based On IBM Cloud Object Storage Data in Mode
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Mode and build visualizations using live IBM Cloud Object Storage data.
-
Create Power BI Reports on Real-Time Scrapfly Data
Use the CData ODBC Driver for Scrapfly to visualize Scrapfly data in Power BI Desktop.
-
How to Connect to Live GraphQL Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your GraphQL data for you.
-
How to Query Phoenix Data in MySQL Workbench
Execute MySQL queries against live Phoenix data from MySQL Workbench.
-
Deploy the ADO.NET Provider for Act CRM on an SSRS Report Server
Connect to Act CRM data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use Agno to Talk to Your Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Salesforce Marketing data for you.
-
Automated Continuous Mode Replication to MySQL
Use CData Sync for automated, continuous, customizable Mode replication to MySQL.
-
Query SAP Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP data.
-
Getting Started with the CData Connect AI Python SDK for Sage Intacct
Install the CData Connect AI Python SDK to read and write live Sage Intacct data with standard DB-API 2.0 Python code.
-
Automated Continuous Facebook Ads Replication to Snowflake
Use CData Sync for automated, continuous, customizable Facebook Ads replication to Snowflake.
-
Automated Continuous Clari Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clari replication to Azure SQL Database.
-
Replicate Paymo Data in Heroku for Use in Salesforce Connect
Replicate Paymo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Seamlessly Import PhantomBuster Data into IBM SPSS Modeler
Integrate PhantomBuster data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Tableau Connector for Freshsales
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Establish a Live Connection with Presto Data using Tableau Bridge
The CData ODBC Driver for Presto enables you to integrate live Presto data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to OpenWeatherMap Data in NetBeans
Connect to OpenWeatherMap data in NetBeans with the data source configuration wizard.
-
Connect to SQL Server Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SQL Server to connect to SQL Server data and execute queries in PowerBuilder.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Marketo
Provide connectivity to Marketo data through an SAP BusinessObjects universe.
-
Integrate OpenCode with Live HDFS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live HDFS data from within your AI coding agent.
-
Automated Continuous Printful Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Printful replication to Google Cloud SQL.
-
Automated Continuous DocuSign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable DocuSign replication to Apache Cassandra.
-
Viewing Oracle SCM Data in RAD Studio Data Explorer
How to view Oracle SCM data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle SCM.
-
Natively Connect to Square Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Square data. Leverage the native support for ODBC in PHP.
-
Connecting Moonlit Workflow with Certinia 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 Certinia data in real time.
-
ETL Hubstaff in Oracle Data Integrator
This article shows how to transfer Hubstaff data into a data warehouse using Oracle Data Integrator.
-
Access Live Moosend Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Moosend data from your Google Sheets.
-
Use Dash to Build Web Apps on Sendwithus Data via CData Connect AI
Build interactive Dash web apps on live Sendwithus data using pandas and the CData Connect AI Python SDK.
-
Analyze SAS Data Sets Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAS Data Sets data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Visualize Lakebase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Lakebase data in Python.
-
Connect to Paylocity Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Paylocity data.
-
Query Front Data as a MySQL Database in Node.js
Execute MySQL queries against Front data from Node.js.
-
Automated Continuous Onfleet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Onfleet replication to Apache Cassandra.
-
Work with Mailjet Data in FoxPro
Load Mailjet data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Presto
Provide connectivity to Presto data through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Lakebase Data in ThoughtSpot
Use CData Connect AI to connect to live Lakebase data for modeling, searching, and visualizing.
-
Import Real-Time LeadDesk Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LeadDesk data in ColdFusion.
-
Excel Spreadsheet Automation on Amazon DynamoDB Data with the QUERY Formula
Pull data from Amazon DynamoDB, automate spreadsheets, and more with the QUERY formula.
-
Viewing CSV Data in RAD Studio Data Explorer
How to view CSV data in RAD Studio Data Explorer using the CData ODBC Driver for CSV.
-
Explore Geographical Relationships in CouchDB Data with Power Map
Create data visualizations with CouchDB data in Power Map.
-
Connect to Real-Time Google Ad Manager Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Google Ad Manager and Dataflow to import and use Google Ad Manager data in Power Apps.
-
Integrating Boomi Agentstudio with Authorize.Net Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Authorize.Net data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Brex Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Brex replication to Amazon Redshift.
-
Use the CData Software ODBC Driver for Google Search in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Search results in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Search.
-
How to import Todoist Data into Apache Solr
Use the CData Software JDBC Driver for Todoist in Data Import Handler and create an automated import of Todoist data to Apache Solr Enterprise Search platform.
-
Connecting Moonlit Workflow with CouchDB 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 CouchDB data in real time.
-
Write a Simple Go Application to work with Instagram Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Instagram data.
-
How to Build an ETL App for Azure Analysis Services Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Analysis Services data in Python with petl.
-
Use the CData ODBC Driver for Tickspot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tickspot to connect to Tickspot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tickspot data in Excel.
-
Connecting GenSpark with Asana Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Asana data without any replication or custom integration required.
-
Connect to Google Contacts Data from HeidiSQL
Use CData Connect AI to connect to and query live Google Contacts data from HeidiSQL.
-
Publish Crystal Reports on Zoho Creator Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Creator data.
-
Replicate Multiple Aircall Accounts
Replicate multiple Aircall accounts to one or many databases.
-
How to connect to SAP HANA XS Advanced Data with Squirrel SQL client
Connect to SAP HANA XS Advanced data and execute queries in the Squirrel SQL Client.
-
Create SSAS Tabular Models from Zoho Recruit Data
How to build a SQL Server Analysis Service Tabular Model from Zoho Recruit data using CData drivers.
-
Build Automated Workflows with Live Wave Financial Data in Workato
Use CData Connect AI to connect to live Wave Financial data and build automated workflows in Workato.
-
Connect to Copper from a Connection Pool in WebLogic
Use the CData JDBC Driver for Copper to connect to Copper data from Web applications running on WebLogic.
-
How to Visualize Salesforce Pardot Data in Python with pandas
Use pandas and other modules to analyze and visualize live Salesforce Pardot data in Python.
-
Interact with Live Redshift Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Redshift data.
-
Connect to SAP HANA Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP HANA data from HeidiSQL.
-
Integrating Claude Code CLI with Miro 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.
-
Connect to Greenhouse Data from a Connection Pool in Jetty
The Greenhouse JDBC Driver supports connection pooling: This article shows how to connect faster to Greenhouse data from Web apps in Jetty.