CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Odoo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Odoo replication to SingleStore.
-
Use the CData Software ODBC Driver for Discord in SAS for Real-Time Reporting and Analytics
Connect to real-time Discord data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Discord.
-
Automated Continuous HelloSign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HelloSign replication to Apache Cassandra.
-
Build MySQL-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live MySQL data and build MySQL-connected web apps with Axios.
-
Automated Continuous Eventbrite Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Eventbrite replication to delimited files (CSV/TSV).
-
How to Query Omnisend Data in MySQL Workbench
Execute MySQL queries against live Omnisend data from MySQL Workbench.
-
Integrate Google's Vertex AI Agent with Live Cvent 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 Cvent data within intelligent workflows.
-
Import and Visualize LightSpeedRetail Data in Power View
Create data visualizations based on LightSpeedRetail data in Excel.
-
Build Dashboards with Snowflake Data in DBxtra
Create dynamic dashboards and perform analytics based on Snowflake data in DBxtra.
-
Analyze Avalara AvaTax Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Avalara AvaTax data and visualize Avalara AvaTax data in SAP Analytics Cloud.
-
Connect to Guru 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 Guru and work with Guru data in your FileMaker application.
-
ETL Mode in Oracle Data Integrator
This article shows how to transfer Mode data into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Box Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Box data for you.
-
LINQ to LDAP Objects
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 LDAP Data Provider.
-
Establish a Live Connection with MarkLogic Data using Tableau Bridge
The CData ODBC Driver for MarkLogic enables you to integrate live MarkLogic data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build AI/ML Models with Live Moosend Data using Dataiku
Connect Moosend Data with Dataiku using the CData API Driver for JDBC.
-
Build Vault CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Vault CRM Data and create custom apps in Mendix.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy
Connect to Active Directory data in MicroStrategy Developer using the CData Software JDBC Driver for Active Directory.
-
Getting Started with the CData Tableau Connector for Everhour
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Stream Google Calendar Data into Apache Kafka Topics
Access and stream Google Calendar data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Prepare, Blend, and Analyze Gmail Data in Alteryx Designer (Connect AI)
Build workflows to access live Gmail data for self-service data analytics.
-
Build Gong-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Gong Data and create custom apps in Bubble.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy Web
Connect to Freshservice data in MicroStrategy Web using the CData Software ODBC Driver for Freshservice.
-
Connect to ActiveCampaign Data in ACL Analytics
Connect to ActiveCampaign data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ActiveCampaign data.
-
Use JayDeBeApi to access ConvertAPI Data in Python
Use standard Python scripting and the development environment of your choice to access live ConvertAPI data.
-
Connect to Microsoft Entra ID Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Microsoft Entra ID Data and connect to Microsoft Entra ID data in Akorbi Digital RunMyProcess.
-
Publish Crystal Reports on Greenplum Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Greenplum data.
-
Access Live HBase Data in Excel 365 Online (Excel for the web)
Connect to HBase data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Use the CData Software ODBC Driver for Zendesk in MicroStrategy Web
Connect to Zendesk data in MicroStrategy Web using the CData Software ODBC Driver for Zendesk.
-
Query Zoho Books Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Books data from Node.js.
-
How to Easily Query Pingdom Data in OpenOffice Base
Connect to Pingdom data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData Software ODBC Driver for CampaignMonitor in SAS for Real-Time Reporting and Analytics
Connect to real-time CampaignMonitor data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CampaignMonitor.
-
Use the CData SSIS Components to Insert New or Update Existing LinkedIn Records from SQL Server
Easily push SQL Server data to LinkedIn using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into LinkedIn or update existing records with data from a SQL Server database.
-
How to Connect DBeaver to Pinecone via a JDBC Driver
Manage Pinecone data with visual tools in DBeaver like the query browser.
-
Connect to Pushbullet from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pushbullet to connect to Pushbullet data from Web applications running on WebLogic.
-
Automated Continuous SurveyMonkey Replication to Oracle
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Oracle.
-
Visualize Avro 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 Avro data into TIBCO Spotfire.
-
Build a PostgreSQL Interface for Azure Data Catalog Data using the CData JDBC Driver
Use the Remoting features of the Azure Data Catalog JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Aircall Data in DataGrip
Create a Data Source for Aircall in DataGrip and use SQL to query live Aircall data.
-
Use Dash to Build Web Apps on GitHub Data via CData Connect AI
Build interactive Dash web apps on live GitHub data using pandas and the CData Connect AI Python SDK.
-
Build Snowflake-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Snowflake Data and create custom apps in Bubble.
-
Import Real-Time Act CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Act CRM data in ColdFusion.
-
Import Real-Time SAP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP data in ColdFusion.
-
Connect to Testmonitor Data in Aqua Data Studio
Access Testmonitor data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
DataBind Controls to ZendeskSell Data in Delphi
DataBind to ZendeskSell data in Delphi with standard data access components and controls.
-
Access Live Timely Data in Excel 365 Online (Excel for the web)
Connect to Timely data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Prepare, Blend, and Analyze eBay Analytics Data in Alteryx Designer (Connect AI)
Build workflows to access live eBay Analytics data for self-service data analytics.
-
Using the CData Software ODBC Driver for Google Search in PyCharm
Connect to Google Search as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Search.
-
Automated Continuous Pipedrive Replication to SQLite
Use CData Sync for automated, continuous, customizable Pipedrive replication to SQLite.
-
Build Charts with Outreach.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Outreach.io data in Clear Analytics.
-
How to Connect Flowise AI Agents to Live Gong 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 Gong data without replication.
-
Connect to MongoDB Data in DBArtisan
Use wizards in DBArtisan to configure MongoDB data as a data source.
-
Connect Salesforce Data 360 Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesforce Data 360 data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect the Power BI Service to Confluence: Complete Guide
Connect to the CData Software Power BI Connector for Confluence from PowerBI.com to provide real-time Confluence data across the organization.
-
Connect to BambooHR Data in RapidMiner
Integrate BambooHR data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time Teamgate Data
Use CData Power BI Connectors to visualize Teamgate data in Power BI.
-
How to Connect to Live SAP BusinessObjects BI 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 SAP BusinessObjects BI data through natural language.
-
Automated Continuous Todoist Replication to SingleStore
Use CData Sync for automated, continuous, customizable Todoist replication to SingleStore.
-
Analyze LinkedIn Ads Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LinkedIn Ads data in Microsoft R Open.
-
Integrate Zoho CRM Data in Pentaho Data Integration
Build ETL pipelines based on Zoho CRM data in the Pentaho Data Integration tool.
-
Connect to SAP BusinessObjects BI Data in JRuby
Create a simple JRuby app with access to live SAP BusinessObjects BI data.
-
Build AI/ML Models with Live Dynamics NAV Data using Dataiku
Connect Dynamics NAV Data with Dataiku using the CData JDBC Driver for Dynamics NAV.
-
Bridge BambooHR Connectivity with Apache NiFi
Access and process BambooHR data in Apache NiFi using the CData JDBC Driver.
-
Stream SAP Concur Data into Apache Kafka Topics
Access and stream SAP Concur data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use Azure AI Foundry to Talk to Your DocuSign 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 DocuSign data for you.
-
DataBind Controls to Perigon Data in Delphi
DataBind to Perigon data in Delphi with standard data access components and controls.
-
Integrate SendGrid Data in the Pentaho Report Designer
Publish reports based on SendGrid data in the Pentaho BI tool.
-
Connect to Presto Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Presto data.
-
Create Google Spanner-Connected Business Apps in AppSheet
Connect to Google Spanner Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google Spanner data.
-
Query Twilio Data in DataGrip
Create a Data Source for Twilio in DataGrip and use SQL to query live Twilio data.
-
Connect to Exa Data in Jaspersoft Studio
Execute SQL to remote Exa data in Jaspersoft Studio.
-
Analyze Live Mailjet Data in SAS Viya
Use CData Connect AI to connect to Mailjet data from SAS Viya and deploy self-service analytics using live Mailjet data.
-
How to Connect to Live Optimizely 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 Optimizely data for you.
-
Query Exa Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Exa data from Node.js.
-
Automate Reckon Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Reckon data from PowerShell? This article demonstrates how to utilize the Reckon Cmdlets for tasks like connecting to Reckon data, automating operations, downloading data, and more.
-
Building Dynamic Web Pages with Suadeo Data Using AngularJS
Create single-page applications with live connectivity to Suadeo using the CData API Server.
-
Build Pipelines with Live Twilio Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Twilio from Google Cloud Data Fusion, enabling the integration of live Twilio data into the building and management of effective data pipelines.
-
Automated Continuous SendPulse Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendPulse replication to Amazon Redshift.
-
Natively Connect to Google Tasks Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Tasks data. Leverage the native support for ODBC in PHP.
-
Use Databricks Agent Bricks to Talk to Your Azure DevOps Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Azure DevOps data for you.
-
Getting Started with the CData Power BI Connector for OpenWeatherMap
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Create SSAS Tabular Models from Twilio Data
How to build a SQL Server Analysis Service Tabular Model from Twilio data using CData drivers.
-
Use JayDeBeApi to access Toggl Data in Python
Use standard Python scripting and the development environment of your choice to access live Toggl data.
-
Import Real-Time Azure Data Catalog Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Azure Data Catalog data in ColdFusion.
-
Connect to Adobe Commerce Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Adobe Commerce Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Impala Data from PowerBuilder via JDBC
This article demonstrates how to access Impala data from PowerBuilder using the Impala JDBC Driver.
-
Connect to Google Contacts Data in DBeaver
Use the CData ODBC Driver to connect to Google Contacts data in DBeaver.
-
Use the CData ODBC Driver for Discord in Microsoft Power Query
You can use the CData Discord ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Discord data into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for Spark
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Spark.
-
Interact with Live Apollo Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Apollo data.
-
Integrating Kiro with VWO 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.
-
Create Sage 200-Connected Dashboards in Grafana
Connect to Sage 200 Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Sage 200 data.
-
Rapidly Develop Cloudant-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 Cloudant.
-
Provide OData Services of Deel Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Deel data by developing a WCF Service Application.
-
Integrating Cursor with OnePageCrm 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.
-
Connect to Reckon Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Reckon and the SQL Gateway to access Reckon data from Google Apps Script.
-
Visualize Live Quickbase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Quickbase data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData ODBC Driver for Mailgun in Microsoft Power Query
You can use the CData Mailgun ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mailgun data into Microsoft Power Query.
-
How to load QuickBooks Online data into Elasticsearch via Logstash
Introducing a simple method to load QuickBooks Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Certinia-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Certinia Data and create custom apps in Mendix.