CData Software - Knowledge Base
Recent Articles
-
Publish EnterpriseDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live EnterpriseDB.
-
Connect to Clockify Data from a Connection Pool in Jetty
The Clockify JDBC Driver supports connection pooling: This article shows how to connect faster to Clockify from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Missive in MicroStrategy Desktop
Connect to Missive in MicroStrategy Desktop using the CData Software ODBC Driver for Missive.
-
How to Access Nethunt Data Using Entity Framework
This article shows how to access Nethunt using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate Theia IDE with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate with Bright Data Data in JReport Designer
Create charts and reports based on Bright Data in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing Cloud through an SAP BusinessObjects universe.
-
Automated Continuous Amazon S3 Replication to Databricks
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Databricks.
-
Build Voice Agents in ElevenLabs with access to Live Authorize.Net Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Authorize.Net.
-
Connect to Google Drive Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Drive Data and connect to Google Drive in Akorbi Digital RunMyProcess.
-
Process & Analyze Asana Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Asana Data.
-
Connect to IBM Cloud Object Storage Data in RapidMiner
Integrate IBM Cloud Object Storage with standard components and data source configuration wizards in RapidMiner Studio.
-
Build AI Agents with Google Calendar Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Google Calendar through CData Connect AI.
-
DataBind SAP Business Warehouse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP Business Warehouse with the DevExpress Windows Forms and Web controls to provide SAP Business Warehouse to a chart.
-
Enable the Spotify JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Spotify.
-
Automated Continuous Wave Financial Replication to Vertica
Use CData Sync for automated, continuous, customizable Wave Financial replication to Vertica.
-
Build HBase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for HBase to explore live HBase Data in Gemini Code Assist to assist with building HBase-powered applications.
-
How to Seamlessly Import Authorize.Net Data into IBM SPSS Modeler
Integrate Authorize.Net data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for MYOB AccountRight
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for MYOB AccountRight.
-
Rapidly Develop Pinterest-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 Pinterest.
-
How to Build an ETL App for Sybase Data in Python with CData Connect AI
Build ETL pipelines that read and write live Sybase in Python with petl and the CData Connect AI Python SDK.
-
Prepare, Blend, and Analyze Snapchat Ads Data in Alteryx Designer (ODBC)
Build workflows to access live Snapchat Ads for self-service data analytics.
-
Build Data Flows from SQL Server to Oracle Eloqua through SSIS
Easily push SQL Server data to Oracle Eloqua using the CData SSIS Tasks for Oracle Eloqua.
-
Seamlessly Bring Square Data into Retool Using CData Connect AI
Integrate Square data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Telegram-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Telegram and build web apps with connectivity to live Telegram.
-
Integrate Box Data in Pentaho Data Integration
Build ETL pipelines based on Box in the Pentaho Data Integration tool.
-
How to Connect to Live Certinia 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 Certinia for you.
-
How to connect to SendPulse Data in DBVisualizer
Integrate SendPulse with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Quickbase Data in TIBCO Spotfire through ADO.NET
Integrate Quickbase into dashboards in TIBCO Spotfire.
-
Visualize Live Google Contacts Data in the Power BI Service
Use CData Connect AI to connect to live Google Contacts and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect Flowise AI Agents to Live Okta 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 Okta without replication.
-
LINQ to LeadDesk 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 LeadDesk Data Provider.
-
Build Dashboards with SAP BusinessObjects BI Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI in DBxtra.
-
Use the CData Software ODBC Driver for Lakebase in SAS for Real-Time Reporting and Analytics
Connect to real-time Lakebase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Lakebase.
-
How to Connect the Power BI Service to Eventbrite: Complete Guide
Connect to the CData Software Power BI Connector for Eventbrite from PowerBI.com to provide real-time Eventbrite across the organization.
-
Connect to Excel Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Excel Online from HeidiSQL.
-
Build MVC Applications with Connectivity to Bright Data Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Bright Data from an ASP.NET MVC application.
-
Automated Continuous Calendly Replication to SQL Server
Use CData Sync for automated, continuous, customizable Calendly replication to SQL Server.
-
Visualize EnterpriseDB Data in TIBCO Spotfire through OData
Integrate EnterpriseDB into dashboards in TIBCO Spotfire.
-
Integrating SparkPost Data in Talend Cloud Data Management Platform
Connect SparkPost Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Load Strava Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Strava to a database.
-
Create SAP Hybris C4C-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Hybris C4C Data from Klipfolio and build custom visualizations using live SAP Hybris C4C.
-
Connect to ScrapingBee Data from PowerBuilder via JDBC
This article demonstrates how to access ScrapingBee from PowerBuilder using the ScrapingBee JDBC Driver.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy Web
Connect to LDAP in MicroStrategy Web using the CData Software ODBC Driver for LDAP.
-
Automate Microsoft OneLake Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft OneLake replication to Couchbase.
-
Publish Crystal Reports on Trello Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Trello.
-
Create Informatica Mappings From/To an ODBC Data Source for SuiteCRM
Create an ODBC connection to SuiteCRM in Informatica and browse and transfer SuiteCRM.
-
Create Power BI Reports on Real-Time SingleStore Data
Use the CData ODBC Driver for SingleStore to visualize SingleStore in Power BI Desktop.
-
Build Semantic Layer Views for CSV Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for CSV/TSV Files.
-
Access Reply.io Data from MySQL in PHP
Connect to Reply.io through the standard MySQL libraries in PHP.
-
Connect and Visualize Live IBM Informix Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live IBM Informix into the Databricks platform and create visualization dashboards with real-time IBM Informix.
-
Automated Continuous SAP BusinessObjects BI Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Apache Kafka.
-
Automate GetResponse Data Replication to Couchbase
Use CData Sync to Customize and automate GetResponse replication to Couchbase.
-
Integrate Live Drip Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Drip to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Dashboards with Salesforce Pardot Data in DBxtra
Create dynamic dashboards and perform analytics based on Salesforce Pardot in DBxtra.
-
Access Live Snapchat Ads Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Snapchat Ads from your Google Sheets.
-
How to Query Live Snapchat Ads Data in Perplexity MacOS Desktop
Connect to and query live Snapchat Ads Data in Perplexity Desktop using CData MCP Server.
-
Connect to Rootly Data in RazorSQL
Connect to Rootly from wizards and query Rootly from the GUI in the RazorSQL database management tool.
-
Visualize Live Confluence Data in the Power BI Service
Use CData Connect AI to connect to live Atlassian Confluence and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to load XML data into Elasticsearch via Logstash
Introducing a simple method to load XML data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to SharePoint Excel Services Data from a Connection Pool in Jetty
The SharePoint Excel Services JDBC Driver supports connection pooling: This article shows how to connect faster to SharePoint Excel Services from Web apps in Jetty.
-
Deploy the ADO.NET Provider for CouchDB on an SSRS Report Server
Connect to Apache CouchDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData ADO.NET Provider for Anaplan
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Anaplan.
-
Load ConstantContact Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load ConstantContact to a database.
-
Access Live Google Ads Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Google Ads data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Automated Continuous SAP Concur Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Concur replication to Oracle.
-
Import Real-Time FreshBooks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use FreshBooks in ColdFusion.
-
Analyze Outreach.io Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Outreach.io and visualize live Outreach.io in Infragistics Reveal.
-
A PostgreSQL Interface for Shopify Data using the CData ODBC Driver
Use the SQL Gateway and Shopify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Supabase Data Replication to Teradata
Use CData Sync to Customize and automate Supabase replication to Teradata.
-
Use the CData ODBC Driver for MYOB AccountRight from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MYOB AccountRight to connect to MYOB AccountRight from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MYOB AccountRight in Excel.
-
Automate Blackbaud FE NXT Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Blackbaud FE NXT and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Codex CLI with Deel 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 Odoo in SpagoBI
Create reports featuring live Odoo ERP in SpagoBI Studio. Host Odoo reports on SpagoBI Server.
-
Visualize Anaplan Data in TIBCO Spotfire through ADO.NET
Integrate Anaplan into dashboards in TIBCO Spotfire.
-
How to connect to Microsoft Teams Data from IntelliJ
Integrate connectivity to Microsoft Teams with wizards in IntelliJ.
-
Create Dashboards and Visualize Live Xero Data in Geckoboard
Use CData Connect AI to connect to live Xero Accounting and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Edit and Search FTP External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of FTP Servers to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create FTP objects that you can access from apps and the dashboard.
-
Integrate LibreChat with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Kintone from within the chat interface.
-
Automated Continuous ADP Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ADP replication to Azure SQL Database.
-
Validate YouTube Analytics Data with QuerySurge
Access and validate YouTube Analytics in QuerySurge using the CData JDBC Driver.
-
Access Live SendPulse Data in Coginiti Pro
Connect to and query live SendPulse from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Zoho Books Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Zoho Books replication to Apache Kafka.
-
Create Vertica-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Vertica Data from OutSystems and build custom enterprise apps using live Vertica.
-
ETL ServiceNow in Oracle Data Integrator
This article shows how to transfer ServiceNow into a data warehouse using Oracle Data Integrator.
-
Build Splunk-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Splunk to explore live Splunk Data in Gemini Code Assist to assist with building Splunk-powered applications.
-
How to work with CouchDB Data in Apache Spark using SQL
Access and process CouchDB Data in Apache Spark using the CData Software JDBC Driver.
-
Excel Spreadsheet Automation on Auth0 Data with the QUERY Formula
Pull data from Auth0, automate spreadsheets, and more with the QUERY formula.
-
Validate Zoho CRM Data with QuerySurge
Access and validate Zoho CRM in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Salesforce Marketing from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Marketing Cloud in Excel.
-
Integrating GitHub Copilot CLI with Microsoft SharePoint 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.
-
How to connect to Nuclia Data with Squirrel SQL client
Connect to Nuclia and execute queries in the Squirrel SQL Client.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Elorus
Provide connectivity to Elorus through an SAP BusinessObjects universe.
-
Integrate with Zoho Creator Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Zoho Creator to a JSON file on disk.
-
Automated Continuous ActiveCampaign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to AlloyDB.
-
Import Real-Time Sybase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sybase in ColdFusion.
-
Build AI/ML Models with Live Adobe Target Data using Dataiku
Connect Adobe Target Data with Dataiku using the CData JDBC Driver for Adobe Target.
-
Working with Xero Data in LINQPad
Execute LINQ queries to Xero Accounting in LINQPad.
-
Integrating OpenCode Terminal with Exact Online 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.
-
How to connect PolyBase to CampaignMonitor
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CampaignMonitor.