CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Mode Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Mode replication to Apache Kafka.
-
Integrating LangGraph with Gmail Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Gmail within automated workflows.
-
How to Connect to & Open Outlook Data in Microsoft Excel
This article uses the CData ODBC driver for Outlook to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time Aha! Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Aha! in ColdFusion.
-
Analyze Odoo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Odoo ERP in Microsoft R Open.
-
Query Flowlu Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Flowlu and perform CRUD operations on Flowlu from Node.js.
-
Bridge Ontraport Connectivity with Apache NiFi
Access and process Ontraport in Apache NiFi using the CData JDBC Driver.
-
Create Azure Table-Connected Business Apps in AppSheet
Connect to Azure Table Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Table Storage.
-
Use the CData API Server to Access Sage Cloud Accounting Data in Microsoft PowerPivot
Use the CData API Server to connect to live Sage Business Cloud Accounting in the Power Pivot business intelligence tool.
-
Stream Google Drive Data into Apache Kafka Topics
Access and stream Google Drive in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Automated Workflows with Live Microsoft Planner Data in Workato
Use CData Connect AI to connect to live Microsoft Planner and build automated workflows in Workato.
-
Connect to Float Data in RapidMiner
Integrate Float with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Python Connector for Microsoft Ads
Learn to install and license the CData Python Connector
-
Build Automated Workflows with Live Gong Data in Workato
Use CData Connect AI to connect to live Gong and build automated workflows in Workato.
-
Connect and Visualize Live QuickBooks Online Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live QuickBooks Online into the Databricks platform and create visualization dashboards with real-time QuickBooks Online.
-
How to load Google Cloud Storage data into Elasticsearch via Logstash
Introducing a simple method to load Google Cloud Storage data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Salesforce-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Salesforce to explore live Salesforce Data in GitHub Copilot to assist with building Salesforce-powered applications.
-
Automated Continuous Sugar CRM Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sugar CRM replication to OneLake in Microsoft Fabric.
-
Integrating LlamaIndex with Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Databricks in real time.
-
Visualize Live SendPulse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SendPulse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
View Reports on Real-Time GitHub Data in Power BI Report Server
Use the CData ODBC Driver for GitHub to visualize GitHub in Power BI Desktop and then publish them to Power BI Report Server.
-
Operational Reporting on Google Calendar Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Calendar.
-
Query Odoo Data as a SQL Server Database in Node.js
Execute SQL Server queries against Odoo ERP from Node.js.
-
Build MVC Applications with Connectivity to Hugging Face Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Hugging Face from an ASP.NET MVC application.
-
Build SuiteCRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SuiteCRM to explore live SuiteCRM Data in GitHub Copilot to assist with building SuiteCRM-powered applications.
-
Connect to Shippo in SpagoBI
Create reports featuring live Shippo in SpagoBI Studio. Host Shippo reports on SpagoBI Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Cloud Object Storage
Provide connectivity to IBM Cloud Object Storage through an SAP BusinessObjects universe.
-
Stream XML Data into Apache Kafka Topics
Access and stream XML Files in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live Oracle SCM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle SCM through MCP integration.
-
Natively Connect to Power BI XMLA Data in PHP
The CData ODBC driver for Power BI XMLA enables you to create PHP applications with connectivity to Power BI XMLA. Leverage the native support for ODBC in PHP.
-
DataBind Controls to Redis Data in C++Builder
DataBind to Redis in C++Builder with standard components and controls.
-
Access Live Auth0 Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Auth0 data source in TIBCO Data Virtualization Studio and gain access to live Auth0 from your TDV Server.
-
Connect to Rootly Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Rootly to connect to Rootly and execute queries in PowerBuilder.
-
DataBind Charts to Clockify Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Clockify from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Use the CData Software JDBC Driver for GetResponse in MicroStrategy
Connect to GetResponse in MicroStrategy Developer using the CData Software JDBC Driver for GetResponse.
-
Automated Continuous AgileCRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable AgileCRM replication to IBM DB2.
-
Access Live Short.io Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Short.io into the statistical analysis tools available in SAS JMP. This article shows how to use Short.io in the Graph Builder and Query Builder.
-
Analyze Zoho CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Zoho CRM and visualize Zoho CRM in SAP Analytics Cloud.
-
Connect and Visualize Live Snowflake Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Snowflake into the Databricks platform and create visualization dashboards with real-time Snowflake.
-
Replicate Multiple Xero Accounts
Replicate multiple Xero accounts to one or many databases.
-
Automated Continuous Teamwork Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Teamwork replication to Apache Kafka.
-
How to Query Live Bannerbear Data in Claude Desktop
Connect to and query live Bannerbear Data in Claude Desktop using CData MCP Server.
-
Publish Dynamics CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Dynamics CRM.
-
Integrate Google Tasks Data in Pentaho Data Integration
Build ETL pipelines based on Google Tasks in the Pentaho Data Integration tool.
-
Build Semantic Layer Views for Microsoft Teams Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Teams.
-
Analyze Helpscout Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Helpscout and visualize live Helpscout in Infragistics Reveal.
-
Connect to Dynamics CRM Data in NetBeans
Connect to Microsoft Dynamics CRM in NetBeans with the data source configuration wizard.
-
Visualize Sendwithus Data in TIBCO Spotfire through OData
Integrate Sendwithus into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from LionDesk Data
Establish a connection to LionDesk data from SQL Server Analysis Services, and use the LionDesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Azure Table-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Azure Table Data from OutSystems and build custom enterprise apps using live Azure Table Storage.
-
How to import Webflow Data into Apache Solr
Use the CData Software JDBC Driver for Webflow in Data Import Handler and create an automated import of Webflow to Apache Solr Enterprise Search platform.
-
Access Live CSV Data in Excel 365 Online (Excel for the web)
Connect to CSV/TSV Files from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous NetSuite SuiteAnalytics Replication to Databricks
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to Databricks.
-
Build Data Flows from Oracle to SQL Server using SSIS
Easily back up Oracle Database to SQL Server using the SSIS components for Oracle.
-
Building Dynamic Web Pages with Certinia Data Using AngularJS
Create single-page applications with live connectivity to Certinia using the CData API Server.
-
Create Oracle Service Cloud-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Service Cloud Data from Klipfolio and build custom visualizations using live Oracle Service Cloud.
-
How to Seamlessly Import Azure Table Data into IBM SPSS Modeler
Integrate Azure Table data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Live Zoho Recruit Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Zoho Recruit into the statistical analysis tools available in SAS JMP. This article shows how to use Zoho Recruit in the Graph Builder and Query Builder.
-
Connect to SAP Fieldglass Data from a Connection Pool in JBoss
Integrate SAP Fieldglass into Java servlets: Use the Management Console in JBoss to install the SAP Fieldglass JDBC Driver.
-
Explore Geographical Relationships in Attio Data with Power Map
Create data visualizations with Attio in Power Map.
-
Connect to Confluence Data in JRuby
Create a simple JRuby app with access to live Atlassian Confluence.
-
Build Apps with Live Azure Synapse in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Synapse into the Adalo platform and build custom mobile and web applications with real-time Azure Synapse.
-
Prepare, Blend, and Analyze Asana Data in Alteryx Designer (Connect AI)
Build workflows to access live Asana for self-service data analytics.
-
Automated Continuous Zoho CRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho CRM replication to AlloyDB.
-
Automated Continuous Pingdom Replication to SQLite
Use CData Sync for automated, continuous, customizable Pingdom replication to SQLite.
-
Automate ChargeOver Data Replication to Azure Data Lake
Use CData Sync to customize and automate ChargeOver replication to Azure Data Lake.
-
How to Visualize Hubstaff Data in Python with pandas
Use pandas and other modules to analyze and visualize live Hubstaff in Python.
-
Create Data Visualizations in Cognos BI with ChargeOver Data
Access ChargeOver as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Dashboards and Visualize Live Slack Data in Geckoboard
Use CData Connect AI to connect to live Slack and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrating LangGraph with ActiveCampaign Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ActiveCampaign within automated workflows.
-
Replicate eBay Analytics Data to Multiple Databases
Replicate eBay Analytics to disparate databases with a point-and-click configuration.
-
Automated Continuous Ontraport Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Ontraport replication to Google Cloud SQL.
-
Build WordPress-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live WordPress.
-
Integrating Kiro CLI with Avalara AvaTax 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.
-
Integrate Cursor with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Financials Cloud from within the editor.
-
Build Cloudant-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live IBM Cloudant.
-
Replicate Instantly Data from PowerShell
Write a quick PowerShell script to query Instantly. Use connectivity to the live data to replicate Instantly to SQL Server.
-
LINQ to Gmail 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 Gmail Data Provider.
-
Use the CData ODBC Driver for FHIR in Microsoft Power Query
You can use the CData FHIR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FHIR into Microsoft Power Query.
-
Import Real-Time Jira Assets Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Jira Assets in ColdFusion.
-
Automated Continuous Billsby Replication to MySQL
Use CData Sync for automated, continuous, customizable Billsby replication to MySQL.
-
Connect to Exact Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Exact Online from HeidiSQL.
-
Publish Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.
-
Automated Continuous PolarTeamPro Replication to MySQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MySQL.
-
Connect to PDFMonkey Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Act CRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Act CRM from HeidiSQL.
-
Integrate with Gmail Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gmail to a JSON file on disk.
-
How to connect to XML Data in DBVisualizer
Integrate XML Files with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous ZohoExpense Replication to SQL Server
Use CData Sync for automated, continuous, customizable ZohoExpense replication to SQL Server.
-
Getting Started with the CData Tableau Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Perform Batch Operations with QuickBooks Data in Apache NiFi
Connect to QuickBooks Desktop and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build Dashboards with LinkedIn Data in Dundas BI
Create dynamic dashboards and perform analytics based on LinkedIn in Dundas BI.
-
Choosing the Best Method to Connect ADP to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ADP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Prepare, Blend, and Analyze Browserless Data in Alteryx Designer (ODBC)
Build workflows to access live Browserless for self-service data analytics.
-
Creating Sage Cloud Accounting-Connected Applications in Unqork
You can use CData Connect AI to feed Sage Business Cloud Accounting to Unqork and build custom business apps.
-
Import Real-Time Pinterest Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pinterest in ColdFusion.
-
How to Connect to FreeAgent Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to FreeAgent. Leverage the pyodbc module for ODBC in Python.
-
Use Claude to Talk to Your Act-On 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 Act-On for you.
-
Build CSV-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for CSV Data and create custom apps in Bubble.
-
Use the CData Software JDBC Driver for Ontraport in MicroStrategy Desktop
Connect to Ontraport in MicroStrategy Desktop using the CData Software JDBC Driver for Ontraport.