CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Pipeliner CRM Data
Create Python applications that use pandas and Dash to build Pipeliner CRM-connected web apps.
-
How to connect and process Placid data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Placid data.
-
Integrate Theia IDE with Live CockroachDB 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 CockroachDB data from within the development environment.
-
Build AI/ML Models with Live Strava Data using Dataiku
Connect Strava Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Google Translate Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Translate replication to Snowflake.
-
Automate Browserless Data Replication to Azure Data Lake
Use CData Sync to customize and automate Browserless data replication to Azure Data Lake.
-
Integrate Google's Antigravity Agent with Live Wave Financial Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Wave Financial data using the Model Context Protocol.
-
How to import Paddle Data into Apache Solr
Use the CData Software JDBC Driver for Paddle in Data Import Handler and create an automated import of Paddle data to Apache Solr Enterprise Search platform.
-
Automated Continuous Xero Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Xero replication to Apache Cassandra.
-
Access Act-On Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Act-On data from your Oracle system.
-
How to Connect to & Open LaunchDarkly Data in Microsoft Excel
This article uses the CData ODBC driver for LaunchDarkly to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Use the CData ODBC Driver for Freshdesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshdesk to connect to Freshdesk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshdesk data in Excel.
-
Build ZohoMarketingHub-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ZohoMarketingHub Data and create custom apps in Bubble.
-
How to Access Live NASA Data in Power Automate Desktop via ODBC
The CData ODBC Driver for NASA enables you to integrate NASA data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect Flowise AI Agents to Live Freshdesk 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 Freshdesk data without replication.
-
Getting Started with the CData ADO.NET Provider for Procore
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Vault CRM-Connected Business Apps in AppSheet
Connect to Vault CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Vault CRM data.
-
Integrating Gumloop with Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Figshare data within automated workflows.
-
Publish YouTube Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live YouTube Analytics data.
-
Integrating Dataiku with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Microsoft Entra ID data.
-
How to Connect to Live Jumpseller 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 Jumpseller data for you.
-
How to Easily Query Planio Data in OpenOffice Base
Connect to Planio data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Analyze Xero Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Xero from Power Pivot. You will use the Table Import Wizard to load Xero data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Zoho Books Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zoho Books data without replication.
-
Build a PostgreSQL Interface for Onfleet Data using the CData JDBC Driver
Use the Remoting features of the Onfleet JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect Snapchat Ads to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Snapchat Ads data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Confluence Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Confluence Data and connect to Confluence data in Akorbi Digital RunMyProcess.
-
Connect to Parquet Data in CloverDX (formerly CloverETL)
Transfer Parquet data using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from Discord to SQL Server using SSIS
Easily back up Discord data to SQL Server using the SSIS components for Discord.
-
How to Build an ETL App for Salesloft Data in Python with CData Connect AI
Build ETL pipelines that read and write live Salesloft data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Zoho Recruit Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Recruit as an External Source in Dremio.
-
Excel Spreadsheet Automation on Mailjet Data with the QUERY Formula
Pull data from Mailjet, automate spreadsheets, and more with the QUERY formula.
-
Integrate Devin with Live Bright Data Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Bright Data data.
-
xBase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on xBase facts in real time.
-
Build a Simple VCL Application for Gumroad Data
How to build a simple VCL Application to view Gumroad data in RAD Studio using the CData ODBC Driver for Gumroad.
-
Create Apps from SQL Analysis Services Data in Qlik Sense Cloud
Use CData Connect AI to connect to SQL Analysis Services Data and build apps from live SQL Analysis Services data in Qlik Sense Cloud.
-
Getting Started with the CData Excel Add-In for Bitly
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Bitly.
-
How to import Freshdesk Data into Apache Solr
Use the CData Software JDBC Driver for Freshdesk in Data Import Handler and create an automated import of Freshdesk data to Apache Solr Enterprise Search platform.
-
How to Access SAP HANA XS Advanced Data Using Entity Framework
This article shows how to access SAP HANA XS Advanced data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Notion-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Notion data.
-
Link Pingdom with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Pingdom data in Filemaker Pro for Mac or Windows.
-
Integrate Google's Vertex AI Agent with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Phoenix data within intelligent workflows.
-
Natively Connect to MessageBird Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MessageBird data. Leverage the native support for ODBC in PHP.
-
Connect to Azure Synapse Data in Claris FileMaker Pro
Use the CData ODBC Driver for Azure Synapse in FileMaker Pro to connect to Azure Synapse and work with Azure Synapse data in your FileMaker applications.
-
Use the CData Software ODBC Driver for Confluence in MicroStrategy
Connect to Confluence data in MicroStrategy Developer using the CData Software ODBC Driver for Confluence.
-
Integrating Kiro with Sybase IQ 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.
-
Build AI/ML Models with Live Reckon Accounts Hosted Data using Dataiku
Connect Reckon Accounts Hosted Data with Dataiku using the CData JDBC Driver for Reckon Accounts Hosted.
-
Automated Continuous ConvertAPI Replication to SingleStore
Use CData Sync for automated, continuous, customizable ConvertAPI replication to SingleStore.
-
Build AI/ML Models with Live Cosmos DB Data using Dataiku
Connect Cosmos DB Data with Dataiku using the CData JDBC Driver for Cosmos DB.
-
Excel Spreadsheet Automation on SAP Data with the QUERY Formula
Pull data from SAP, automate spreadsheets, and more with the QUERY formula.
-
Connect to GetResponse 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 GetResponse data.
-
Automated Continuous MariaDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MariaDB replication to Google Cloud SQL.
-
Getting Started with the CData Connect AI Python SDK for Bullhorn CRM
Install the CData Connect AI Python SDK to read and write live Bullhorn CRM data with standard DB-API 2.0 Python code.
-
Automated Continuous Toggl Replication to Oracle
Use CData Sync for automated, continuous, customizable Toggl replication to Oracle.
-
Automated Continuous HelloSign Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable HelloSign replication to Google Cloud SQL.
-
Connect to Act-On Data in CloverDX (formerly CloverETL)
Transfer Act-On data using the visual workflow in the CloverDX data integration tool.
-
Connect to Act-On Data in HULFT Integrate
Connect to Act-On as a JDBC data source in HULFT Integrate
-
Query Live LDAP Objects in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live LDAP objects directly from the development environment.
-
Automated Continuous HDFS Replication to Amazon S3
Use CData Sync for automated, continuous, customizable HDFS replication to Amazon S3.
-
How to Connect to & Open Zuora Data in Microsoft Excel
This article uses the CData ODBC driver for Zuora to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Process & Analyze Typeform Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Typeform Data.
-
Query Live Snapchat Ads Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Snapchat Ads data directly from the development environment.
-
Integrating Gumloop with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Jira Assets data within automated workflows.
-
Build Bright Data-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 Bright Data data without replication.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Perigon
Provide connectivity to Perigon data through an SAP BusinessObjects universe.
-
How to create CSV federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for CSV data in MySQL .
-
Connect to Microsoft OneDrive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft OneDrive as an External Source in Dremio.
-
Build an OLAP Cube in SSAS from Retently Data
Establish a connection to Retently data data from SQL Server Analysis Services, and use the Retently Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Superchat with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Superchat with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Superchat data.
-
Build AI/ML Models with Live Unbounce Data using Dataiku
Connect Unbounce Data with Dataiku using the CData API Driver for JDBC.
-
Create Reports from SendPulse Data in Looker Studio
Use CData Connect AI to gain access to live SendPulse data and create custom reports in Looker Studio.
-
How to create an RPA flow for SAP ByDesign Data in UiPath Studio
Use the SAP ByDesign ODBC Driver to create workflows that access real-time SAP ByDesign data without any coding.
-
Object-Relational Mapping (ORM) with Contentful 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 Contentful data into a Java-based ORM framework, Hibernate.
-
Connect to and Visualize Live Active Directory Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Active Directory data.
-
Trigger QuickBooks IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for QuickBooks with standard wizards in Logic Apps.
-
Integrating Codex with SAP Hybris C4C 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.
-
Use the CData Software ODBC Driver for CapsuleCRM in MicroStrategy Desktop
Connect to CapsuleCRM data in MicroStrategy Desktop using the CData Software ODBC Driver for CapsuleCRM.
-
How to Create Power BI Visual Reports with Real-Time ShipEngine Data
Use CData Power BI Connectors to visualize ShipEngine data in Power BI.
-
Import and Visualize Tanda Data in Power View
Create data visualizations based on Tanda data in Excel.
-
Natively Connect to Facebook Ads Data in PHP
The CData ODBC driver for Facebook Ads enables you to create PHP applications with connectivity to Facebook Ads data. Leverage the native support for ODBC in PHP.
-
Use the CData ODBC Driver for Azure Synapse in Microsoft Power Query
You can use the CData Azure Synapse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure Synapse data into Microsoft Power Query.
-
Access ZohoSubscriptions Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ZohoSubscriptions data from HeidiSQL.
-
How to work with Klaviyo Data in Apache Spark using SQL
Access and process Klaviyo Data in Apache Spark using the CData Software JDBC Driver.
-
Model, Search, and Visualize Live API Data in ThoughtSpot
Use CData Connect AI to connect to live API data for modeling, searching, and visualizing.
-
Query Epicor Kinetic Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Epicor Kinetic data from Node.js.
-
Use JayDeBeApi to access SparkPost Data in Python
Use standard Python scripting and the development environment of your choice to access live SparkPost data.
-
Integrating Antigravity CLI with Factorial data via CData CLI
Connect Factorial data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LlamaIndex with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Asana data in real time.
-
Integrate Goose with Live Epicor Kinetic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Epicor Kinetic data from within the local AI agent.
-
Connect to Miro Data from a Connection Pool in Jetty
The Miro JDBC Driver supports connection pooling: This article shows how to connect faster to Miro data from Web apps in Jetty.
-
Connect to Zoho CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoho CRM.
-
Build an OLAP Cube in SSAS from Bugsnag Data
Establish a connection to Bugsnag data data from SQL Server Analysis Services, and use the Bugsnag Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous PolarTeamPro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to Azure SQL Database.
-
Migrating data from MailerSend to Google BigQuery using CData SSIS Components.
Easily push MailerSend data to Google BigQuery using the CData SSIS Tasks for MailerSend and Google BigQuery.
-
Working with FreshBooks Data in LINQPad
Execute LINQ queries to FreshBooks data in LINQPad.
-
Automated Continuous ScrapingBee Replication to SQLite
Use CData Sync for automated, continuous, customizable ScrapingBee replication to SQLite.
-
Import Real-Time Cloudflare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Cloudflare data in ColdFusion.
-
How to load MessageBird data into Elasticsearch via Logstash
Introducing a simple method to load MessageBird data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Import Real-Time Blackbaud FE NXT Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Blackbaud FE NXT data in ColdFusion.
-
Automated Continuous Invoiced Replication to SQL Server
Use CData Sync for automated, continuous, customizable Invoiced replication to SQL Server.