CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Salesforce Marketing
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Salesforce Marketing.
-
Build Apps with Live CampaignMonitor Data Using the Low-Code Development Platform of Mendix
Connect CampaignMonitor with Mendix to build apps using the CData API Driver for JDBC.
-
Automate PivotalTracker Data Replication to Couchbase
Use CData Sync to Customize and automate PivotalTracker replication to Couchbase.
-
Connect to Power BI XMLA Data in Google Apps Script via Connect AI
Use CData Connect AI to access Power BI XMLA in Google Apps Script.
-
Connect Keap to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Keap using the CData Python MCP Server.
-
How to create Visio diagrams from Airtable Data
Automatically update Airtable with the changes you make to Visio master shapes.
-
Work with Live PayPal Data in Power Query
Use CData Connect AI to connect to PayPal and work with live PayPal in Microsoft Power Query.
-
Migrating data from Odoo to Databricks using CData SSIS Components.
Easily push Odoo ERP to Databricks using the CData SSIS Tasks for Odoo and Databricks.
-
Analyze ZohoMarketingHub Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoMarketingHub with the CData JDBC Driver for ZohoMarketingHub.
-
Use Dash to Build to Web Apps on AfterShip Data
Create Python applications that use pandas and Dash to build AfterShip-connected web apps.
-
Enable the ChartMogul JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ChartMogul.
-
Connecting GenSpark with ShipStation Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ShipStation without any replication or custom integration required.
-
Deploy the ADO.NET Provider for Omnisend on an SSRS Report Server
Connect to Omnisend 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.
-
Build Dashboards with Oracle Financials Cloud Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Financials Cloud in Dundas BI.
-
Create Paylocity-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Paylocity Data from OutSystems and build custom enterprise apps using live Paylocity.
-
How to Connect to & Open Landbot Data in Microsoft Excel
This article uses the CData ODBC driver for Landbot to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Working with Timely Data in LINQPad
Execute LINQ queries to Timely in LINQPad.
-
Replicate Bugsnag Data to Multiple Databases
Replicate Bugsnag to disparate databases with a point-and-click configuration.
-
Query Adobe Commerce Data as a SQL Server Database in Node.js
Execute SQL Server queries against Adobe Commerce from Node.js.
-
Feed WooCommerce Data into FineReport
How to set WooCommerce as a JDBC data source in FineReport.
-
How to Connect the Power BI Service to ZohoMarketingHub: Complete Guide
Connect to the CData Software Power BI Connector for ZohoMarketingHub from PowerBI.com to provide real-time ZohoMarketingHub across the organization.
-
Integrate with Redis Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Redis to a JSON file on disk.
-
Replicate LeadDesk Data to Multiple Databases via the CData Sync CLI
Replicate LeadDesk to disparate databases with a single configuration.
-
Build Paylocity-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Paylocity and build Paylocity-connected web apps with Axios.
-
Design BIRT Reports on Raisers Edge NXT Data
Provide current Raisers Edge NXT to your embedded analytics.
-
Use JayDeBeApi to access Freshsales Data in Python
Use standard Python scripting and the development environment of your choice to access live Freshsales.
-
Use the CData ODBC Driver for Browserless in Microsoft Power Query
You can use the CData Browserless ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Browserless into Microsoft Power Query.
-
Connect to ZohoDesk Data from a Connection Pool in JBoss
Integrate ZohoDesk into Java servlets: Use the Management Console in JBoss to install the ZohoDesk JDBC Driver.
-
Stream Stripe Data into Apache Kafka Topics
Access and stream Stripe in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query Greenplum Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Pivotal GreenPlum and perform CRUD operations on Greenplum from Node.js.
-
How to Build an ETL App for Quickbase Data in Python with CData
Create ETL applications and real-time data pipelines for Quickbase in Python with petl.
-
A PostgreSQL Interface for SendGrid Data using the CData ODBC Driver
Use the SQL Gateway and SendGrid ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate LibreChat with Live Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Asana from within the chat interface.
-
Use Databricks Agent Bricks to Talk to Your SAP SuccessFactors Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP SuccessFactors for you.
-
How to load Avro data into Elasticsearch via Logstash
Introducing a simple method to load Avro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Email Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Email using standard SQL.
-
Connect to and Query Gong Data in QlikView over ODBC
Create data visualizations with Gong in QlikView.
-
Load Humanity Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Humanity to a database.
-
Quaderno Reporting in OBIEE with the Quaderno JDBC Driver
Deploy the Quaderno JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Planio Reporting in OBIEE with the Planio JDBC Driver
Deploy the Planio JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to integrate Freshdesk with Apache Airflow
Access and process Freshdesk in Apache Airflow using the CData JDBC Driver.
-
SAP ByDesign Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Business ByDesign through CData Connect AI using different applications and tools.
-
Build Google Directory-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Directory.
-
Connect to WooCommerce Data in DBeaver
Use the CData ODBC Driver to connect to WooCommerce in DBeaver.
-
View Reports on Real-Time Twilio Data in Power BI Report Server
Use the CData ODBC Driver for Twilio to visualize Twilio in Power BI Desktop and then publish them to Power BI Report Server.
-
Edit and Search Xero External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.
-
Automated Continuous AdRoll Replication to Databricks
Use CData Sync for automated, continuous, customizable AdRoll replication to Databricks.
-
Getting Started with the CData Excel Add-In for Perplexity
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Perplexity.
-
Integrating Antigravity CLI with Oracle Database via CData CLI
Connect Oracle Database to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to & Open Elasticsearch Data in Microsoft Excel
This article uses the CData ODBC driver for Elasticsearch to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Twilio Data Replication to Azure Synapse
Use CData Sync to customize and automate Twilio replication to Azure Synapse.
-
Connect Freshsales Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshsales using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Using the CData Software ODBC Driver for Trello in PyCharm
Connect to Trello as an ODBC data source in PyCharm using the CData Software ODBC Driver for Trello.
-
Automated Continuous SAP BusinessObjects BI Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Google Cloud SQL.
-
Access Typeform Data from MySQL in PHP
Connect to Typeform through the standard MySQL libraries in PHP.
-
How to Connect the Power BI Service to Copper: Complete Guide
Connect to the CData Software Power BI Connector for Copper from PowerBI.com to provide real-time Copper across the organization.
-
Integrating Boomi Agentstudio with IBM Cloud Object Storage Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to IBM Cloud Object Storage, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Query Live Kintone 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 Kintone directly from the development environment.
-
Connect PivotalTracker Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PivotalTracker using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect and process Nethunt from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Nethunt.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Drive
Provide connectivity to Google Drive through an SAP BusinessObjects universe.
-
How to Connect to Live Google Directory 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 Google Directory for you.
-
DataBind Controls to JotForm Data in Delphi
DataBind to JotForm in Delphi with standard data access components and controls.
-
How to load Act CRM data into Elasticsearch via Logstash
Introducing a simple method to load Act CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Asana in Microsoft Power Query
You can use the CData Asana ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Asana into Microsoft Power Query.
-
Connect to Quickbase from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Quickbase, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Rapidly Develop Chargebee-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Chargebee.
-
Integrate SAP Concur Data in the Pentaho Report Designer
Publish reports based on SAP Concur in the Pentaho BI tool.
-
DataBind Controls to Active Directory Data in Delphi
DataBind to Active Directory in Delphi with standard data access components and controls.
-
Integrate with CouchDB Data in JReport Designer
Create charts and reports based on Apache CouchDB in JReport Designer.
-
Use the CData Software ODBC Driver for Billsby in MicroStrategy
Connect to Billsby in MicroStrategy Developer using the CData Software ODBC Driver for Billsby.
-
Create Informatica Mappings From/To an ODBC Data Source for Short.io
Create an ODBC connection to Short.io in Informatica and browse and transfer Short.io.
-
How to Connect to & Open Airtable Data in Microsoft Excel
This article uses the CData ODBC driver for Airtable to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Live Certinia Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Certinia in CData Connect AI and connect to your Certinia from PostgreSQL.
-
How to work with EnterpriseDB Data in Apache Spark using SQL
Access and process EnterpriseDB Data in Apache Spark using the CData Software JDBC Driver.
-
Query Instagram Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Instagram from Node.js.
-
Extract, Transform, and Load RSS Feeds in Informatica PowerCenter
Create a simple Workflow for RSS Feeds in Informatica PowerCenter.
-
Automated Continuous Workday Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Workday replication to Google BigQuery.
-
Provide OData Services of Azure Data Lake Storage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Azure Data Lake Storage by developing a WCF Service Application.
-
Validate Twilio Data with QuerySurge
Access and validate Twilio in QuerySurge using the CData JDBC Driver.
-
How to Query Live Raisers Edge NXT Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Raisers Edge NXT data in natural language using Python.
-
Connect to Jodoo Data from PowerBuilder via ADO.NET
This article demonstrates how to access Jodoo from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use Agno to Talk to Your Adobe Commerce 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 Adobe Commerce for you.
-
How to connect to PDFMonkey Data in DBVisualizer
Integrate PDFMonkey with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Data Visualizations in Cognos BI with SendPulse Data
Access SendPulse as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build a Dynamic React App with Live Data Using CData API Server
Learn how to build a dynamic React app powered by live data using CData API Server’s REST and OData endpoints.
-
DataBind HubSpot Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HubSpot with the DevExpress Windows Forms and Web controls to provide HubSpot to a chart.
-
How to Connect to Live Vertica Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Vertica for you.
-
Build a Simple VCL Application for JotForm Data
How to build a simple VCL Application to view JotForm in RAD Studio using the CData ODBC Driver for JotForm.
-
Build Semantic Layer Views for Greenplum Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Pivotal GreenPlum.
-
Connect to ZohoExpense from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZohoExpense to connect to ZohoExpense from Web applications running on WebLogic.
-
Automated Continuous ZohoDesk Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Apache Cassandra.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Contacts
Create Google Contacts data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Google Cloud Storage Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Cloud Storage and build visualizations in Tableau Cloud.
-
DataBind Controls to Salesforce Marketing Data in Delphi
DataBind to Salesforce Marketing Cloud in Delphi with standard data access components and controls.
-
Establish a Live Connection with Sage 200 Data using Tableau Bridge
The CData ODBC Driver for Sage 200 enables you to integrate live Sage 200 into Tableau Cloud dashboards using the Tableau Bridge.
-
Connecting Pipedream with Office 365 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 Office 365 data in real time.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Office 365 using the Model Context Protocol.
-
Create a Data Access Object for Pipeliner CRM Data using JDBI
A brief overview of creating a SQL Object API for Pipeliner CRM in JDBI.
-
Stream Beeminder Data into Apache Kafka Topics
Access and stream Beeminder in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.