CData Software - Knowledge Base
Recent Articles
-
Create Datasets from Google Campaign Manager 360 in Domo Workbench and Build Visualizations of Google Campaign Manager 360 Data in Domo
Use the CData Software ODBC Driver for Google Campaign Manager 360 to create datasets from Google Campaign Manager 360 data in Domo Workbench and then build visualizations in the Domo service.
-
Replicate OnePageCrm Data to Multiple Databases
Replicate OnePageCrm data to disparate databases with a point-and-click configuration.
-
How to Connect the Power BI Service to ZohoInvoice: Complete Guide
Connect to the CData Software Power BI Connector for ZohoInvoice from PowerBI.com to provide real-time ZohoInvoice data across the organization.
-
Use Grok to Talk to Your DocuSign 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 DocuSign data for you.
-
Automated Continuous Salesforce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Salesforce replication to SQL Server.
-
Connect to Monday.com Data in RazorSQL
Connect to Monday.com from wizards and query Monday.com data from the GUI in the RazorSQL database management tool.
-
View Reports on Real-Time Bullhorn CRM Data in Power BI Report Server
Use the CData ODBC Driver for Bullhorn CRM to visualize Bullhorn CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
DataBind Charts to Cosmos DB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Cosmos DB data 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.
-
Stream Apollo Data into Apache Kafka Topics
Access and stream Apollo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Hugging Face with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hugging Face with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Hugging Face data.
-
Integrate LibreChat with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Basecamp data from within the chat interface.
-
Connect to Active Directory Data from AWS Glue
Use CData Connect AI to gain access to live Active Directory data from your AWS Glue jobs.
-
How to Connect to Live DB2 Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your DB2 data for you.
-
Getting Started with the CData Python Connector for Aircall
Learn to install and license the CData Python Connector and configure a connection to live Aircall data.
-
Seamlessly Bring eBay Data into Retool Using CData Connect AI
Integrate eBay data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use the CData ODBC Driver for HubDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HubDB to connect to HubDB data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HubDB data in Excel.
-
Connect to SAP Fieldglass Data in JRuby
Create a simple JRuby app with access to live SAP Fieldglass data.
-
How to Seamlessly Import Autopilot Data into IBM SPSS Modeler
Integrate Autopilot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access ServiceDesk Plus Data from MySQL in PHP
Connect to ServiceDesk Plus through the standard MySQL libraries in PHP.
-
Visualize Azure Data Lake Storage Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Data Lake Storage data.
-
Integrate Google's Antigravity Agent with Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP HANA data using the Model Context Protocol.
-
Automate Airtable Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Airtable data from PowerShell? This article demonstrates how to utilize the Airtable Cmdlets for tasks like connecting to Airtable data, automating operations, downloading data, and more.
-
Getting Started with the CData Connect AI Python SDK for Greenhouse
Install the CData Connect AI Python SDK to read live Greenhouse data with standard DB-API 2.0 Python code.
-
Explore Geographical Relationships in Drip Data with Power Map
Create data visualizations with Drip data in Power Map.
-
Access Email Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Email data from your Oracle system.
-
Connect to Zoom from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoom data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Avro Data in Ruby
Connect to Avro data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Microsoft Dataverse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Dataverse data in Microsoft R Open.
-
Build Kafka-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Kafka data and build Kafka-connected web apps with Axios.
-
Excel Spreadsheet Automation on ServiceNow Data with the QUERY Formula
Pull data from ServiceNow, automate spreadsheets, and more with the QUERY formula.
-
Use Azure AI Foundry to Talk to Your WordPress 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 WordPress data for you.
-
Import Real-Time Unbounce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Unbounce data in ColdFusion.
-
How to Connect to Live Microsoft Entra ID Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Entra ID data for you.
-
Automated Continuous SendInBlue Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendInBlue replication to Amazon Redshift.
-
Build Pipedrive-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pipedrive data.
-
Connect SAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP data using the CData Python MCP Server.
-
Connect to MySQL Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MySQL data using standard SQL.
-
Access Salesforce Marketing Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Salesforce Marketing data.
-
Automate Aweber Data Replication to Azure Data Lake
Use CData Sync to customize and automate Aweber data replication to Azure Data Lake.
-
Use Dash to Build to Web Apps on ScrapingBee Data
Create Python applications that use pandas and Dash to build ScrapingBee-connected web apps.
-
Connect to Real-Time Paylocity Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Paylocity and Dataflow to import and use Paylocity data in Power Apps.
-
Extract, Transform, and Load Cloudflare Data in Informatica PowerCenter
Create a simple Workflow for Cloudflare data in Informatica PowerCenter.
-
Add ZohoMarketingHub Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoMarketingHub with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Work with ShipEngine Data in AWS Glue Jobs Using JDBC
Connect to ShipEngine from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Mocean Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mocean data data in natural language using Python.
-
Bridge Azure Table Connectivity with Apache NiFi
Access and process Azure Table data in Apache NiFi using the CData JDBC Driver.
-
Viewing Workable Data in RAD Studio Data Explorer
How to view Workable data in RAD Studio Data Explorer using the CData ODBC Driver for Workable.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot data in MicroStrategy Desktop using the CData Software JDBC Driver for HubSpot.
-
Use the CData Software ODBC Driver for PDFMonkey in MicroStrategy Desktop
Connect to PDFMonkey data in MicroStrategy Desktop using the CData Software ODBC Driver for PDFMonkey.
-
Automated Continuous Vertica Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Vertica replication to Apache Cassandra.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel
Provide connectivity to Excel data through an SAP BusinessObjects universe.
-
Process & Analyze CockroachDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live CockroachDB Data.
-
Getting Started with the CData Python Connector for Microsoft Exchange
Learn to install and license the CData Python Connector and configure a connection to live Microsoft Exchange data.
-
Connect to Short.io Data in Ruby
Connect to Short.io data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect the Power BI Service to Highrise: Complete Guide
Connect to the CData Software Power BI Connector for Highrise from PowerBI.com to provide real-time Highrise data across the organization.
-
DataBind REST Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for REST with the DevExpress Windows Forms and Web controls to provide REST data to a chart.
-
Integrate Cursor with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Confluence data from within the editor.
-
Integrate Live Sage Intacct Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sage Intacct data and integrate live Sage Intacct data into apps built in Microsoft Power Apps.
-
Use the CData ODBC Driver for Pipeline CRM in Microsoft Power Query
You can use the CData Pipeline CRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pipeline CRM data into Microsoft Power Query.
-
Integrate Devin with Live NetSuite SuiteAnalytics Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live NetSuite SuiteAnalytics data.
-
Getting Started with the CData Tableau Connector for BambooHR
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Live Zoho Creator Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Creator data.
-
How to connect to Bitly Data in DBVisualizer
Integrate Bitly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Basecamp Replication to Databricks
Use CData Sync for automated, continuous, customizable Basecamp replication to Databricks.
-
Analyze SAP SuccessFactors LMS Data in Looker
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Looker and build custom apps using live SAP SuccessFactors LMS data.
-
Connect Redshift to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Redshift with IBM WebSphere for seamless data integration and connectivity.
-
Operational Reporting on ShipStation Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ShipStation data.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry data in MicroStrategy Desktop using the CData Software ODBC Driver for Sentry.
-
Connect to Vercel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vercel data using standard SQL.
-
Visualize Live Greenplum Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Greenplum data into custom reports in Power BI.
-
Integrating Antigravity CLI with Pipeliner CRM data via CData CLI
Connect Pipeliner CRM data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Deploy the ADO.NET Provider for Oracle Sales on an SSRS Report Server
Connect to Oracle Sales data 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.
-
Create Datasets from VWO in Domo Workbench and Build Visualizations of VWO Data in Domo
Use the CData Software ODBC Driver for VWO to create datasets from VWO data in Domo Workbench and then build visualizations in the Domo service.
-
Use Grok to Talk to Your Pinterest 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 Pinterest data for you.
-
Automated Continuous Cloudant Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cloudant replication to Apache Kafka.
-
Connect to Redshift Data from a Connection Pool in Jetty
The Redshift JDBC Driver supports connection pooling: This article shows how to connect faster to Redshift data from Web apps in Jetty.
-
Connect to SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data.
-
Build Zoho Books-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zoho Books Data and create custom apps in Bubble.
-
Build a Singer.io Tap for PostgreSQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PostgreSQL data using the CData Python Connector.
-
Deploy the ADO.NET Provider for Mode on an SSRS Report Server
Connect to Mode data 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.
-
Write a Simple Go Application to work with NetSuite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NetSuite data.
-
ETL Recurly in Oracle Data Integrator
This article shows how to transfer Recurly data into a data warehouse using Oracle Data Integrator.
-
Integrate ZohoInvoice Data into Power Automate Desktop using CData Connect
CData Connect for ZohoInvoice Data enables you to integrate ZohoInvoice data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Cursor with Dynamics 365 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.
-
Integrate ClickUp with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ClickUp with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ClickUp data.
-
Use Claude to Talk to Your RSS Feeds via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your RSS feeds for you.
-
How to Visualize Azure Synapse Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Synapse data in Python.
-
Automated Continuous Oracle Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle replication to Amazon Redshift.
-
Connect to ConstantContact Data from a Connection Pool in JBoss
Integrate ConstantContact data into Java servlets: Use the Management Console in JBoss to install the ConstantContact JDBC Driver.
-
Use the CData ODBC Driver for Certinia from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Certinia to connect to Certinia data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Certinia data in Excel.
-
Build Semantic Layer Views for CouchDB Data in APOS Live Data Gateway
Use the CData Connector for CouchDB in APOS Live Data Gateway to build Semantic Layer Views for CouchDB data.
-
Using the CData Software ODBC Driver for Factorial in PyCharm
Connect to Factorial as an ODBC data source in PyCharm using the CData Software ODBC Driver for Factorial.
-
Deploy the ADO.NET Provider for SAP Hybris C4C on an SSRS Report Server
Connect to SAP Hybris C4C data 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.
-
Create Dynamic Foursquare Grids Using the Infragistics XamDataGrid
Learn how you can connect Foursquare to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Salesforce Marketing Accounts
Replicate multiple Salesforce Marketing accounts to one or many databases.
-
Work with Live Samanage Data in Power Query
Use CData Connect AI to connect to Samanage data and work with live Samanage data in Microsoft Power Query.
-
Analyze Blackbaud FE NXT Data in Cognos Analytics
Use CData Connect AI to connect to Blackbaud FE NXT Data from Cognos Analytics and analyze live Blackbaud FE NXT data.
-
Integrate OpenCode with Live Microsoft Teams Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft Teams data from within your AI coding agent.
-
Access Yelp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Yelp data from HeidiSQL.
-
How to Seamlessly Import SAP HANA Data into IBM SPSS Modeler
Integrate SAP HANA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.