CData Software - Knowledge Base
Recent Articles
-
Build Sage Cloud Accounting-Connected Apps in Choreo
Use CData Connect AI to connect to Sage Cloud Accounting Data from Choreo and build custom apps using live Sage Cloud Accounting data.
-
Use Microsoft Copilot Studio to talk to your Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Timely data for you.
-
A PostgreSQL Interface for Pushbullet Data (MySQL Remoting via JDBC)
Use the Remoting features of the Pushbullet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from XML Data in Qlik Sense Cloud
Use CData Connect AI to connect to XML Data and build apps from live XML data in Qlik Sense Cloud.
-
Access Live CockroachDB Data in Excel 365 Online (Excel for the web)
Connect to CockroachDB data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Couchbase Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Couchbase data in the Denodo Virtual DataPort Administrator.
-
How to connect and process Azure Table data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Azure Table data.
-
Create CapsuleCRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CapsuleCRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Visualize Live VWO Data in the Power BI Service
Use CData Connect AI to connect to live VWO data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Work with Live MarkLogic Data in Power Query
Use CData Connect AI to connect to MarkLogic data and work with live MarkLogic data in Microsoft Power Query.
-
Automated Continuous Eventbrite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Eventbrite replication to Apache Cassandra.
-
Connect and Visualize Live Square Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Square data into the Databricks platform and create visualization dashboards with real-time Square data.
-
Use Biml to Build SSIS Tasks to Replicate ZendeskSell Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZendeskSell data to SQL Server.
-
Integrate Live Attio Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Attio from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Attio data.
-
Import Real-Time Productboard Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Productboard data in ColdFusion.
-
Build Campaigner-Connected Apps in Choreo
Use CData Connect AI to connect to Campaigner Data from Choreo and build custom apps using live Campaigner data.
-
Automated Continuous Hubstaff Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Hubstaff replication to Azure SQL Database.
-
Connect to Oracle Sales Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Oracle Sales data from Filemaker Pro on Mac.
-
Integrate Live Elasticsearch Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Elasticsearch data from within the IDE.
-
Use Azure AI Foundry to Talk to Your XML 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 XML data for you.
-
Access Live Omnisend Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Omnisend data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Build an ETL App for Greenplum Data in Python with CData
Create ETL applications and real-time data pipelines for Greenplum data in Python with petl.
-
Create Apps from SAS xpt Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAS xpt Data and build apps from live SAS xpt data in Qlik Sense Cloud.
-
Integrate ADP Data in Pentaho Data Integration
Build ETL pipelines based on ADP data in the Pentaho Data Integration tool.
-
Getting Started with the CData Connect AI Python SDK for AgileCRM
Install the CData Connect AI Python SDK to read live AgileCRM data with standard DB-API 2.0 Python code.
-
Connect Coda to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Coda data using the CData Python MCP Server.
-
Getting Started with the CData Power BI Connector for Codat
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Scrapfly Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Scrapfly data.
-
Connect to Hive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Hive Data and connect to Hive data in Akorbi Digital RunMyProcess.
-
Build Dashboards with Asana Data in Dundas BI
Create dynamic dashboards and perform analytics based on Asana data in Dundas BI.
-
Integrate Live Mode Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Mode data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect to OData Services in DBVisualizer
Integrate OData services with visual data analysis tools and data connection wizards in DBVisualizer
-
Use ChatGPT to Talk to Your Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Azure Data Lake Storage data for you.
-
Build Charts with Presto Data in Clear Analytics
Create dynamic charts and perform analytics based on Presto data in Clear Analytics.
-
Analyze Jira Assets Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Jira Assets data in Microsoft R Open.
-
Access Contentful Data from MySQL in Amazon QuickSight
Connect to Contentful and build visualizations of Contentful data using a MySQL Connection in Amazon QuickSight.
-
Connect to Front Data from PowerBuilder via JDBC
This article demonstrates how to access Front data from PowerBuilder using the Front JDBC Driver.
-
Build Zoho Books-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Books Data from Choreo and build custom apps using live Zoho Books data.
-
How to Connect to Zoom Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zoom data. Leverage the pyodbc module for ODBC in Python.
-
Connect to AfterShip from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from AfterShip data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Pinecone with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Pinecone with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pinecone data.
-
Connect to Coda Data from PowerBuilder via ADO.NET
This article demonstrates how to access Coda data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Moving Data from QuickBooks to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live QuickBooks data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build an OLAP Cube in SSAS from NASA Data
Establish a connection to NASA data data from SQL Server Analysis Services, and use the NASA Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Excel Online Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Excel Online data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from PingOne to Databricks using CData SSIS Components.
Easily push PingOne data to Databricks using the CData SSIS Tasks for PingOne and Databricks.
-
Perplexity Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Perplexity data through CData Connect AI using different applications and tools.
-
Create Reports with ZohoSubscriptions Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ZohoSubscriptions data.
-
Build Automated Workflows with Live Snowflake Data in Workato
Use CData Connect AI to connect to live Snowflake data and build automated workflows in Workato.
-
Use Claude to Talk to Your ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your ZohoMarketingHub data for you.
-
Integrate with Live QuickBooks Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks from the MuleSoft Anypoint Platform to integrate live QuickBooks data into custom reports and dashboards.
-
Automate Mistral AI Data Replication to Azure Synapse
Use CData Sync to customize and automate Mistral AI data replication to Azure Synapse.
-
Integrating Dataiku with Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Xero data.
-
Import Real-Time SharePoint Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SharePoint data in ColdFusion.
-
How to Work with Apollo Data in AWS Glue Jobs Using JDBC
Connect to Apollo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Yelp Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Yelp replication to PostgreSQL.
-
LINQ to Epicor Kinetic Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Epicor Kinetic Data Provider.
-
Connect to Cosmos DB Data from a Connection Pool in JBoss
Integrate Cosmos DB data into Java servlets: Use the Management Console in JBoss to install the Cosmos DB JDBC Driver.
-
Getting Started with the CData Excel Add-In for WordPress
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for WordPress.
-
Connect to Quickbase Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Quickbase data.
-
Excel Spreadsheet Automation on Dynamics 365 Data with the QUERY Formula
Pull data from Dynamics 365, automate spreadsheets, and more with the QUERY formula.
-
Analyze MariaDB Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MariaDB data in Microsoft R Open.
-
Natively Connect to ZohoDesk Data in PHP
The CData ODBC driver for ZohoDesk enables you to create PHP applications with connectivity to ZohoDesk data. Leverage the native support for ODBC in PHP.
-
Stream ZeroBounce Data into Apache Kafka Topics
Access and stream ZeroBounce data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Create Power BI Visual Reports with Real-Time Hugging Face Data
Use CData Power BI Connectors to visualize Hugging Face data in Power BI.
-
Perform Batch Operations with PostgreSQL Data in Apache NiFi
Connect to PostgreSQL data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous Google Search Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Search replication to Databricks.
-
Integrate Live Couchbase Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Couchbase from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Couchbase data.
-
ETL Mocean in Oracle Data Integrator
This article shows how to transfer Mocean data into a data warehouse using Oracle Data Integrator.
-
Build a Simple VCL Application for Hubstaff Data
How to build a simple VCL Application to view Hubstaff data in RAD Studio using the CData ODBC Driver for Hubstaff.
-
Design BIRT Reports on Auth0 Data
Provide current Auth0 data to your embedded analytics.
-
Build Apps with Live Apollo data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apollo data into the Adalo platform and build custom mobile and web applications with real-time Apollo data.
-
How to Connect to Live Freshdesk 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 Freshdesk data for you.
-
Object-Relational Mapping (ORM) with OpenWeatherMap 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 OpenWeatherMap data into a Java-based ORM framework, Hibernate.
-
Analyze YouTube Analytics Data in Cognos Analytics
Use CData Connect AI to connect to YouTube Analytics Data from Cognos Analytics and analyze live YouTube Analytics data.
-
Seamlessly Bring Cloudflare Data into Retool Using CData Connect AI
Integrate Cloudflare data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Choosing the Best Method to Connect Wistia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Wistia data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Zuora Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Zuora data.
-
Stream RSS Feeds into Apache Kafka Topics
Access and stream RSS feeds in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Kiro with Impala 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.
-
LINQ to Testmonitor Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Testmonitor Data Provider.
-
Build MVC Applications with Connectivity to LeadDesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LeadDesk from an ASP.NET MVC application.
-
DataBind Controls to MongoDB Data in C++Builder
DataBind to MongoDB data in C++Builder with standard components and controls.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Grafana
Provide connectivity to Grafana data through an SAP BusinessObjects universe.
-
Integrate Live BigCommerce Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BigCommerce data and integrate live BigCommerce data into apps built in Microsoft Power Apps.
-
Integrating LlamaIndex with Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Box data in real time.
-
Work with Attio Data in FoxPro
Load Attio data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Dash to Build to Web Apps on PhantomBuster Data
Create Python applications that use pandas and Dash to build PhantomBuster-connected web apps.
-
Connect to SAP ByDesign Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP ByDesign data from Crystal Reports.
-
How to Connect to Live LinkedIn Ads 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 LinkedIn Ads data through natural language.
-
Connect Workable Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Workable data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Wrike Data in RazorSQL
Connect to Wrike from wizards and query Wrike data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Active Directory Replication to Databricks
Use CData Sync for automated, continuous, customizable Active Directory replication to Databricks.
-
Integrate Goose with Live Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Power BI XMLA data from within the local AI agent.
-
Using the CData Software ODBC Driver for Testmonitor in PyCharm
Connect to Testmonitor as an ODBC data source in PyCharm using the CData Software ODBC Driver for Testmonitor.
-
Connect to and Query Amplitude Data in QlikView over ODBC
Create data visualizations with Amplitude data in QlikView.
-
Import MailChimp Data Using Azure Data Factory
Use CData Connect AI to connect to MailChimp Data from Azure Data Factory and import live MailChimp data.
-
Connect to Teradata Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Teradata data using standard SQL.
-
Connecting Moonlit Workflow with IBM Cloud Object Storage Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM Cloud Object Storage data in real time.
-
Query Exact Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Exact Online data.