CData Software - Knowledge Base
Recent Articles
-
Access Live Email Data in Excel 365 Online (Excel for the web)
Connect to Email data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access HubDB Data from MySQL in Amazon QuickSight
Connect to HubDB and build visualizations of HubDB data using a MySQL Connection in Amazon QuickSight.
-
Build a Simple VCL Application for Adobe Analytics Data
How to build a simple VCL Application to view Adobe Analytics data in RAD Studio using the CData ODBC Driver for Adobe Analytics.
-
Stream Bitbucket Data into Apache Kafka Topics
Access and stream Bitbucket data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Freshdesk Reporting in OBIEE with the Freshdesk JDBC Driver
Deploy the Freshdesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live eBay Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live eBay data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Sage Intacct Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sage Intacct data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating OpenCode with Jira Assets 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 Power BI Connector for Bitly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating Dataiku with Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Quickbase data.
-
Replicate Testmonitor Data to Multiple Databases via the CData Sync CLI
Replicate Testmonitor data to disparate databases with a single configuration.
-
Automate Demio Data Replication to SAP HANA
Use CData Sync to customize and automate Demio data replication to SAP HANA.
-
Connect to and Visualize Live FHIR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live FHIR data.
-
Integrate Notion with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Notion with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Notion data.
-
Replicate Multiple Teamwork Accounts via the CData Sync CLI
Replicate multiple Teamwork accounts to one or many databases.
-
Build Apps with Live Bullhorn CRM Data Using the Low-Code Development Platform of Mendix
Connect Bullhorn CRM data with Mendix to build apps using the CData JDBC Driver for Bullhorn CRM.
-
Load Snapchat Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Snapchat Ads data to a database.
-
Automated Continuous CloudConvert Replication to SQL Server
Use CData Sync for automated, continuous, customizable CloudConvert replication to SQL Server.
-
Use Agno to Talk to Your SQL Analysis Services 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 SQL Analysis Services data for you.
-
DataBind Controls to VWO Data in Delphi
DataBind to VWO data in Delphi with standard data access components and controls.
-
Integrate with Cloudant Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Cloudant data in SnapLogic.
-
Natively Connect to Missive Data in PHP
The CData ODBC driver for Missive enables you to create PHP applications with connectivity to Missive data. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData Excel Add-In for PostgreSQL
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PostgreSQL.
-
Publish Slack-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Slack data.
-
Integrate Theia IDE with Live Active Directory 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 Active Directory data from within the development environment.
-
Object-Relational Mapping (ORM) with Nethunt Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Nethunt data into a Java-based ORM framework, Hibernate.
-
Connect to Microsoft Teams Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Teams data.
-
How to Connect to Live ZohoMarketingHub 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 ZohoMarketingHub data through natural language.
-
Access Paymo Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Paymo data from your Oracle system.
-
How to connect to iContact Data with Squirrel SQL client
Connect to iContact data and execute queries in the Squirrel SQL Client.
-
How to load Zendesk data into Elasticsearch via Logstash
Introducing a simple method to load Zendesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to load Monday.com data into Elasticsearch via Logstash
Introducing a simple method to load Monday.com data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import Real-Time Cvent Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cvent data in ColdFusion.
-
Connect to PabblySubscriptions Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PabblySubscriptions and the SQL Gateway to access PabblySubscriptions data from Google Apps Script.
-
Building Dynamic Web Pages with SAP Ariba Source Data Using AngularJS
Create single-page applications with live connectivity to SAP Ariba Source using the CData API Server.
-
Connect to Greenhouse Data in JRuby
Create a simple JRuby app with access to live Greenhouse data.
-
Replicate Databricks Data to Multiple Databases
Replicate Databricks data to disparate databases with a point-and-click configuration.
-
Build Dashboards with SendPulse Data in Dundas BI
Create dynamic dashboards and perform analytics based on SendPulse data in Dundas BI.
-
Build Data Flows from Mode to SQL Server using SSIS
Easily back up Mode data to SQL Server using the SSIS components for Mode.
-
Model, Search, and Visualize Live Oracle Financials Cloud Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Financials Cloud data for modeling, searching, and visualizing.
-
Integrate Live Epicor Kinetic Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Epicor Kinetic from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Epicor Kinetic data.
-
Automated Continuous HubSpot Replication to Databricks
Use CData Sync for automated, continuous, customizable HubSpot replication to Databricks.
-
Migrating data from Supabase to Google BigQuery using CData SSIS Components.
Easily push Supabase data to Google BigQuery using the CData SSIS Tasks for Supabase and Google BigQuery.
-
Use the CData ODBC Driver for Spark in Microsoft Power Query
You can use the CData Spark ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Spark data into Microsoft Power Query.
-
Build Twitter Ads-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Twitter Ads data and build web apps with connectivity to live Twitter Ads data.
-
How to Connect to & Open Hacker News Data in Microsoft Excel
This article uses the CData ODBC driver for Hacker News to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Moving Data from Recurly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Recurly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Voice Agents in ElevenLabs with access to Live Notion Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Notion data.
-
Connect to Customer.io Data in RapidMiner
Integrate Customer.io data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Agno to Talk to Your EnterpriseDB 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 EnterpriseDB data for you.
-
Integrate Open WebUI with Live Cloudant Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Cloudant data from within the chat interface.
-
Migrating data from Zoho Recruit to Google BigQuery using CData SSIS Components.
Easily push Zoho Recruit data to Google BigQuery using the CData SSIS Tasks for Zoho Recruit and Google BigQuery.
-
Use Grok to Talk to Your GetResponse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your GetResponse data for you.
-
Import ServiceDesk Plus Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ServiceDesk Plus Data and provide access to live ServiceDesk Plus data for custom reports in the Power BI Service.
-
Visualize Spotify Data in Sisense
Create an ElastiCube in Sisense app with access to Spotify data.
-
Build Shippo-Connected Apps in Choreo
Use CData Connect AI to connect to Shippo Data from Choreo and build custom apps using live Shippo data.
-
Visualize Teamwork 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 Teamwork data into TIBCO Spotfire.
-
Stream FreeAgent Data into Apache Kafka Topics
Access and stream FreeAgent data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating GitHub Copilot with Bitly 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.
-
Publish Crystal Reports on Spark Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Spark data.
-
Connect Tally to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Tally data using the CData Python MCP Server.
-
Use the CData Software ODBC Driver for PagerDuty in MicroStrategy Web
Connect to PagerDuty data in MicroStrategy Web using the CData Software ODBC Driver for PagerDuty.
-
Edit and Search External JSON Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of JSON services to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create JSON Services objects that you can access from apps and the dashboard.
-
Automated Continuous Landbot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Landbot replication to delimited files (CSV/TSV).
-
Create Datasets from Hugging Face in Domo Workbench and Build Visualizations of Hugging Face Data in Domo
Use the CData Software ODBC Driver for Hugging Face to create datasets from Hugging Face data in Domo Workbench and then build visualizations in the Domo service.
-
Provide OData Services of Mixpanel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Mixpanel data by developing a WCF Service Application.
-
A PostgreSQL Interface for Perplexity Data (MySQL Remoting via JDBC)
Use the Remoting features of the Perplexity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Trae with Live ShipStation Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ShipStation data from within the AI-powered IDE.
-
Automated Continuous Klaviyo Replication to SQL Server
Use CData Sync for automated, continuous, customizable Klaviyo replication to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Spotify Data
Use CData Power BI Connectors to visualize Spotify data in Power BI.
-
Integrate Hugging Face Data in the Pentaho Report Designer
Publish reports based on Hugging Face data in the Pentaho BI tool.
-
Use Agno to Talk to Your Instagram 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 Instagram data for you.
-
Analyze Paymo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Paymo from Power Pivot. You will use the Table Import Wizard to load Paymo data. You can visually build the import query or use any SQL supported by the driver.
-
How to create xBase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for xBase data in MySQL .
-
Connect to ZarMoney Data in Aqua Data Studio
Access ZarMoney data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Real-Time ZohoExpense Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoExpense data in ColdFusion.
-
Create Power BI Reports on Real-Time Dotmailer Data
Use the CData ODBC Driver for Dotmailer to visualize Dotmailer data in Power BI Desktop.
-
Create Apps from Microsoft Dataverse Data in Qlik Sense Cloud
Use CData Connect AI to connect to Microsoft Dataverse Data and build apps from live Microsoft Dataverse data in Qlik Sense Cloud.
-
Automated Continuous Kafka Replication to MongoDB
Use CData Sync for automated, continuous, customizable Kafka replication to MongoDB.
-
Query Avalara AvaTax Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Avalara AvaTax data from Node.js.
-
Access Live iContact Data in Excel 365 Online (Excel for the web)
Connect to iContact data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build MVC Applications with Connectivity to Email Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Email from an ASP.NET MVC application.
-
Enable the Snowflake JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Snowflake data.
-
Build Avalara AvaTax-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Avalara AvaTax data and build Avalara AvaTax-connected web apps with Axios.
-
Access SAS xpt Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SAS xpt data from HeidiSQL.
-
Trigger Microsoft Dataverse IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Microsoft Dataverse with standard wizards in Logic Apps.
-
Deploy the ADO.NET Provider for Mixpanel on an SSRS Report Server
Connect to Mixpanel data 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.
-
Connect to Klipfolio Data in ACL Analytics
Connect to Klipfolio data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Klipfolio data.
-
Getting Started with the CData SSIS Components for SAP Concur
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Concur.
-
View Reports on Real-Time Spark Data in Power BI Report Server
Use the CData ODBC Driver for Spark to visualize Spark data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Exact Online Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Exact Online data from Filemaker Pro on Mac.
-
Prepare, Blend, and Analyze Google Search Results in Alteryx Designer (Connect AI)
Build workflows to access live Google Search results for self-service data analytics.
-
Connecting Pipedream with Avro 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 Avro data in real time.
-
Jumpseller Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Jumpseller data through CData Connect AI using different applications and tools.
-
Create Data Visualizations in Cognos BI with RSS Feeds
Access RSS feeds as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Seamlessly Bring Attio Data into Retool Using CData Connect AI
Integrate Attio data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Multiple Retently Accounts
Replicate multiple Retently accounts to one or many databases.
-
Integrate with Live Moosend Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Moosend from the MuleSoft Anypoint Platform to integrate live Moosend data into custom reports and dashboards.
-
Integrating Boomi Agentstudio with GetResponse Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to GetResponse data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to MarkLogic Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MarkLogic to connect to MarkLogic data and execute queries in PowerBuilder.