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 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 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 from MySQL Workbench.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Cvent within intelligent workflows.
-
Import and Visualize LightSpeedRetail Data in Power View
Create data visualizations based on LightSpeedRetail in Excel.
-
Build Dashboards with Snowflake Data in DBxtra
Create dynamic dashboards and perform analytics based on Snowflake in DBxtra.
-
Analyze Avalara AvaTax Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Avalara AvaTax and visualize Avalara AvaTax 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 in your FileMaker application.
-
ETL Mode in Oracle Data Integrator
This article shows how to transfer Mode 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 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 into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Databricks-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Databricks to explore live Databricks Data in Cursor to assist with building Databricks-powered applications.
-
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 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 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 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 in MicroStrategy Web using the CData Software ODBC Driver for Freshservice.
-
Connect to ActiveCampaign Data in ACL Analytics
Connect to ActiveCampaign via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ActiveCampaign.
-
Use JayDeBeApi to access ConvertAPI Data in Python
Use standard Python scripting and the development environment of your choice to access live ConvertAPI.
-
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 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 Pivotal GreenPlum.
-
Access Live HBase Data in Excel 365 Online (Excel for the web)
Connect to Apache HBase 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 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 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 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 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 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 Apache Avro 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.
-
Use Dash to Build Web Apps on GitHub Data via CData Connect AI
Build interactive Dash web apps on live GitHub 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 in ColdFusion.
-
Import Real-Time SAP Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SAP ERP/NetWeaver in ColdFusion.
-
Connect to Testmonitor Data in Aqua Data Studio
Access Testmonitor 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 in Delphi with standard data access components and controls.
-
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 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 without replication.
-
Connect to MongoDB Data in DBArtisan
Use wizards in DBArtisan to configure MongoDB 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 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 Atlassian Confluence across the organization.
-
Connect to BambooHR Data in RapidMiner
Integrate BambooHR 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 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 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 in Microsoft R Open.
-
Integrate Zoho CRM Data in Pentaho Data Integration
Build ETL pipelines based on Zoho CRM 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.
-
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 in Apache NiFi using the CData JDBC Driver.
-
Stream SAP Concur Data into Apache Kafka Topics
Access and stream SAP Concur 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 for you.
-
DataBind Controls to Perigon Data in Delphi
DataBind to Perigon in Delphi with standard data access components and controls.
-
Integrate SendGrid Data in the Pentaho Report Designer
Publish reports based on SendGrid 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.
-
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.
-
Query Twilio Data in DataGrip
Create a Data Source for Twilio in DataGrip and use SQL to query live Twilio.
-
Connect to Exa Data in Jaspersoft Studio
Execute SQL to remote Exa in Jaspersoft Studio.
-
Query Exa Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Exa from Node.js.
-
Automate Reckon Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Reckon from PowerShell? This article demonstrates how to utilize the Reckon Cmdlets for tasks like connecting to Reckon, 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 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. 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 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 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.
-
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 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 Apache Impala from PowerBuilder using the Impala JDBC Driver.
-
Connect to Google Contacts Data in DBeaver
Use the CData ODBC Driver to connect to Google Contacts 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 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.
-
Integrating Kiro CLI 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.
-
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 by developing a WCF Service Application.
-
Integrating Cursor CLI 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 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 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 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.
-
Connect to Impala Data in Ruby
Connect to Apache Impala in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Work with Mocean Data in AWS Glue Jobs Using JDBC
Connect to Mocean from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connecting GenSpark with Raisers Edge NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Raisers Edge NXT without any replication or custom integration required.
-
Connect to Greenhouse Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Greenhouse from Filemaker Pro on Mac.