CData Software - Knowledge Base
Recent Articles
-
Connect to Microsoft Planner from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Microsoft Planner, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Tableau Connector for Clockify
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating Dataiku with BigQuery Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google BigQuery.
-
Query Quickbase Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Quickbase from Node.js.
-
Connect to Suadeo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Suadeo in FileMaker Pro to connect to Suadeo and work with Suadeo in your FileMaker applications.
-
Integrate Figshare with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Figshare with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Figshare.
-
Import Real-Time Guru Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Guru in ColdFusion.
-
Connect to Cassandra Data in Ruby
Connect to Apache Cassandra in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Add Auth0 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Auth0 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Import Real-Time Lakebase Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Lakebase in ColdFusion.
-
View Reports on Real-Time CircleCI Data in Power BI Report Server
Use the CData ODBC Driver for CircleCI to visualize CircleCI in Power BI Desktop and then publish them to Power BI Report Server.
-
Build SharePoint Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft SharePoint and build visualizations in Tableau.
-
Operational Reporting on Sendwithus Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sendwithus.
-
Load PagerDuty Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PagerDuty to a database.
-
Connect to FreshBooks from Asprova with CData Software ODBC Driver for FreshBooks
This article shows how to connect faster to FreshBooks data from Asprova.
-
Build MVC Applications with Connectivity to Exact Online Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Exact Online from an ASP.NET MVC application.
-
Explore Geographical Relationships in SQL Analysis Services Data with Power Map
Create data visualizations with SQL Analysis Services in Power Map.
-
Access Freshsales Data from MySQL in PHP
Connect to Freshsales through the standard MySQL libraries in PHP.
-
Connect to Unbounce Data in Ruby
Connect to Unbounce in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Bridge Gong Connectivity with Apache NiFi
Access and process Gong in Apache NiFi using the CData JDBC Driver.
-
Analyze Bitbucket Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bitbucket with the CData JDBC Driver for Bitbucket.
-
Connect to and Query DocuSign Data in QlikView over ODBC
Create data visualizations with DocuSign in QlikView.
-
Build Asana-Connected Apps in Choreo
Use CData Connect AI to connect to Asana Data from Choreo and build custom apps using live Asana.
-
Access Facebook Data from MySQL in Amazon QuickSight
Connect to Facebook and build visualizations of Facebook using a MySQL Connection in Amazon QuickSight.
-
Create SSAS Tabular Models from REST Data
How to build a SQL Server Analysis Service Tabular Model from REST using CData drivers.
-
Validate Opsgenie Data with QuerySurge
Access and validate Opsgenie in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Calendly Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Calendly replication to AlloyDB.
-
Replicate Multiple SAP Hybris C4C Accounts
Replicate multiple SAP Hybris C4C accounts to one or many databases.
-
Visualize Clockify Data in TIBCO Spotfire through ADO.NET
Integrate Clockify into dashboards in TIBCO Spotfire.
-
Analyze Blackbaud FE NXT Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Blackbaud FE NXT with the CData JDBC Driver for Blackbaud FE NXT.
-
Connect to Zuora Data from a Connection Pool in JBoss
Integrate Zuora into Java servlets: Use the Management Console in JBoss to install the Zuora JDBC Driver.
-
How to Work with Wistia Data in AWS Glue Jobs Using JDBC
Connect to Wistia from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query, Visualize, and Share live Twilio Data in Redash
Use CData Connect AI to connect to live Twilio in Redash for querying, visualizing, and sharing.
-
Integrate Vault CRM Data in Pentaho Data Integration
Build ETL pipelines based on Veeva Vault & Vault CRM in the Pentaho Data Integration tool.
-
Getting Started with the CData ODBC Driver for Exact Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Exact Online.
-
Build Campaigner-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Campaigner Data in Cursor to assist with building Campaigner-powered applications.
-
Provide OData Services of Coinbase Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Coinbase by developing a WCF Service Application.
-
Use Azure AI Foundry to Talk to Your Email 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 Email for you.
-
Build a PostgreSQL Interface for SendInBlue Data using the CData JDBC Driver
Use the Remoting features of the SendInBlue JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to Browserless Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Browserless 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.
-
Getting Started with the CData JDBC Driver for CampaignMonitor
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CampaignMonitor.
-
Query MariaDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MariaDB entities in PHP by modeling them as objects.
-
Build Coda-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Coda Data in Claude Code to assist with building Coda-powered applications.
-
Connect to CircleCI Data in RapidMiner
Integrate CircleCI with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Auth0 Data in the Pentaho Report Designer
Publish reports based on Auth0 in the Pentaho BI tool.
-
A PostgreSQL Interface for Parallel Data using the CData ODBC Driver
Use the SQL Gateway and Parallel ODBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on Adobe Analytics Data with the QUERY Formula
Pull data from Adobe Analytics, automate spreadsheets, and more with the QUERY formula.
-
Object-Relational Mapping (ORM) with Parallel Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Parallel into a Java-based ORM framework, Hibernate.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Active Directory
Provide connectivity to Active Directory through an SAP BusinessObjects universe.
-
Building Dynamic Web Pages with Azure Analysis Services Data Using AngularJS
Create single-page applications with live connectivity to Azure Analysis Services using the CData API Server.
-
How to connect to Amplitude Data from Spring Boot
Connect to Amplitude in a Spring Boot Application using the CData API Driver for JDBC
-
Build Dashboards with Google Sheets Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.
-
Access Live Oracle Service Cloud Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Oracle Service Cloud from your Excel spreadsheets.
-
Build Agents in Relevance AI with Access to Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP SuccessFactors within intelligent agent workflows.
-
Use Dash to Build to Web Apps on Webflow Data
Create Python applications that use pandas and Dash to build Webflow-connected web apps.
-
Connect to Yelp Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Yelp to connect to Yelp and execute queries in PowerBuilder.
-
Connect to Google Drive Data in ACL Analytics
Connect to Google Drive via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Google Drive.
-
Build Hubstaff-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Hubstaff Data in Gemini Code Assist to assist with building Hubstaff-powered applications.
-
How to create an RPA flow for ChartMogul Data in UiPath Studio
Use the ChartMogul ODBC Driver to create workflows that access real-time ChartMogul without any coding.
-
Consume Coda OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Coda feeds that reflect any changes in SAP Lumira.
-
How to create Visio diagrams from Impala Data
Automatically update Apache Impala with the changes you make to Visio master shapes.
-
Publish EnterpriseDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live EnterpriseDB.
-
Build Zoho Recruit-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Zoho Recruit Data in Claude Code to assist with building Zoho Recruit-powered applications.
-
Create Power BI Reports on Real-Time SAP HANA XS Advanced Data
Use the CData ODBC Driver for SAP HANA XS Advanced to visualize SAP HANA XS Advanced in Power BI Desktop.
-
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.
-
Publish Crystal Reports on Excel Online Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel Online.
-
Add Avro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Avro with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Theia IDE with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Visualize Vimeo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vimeo in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Salesforce Marketing
Provide connectivity to Salesforce Marketing Cloud through an SAP BusinessObjects universe.
-
Visualize Live FormSite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FormSite using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
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.
-
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.
-
Access HelloSign Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access HelloSign from your Oracle system.
-
Automated Continuous Insightly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Insightly replication to SingleStore.
-
Connect to Mouseflow Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Mouseflow using standard SQL.
-
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.
-
Replicate Samanage Data to Multiple Databases via the CData Sync CLI
Replicate Samanage to disparate databases with a single configuration.
-
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 Templated-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 Templated.
-
Connecting Mastra with Authorize.Net 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 Authorize.Net, no replication required.
-
Connect to SAP Fieldglass Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Fieldglass from PowerBuilder using the SAP Fieldglass JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Typeform
Provide connectivity to Typeform through an SAP BusinessObjects universe.
-
Analyze PolarTeamPro Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of PolarTeamPro and visualize live PolarTeamPro in Infragistics Reveal.
-
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.
-
Automated Continuous Nethunt Replication to Oracle
Use CData Sync for automated, continuous, customizable Nethunt replication to Oracle.
-
Build Telegram-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Telegram and build web apps with connectivity to live Telegram.
-
Use CData Connect AI to Access Zoho Books Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Books in the Power Pivot business intelligence tool.
-
Visualize Quickbase Data in TIBCO Spotfire through ADO.NET
Integrate Quickbase into dashboards in TIBCO Spotfire.
-
Create Datasets from Exa in Domo Workbench and Build Visualizations of Exa Data in Domo
Use the CData Software ODBC Driver for Exa to create datasets from Exa in Domo Workbench and then build visualizations in the Domo service.
-
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.
-
Build Dashboards with SAP BusinessObjects BI Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI in DBxtra.
-
Create Power BI Reports on Real-Time Adobe Experience Manager Data
Use the CData ODBC Driver for Adobe Experience Manager to visualize Adobe Experience Manager in Power BI Desktop.
-
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.
-
Integrate with live Box Data in Jitterbit
Use CData Connect AI to connect to and integrate live Box in Jitterbit.
-
Build CockroachDB-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for CockroachDB to explore live CockroachDB Data in GitHub Copilot to assist with building CockroachDB-powered applications.
-
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.