CData Software - Knowledge Base
Recent Articles
-
How to Query Live Power BI XMLA Data in Claude Desktop
Connect to and query live Power BI XMLA Data in Claude Desktop using CData MCP Server.
-
Visualize DocuSign Data in Tableau
The CData ODBC driver for DocuSign enables you integrate DocuSign into Tableau dashboards.
-
How to import ConvertKit Data into Apache Solr
Use the CData Software JDBC Driver for ConvertKit in Data Import Handler and create an automated import of ConvertKit to Apache Solr Enterprise Search platform.
-
Query Basecamp Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Basecamp entities in PHP by modeling them as objects.
-
Automated Continuous Drift Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Drift replication to Apache Kafka.
-
Avaza Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Avaza facts in real time.
-
How to Access Live Avaza Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Avaza enables you to integrate Avaza into workflows built using Microsoft Power Automate Desktop.
-
Connecting Moonlit Workflow with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your GitHub in real time.
-
DataBind Charts to Mixpanel Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mixpanel 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.
-
Access Live CampaignMonitor Data in Coginiti Pro
Connect to and query live CampaignMonitor from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build SAP Business Warehouse-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAP Business Warehouse to explore live SAP Business Warehouse Data in GitHub Copilot to assist with building SAP Business Warehouse-powered applications.
-
Create a Data Access Object for Codat Data using JDBI
A brief overview of creating a SQL Object API for Codat in JDBI.
-
How to connect to SageHR Data with Squirrel SQL client
Connect to SageHR and execute queries in the Squirrel SQL Client.
-
Access Live CockroachDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CockroachDB from your Google Sheets.
-
Connect to Amazon DynamoDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Amazon DynamoDB as an External Source in Dremio.
-
Stream Salesforce CRM Analytics Data into Apache Kafka Topics
Access and stream Salesforce CRM Analytics in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Live Teamgate Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Teamgate.
-
Build Apps with Live JDBC-ODBC Bridge Data Using the Low-Code Development Platform of Mendix
Connect JDBC-ODBC Bridge with Mendix to build apps using the CData JDBC-ODBC Bridge.
-
Integrating GitHub Copilot CLI with Azure Table Storage 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 Easily Query Parallel Data in OpenOffice Base
Connect to Parallel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Delighted Replication to SingleStore
Use CData Sync for automated, continuous, customizable Delighted replication to SingleStore.
-
Automated Continuous Planio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Planio replication to Amazon Redshift.
-
Import Real-Time SendInBlue Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SendInBlue in ColdFusion.
-
Getting Started with the CData Power BI Connector for Rootly
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use Grok to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your BigCommerce for you.
-
Use the CData Software JDBC Driver for Salesforce Data 360 in MicroStrategy
Connect to Salesforce Data 360 in MicroStrategy Developer using the CData Software JDBC Driver for Salesforce Data 360.
-
Connect to IBM Informix Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live IBM Informix.
-
Query CSV Data in ColdFusion
Write standard ColdFusion data access code to connect to CSV/TSV Files.
-
Connect to SAP SuccessFactors LMS Data in Jaspersoft Studio
Execute SQL to remote SAP SuccessFactors LMS in Jaspersoft Studio.
-
Build Data Flows from AgileCRM to SQL Server using SSIS
Easily back up AgileCRM to SQL Server using the SSIS components for AgileCRM.
-
Vimeo Reporting in OBIEE with the Vimeo JDBC Driver
Deploy the Vimeo JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Charts with Perigon Data in Clear Analytics
Create dynamic charts and perform analytics based on Perigon in Clear Analytics.
-
Analyze FormSite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze FormSite with the CData JDBC Driver for FormSite.
-
Import Real-Time Bugsnag Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bugsnag in ColdFusion.
-
Validate NetSuite Data with QuerySurge
Access and validate NetSuite CRM & ERP in QuerySurge using the CData JDBC Driver.
-
Use Claude to Talk to Your Monday.com 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 Monday.com for you.
-
Explore Geographical Relationships in Bright Data Data with Power Map
Create data visualizations with Bright Data in Power Map.
-
Create Informatica Mappings From/To an ODBC Data Source for Mistral AI
Create an ODBC connection to Mistral AI in Informatica and browse and transfer Mistral AI.
-
Use the CData ODBC Driver for Codat in Microsoft Power Query
You can use the CData Codat ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Codat into Microsoft Power Query.
-
Automated Continuous Dynamics 365 Business Central Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to OneLake in Microsoft Fabric.
-
Analyze Salesforce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesforce & Force.com in Microsoft R Open.
-
Connect to AgileCRM from Asprova with CData Software ODBC Driver for AgileCRM
This article shows how to connect faster to AgileCRM data from Asprova.
-
Migrating data from QuickBooks Online to Databricks using CData SSIS Components.
Easily push QuickBooks Online to Databricks using the CData SSIS Tasks for QuickBooks Online and Databricks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for EmailOctopus
Provide connectivity to EmailOctopus through an SAP BusinessObjects universe.
-
Connect to Contentful Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Contentful and the SQL Gateway to access Contentful from Google Apps Script.
-
How to connect to Oracle Service Cloud Data with Squirrel SQL client
Connect to Oracle Service Cloud and execute queries in the Squirrel SQL Client.
-
Access Live Google Directory 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 Google Directory through MCP integration.
-
Integrate Live FreshBooks Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to FreshBooks and integrate live FreshBooks into apps built in Microsoft Power Apps.
-
Use the CData Software ODBC Driver for Retently in SAS for Real-Time Reporting and Analytics
Connect to real-time Retently in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Retently.
-
Integrate with Bannerbear Data in JReport Designer
Create charts and reports based on Bannerbear in JReport Designer.
-
Create DocuSign-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to DocuSign Data from Klipfolio and build custom visualizations using live DocuSign.
-
Use the CData Software JDBC Driver for Adobe Experience Manager in MicroStrategy Web
Connect to Adobe Experience Manager in MicroStrategy Web using the CData Software JDBC Driver for Adobe Experience Manager.
-
Migrating data from RabbitMQ to Databricks using CData SSIS Components.
Easily push RabbitMQ to Databricks using the CData SSIS Tasks for RabbitMQ and Databricks.
-
Connect to Flowlu Data in CloverDX (formerly CloverETL)
Transfer Flowlu using the visual workflow in the CloverDX data integration tool.
-
Import Real-Time Coda Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Coda in ColdFusion.
-
Analyze NetSuite Data in Looker
Use CData Connect AI to connect to NetSuite Data from Looker and build custom apps using live NetSuite CRM & ERP.
-
Connect to Wave Financial Data in Ruby
Connect to Wave Financial in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connecting Mastra with MarkLogic 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 MarkLogic, no replication required.
-
Use the CData ODBC Driver for MarkLogic in Microsoft Power Query
You can use the CData MarkLogic ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MarkLogic into Microsoft Power Query.
-
Connect to Ontraport Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Ontraport as an External Source in Dremio.
-
Connect to Zoho CRM Data in ACL Analytics
Connect to Zoho CRM via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zoho CRM.
-
Integrate Open WebUI with Live Adobe Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Adobe Analytics from within the chat interface.
-
Connect Google Ad Manager to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Ad Manager with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop
Connect to Google Campaign Manager 360 in MicroStrategy Desktop using the CData Software JDBC Driver for Google Campaign Manager 360.
-
Getting Started with the CData Python Connector for Clio
Learn to install and license the CData Python Connector
-
Connect to Adobe Analytics Data in JRuby
Create a simple JRuby app with access to live Adobe Analytics.
-
Access Live Jira Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Atlassian Jira from your Google Sheets.
-
Write a Simple Go Application to work with AdRoll Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to AdRoll.
-
Query Dynamics 365 Business Central Data as a MySQL Database in Node.js
Execute MySQL queries against Dynamics 365 Business Central from Node.js.
-
Connect and Query Live SingleStore Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SingleStore into Databricks
-
How to load SendGrid data into Elasticsearch via Logstash
Introducing a simple method to load SendGrid data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Publish Webex-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Webex.
-
DataBind Charts to Gmail Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Gmail 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.
-
Query Webflow Data in ColdFusion
Write standard ColdFusion data access code to connect to Webflow.
-
Build an OLAP Cube in SSAS from Microsoft Teams Data
Establish a connection to Microsoft Teams data from SQL Server Analysis Services, and use the Microsoft Teams Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Access Live SAP SuccessFactors LMS Data in Visual Studio Code via Cline
Run CData MCP Server for SAP SuccessFactors LMS on Windows Subsytem for Linux (WSL) and connect to live SAP SuccessFactors LMS from the Cline extension in Visual Studio Code.
-
Consume Email OData Feeds in PowerBuilder
This article demonstrates how to consume Email as OData feeds from PowerBuilder using the API Server.
-
Create SSAS Tabular Models from RSS Feeds
How to build a SQL Server Analysis Service Tabular Model from RSS Feeds using CData drivers.
-
Integrate with Jodoo Data in JReport Designer
Create charts and reports based on Jodoo in JReport Designer.
-
View Reports on Real-Time ZarMoney Data in Power BI Report Server
Use the CData ODBC Driver for ZarMoney to visualize ZarMoney in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData ODBC Driver for LinkedIn from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LinkedIn to connect to LinkedIn from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LinkedIn in Excel.
-
Automated Continuous Google Ads Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon Redshift.
-
Connect Freshdesk to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Freshdesk with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to Zoho Recruit Data from IntelliJ
Integrate connectivity to Zoho Recruit with wizards in IntelliJ.
-
Build SAP SuccessFactors Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP SuccessFactors and build visualizations in Tableau.
-
Access Live Microsoft Entra ID Data in TIBCO Data Virtualization
Use the Microsoft Entra ID Tibco DV Adapter to create a Microsoft Entra ID data source in TIBCO Data Virtualization Studio and gain access to live Microsoft Entra ID from your TDV Server.
-
Build Oracle SCM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle SCM Data from Zoho Analytics and import live Oracle SCM.
-
Use JayDeBeApi to access Contentful Data in Python
Use standard Python scripting and the development environment of your choice to access live Contentful.
-
Azure DevOps Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Azure DevOps facts in real time.
-
Access Live IBM Cloud Object Storage Data in Excel 365 Online (Excel for the web)
Connect to IBM Cloud Object Storage from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Integrate with Avro Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Avro in SnapLogic.
-
Integrate Live ZohoMarketingHub Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoMarketingHub to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Publish Reports with LDAP Objects in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LDAP.
-
Integrating GitHub Copilot CLI with Apache CouchDB 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.
-
Replicate Microsoft Dataverse Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Dataverse (CDS) to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Jetty Security Notice Overview
CData is aware of a potential security issue with the Jetty embedded webserver (versions as high as 10.0.20, 11.0.20, and 12.0.7).
-
Create Reports from Twilio Data in Looker Studio
Use CData Connect AI to gain access to live Twilio and create custom reports in Looker Studio.
-
How to connect to Cloudant Data with Squirrel SQL client
Connect to IBM Cloudant and execute queries in the Squirrel SQL Client.
-
Integrating Claude Code CLI with SAP Concur 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.
-
Build a Singer.io Tap for MYOB AccountRight With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MYOB AccountRight data using