CData Software - Knowledge Base
Recent Articles
-
Build Apps with Live Apollo in Adalo using CData Connect AI
Use CData Connect AI to integrate live Apollo into the Adalo platform and build custom mobile and web applications with real-time Apollo.
-
DataBind Microsoft Dataverse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Dataverse with the DevExpress Windows Forms and Web controls to provide Microsoft Dataverse (CDS) to a chart.
-
Query Front Data as a MySQL Database in Node.js
Execute MySQL queries against Front from Node.js.
-
Connect to GraphQL Data in HULFT Integrate
Connect to GraphQL as a JDBC data source in HULFT Integrate
-
Choosing the Best Method to Connect Wistia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Wistia from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Work with Live GraphQL Data in Power Query
Use CData Connect AI to connect to GraphQL and work with live GraphQL in Microsoft Power Query.
-
How to Access Live Chargebee Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Chargebee enables you to integrate Chargebee into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Dotmailer 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.
-
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 in real time.
-
Connect Workable Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Workable using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Operational Reporting on Splunk Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Splunk.
-
Use the CData Software ODBC Driver for Perplexity in MicroStrategy Desktop
Connect to Perplexity in MicroStrategy Desktop using the CData Software ODBC Driver for Perplexity.
-
Connect to and Visualize Live Azure Data Lake Storage Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Data Lake Storage.
-
How to Work with Azure Data Catalog Data in ETL Validator JDBC
Connect to Azure Data Catalog from ETL Validator jobs using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Harvest Data in Alteryx Designer (ODBC)
Build workflows to access live Harvest for self-service data analytics.
-
Connect SendInBlue Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SendInBlue using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Webex Data in JRuby
Create a simple JRuby app with access to live Webex.
-
Automated Continuous Hive Replication to SingleStore
Use CData Sync for automated, continuous, customizable Hive replication to SingleStore.
-
Write a Simple Go Application to work with Instagram Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Instagram.
-
Edit and Search Trello External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Trello to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Trello objects that you can access from apps and the dashboard.
-
Connect to BenchmarkEmail Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to BenchmarkEmail and work with BenchmarkEmail in your FileMaker application.
-
Connect to Facebook Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Facebook Ads from Filemaker Pro on Mac.
-
Connect to Box Data in RazorSQL
Connect to Box from wizards and query Box from the GUI in the RazorSQL database management tool.
-
Build Data Flows from QuickBooks Online to SQL Server using SSIS
Easily back up QuickBooks Online to SQL Server using the SSIS components for QuickBooks Online.
-
Getting Started with the CData Tableau Connector for MarkLogic
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for MarkLogic.
-
Replicate Multiple Presto Accounts via the CData Sync CLI
Replicate multiple Presto accounts to one or many databases.
-
Provide OData Services of Invoiced Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Invoiced by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for LinkedIn in MicroStrategy Desktop
Connect to LinkedIn in MicroStrategy Desktop using the CData Software ODBC Driver for LinkedIn.
-
Connect to Drip Data from a Connection Pool in JBoss
Integrate Drip into Java servlets: Use the Management Console in JBoss to install the Drip JDBC Driver.
-
Create Reports with RabbitMQ Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date RabbitMQ.
-
Use Azure AI Foundry to Talk to Your LinkedIn 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 LinkedIn for you.
-
Automated Continuous Tickspot Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Tickspot replication to IBM DB2.
-
Integrating Claude Code CLI with BambooHR 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.
-
Rapidly Develop Shopify-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 Shopify.
-
Explore Geographical Relationships in Odoo Data with Power Map
Create data visualizations with Odoo ERP in Power Map.
-
Building Dynamic Web Pages with Google Analytics Data Using AngularJS
Create single-page applications with live connectivity to Google Analytics using the CData API Server.
-
Build Charts with PhantomBuster Data in Clear Analytics
Create dynamic charts and perform analytics based on PhantomBuster in Clear Analytics.
-
Build Apps with Live LionDesk Data Using the Low-Code Development Platform of Mendix
Connect LionDesk with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous GitHub Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable GitHub replication to Apache Kafka.
-
Integrating Claude Code CLI with Unbounce 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.
-
Automated Continuous Blackbaud FE NXT Replication to SingleStore
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to SingleStore.
-
Use the CData ODBC Driver for Klipfolio in Microsoft Power Query
You can use the CData Klipfolio ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Klipfolio into Microsoft Power Query.
-
Build Dashboards with Opsgenie Data in Dundas BI
Create dynamic dashboards and perform analytics based on Opsgenie in Dundas BI.
-
Automated Continuous Slack Replication to MySQL
Use CData Sync for automated, continuous, customizable Slack replication to MySQL.
-
Automated Continuous Azure DevOps Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Azure DevOps replication to IBM DB2.
-
Integrating Codex CLI with Salesforce & Force.com 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.
-
Analyze Oracle Sales Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle Sales with the CData JDBC Driver for Oracle Sales.
-
Bridge Office 365 Connectivity with Apache NiFi
Access and process Microsoft Office 365 in Apache NiFi using the CData JDBC Driver.
-
Use Claude to Talk to Your Paylocity 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 Paylocity for you.
-
Use the CData ODBC Driver for Tavily from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Tavily to connect to Tavily from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Tavily in Excel.
-
Integrating GitHub Copilot CLI with Couchbase 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 Live Okta Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Okta into the statistical analysis tools available in SAS JMP. This article shows how to use Okta in the Graph Builder and Query Builder.
-
Build ChargeOver-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ChargeOver and build web apps with connectivity to live ChargeOver.
-
Create Templated Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Templated data access from reports, embedded analytics, and more.
-
Build Data Flows from BigCommerce to SQL Server using SSIS
Easily back up BigCommerce to SQL Server using the SSIS components for BigCommerce.
-
How to connect and process Delighted from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Delighted.
-
Analyze Outreach.io Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Outreach.io and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automated Continuous Splunk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Splunk replication to SQL Server.
-
Viewing Deel Data in RAD Studio Data Explorer
How to view Deel in RAD Studio Data Explorer using the CData ODBC Driver for Deel.
-
Visualize SurveyMonkey 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 SurveyMonkey into TIBCO Spotfire.
-
Viewing Retently Data in RAD Studio Data Explorer
How to view Retently in RAD Studio Data Explorer using the CData ODBC Driver for Retently.
-
Build Apps with Live Klaviyo in Adalo using CData Connect AI
Use CData Connect AI to integrate live Klaviyo into the Adalo platform and build custom mobile and web applications with real-time Klaviyo.
-
Getting Started with the CData Tableau Connector for VWO
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Dynamic Monday.com Grids Using the Infragistics XamDataGrid
Learn how you can connect Monday.com to Infragistics XamDataGrid to build dynamic grids.
-
Design BIRT Reports on ConstantContact Data
Provide current ConstantContact to your embedded analytics.
-
How to connect SharePoint with Microsoft OneDrive Data through external lists
Provide Microsoft OneDrive to SharePoint users as an external list.
-
Use the CData Software JDBC Driver for Salesloft in MicroStrategy Web
Connect to Salesloft in MicroStrategy Web using the CData Software JDBC Driver for Salesloft.
-
Configure the CData JDBC Driver for Nethunt in a Connection Pool in Tomcat
Connect to Nethunt from a connection pool in Tomcat.
-
Getting Started with the CData Connect AI Python SDK for Klaviyo
Install the CData Connect AI Python SDK to read and write live Klaviyo with standard DB-API 2.0 Python code.
-
Automated Continuous SQL Server Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SQL Server replication to IBM DB2.
-
Use Manus AI to Talk to Your Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle Financials Cloud.
-
Process & Analyze HubSpot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HubSpot Data.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Dynamics 365.
-
How to Connect to ZohoMarketingHub Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ZohoMarketingHub. Leverage the pyodbc module for ODBC in Python.
-
Build Automated Basecamp-Connected Workflows in Zapier
Use CData Connect AI to connect to live Basecamp and build automated workflows in Zapier.
-
Analyze Sage 300 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sage 300 and visualize live Sage 300 in Infragistics Reveal.
-
Automate EnterpriseDB Data Replication to SAP HANA
Use CData Sync to customize and automate EnterpriseDB replication to SAP HANA.
-
DataBind Controls to Nuclia Data in C++Builder
DataBind to Nuclia in C++Builder with standard components and controls.
-
Create Data Visualizations in Cognos BI with CloudConvert Data
Access CloudConvert as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Operational Reporting on Mailgun Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Mailgun.
-
How to Work with Discord Data in AWS Glue Jobs Using JDBC
Connect to Discord from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Charts with Templated Data in Clear Analytics
Create dynamic charts and perform analytics based on Templated in Clear Analytics.
-
Automated Continuous Adobe Commerce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to IBM DB2.
-
Use Dash to Build to Web Apps on Perigon Data
Create Python applications that use pandas and Dash to build Perigon-connected web apps.
-
Choosing the Best Method to Connect ClickUp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ClickUp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect DBeaver to Simplesat via a JDBC Driver
Manage Simplesat with visual tools in DBeaver like the query browser.
-
Visualize Live YouTube Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live YouTube Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Google Ad Manager-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Ad Manager.
-
Automated Continuous Amazon Marketplace Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to delimited files (CSV/TSV).
-
Connect to Azure DevOps 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 Azure DevOps.
-
Establish a Live Connection with Webflow Data using Tableau Bridge
The CData ODBC Driver for Webflow enables you to integrate live Webflow into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Highrise Replication to SQLite
Use CData Sync for automated, continuous, customizable Highrise replication to SQLite.
-
Create Rootly Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Rootly data access from reports, embedded analytics, and more.
-
Connect to Autopilot Data in Jaspersoft Studio
Execute SQL to remote Autopilot in Jaspersoft Studio.
-
Connect to Wave Financial Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
LINQ to Autopilot 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 Autopilot Data Provider.
-
Bitbucket Reporting in OBIEE with the Bitbucket JDBC Driver
Deploy the Bitbucket JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Edit and Search External Adobe Commerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Adobe Commerce to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Adobe Commerce Data objects that you can access from apps and the dashboard.
-
Object-Relational Mapping (ORM) with Zoho Books 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 Zoho Books into a Java-based ORM framework, Hibernate.
-
Analyze Nethunt Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Nethunt in Microsoft R Open.