CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Acumatica Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Acumatica replication to Azure SQL Database.
-
Build Twilio-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Twilio to explore live Twilio Data in Cursor to assist with building Twilio-powered applications.
-
Integrate Theia IDE with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Prepare, Blend, and Analyze Greenhouse Data in Alteryx Designer (ODBC)
Build workflows to access live Greenhouse for self-service data analytics.
-
How to connect Amazon QuickSight to GraphQL Data
Create a connection to GraphQL in CData Connect AI and insert GraphQL into Amazon QuickSight SPICE to build interactive dashboards.
-
Access Live SuiteCRM Data in AWS Lambda
Connect to live SuiteCRM in AWS Lambda using the CData JDBC Driver.
-
Access Live Landbot Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Landbot into the statistical analysis tools available in SAS JMP. This article shows how to use Landbot in the Graph Builder and Query Builder.
-
Integrate Theia IDE with Live MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate with Zoho Inventory Data in JReport Designer
Create charts and reports based on Zoho Inventory in JReport Designer.
-
Create Dynamic Workable Grids Using the Infragistics XamDataGrid
Learn how you can connect Workable to Infragistics XamDataGrid to build dynamic grids.
-
Query Azure Data Lake Storage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Data Lake Storage from Node.js.
-
Validate SAP Fieldglass Data with QuerySurge
Access and validate SAP Fieldglass in QuerySurge using the CData JDBC Driver.
-
Connect to SharePoint Excel Services Data in DBArtisan
Use wizards in DBArtisan to configure SharePoint Excel Services as a data source.
-
Design BIRT Reports on Clari Data
Provide current Clari to your embedded analytics.
-
Use the CData Software ODBC Driver for Cloudflare in MicroStrategy
Connect to Cloudflare in MicroStrategy Developer using the CData Software ODBC Driver for Cloudflare.
-
Access Live Tally Data in Coginiti Pro
Connect to and query live Tally ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build a PostgreSQL Interface for Paddle Data using the CData JDBC Driver
Use the Remoting features of the Paddle JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage PolarTeamPro Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PolarTeamPro.
-
Use the CData Software JDBC Driver for Google Analytics in MicroStrategy
Connect to Google Analytics in MicroStrategy Developer using the CData Software JDBC Driver for Google Analytics.
-
Create Power BI Reports on Real-Time Spotify Data
Use the CData ODBC Driver for Spotify to visualize Spotify in Power BI Desktop.
-
Connect to Scrapfly Data in Aqua Data Studio
Access Scrapfly from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Box Data from MySQL in Amazon QuickSight
Connect to Box and build visualizations of Box using a MySQL Connection in Amazon QuickSight.
-
Access Cvent Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Cvent from your Oracle system.
-
How to Build an ETL App for Quickbase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Quickbase in Python with petl and the CData Connect AI Python SDK.
-
Use Manus AI to Talk to Your Highrise 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 Highrise CRM.
-
Automate Recurly Data Replication to SAP HANA
Use CData Sync to customize and automate Recurly replication to SAP HANA.
-
How to Access Live Klaviyo Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Klaviyo enables you to integrate Klaviyo into workflows built using Microsoft Power Automate Desktop.
-
How to connect to iContact Data in DBVisualizer
Integrate iContact with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to MailerLite 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 MailerLite and work with MailerLite in your FileMaker application.
-
Connect to Guru Data in RapidMiner
Integrate Guru with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Snapchat Ads in SpagoBI
Create reports featuring live Snapchat Ads in SpagoBI Studio. Host Snapchat Ads reports on SpagoBI Server.
-
Analyze PDFMonkey Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze PDFMonkey in Microsoft R Open.
-
Use Biml to Build SSIS Tasks to Replicate Freshservice Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshservice to SQL Server.
-
Automated Continuous SurveyMonkey Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to PostgreSQL.
-
DataBind Controls to Google Forms Data in Delphi
DataBind to Google Forms in Delphi with standard data access components and controls.
-
Build Data Flows from MarkLogic to SQL Server using SSIS
Easily back up MarkLogic to SQL Server using the SSIS components for MarkLogic.
-
Connect to and Visualize Live Apify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apify.
-
Integrate Live SAP Business One Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Business One from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Business One.
-
Automate Wrike Data Replication to SAP HANA
Use CData Sync to customize and automate Wrike replication to SAP HANA.
-
Query ZohoPeople Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoPeople from Node.js.
-
Automated Continuous Google Tasks Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Tasks replication to Amazon S3.
-
How to create Exact Online federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Exact Online in MySQL .
-
Connect to QuickBooks Time from Asprova with CData Software ODBC Driver for QuickBooks Time
This article shows how to connect faster to QuickBooks Time data from Asprova.
-
Integrating GitHub Copilot CLI with Oracle SCM 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.
-
Design BIRT Reports on SendPulse Data
Provide current SendPulse to your embedded analytics.
-
Build Webflow-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Webflow.
-
Access Live SAP BusinessObjects BI Data in TIBCO Data Virtualization
Use the SAP BusinessObjects BI Tibco DV Adapter to create a SAP BusinessObjects BI data source in TIBCO Data Virtualization Studio and gain access to live SAP BusinessObjects BI from your TDV Server.
-
Create Data Visualizations in Cognos BI with SurveyMonkey Data
Access SurveyMonkey as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Microsoft OneDrive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft OneDrive Data and connect to Microsoft OneDrive in Akorbi Digital RunMyProcess.
-
Connect to Sage 300 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Sage 300 as an External Source in Dremio.
-
Integrate Chargebee Data in Pentaho Data Integration
Build ETL pipelines based on Chargebee in the Pentaho Data Integration tool.
-
Establish a Live Connection with AfterShip Data using Tableau Bridge
The CData ODBC Driver for AfterShip enables you to integrate live AfterShip into Tableau Cloud dashboards using the Tableau Bridge.
-
Build EnterpriseDB-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for EnterpriseDB Data and create custom apps in Bubble.
-
Use JayDeBeApi to access Adobe Commerce Data in Python
Use standard Python scripting and the development environment of your choice to access live Adobe Commerce.
-
How to connect and process ADP from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ADP.
-
Connect to Cvent from a Connection Pool in WebLogic
Use the CData JDBC Driver for Cvent to connect to Cvent from Web applications running on WebLogic.
-
Access Adobe Commerce Data from MySQL in PHP
Connect to Adobe Commerce through the standard MySQL libraries in PHP.
-
Easily Integrate Invoiced Data in Lazarus Pascal IDE
Learn how to easily integrate live Invoiced in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating LlamaIndex with Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sage Business Cloud Accounting in real time.
-
Use JayDeBeApi to access Foursquare Data in Python
Use standard Python scripting and the development environment of your choice to access live Foursquare.
-
Access Live Sage 200 Data in TIBCO Data Virtualization
Use the Sage 200 Tibco DV Adapter to create a Sage 200 data source in TIBCO Data Virtualization Studio and gain access to live Sage 200 from your TDV Server.
-
Build Apps with Live Salesforce Data 360 Data Using the Low-Code Development Platform of Mendix
Connect Salesforce Data 360 with Mendix to build apps using the CData JDBC Driver for Salesforce Data 360.
-
Integrating Gumloop with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Vertica within automated workflows.
-
Enable the Cosmos DB JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Azure Cosmos DB.
-
How to connect and process Tickspot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tickspot.
-
How to Query Live Dynamics CRM Data in Perplexity MacOS Desktop
Connect to and query live Dynamics CRM Data in Perplexity Desktop using CData MCP Server.
-
Analyze SingleStore Data in Looker
Use CData Connect AI to connect to SingleStore Data from Looker and build custom apps using live SingleStore.
-
Create Bullhorn CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Bullhorn CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to connect and process Sage 300 from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sage 300.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Dataverse (CDS) to Power BI dashboards. Simply drag and drop Microsoft Dataverse (CDS) into data visuals on the Power BI canvas.
-
Query ActiveCampaign Data as a SQL Server Database in Node.js
Execute SQL Server queries against ActiveCampaign from Node.js.
-
Easily Integrate Spark Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Spark SQL in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI Reports on Real-Time Monday.com Data
Use the CData ODBC Driver for Monday.com to visualize Monday.com in Power BI Desktop.
-
Automated Continuous Kafka Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Apache Kafka replication to OneLake in Microsoft Fabric.
-
Integrate Eventbrite Data in the Pentaho Report Designer
Publish reports based on Eventbrite in the Pentaho BI tool.
-
Prepare, Blend, and Analyze Hubstaff Data in Alteryx Designer (ODBC)
Build workflows to access live Hubstaff for self-service data analytics.
-
Connect to Act CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Act CRM.
-
Automated Continuous Freshsales Replication to SingleStore
Use CData Sync for automated, continuous, customizable Freshsales replication to SingleStore.
-
Automated Continuous Excel Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Excel Online replication to PostgreSQL.
-
How to connect to Databricks Data from Spring Boot
Connect to Databricks in a Spring Boot Application using the CData JDBC Driver for Databricks
-
Build Visualizations of JSON Services in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of JSON in Birst.
-
Migrating data from Gmail to Google BigQuery using CData SSIS Components.
Easily push Gmail to Google BigQuery using the CData SSIS Tasks for Gmail and Google BigQuery.
-
Connect to SpaceX Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SpaceX using standard SQL.
-
Excel Spreadsheet Automation on Azure Analysis Services Data with the QUERY Formula
Pull data from Azure Analysis Services, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Elorus Replication to MySQL
Use CData Sync for automated, continuous, customizable Elorus replication to MySQL.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP Hybris C4C in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP Hybris C4C.
-
Create a Data Access Object for Spark Data using JDBI
A brief overview of creating a SQL Object API for Apache Spark SQL in JDBI.
-
Access Live MarkLogic Data in Coginiti Pro
Connect to and query live MarkLogic from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Google Translate Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Translate.
-
Connect to Freshteam Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Freshteam in the Denodo Virtual DataPort Administrator.
-
DataBind Controls to JobNimbus Data in C++Builder
DataBind to JobNimbus in C++Builder with standard components and controls.
-
How to Work with Office 365 Data in AWS Glue Jobs Using JDBC
Connect to Office 365 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for Demio
Create Demio data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Zoho Creator Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Creator by developing a WCF Service Application.
-
Create Dynamic Freshservice Grids Using the Infragistics XamDataGrid
Learn how you can connect Freshservice to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Python Connector for Sage 200
Learn to install and license the CData Python Connector
-
Getting Started with the CData ODBC Driver for Trello
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Trello.
-
Connect Microsoft Exchange to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Microsoft Exchange using the CData Python MCP Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live MySQL using the Model Context Protocol.
-
Analyze Oracle Sales Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Oracle Sales and visualize live Oracle Sales in Infragistics Reveal.