CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Guru Data through external lists
Provide Guru to SharePoint users as an external list.
-
How to connect PolyBase to Zendesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zendesk.
-
Analyze Live Oracle Service Cloud Data in SAS Viya
Use CData Connect AI to connect to Oracle Service Cloud from SAS Viya and deploy self-service analytics using live Oracle Service Cloud.
-
Build Voice Agents in ElevenLabs with access to Live Trello Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Trello.
-
Connect CampaignMonitor Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CampaignMonitor using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for ZeroBounce in MicroStrategy Web
Connect to ZeroBounce in MicroStrategy Web using the CData Software JDBC Driver for ZeroBounce.
-
Use the CData Software JDBC Driver for Rebilly in MicroStrategy Desktop
Connect to Rebilly in MicroStrategy Desktop using the CData Software JDBC Driver for Rebilly.
-
Integrate Real-Time Access to Codat in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Codat in real time.
-
Provide OData Services of SAP Fieldglass Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Fieldglass by developing a WCF Service Application.
-
Connect to Planio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Planio to connect to Planio and execute queries in PowerBuilder.
-
Visualize Marketo Data in Sisense
Create an ElastiCube in Sisense app with access to Marketo.
-
Connecting GenSpark with Vertica Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Vertica without any replication or custom integration required.
-
SparkPost Reporting in OBIEE with the SparkPost JDBC Driver
Deploy the SparkPost JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Marketo-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Marketo.
-
Integrate Theia IDE with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Automated Continuous Microsoft Exchange Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to SQLite.
-
Integrate with Smartsheet Data in JReport Designer
Create charts and reports based on Smartsheet in JReport Designer.
-
Use the CData Software ODBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify in MicroStrategy Desktop using the CData Software ODBC Driver for Spotify.
-
Create BigQuery-Connected Business Apps in AppSheet
Connect to BigQuery Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Google BigQuery.
-
Connecting GenSpark with SQL Analysis Services Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SQL Analysis Services without any replication or custom integration required.
-
How to Query Excel Online Data in MySQL Workbench
Execute MySQL queries against live Microsoft Excel Online from MySQL Workbench.
-
Build AI Agents with BigCommerce 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 BigCommerce through CData Connect AI.
-
Create Reports from DocuSign Data in Looker Studio
Use CData Connect AI to gain access to live DocuSign and create custom reports in Looker Studio.
-
Automated Continuous eBay Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay replication to MySQL.
-
Connect to Stack Exchange Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Stack Exchange.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zuora using the Model Context Protocol.
-
Query Smartsheet Data in ColdFusion
Write standard ColdFusion data access code to connect to Smartsheet.
-
Connect to SAP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP ERP/NetWeaver.
-
How to Create Power BI Visual Reports with Real-Time Pipedrive Data
Use CData Power BI Connectors to visualize Pipedrive in Power BI.
-
Operational Reporting on EmailOctopus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote EmailOctopus.
-
Connecting Mastra with Raisers Edge NXT Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Raisers Edge NXT, no replication required.
-
Moving Data from Zoho Creator to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Creator data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Query Live WordPress Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live WordPress data in natural language using Python.
-
Access Live PayPal Data in AWS Lambda (with IntelliJ IDEA)
Connect to live PayPal in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Prepare, Blend, and Analyze SAP Netweaver Gateway Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Netweaver Gateway for self-service data analytics.
-
How to Easily Query Rebilly Data in OpenOffice Base
Connect to Rebilly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Impala-Connected Applications in Appsmith
Connect to Impala Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apache Impala.
-
Build Drift-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Drift and build web apps with connectivity to live Drift.
-
Automated Continuous Figshare Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Figshare replication to Google Cloud SQL.
-
How to load Procore data into Elasticsearch via Logstash
Introducing a simple method to load Procore data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share ServiceDesk Plus Data dashboards with Tableau Server
The CData ODBC driver for ServiceDesk Plus enables you integrate ServiceDesk Plus into Tableau dashboards.
-
Connect to Webflow Data in DBArtisan
Use wizards in DBArtisan to configure Webflow as a data source.
-
Integrate Cline with Live Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Procore from within your IDE.
-
Integrating Claude Code CLI with Trello 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.
-
Automated Continuous MongoDB Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MongoDB replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Teams Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Teams to SQL Server.
-
Analyze Shippo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shippo with the CData JDBC Driver for Shippo.
-
How to publish and share Twilio Data dashboards with Tableau Server
The CData ODBC driver for Twilio enables you integrate Twilio into Tableau dashboards.
-
Getting Started with the CData Excel Add-In for Google Campaign Manager 360
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Campaign Manager 360.
-
View Reports on Real-Time MariaDB Data in Power BI Report Server
Use the CData ODBC Driver for MariaDB to visualize MariaDB in Power BI Desktop and then publish them to Power BI Report Server.
-
Write a Simple Go Application to work with Pipeline CRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Pipeline CRM.
-
Visualize Qualaroo Data in Sisense
Create an ElastiCube in Sisense app with access to Qualaroo.
-
Use the CData Software JDBC Driver for SAS Data Sets in MicroStrategy Desktop
Connect to SAS Data Sets in MicroStrategy Desktop using the CData Software JDBC Driver for SAS Data Sets.
-
Use Manus AI to Talk to Your CockroachDB 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 CockroachDB.
-
Connect to Live Zoho Creator Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Creator Data in CData Connect AI and connect to your Zoho Creator from MicroStrategy.
-
DataBind Controls to Quickbase Data in C++Builder
DataBind to Quickbase in C++Builder with standard components and controls.
-
Migrating data from Microsoft Entra ID to Google BigQuery using CData SSIS Components.
Easily push Microsoft Entra ID to Google BigQuery using the CData SSIS Tasks for Microsoft Entra ID and Google BigQuery.
-
Replicate Multiple Avaza Accounts via the CData Sync CLI
Replicate multiple Avaza accounts to one or many databases.
-
Configure the CData JDBC Driver for Rebilly in a Connection Pool in Tomcat
Connect to Rebilly from a connection pool in Tomcat.
-
Query Jira Data in ColdFusion
Write standard ColdFusion data access code to connect to Atlassian Jira.
-
Build Authorize.Net-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Authorize.Net to explore live Authorize.Net Data in Cursor to assist with building Authorize.Net-powered applications.
-
Edit and Search TaxJar External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of TaxJar to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create TaxJar objects that you can access from apps and the dashboard.
-
Build Dashboards with Mistral AI Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mistral AI in Dundas BI.
-
Create Dynamic Clockify Grids Using the Infragistics XamDataGrid
Learn how you can connect Clockify to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Discourse Data with Squirrel SQL client
Connect to Discourse and execute queries in the Squirrel SQL Client.
-
Validate Amplitude Data with QuerySurge
Access and validate Amplitude in QuerySurge using the CData JDBC Driver.
-
DataBind Flowlu Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Flowlu to a chart.
-
Connect to Presto from Asprova with CData Software ODBC Driver for Presto
This article shows how to connect faster to Presto data from Asprova.
-
Query Zoho Recruit Data in DataGrip
Create a Data Source for Zoho Recruit in DataGrip and use SQL to query live Zoho Recruit.
-
Validate ServiceDesk Plus Data with QuerySurge
Access and validate ServiceDesk Plus in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for Superchat from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Superchat to connect to Superchat from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Superchat in Excel.
-
Connect to ZendeskSell Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZendeskSell in the Denodo Virtual DataPort Administrator.
-
Create Pingdom Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pingdom from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous ClickUp Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ClickUp replication to Apache Cassandra.
-
A PostgreSQL Interface for xBase Data using the CData ODBC Driver
Use the SQL Gateway and xBase ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Unbounce Data from Spring Boot
Connect to Unbounce in a Spring Boot Application using the CData API Driver for JDBC
-
Use the CData Software JDBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Teams.
-
Automated Continuous Azure DevOps Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Apache Cassandra.
-
Visualize Eventbrite Data in TIBCO Spotfire through OData
Integrate Eventbrite into dashboards in TIBCO Spotfire.
-
Replicate Multiple Freshteam Accounts via the CData Sync CLI
Replicate multiple Freshteam accounts to one or many databases.
-
Validate SharePoint Excel Services Data with QuerySurge
Access and validate SharePoint Excel Services in QuerySurge using the CData JDBC Driver.
-
How to Query Live ServiceNow Data in Claude Desktop
Connect to and query live ServiceNow Data in Claude Desktop using CData MCP Server.
-
How to connect to Pinterest Data from IntelliJ
Integrate connectivity to Pinterest with wizards in IntelliJ.
-
Connect to PingOne Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PingOne and the SQL Gateway to access PingOne from Google Apps Script.
-
Use JayDeBeApi to access Spark Data in Python
Use standard Python scripting and the development environment of your choice to access live Apache Spark SQL.
-
Automated Continuous Wistia Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Wistia replication to Azure SQL Database.
-
How to Connect to Azure Synapse Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Azure Synapse. Leverage the pyodbc module for ODBC in Python.
-
Build MVC Applications with Connectivity to SAP Netweaver Gateway Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Netweaver Gateway from an ASP.NET MVC application.
-
Import Sage 200 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Sage 200 Data and provide access to live Sage 200 for custom reports in the Power BI Service.
-
Analyze Oracle SCM Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle SCM in Microsoft R Open.
-
Integrating Codex CLI with SAP Business Warehouse 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.
-
Use Microsoft Copilot Studio to talk to your Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Marketo for you.
-
Automated Continuous MariaDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MariaDB replication to Google BigQuery.
-
Access Live Google Search Results in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Search in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Facebook Ads Data Replication to Teradata
Use CData Sync to Customize and automate Facebook Ads replication to Teradata.
-
Building Dynamic Web Pages with Webex Data Using AngularJS
Create single-page applications with live connectivity to Webex using the CData API Server.
-
Use Biml to Build SSIS Tasks to Replicate Amplitude Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Amplitude to SQL Server.
-
How to connect to HDFS Data from Spring Boot
Connect to HDFS in a Spring Boot Application using the CData JDBC Driver for HDFS
-
How to Work with Google Forms Data in ETL Validator JDBC
Connect to Google Forms from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting Mastra with Zoho Inventory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Zoho Inventory, no replication required.