CData Software - Knowledge Base
Recent Articles
-
Connect to Jira Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Jira and the SQL Gateway to access Jira data from Google Apps Script.
-
How to create an RPA flow for EmailOctopus Data in UiPath Studio
Use the EmailOctopus ODBC Driver to create workflows that access real-time EmailOctopus data without any coding.
-
Connect Salesforce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Google Ads Data in Jaspersoft Studio
Execute SQL to remote Google Ads data in Jaspersoft Studio.
-
Access Quaderno Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Quaderno data from HeidiSQL.
-
Integrating Codex with Workday 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.
-
Access REST Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live REST data from HeidiSQL.
-
Publish Wave Financial-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Wave Financial data.
-
Add SFTP Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SFTP with the Informatica Enterprise Data Catalog to classify and organize data.
-
Interact with Live JSON Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live JSON services.
-
How to Visualize TaxJar Data in Python with pandas
Use pandas and other modules to analyze and visualize live TaxJar data in Python.
-
Build Snowflake Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Snowflake data and build visualizations in Tableau Cloud.
-
Build Data Flows from Anaplan to SQL Server using SSIS
Easily back up Anaplan data to SQL Server using the SSIS components for Anaplan.
-
Create Hugging Face Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Hugging Face from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Google Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to Google Cloud SQL.
-
Visualize Jira Assets 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 Jira Assets data into TIBCO Spotfire.
-
Integrating LlamaIndex with QuickBooks Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on QuickBooks Online data in real time.
-
Automated Continuous Shopify Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Shopify replication to Apache Cassandra.
-
Link AfterShip with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate AfterShip data in Filemaker Pro for Mac or Windows.
-
How to connect and process HDFS data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live HDFS data.
-
Use the CData Software ODBC Driver for Monday.com in MicroStrategy Web
Connect to Monday.com data in MicroStrategy Web using the CData Software ODBC Driver for Monday.com.
-
Connect to Pipedrive Data in HULFT Integrate
Connect to Pipedrive as a JDBC data source in HULFT Integrate
-
Build Blackbaud FE NXT Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Blackbaud FE NXT data and build visualizations in Tableau.
-
Integrate OpenCode with Live Sage 300 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sage 300 data from within your AI coding agent.
-
Getting Started with the CData SSIS Components for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for EmailOctopus.
-
How to Connect Flowise AI Agents to Live Dynamics 365 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 Dynamics 365 data without replication.
-
Connect to Printify Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Printify Data and connect to Printify data in Akorbi Digital RunMyProcess.
-
Stream Square Data into Apache Kafka Topics
Access and stream Square data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Easily Query Cohere Data in OpenOffice Base
Connect to Cohere data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build AI/ML Models with Live Paddle Data using Dataiku
Connect Paddle Data with Dataiku using the CData API Driver for JDBC.
-
Integrate Sybase IQ Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Sybase IQ data and integrate live Sybase IQ data into your Power Automate tasks.
-
Search External Sage 300 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Sage 300 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Sage 300 Data objects that you can access from apps and the dashboard.
-
Connect and Visualize Live Adobe Commerce Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Commerce data into the Databricks platform and create visualization dashboards with real-time Adobe Commerce data.
-
Connect to Azure Analysis Services Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Analysis Services to connect to Azure Analysis Services data and execute queries in PowerBuilder.
-
Moving Data from ElevenLabs to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ElevenLabs data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with Azure Synapse Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Azure Synapse data through CData Connect AI.
-
Publish PingOne-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PingOne data.
-
Connecting Agentforce with FreshBooks Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your FreshBooks data for you.
-
Using the CData Software ODBC Driver for Xero in PyCharm
Connect to Xero as an ODBC data source in PyCharm using the CData Software ODBC Driver for Xero.
-
Integrate Goose with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Redshift data from within the local AI agent.
-
View Reports on Real-Time Salesforce CRM Analytics Data in Power BI Report Server
Use the CData ODBC Driver for Salesforce CRM Analytics to visualize Salesforce CRM Analytics data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Azure AI Foundry to Talk to Your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Redshift data for you.
-
Use Databricks Agent Bricks to Talk to Your Gong Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Gong data for you.
-
Connect to Live Cloudflare Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cloudflare in CData Connect AI and connect to your Cloudflare data from PostgreSQL.
-
Automated Continuous SQL Server Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SQL Server replication to Apache Cassandra.
-
Access ShipStation Data from MySQL in PHP
Connect to ShipStation through the standard MySQL libraries in PHP.
-
Rapidly Develop Oracle HCM Cloud-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 Oracle HCM Cloud.
-
Getting Started with the CData JDBC Driver for Microsoft Planner
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Planner.
-
Build Facebook-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Facebook Data and create custom apps in Bubble.
-
Build Agents in Relevance AI with Access to Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on OneNote data within intelligent agent workflows.
-
How to create an RPA flow for MailerSend Data in UiPath Studio
Use the MailerSend ODBC Driver to create workflows that access real-time MailerSend data without any coding.
-
Create a Data Access Object for Everhour Data using JDBI
A brief overview of creating a SQL Object API for Everhour data in JDBI.
-
Use Azure AI Foundry to Talk to Your Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Zoom data for you.
-
Connect CouchDB Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CouchDB data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Work with Live Smartsheet Data in Power Query
Use CData Connect AI to connect to Smartsheet data and work with live Smartsheet data in Microsoft Power Query.
-
Automate Egnyte Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Egnyte data from PowerShell? This article demonstrates how to utilize the Egnyte Cmdlets for tasks like connecting to Egnyte data, automating operations, downloading data, and more.
-
How to connect to Basecamp Data from IntelliJ
Integrate connectivity to Basecamp data with wizards in IntelliJ.
-
Connect to Real-Time Accelo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Accelo data in Power Apps.
-
Query Reckon Data as a SQL Server Database in Node.js
Execute SQL Server queries against Reckon data from Node.js.
-
Automated Continuous DB2 for i Replication to MySQL
Use CData Sync for automated, continuous, customizable DB2 for i replication to MySQL.
-
How to Connect the Power BI Service to Pushbullet: Complete Guide
Connect to the CData Software Power BI Connector for Pushbullet from PowerBI.com to provide real-time Pushbullet data across the organization.
-
Integrate EmailOctopus with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate EmailOctopus with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to EmailOctopus data.
-
Replicate Multiple Invoiced Accounts via the CData Sync CLI
Replicate multiple Invoiced accounts to one or many databases.
-
Connect Planio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Planio data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Sybase Data in Aqua Data Studio
Access Sybase data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Marketo Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Marketo with the DevExpress Windows Forms and Web controls to provide Marketo data to a chart.
-
Access Insightly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Insightly data from HeidiSQL.
-
Build Automated Workflows with Live Exact Online Data in Workato
Use CData Connect AI to connect to live Exact Online data and build automated workflows in Workato.
-
Establish a Live Connection with Unbounce Data using Tableau Bridge
The CData ODBC Driver for Unbounce enables you to integrate live Unbounce data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate Avaza Data Replication to Azure Data Lake
Use CData Sync to customize and automate Avaza data replication to Azure Data Lake.
-
Integrate SAP Business One with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Business One with External Services.
-
Automated Continuous Teamwork Replication to SingleStore
Use CData Sync for automated, continuous, customizable Teamwork replication to SingleStore.
-
Import Real-Time Vault CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Vault CRM data in ColdFusion.
-
Build Sage Intacct-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sage Intacct Data and create custom apps in Bubble.
-
Integrate Sybase Data into Power Automate Desktop using CData Connect
CData Connect for Sybase Data enables you to integrate Sybase data into workflows built using Microsoft Power Automate Desktop.
-
How to load Cosmos DB data into Elasticsearch via Logstash
Introducing a simple method to load Cosmos DB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Goose with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Oracle Service Cloud data from within the local AI agent.
-
Integrating Codex with Presto 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 HCL Domino Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for HCL Domino Data and connect to HCL Domino data in Akorbi Digital RunMyProcess.
-
Integrate Theia IDE with Live Pinterest Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Pinterest data from within the development environment.
-
Integrate Cursor with Live Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Salesforce Pardot data from within the editor.
-
Migrating data from ZohoPeople to Google BigQuery using CData SSIS Components.
Easily push ZohoPeople data to Google BigQuery using the CData SSIS Tasks for ZohoPeople and Google BigQuery.
-
Query PingOne Data in DataGrip
Create a Data Source for PingOne in DataGrip and use SQL to query live PingOne data.
-
Access Google Cloud Storage Data from MySQL in Amazon QuickSight
Connect to Google Cloud Storage and build visualizations of Google Cloud Storage data using a MySQL Connection in Amazon QuickSight.
-
How to use SQLAlchemy ORM to access VWO Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of VWO data.
-
Publish Crystal Reports on Attio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Attio data.
-
Use JayDeBeApi to access Oracle Financials Cloud Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Financials Cloud data.
-
Publish Crystal Reports on MailerSend Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date MailerSend data.
-
Create Salesforce Marketing-Connected Applications in Appsmith
Connect to Salesforce Marketing Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce Marketing data.
-
Getting Started with the CData Python Connector for Wave Financial
Learn to install and license the CData Python Connector and configure a connection to live Wave Financial data.
-
Create Odoo-Connected Applications in Appsmith
Connect to Odoo Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Odoo data.
-
Automate ClickUp Data Replication to Azure Data Lake
Use CData Sync to customize and automate ClickUp data replication to Azure Data Lake.
-
Getting Started with the CData Python Connector for Testmonitor
Learn to install and license the CData Python Connector and configure a connection to live Testmonitor data.
-
How to load Spark data into Elasticsearch via Logstash
Introducing a simple method to load Spark data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automate SAP Business One Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Business One data from PowerShell? This article demonstrates how to utilize the SAP Business One Cmdlets for tasks like connecting to SAP Business One data, automating operations, downloading data, and more.
-
Build Pipelines with Live Google Campaign Manager 360 Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Campaign Manager 360 from Google Cloud Data Fusion, enabling the integration of live Google Campaign Manager 360 data into the building and management of effective data pipelines.
-
How to update Microsoft Entra ID from Excel
This article explains how to transfer data from Excel to Microsoft Entra ID using the Excel Add-In for Microsoft Entra ID.
-
Visualize Live SAP Business One Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP Business One data into custom reports in Power BI.
-
Rapidly Develop Google Drive-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 Google Drive.
-
Connect to and Query Zuora Data in QlikView over ODBC
Create data visualizations with Zuora data in QlikView.