CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with Zoho CRM 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.
-
Visualize Supabase Data in Tableau
The CData ODBC driver for Supabase enables you integrate Supabase data into Tableau dashboards.
-
Connect Amazon S3 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amazon S3 with IBM WebSphere for seamless data integration and connectivity.
-
Getting Started with the CData Python Connector for Grafana
Learn to install and license the CData Python Connector and configure a connection to live Grafana data.
-
How to Connect to Live eBay 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 eBay data for you.
-
Build Excel Online-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Excel Online data and build Excel Online-connected web apps with Axios.
-
Integrate Live Asana Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Asana data and integrate live Asana data into apps built in Microsoft Power Apps.
-
Connecting GenSpark with Workday Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Workday data without any replication or custom integration required.
-
Import Real-Time HDFS Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use HDFS data in ColdFusion.
-
Connect to Clio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Clio data.
-
Build Mailgun-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 Mailgun data without replication.
-
How to Connect to Live GitHub 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 GitHub data for you.
-
Create Dashboards and Visualize Live EnterpriseDB Data in Geckoboard
Use CData Connect AI to connect to live EnterpriseDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automate MYOB AccountRight Data Replication to SAP HANA
Use CData Sync to customize and automate MYOB AccountRight data replication to SAP HANA.
-
Rapidly Develop Wave Financial-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 Wave Financial.
-
Connect to Trello Data from PowerBuilder via JDBC
This article demonstrates how to access Trello data from PowerBuilder using the Trello JDBC Driver.
-
Automated Continuous Insightly Replication to SQLite
Use CData Sync for automated, continuous, customizable Insightly replication to SQLite.
-
Seamlessly Bring Supabase Data into Retool Using CData Connect AI
Integrate Supabase data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Data Flows from Avalara AvaTax to SQL Server using SSIS
Easily back up Avalara AvaTax data to SQL Server using the SSIS components for Avalara AvaTax.
-
Getting Started with the CData SSIS Components for ZohoSubscriptions
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZohoSubscriptions.
-
Build Voice Agents in ElevenLabs with access to Live Reckon Accounts Hosted Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Reckon Accounts Hosted data.
-
Import Amazon Athena Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon Athena Data and provide access to live Amazon Athena data for custom reports in the Power BI Service.
-
Create Dynamic Stack Exchange Grids Using the Infragistics XamDataGrid
Learn how you can connect Stack Exchange to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Adobe Experience Manager Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Experience Manager data from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Experience Manager.
-
Integrating Boomi Agentstudio with Sybase IQ Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sybase IQ data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Integrate OpenCode with Live Act-On Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Act-On data from within your AI coding agent.
-
How to Connect to Live Amazon Marketplace 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 Amazon Marketplace data for you.
-
Access Live Qualaroo Data in Coginiti Pro
Connect to and query live Qualaroo data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access ConvertAPI Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ConvertAPI data from your Oracle system.
-
Access Live Zuora Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zuora data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use CData Connect AI to Access Jira Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Jira data in the Power Pivot business intelligence tool.
-
Load Egnyte Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Egnyte data to a database.
-
Integrate with Reply.io Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reply.io data to a JSON file on disk.
-
Access SAS Data Sets Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAS Data Sets data from HeidiSQL.
-
Integrating Dataiku with Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Raisers Edge NXT data.
-
Use the CData Software JDBC Driver for Insightly in MicroStrategy Desktop
Connect to Insightly data in MicroStrategy Desktop using the CData Software JDBC Driver for Insightly.
-
Query Snapchat Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Snapchat Ads entities in PHP by modeling them as objects.
-
Analyze Bugsnag Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bugsnag data with the CData JDBC Driver for Bugsnag.
-
Build Google Search-Connected Apps in Choreo
Use CData Connect AI to connect to Google Search Results from Choreo and build custom apps using live Google Search results.
-
Choosing the Best Method to Connect VWO to SQL Server: 5 Options Explained
Discover multiple ways to connect and use VWO data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Intercom Data Replication to Teradata
Use CData Sync to Customize and automate Intercom data replication to Teradata.
-
Create Confluence Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Confluence data access from reports, embedded analytics, and more.
-
Analyze Google Sheets Data in Looker
Use CData Connect AI to connect to Google Sheets Data from Looker and build custom apps using live Google Sheets data.
-
Connect to MarkLogic Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with MarkLogic Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Use the CData ODBC Driver for SurveyMonkey in Microsoft Power Query
You can use the CData SurveyMonkey ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SurveyMonkey data into Microsoft Power Query.
-
Query Snowflake Data in DataGrip
Create a Data Source for Snowflake in DataGrip and use SQL to query live Snowflake data.
-
Automated Continuous PagerDuty Replication to MongoDB
Use CData Sync for automated, continuous, customizable PagerDuty replication to MongoDB.
-
Publish IBM Cloud Object Storage-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Cloud Object Storage data.
-
How to Easily Query Coda Data in OpenOffice Base
Connect to Coda data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Interact with Live Email Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Email data.
-
Integrate Google's Antigravity Agent with Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live eBay Analytics data using the Model Context Protocol.
-
Query Adobe Commerce Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Adobe Commerce data from Node.js.
-
Prepare, Blend, and Analyze Google Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live Google Analytics data for self-service data analytics.
-
Automated Continuous Aha! Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Aha! replication to Apache Cassandra.
-
Getting Started with the CData Python Connector for SAP Fieldglass
Learn to install and license the CData Python Connector and configure a connection to live SAP Fieldglass data.
-
Getting Started with the CData Connect AI Python SDK for Snapchat Ads
Install the CData Connect AI Python SDK to read and write live Snapchat Ads data with standard DB-API 2.0 Python code.
-
Connect to Elasticsearch Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Elasticsearch Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Query Microsoft Exchange Data in DataGrip
Create a Data Source for Microsoft Exchange in DataGrip and use SQL to query live Microsoft Exchange data.
-
Stream Rebilly Data into Apache Kafka Topics
Access and stream Rebilly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live GitHub Data in Coginiti Pro
Connect to and query live GitHub data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build an OLAP Cube in SSAS from Microsoft Dataverse Data
Establish a connection to Microsoft Dataverse data data from SQL Server Analysis Services, and use the Microsoft Dataverse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Dynamics 365 Data Replication to Azure Synapse
Use CData Sync to customize and automate Dynamics 365 data replication to Azure Synapse.
-
Import LinkedIn Ads Data Using Azure Data Factory
Use CData Connect AI to connect to LinkedIn Ads Data from Azure Data Factory and import live LinkedIn Ads data.
-
Connecting Mastra with Sage 300 Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Sage 300 data, no replication required.
-
Interact with Live Notion Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Notion data.
-
Automated Continuous Odoo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Odoo replication to IBM DB2.
-
Use the CData ODBC Driver for Clio from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Clio to connect to Clio data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Clio data in Excel.
-
Validate Perigon Data with QuerySurge
Access and validate Perigon data in QuerySurge using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your Slack 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 Slack data for you.
-
Query Quaderno Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Quaderno data from Node.js.
-
Connect to Insightly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Insightly to connect to Insightly data and execute queries in PowerBuilder.
-
How to connect to Klipfolio Data in DBVisualizer
Integrate Klipfolio data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Gumroad Data Replication to Teradata
Use CData Sync to Customize and automate Gumroad data replication to Teradata.
-
Automated Continuous Egnyte Replication to MySQL
Use CData Sync for automated, continuous, customizable Egnyte replication to MySQL.
-
How to connect Amazon QuickSight to ActiveCampaign Data
Create a connection to ActiveCampaign data in CData Connect AI and insert ActiveCampaign data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Azure AI Foundry to Talk to Your SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Build a Singer.io Tap for Azure Data Catalog With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure Data Catalog data using the CData Python Connector.
-
Automated Continuous Postmark Replication to Oracle
Use CData Sync for automated, continuous, customizable Postmark replication to Oracle.
-
Deploy the ADO.NET Provider for RSS on an SSRS Report Server
Connect to RSS feeds 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 JayDeBeApi to access Mouseflow Data in Python
Use standard Python scripting and the development environment of your choice to access live Mouseflow data.
-
How to Connect the Power BI Service to Freshservice: Complete Guide
Connect to the CData Software Power BI Connector for Freshservice from PowerBI.com to provide real-time Freshservice data across the organization.
-
Integrate Sybase with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sybase with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sybase data.
-
Manage SAP BusinessObjects BI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SAP BusinessObjects BI.
-
Use Biml to Build SSIS Tasks to Replicate TaxJar Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate TaxJar data to SQL Server.
-
Connect to Freshsales Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Freshsales data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software ODBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA data in MicroStrategy Web using the CData Software ODBC Driver for SAP HANA.
-
Build Semantic Layer Views for Bright Data Data in APOS Live Data Gateway
Use the CData Connector for Bright Data in APOS Live Data Gateway to build Semantic Layer Views for Bright Data data.
-
Integrate Open WebUI with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sage 200 data from within the chat interface.
-
How to integrate Metabase with CouchDB Data
Use CData Connect AI to connect to live CouchDB data and create an interactive dashboard in Metabase from CouchDB data.
-
How to Work with Zoom Data in AWS Glue Jobs Using JDBC
Connect to Zoom from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect to Email Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Email data. Leverage the pyodbc module for ODBC in Python.
-
Build Kafka Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Kafka data and build visualizations in Tableau Cloud.
-
Integrate with live Pipedrive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Pipedrive data in Jitterbit.
-
Connect to Live Redshift Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Redshift in CData Connect AI and connect to your Redshift data from PostgreSQL.
-
Integrating Attio Data in Talend Cloud Data Management Platform
Connect Attio Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Billsby Data in the Pentaho Report Designer
Publish reports based on Billsby data in the Pentaho BI tool.
-
Connect to Trello Data in RapidMiner
Integrate Trello data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Dash to Build Web Apps on LinkedIn Ads Data via CData Connect AI
Build interactive Dash web apps on live LinkedIn Ads data using pandas and the CData Connect AI Python SDK.
-
Automated Continuous Clockify Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Clockify data replication to OneLake in Microsoft Fabric.
-
Connect to Missive from Asprova with CData Software ODBC Driver for Missive
This article shows how to connect faster to Missive data from Asprova.