CData Software - Knowledge Base
Recent Articles
-
ETL PayPal in Oracle Data Integrator
This article shows how to transfer PayPal data into a data warehouse using Oracle Data Integrator.
-
Visualize Live Lakebase Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Lakebase data into custom reports in Power BI.
-
Automated Continuous CircleCI Replication to SQL Server
Use CData Sync for automated, continuous, customizable CircleCI replication to SQL Server.
-
Use the CData Software JDBC Driver for MailerLite in MicroStrategy
Connect to MailerLite data in MicroStrategy Developer using the CData Software JDBC Driver for MailerLite.
-
Analyze Bullhorn CRM Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Bullhorn CRM data and visualize live Bullhorn CRM data in Infragistics Reveal.
-
How to Connect to Live CouchDB Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your CouchDB data for you.
-
Using the CData Software ODBC Driver for Pinecone in PyCharm
Connect to Pinecone as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pinecone.
-
Load Demio Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Demio data to a database.
-
Connect and Query Live PostgreSQL Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live PostgreSQL data into Databricks and enable direct, live querying and analysis without replication.
-
Replicate Multiple ConstantContact Accounts via the CData Sync CLI
Replicate multiple ConstantContact accounts to one or many databases.
-
How to Visualize Parquet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Parquet data in Python.
-
Integrate Dify with Live TaxJar 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 TaxJar data.
-
Connect to Real-Time Mailjet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mailjet data in Power Apps.
-
Replicate Active Directory Data to Multiple Databases
Replicate Active Directory data to disparate databases with a point-and-click configuration.
-
Connect to Redis Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Redis and the SQL Gateway to access Redis data from Google Apps Script.
-
View Reports on Real-Time ZohoDesk Data in Power BI Report Server
Use the CData ODBC Driver for ZohoDesk to visualize ZohoDesk data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Eventbrite to Google BigQuery using CData SSIS Components.
Easily push Eventbrite data to Google BigQuery using the CData SSIS Tasks for Eventbrite and Google BigQuery.
-
Integrate Goose with Live Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Dynamics 365 Business Central data from within the local AI agent.
-
Perform Batch Operations with Email Data in Apache NiFi
Connect to Email data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Enable the Hive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Hive data.
-
Use the CData SSIS Components to Insert New or Update Existing TaxJar Records from SQL Server
Easily push SQL Server data to TaxJar using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into TaxJar or update existing records with data from a SQL Server database.
-
Analyze MySQL Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MySQL data and visualize MySQL data in SAP Analytics Cloud.
-
Create Dynamic Guru Grids Using the Infragistics XamDataGrid
Learn how you can connect Guru to Infragistics XamDataGrid to build dynamic grids.
-
Natively Connect to Google Sheets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Sheets data. Leverage the native support for ODBC in PHP.
-
Query, Visualize, and Share live Google Cloud Storage Data in Redash
Use CData Connect AI to connect to live Google Cloud Storage data in Redash for querying, visualizing, and sharing.
-
Viewing Procore Data in RAD Studio Data Explorer
How to view Procore data in RAD Studio Data Explorer using the CData ODBC Driver for Procore.
-
How to publish and share Wrike Data dashboards with Tableau Server
The CData ODBC driver for Wrike enables you integrate Wrike data into Tableau dashboards.
-
Create Facebook Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Facebook from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create SSAS Tabular Models from Billsby Data
How to build a SQL Server Analysis Service Tabular Model from Billsby data using CData drivers.
-
Connect to Contentful Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Contentful data using standard SQL.
-
Integrating Cursor with Avaza 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.
-
Create PabblySubscriptions Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PabblySubscriptions from PowerBI.com to create Power BI Dataflows with real-time data.
-
Prepare, Blend, and Analyze Sage 200 Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage 200 data for self-service data analytics.
-
Automated Continuous Sage Intacct Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage Intacct replication to Snowflake.
-
How to Query XML Data in MySQL Workbench
Execute MySQL queries against live XML data from MySQL Workbench.
-
Integrate Live Zendesk Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zendesk data to Blue Prism using the CData ODBC Driver for Zendesk to create automated workflows for repetitive business tasks.
-
Create Informatica Mappings From/To a JDBC Data Source for ConvertKit
Create ConvertKit data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Migrating data from MailChimp to Snowflake using CData SSIS Components.
Easily push MailChimp data to Snowflake using the CData SSIS Tasks for MailChimp and Snowflake.
-
Integrate Cursor with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live PostgreSQL data from within the editor.
-
Create Informatica Mappings From/To a JDBC Data Source for Spark
Create Spark data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Tavily Reporting in OBIEE with the Tavily JDBC Driver
Deploy the Tavily JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Seamlessly Import Stripe Data into IBM SPSS Modeler
Integrate Stripe data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy
Connect to Zuora data in MicroStrategy Developer using the CData Software ODBC Driver for Zuora.
-
How to Connect to Live SAS Data Sets 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 SAS Data Sets data for you.
-
Connect to Kintone from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Kintone data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Cloudflare Data in Ruby
Connect to Cloudflare data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Publish Crystal Reports on Perplexity Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Perplexity data.
-
Getting Started with the CData Tableau Connector for Insightly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Amazon Athena Data in Jaspersoft Studio
Execute SQL to remote Amazon Athena data in Jaspersoft Studio.
-
Add PolarTeamPro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PolarTeamPro with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to HelloSign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HelloSign and the SQL Gateway to access HelloSign data from Google Apps Script.
-
Integrate Real-Time Access to ActiveCampaign in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to ActiveCampaign data in real time.
-
Connect to SAP HANA in SpagoBI
Create reports featuring live SAP HANA data in SpagoBI Studio. Host SAP HANA reports on SpagoBI Server.
-
How to Connect to Moosend Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Moosend data. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time Confluence Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Confluence data in ColdFusion.
-
How to Connect to Live Bitbucket 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 Bitbucket data for you.
-
How to Connect to Live Freshservice Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Freshservice data for you.
-
Migrating data from AlloyDB to Databricks using CData SSIS Components.
Easily push AlloyDB data to Databricks using the CData SSIS Tasks for AlloyDB and Databricks.
-
Automated Continuous Beeminder Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Beeminder replication to Google BigQuery.
-
How to Work with Unbounce Data in AWS Glue Jobs Using JDBC
Connect to Unbounce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to PostgreSQL Data in NetBeans
Connect to PostgreSQL data in NetBeans with the data source configuration wizard.
-
Getting Started with the CData Python Connector for Scrapfly
Learn to install and license the CData Python Connector and configure a connection to live Scrapfly data.
-
Integrate LibreChat with Live ZohoSubscriptions Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ZohoSubscriptions data from within the chat interface.
-
Create Float Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Float from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrate Open WebUI with Live ZohoPeople Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ZohoPeople data from within the chat interface.
-
Connect to Intercom from a Connection Pool in WebLogic
Use the CData JDBC Driver for Intercom to connect to Intercom data from Web applications running on WebLogic.
-
Integrating Claude Code with Monday.com Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Monday.com data within assisted coding and automated development workflows.
-
Build Cloudflare-Connected Apps in Choreo
Use CData Connect AI to connect to Cloudflare Data from Choreo and build custom apps using live Cloudflare data.
-
Query Nuclia Data in ColdFusion
Write standard ColdFusion data access code to connect to Nuclia data.
-
Analyze ClickUp Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of ClickUp data and visualize ClickUp data in SAP Analytics Cloud.
-
Automated Continuous GetResponse Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GetResponse replication to Apache Kafka.
-
Connect and Query Live SuiteCRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SuiteCRM data into Databricks and enable direct, live querying and analysis without replication.
-
Write a Simple Go Application to work with SAP Business Warehouse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Business Warehouse data.
-
Configure the CData JDBC Driver for SendPulse in a Connection Pool in Tomcat
Connect to SendPulse data from a connection pool in Tomcat.
-
Automated Continuous EnterpriseDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Google BigQuery.
-
Connect to Hacker News Data in DBeaver
Use the CData ODBC Driver to connect to Hacker News data in DBeaver.
-
Access Live Google Campaign Manager 360 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 Google Campaign Manager 360 data through MCP integration.
-
Use Biml to Build SSIS Tasks to Replicate Google Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Google Ads data to SQL Server.
-
DataBind Amazon S3 Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Amazon S3 with the DevExpress Windows Forms and Web controls to provide Amazon S3 data to a chart.
-
Connect to OneNote Data from PowerBuilder via JDBC
This article demonstrates how to access OneNote data from PowerBuilder using the OneNote JDBC Driver.
-
Connecting GenSpark with ConstantContact Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to ConstantContact data without any replication or custom integration required.
-
Use the CData SSIS Components to Insert New or Update Existing QuickBooks Records from SQL Server
Easily push SQL Server data to QuickBooks using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into QuickBooks or update existing records with data from a SQL Server database.
-
DataBind Controls to Gumroad Data in Delphi
DataBind to Gumroad data in Delphi with standard data access components and controls.
-
Access Live Omnisend 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 Omnisend data through MCP integration.
-
Connect to Tanda Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Tanda and work with Tanda data in your FileMaker applications.
-
Automated AlloyDB Data Replication to Teradata
Use CData Sync to Customize and automate AlloyDB data replication to Teradata.
-
Bind Live SAP Business One Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP Business One data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
A PostgreSQL Interface for PolarTeamPro Data (MySQL Remoting via JDBC)
Use the Remoting features of the PolarTeamPro JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Google Calendar Data from MySQL in PHP
Connect to Google Calendar through the standard MySQL libraries in PHP.
-
Interact with Live SurveyMonkey Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SurveyMonkey data.
-
Connect to Email Data from HeidiSQL
Use CData Connect AI to connect to and query live Email data from HeidiSQL.
-
Import Real-Time Adobe Commerce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Commerce data in ColdFusion.
-
Visualize ZohoInvoice Data in TIBCO Spotfire through ADO.NET
Integrate ZohoInvoice data into dashboards in TIBCO Spotfire.
-
How to Work with SharePoint Excel Services Data in ETL Validator JDBC
Connect to SharePoint Excel Services from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Keap Data in the Pentaho Report Designer
Publish reports based on Keap data in the Pentaho BI tool.
-
Connect to SharePoint Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SharePoint to connect to SharePoint data and execute queries in PowerBuilder.
-
Create a Data Access Object for SAP Hybris C4C Data using JDBI
A brief overview of creating a SQL Object API for SAP Hybris C4C data in JDBI.
-
Build Data Flows from Postmark to SQL Server using SSIS
Easily back up Postmark data to SQL Server using the SSIS components for Postmark.
-
Establish a Live Connection with ZohoSubscriptions Data using Tableau Bridge
The CData ODBC Driver for ZohoSubscriptions enables you to integrate live ZohoSubscriptions data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect to Live Adobe Target Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Adobe Target data securely in real time.