CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live ActiveCampaign Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ActiveCampaign.
-
Integrate with Reckon Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon to a JSON file on disk.
-
Automated Continuous Apify Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Apify replication to Amazon Redshift.
-
Access Live Jumpseller Data in AWS Lambda
Connect to live Jumpseller in AWS Lambda using the CData JDBC Driver.
-
Build Data Flows from Pinterest to SQL Server using SSIS
Easily back up Pinterest to SQL Server using the SSIS components for Pinterest.
-
Integrating Dataiku with Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Salesforce & Force.com.
-
Replicate Multiple Twitter Ads Accounts via the CData Sync CLI
Replicate multiple Twitter Ads accounts to one or many databases.
-
How to integrate Mailgun with Apache Airflow
Access and process Mailgun in Apache Airflow using the CData JDBC Driver.
-
Prepare, Blend, and Analyze SQL Server Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft SQL Server for self-service data analytics.
-
Connect to Google Analytics Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Google Analytics.
-
Automated Continuous Cloudflare Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Cloudflare replication to Apache Cassandra.
-
Integrating GitHub Copilot CLI with MailerSend 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 Typeform Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Typeform.
-
Connect to Apollo Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Apollo as an External Source in Dremio.
-
Design BIRT Reports on FHIR Data
Provide current FHIR to your embedded analytics.
-
Connect to FTP Data in Claris FileMaker Pro
Use the CData ODBC Driver for FTP in FileMaker Pro to connect to FTP and work with FTP Servers in your FileMaker applications.
-
Use the CData ODBC Driver for Gumroad in Microsoft Power Query
You can use the CData Gumroad ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gumroad into Microsoft Power Query.
-
Access Figshare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Figshare from HeidiSQL.
-
Build Automated Greenhouse-Connected Workflows in Zapier
Use CData Connect AI to connect to live Greenhouse and build automated workflows in Zapier.
-
Connect to ShipStation Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for ShipStation and the Script function in FileMaker Pro to connect to ShipStation and work with ShipStation in your FileMaker application.
-
Automated Continuous Dynamics 365 Business Central Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to delimited files (CSV/TSV).
-
Create BigCommerce Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time BigCommerce data access from reports, embedded analytics, and more.
-
Replicate Twitter Ads Data from PowerShell
Write a quick PowerShell script to query Twitter Ads. Use connectivity to the live data to replicate Twitter Ads to SQL Server.
-
Use Microsoft Copilot Studio to talk to your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MongoDB for you.
-
Load Chargebee Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Chargebee to a database.
-
Trigger Oracle Eloqua IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Oracle Eloqua with standard wizards in Logic Apps.
-
Edit and Search Microsoft Ads External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft Ads to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft Ads objects that you can access from apps and the dashboard.
-
Connect to Apify Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Apify to connect to Apify and execute queries in PowerBuilder.
-
Natively Connect to Avaza Data in PHP
The CData ODBC driver for Avaza enables you to create PHP applications with connectivity to Avaza. Leverage the native support for ODBC in PHP.
-
Integrating Cursor CLI with Raisers Edge NXT 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.
-
Getting Started with the CData Excel Add-In for Campaigner
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Campaigner.
-
Integrate Live WordPress Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to WordPress from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live WordPress.
-
Import Real-Time Everhour Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Everhour in ColdFusion.
-
Visualize Live Twitter Ads Data in the Power BI Service
Use CData Connect AI to connect to live Twitter Ads and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Query Clio Data in DataGrip
Create a Data Source for Clio in DataGrip and use SQL to query live Clio.
-
Build Microsoft Planner-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Planner.
-
Working with Dotmailer Data in LINQPad
Execute LINQ queries to Dotmailer in LINQPad.
-
Connect to Epicor Kinetic Data from HeidiSQL
Use CData Connect AI to connect to and query live Epicor Kinetic from HeidiSQL.
-
Automated Continuous Freshteam Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Freshteam replication to delimited files (CSV/TSV).
-
Build Visualizations of Google Cloud Storage Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Cloud Storage in Birst.
-
How to publish and share YouTube Analytics Data dashboards with Tableau Server
The CData ODBC driver for YouTube Analytics enables you integrate YouTube Analytics into Tableau dashboards.
-
Integrate NASA with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate NASA with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to NASA.
-
How to Connect to Live Twitter Ads 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 Twitter Ads through natural language.
-
Work with Live Monday.com Data in Power Query
Use CData Connect AI to connect to Monday.com and work with live Monday.com in Microsoft Power Query.
-
Query Excel Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Excel.
-
How to Work with Brex Data in ETL Validator JDBC
Connect to Brex from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Presto Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Presto replication to AlloyDB.
-
Access Live Google Ads Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Access Live PayPal Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live PayPal from your Excel spreadsheets.
-
Automated Continuous XML Replication to Databricks
Use CData Sync for automated, continuous, customizable XML replication to Databricks.
-
How to import MYOB AccountRight Data into Apache Solr
Use the CData Software JDBC Driver for MYOB AccountRight in Data Import Handler and create an automated import of MYOB AccountRight to Apache Solr Enterprise Search platform.
-
Write a Simple Go Application to work with ZeroBounce Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ZeroBounce.
-
Access Jira Assets Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jira Assets from HeidiSQL.
-
Use the CData SSIS Components to Insert New or Update Existing Pipedrive Records from SQL Server
Easily push SQL Server data to Pipedrive using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Pipedrive or update existing records with data from a SQL Server database.
-
Automated Continuous Microsoft Planner Replication to Oracle
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Oracle.
-
Publish FHIR-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live FHIR.
-
Automate SurveyMonkey Data Replication to Couchbase
Use CData Sync to Customize and automate SurveyMonkey replication to Couchbase.
-
Choosing the Best Method to Connect LeadDesk to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LeadDesk from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code with Freshservice Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Freshservice within assisted coding and automated development workflows.
-
Integrate Acumatica with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Acumatica with External Services.
-
How to update Paylocity from Excel
This article explains how to transfer data from Excel to Paylocity using the Excel Add-In for Paylocity.
-
Import Real-Time AgileCRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use AgileCRM in ColdFusion.
-
Automated Continuous Access Replication to MongoDB
Use CData Sync for automated, continuous, customizable Access replication to MongoDB.
-
Getting Started with the CData ADO.NET Provider for HDFS
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HDFS.
-
Automated Continuous Oracle Service Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Service Cloud replication to delimited files (CSV/TSV).
-
Using the CData Software ODBC Driver for CircleCI in PyCharm
Connect to CircleCI as an ODBC data source in PyCharm using the CData Software ODBC Driver for CircleCI.
-
How to Access Humanity Data Using Entity Framework
This article shows how to access Humanity using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Certinia-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Certinia and build web apps with connectivity to live Certinia.
-
Automate Float Data Replication to Couchbase
Use CData Sync to Customize and automate Float replication to Couchbase.
-
Build AI/ML Models with Live Pipeliner CRM Data using Dataiku
Connect Pipeliner CRM Data with Dataiku using the CData API Driver for JDBC.
-
Visualize Miro Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Miro into TIBCO Spotfire.
-
Create Quickbase-Connected Dashboards in Grafana
Connect to Quickbase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Quickbase.
-
Migrating data from ServiceNow to Snowflake using CData SSIS Components.
Easily push ServiceNow to Snowflake using the CData SSIS Tasks for ServiceNow and Snowflake.
-
Build LinkedIn Ads Visualizations in Tableau Cloud
Use CData Connect AI to connect to live LinkedIn Ads and build visualizations in Tableau Cloud.
-
How to connect to Active Directory Data from Spring Boot
Connect to Active Directory in a Spring Boot Application using the CData JDBC Driver for Active Directory
-
Create Power BI Reports on Real-Time Dynamics CRM Data
Use the CData ODBC Driver for Dynamics CRM to visualize Microsoft Dynamics CRM in Power BI Desktop.
-
Build Dashboards with xBase Data in Dundas BI
Create dynamic dashboards and perform analytics based on xBase in Dundas BI.
-
Integrate LibreChat with Live Salesforce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesforce & Force.com from within the chat interface.
-
Integrate Pinterest Data in Pentaho Data Integration
Build ETL pipelines based on Pinterest in the Pentaho Data Integration tool.
-
Import Amazon DynamoDB Data Using Azure Data Factory
Use CData Connect AI to connect to Amazon DynamoDB Data from Azure Data Factory and import live Amazon DynamoDB.
-
Automated Continuous SuiteCRM Replication to SQLite
Use CData Sync for automated, continuous, customizable SuiteCRM replication to SQLite.
-
Migrating data from Zoho Books to Snowflake using CData SSIS Components.
Easily push Zoho Books to Snowflake using the CData SSIS Tasks for Zoho Books and Snowflake.
-
Access Live Facebook Ads 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 Facebook Ads through MCP integration.
-
Build Presto-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Presto to explore live Presto Data in Claude Code to assist with building Presto-powered applications.
-
Integrating Google Forms Data in Talend Cloud Data Management Platform
Connect Google Forms Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query SparkPost Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SparkPost from Node.js.
-
DataBind Controls to Stripe Data in C++Builder
DataBind to Stripe in C++Builder with standard components and controls.
-
Establish a Live Connection with MessageBird Data using Tableau Bridge
The CData ODBC Driver for MessageBird enables you to integrate live MessageBird into Tableau Cloud dashboards using the Tableau Bridge.
-
Enable the Todoist JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Todoist.
-
Operational Reporting on MYOB AccountRight Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote MYOB AccountRight.
-
Connect to Adobe Analytics from Asprova with CData Software ODBC Driver for Adobe Analytics
This article shows how to connect faster to Adobe Analytics data from Asprova.
-
Integrating LangGraph with HCL Domino Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on HCL Domino within automated workflows.
-
A PostgreSQL Interface for Spotify Data using the CData ODBC Driver
Use the SQL Gateway and Spotify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to eBay Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for eBay Data and connect to eBay in Akorbi Digital RunMyProcess.
-
Automate QuickBooks Online Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks Online and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting GenSpark with Zuora Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zuora without any replication or custom integration required.
-
Create a Data Access Object for TigerGraph Data using JDBI
A brief overview of creating a SQL Object API for TigerGraph in JDBI.
-
Query Oracle Eloqua Reporting Data as a MySQL Database in Node.js
Execute MySQL queries against Oracle Eloqua Reporting from Node.js.
-
Getting Started with the CData ODBC Driver for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for PolarTeamPro.
-
Getting Started with the CData ODBC Driver for Sendwithus
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Sendwithus.