CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Amazon Athena Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Amazon Athena for you.
-
Integrate Real-Time Access to SurveyMonkey in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SurveyMonkey in real time.
-
Analyze Unbounce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Unbounce with the CData JDBC Driver for Unbounce.
-
How to integrate Metabase with Certinia Data
Use CData Connect AI to connect to live Certinia and create an interactive dashboard in Metabase from Certinia.
-
Easily Integrate EnterpriseDB Data in Lazarus Pascal IDE
Learn how to easily integrate live EnterpriseDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Invoiced Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Invoiced facts in real time.
-
Build AI/ML Models with Live Sugar CRM Data using Dataiku
Connect Sugar CRM Data with Dataiku using the CData JDBC Driver for Sugar.
-
Connect to HelloSign Data in NetBeans
Connect to HelloSign in NetBeans with the data source configuration wizard.
-
Visualize Live MariaDB Data in the Power BI Service
Use CData Connect AI to connect to live MariaDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Load Facebook Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Facebook to a database.
-
Build AgileCRM-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live AgileCRM Data in Cursor to assist with building AgileCRM-powered applications.
-
How to Visualize Copper Data in Python with pandas
Use pandas and other modules to analyze and visualize live Copper in Python.
-
DataBind Charts to Campaigner Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Campaigner 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.
-
How to Connect to Live Elasticsearch 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 Elasticsearch for you.
-
Use JayDeBeApi to access Cosmos DB Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Cosmos DB.
-
Use the CData Software ODBC Driver for Greenplum in SAS for Real-Time Reporting and Analytics
Connect to real-time Pivotal GreenPlum in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Greenplum.
-
Build HDFS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache HDFS and build web apps with connectivity to live Apache HDFS.
-
Automated Continuous Float Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Float replication to delimited files (CSV/TSV).
-
Connect to Reckon Data in Ruby
Connect to Reckon in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Jumpseller Data in Coginiti Pro
Connect to and query live Jumpseller from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Feed ZohoMarketingHub Data into FineReport
How to set ZohoMarketingHub as a JDBC data source in FineReport.
-
Integrating Claude Code with Sugar CRM Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Sugar CRM within assisted coding and automated development workflows.
-
Query Basecamp Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Basecamp and perform CRUD operations on Basecamp from Node.js.
-
Create Rebilly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Rebilly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to FTP Data in CloverDX (formerly CloverETL)
Transfer FTP Servers using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Microsoft Teams to Snowflake using CData SSIS Components.
Easily push Microsoft Teams to Snowflake using the CData SSIS Tasks for Microsoft Teams and Snowflake.
-
Validate Toggl Data with QuerySurge
Access and validate Toggl in QuerySurge using the CData JDBC Driver.
-
How to connect to Google Ad Manager Data in DBVisualizer
Integrate Google Ad Manager with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize Live Gong Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gong.
-
Create MarkLogic Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MarkLogic data access from reports, embedded analytics, and more.
-
DataBind Controls to Active Directory Data in C++Builder
DataBind to Active Directory in C++Builder with standard components and controls.
-
Access Box Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Box from your Oracle system.
-
Access Live Wistia Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Wistia data source in TIBCO Data Virtualization Studio and gain access to live Wistia from your TDV Server.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy Desktop
Connect to ClickUp in MicroStrategy Desktop using the CData Software ODBC Driver for ClickUp.
-
Visualize BigQuery Data in TIBCO Spotfire through ADO.NET
Integrate Google BigQuery into dashboards in TIBCO Spotfire.
-
Use Manus AI to Talk to Your Okta 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 Okta.
-
Automated Continuous Campaigner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Campaigner replication to Azure SQL Database.
-
Connect to PhantomBuster Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PhantomBuster and work with PhantomBuster in your FileMaker applications.
-
Use the CData Software JDBC Driver for Demio in MicroStrategy Web
Connect to Demio in MicroStrategy Web using the CData Software JDBC Driver for Demio.
-
Build Quaderno-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Quaderno Data in Cursor to assist with building Quaderno-powered applications.
-
How to use SQLAlchemy ORM to access ZendeskSell Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of ZendeskSell.
-
Feed Azure Table Data into FineReport
How to set Azure Table Storage as a JDBC data source in FineReport.
-
Query SendInBlue Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SendInBlue and perform CRUD operations on SendInBlue from Node.js.
-
Connect to ScrapingBee Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ScrapingBee as an External Source in Dremio.
-
Consume Mailjet OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Mailjet feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData JDBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Email.
-
How to Easily Query JSON Services in OpenOffice Base
Connect to JSON data in OpenOffice Base using the CData ODBC Driver for JSON and generate reports with live data insights.
-
Integrating Kiro CLI with Notion 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 to Live Airtable Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Airtable through natural language.
-
Feed SharePoint Data into FineReport
How to set Microsoft SharePoint as a JDBC data source in FineReport.
-
How to Connect to Live Spark Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Apache Spark SQL for you.
-
Build a PostgreSQL Interface for Oracle SCM Data using the CData JDBC Driver
Use the Remoting features of the Oracle SCM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with Adobe Target Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Adobe Target.
-
Automated Continuous Apify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Apify replication to Snowflake.
-
Choosing the Best Method to Connect Bugsnag to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Bugsnag from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to SingleStore Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SingleStore. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time PostgreSQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PostgreSQL in ColdFusion.
-
Connect to Jira Assets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Jira Assets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import PingOne Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access PingOne. In this article, you will use the OData format to import PingOne into Microsoft Power Query.
-
Getting Started with the CData ODBC Driver for ChargeOver
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ChargeOver.
-
Access Live Oracle SCM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle SCM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting GenSpark with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitHub without any replication or custom integration required.
-
Automated Continuous EmailOctopus Replication to Databricks
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Databricks.
-
Connect to Dynamics 365 Data in Ruby
Connect to Microsoft Dynamics 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Helpscout-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Helpscout Data in Gemini Code Assist to assist with building Helpscout-powered applications.
-
Analyze WordPress Data in Looker
Use CData Connect AI to connect to WordPress Data from Looker and build custom apps using live WordPress.
-
Use the CData ODBC Driver for Exact Online in Microsoft Power Query
You can use the CData Exact Online ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Exact Online into Microsoft Power Query.
-
Integrating GitHub Copilot CLI with Scrapfly 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 Azure AI Foundry to Talk to Your Microsoft Entra ID 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 Microsoft Entra ID for you.
-
Work with Dynamics 365 Data in FoxPro
Load Microsoft Dynamics 365 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy
Connect to Microsoft OneNote in MicroStrategy Developer using the CData Software ODBC Driver for OneNote.
-
DataBind Charts to ZohoSubscriptions Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoSubscriptions 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.
-
Integrate Live SAP Fieldglass Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Extend Google Sheets with Todoist Data
Make calls to Todoist from Google Apps Script via the API Server.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Web
Connect to ZendeskSell in MicroStrategy Web using the CData Software JDBC Driver for ZendeskSell.
-
Connect to Sybase Data from a Connection Pool in JBoss
Integrate Sybase into Java servlets: Use the Management Console in JBoss to install the Sybase JDBC Driver.
-
Connecting Pipedream with Oracle Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle data in real time.
-
How to Import Data from Float into Google Sheets
Import Float into a Google spreadsheet that is automatically refreshed.
-
Provide OData Services of QuickBooks Online Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Online by developing a WCF Service Application.
-
Access Live BigCommerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live BigCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to CloudConvert Data in Ruby
Connect to CloudConvert in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous AfterShip Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AfterShip replication to Apache Kafka.
-
Automated Continuous GitHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitHub replication to Google BigQuery.
-
Integrate Pipedrive Data in Pentaho Data Integration
Build ETL pipelines based on Pipedrive in the Pentaho Data Integration tool.
-
Create Reports from Procore Data in Looker Studio
Use CData Connect AI to gain access to live Procore and create custom reports in Looker Studio.
-
Connect to ChartMogul Data from a Connection Pool in JBoss
Integrate ChartMogul into Java servlets: Use the Management Console in JBoss to install the ChartMogul JDBC Driver.
-
How to create an RPA flow for Perplexity Data in UiPath Studio
Use the Perplexity ODBC Driver to create workflows that access real-time Perplexity without any coding.
-
Connect to ChargeOver Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ChargeOver in the Denodo Virtual DataPort Administrator.
-
Use Biml to Build SSIS Tasks to Replicate Xero Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Xero Accounting to SQL Server.
-
Visualize Bannerbear Data in Tableau
The CData ODBC driver for Bannerbear enables you integrate Bannerbear into Tableau dashboards.
-
Connect to Clockify Data in JRuby
Create a simple JRuby app with access to live Clockify.
-
Bridge Microsoft Exchange Connectivity with Apache NiFi
Access and process Microsoft Exchange in Apache NiFi using the CData JDBC Driver.
-
Integrating LlamaIndex with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Vertica in real time.
-
DataBind Controls to Excel Online Data in C++Builder
DataBind to Microsoft Excel Online in C++Builder with standard components and controls.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Web
Connect to Mixpanel in MicroStrategy Web using the CData Software JDBC Driver for Mixpanel.
-
Integrate Theia IDE with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Dynamics CRM Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics CRM Data enables you to integrate Microsoft Dynamics CRM into workflows built using Microsoft Power Automate Desktop.
-
How to Query Live Zoho Projects Data in Perplexity MacOS Desktop
Connect to and query live Zoho Projects Data in Perplexity Desktop using CData MCP Server.
-
How to Easily Query ClickUp Data in OpenOffice Base
Connect to ClickUp data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed xBase to Power BI dashboards. Simply drag and drop xBase into data visuals on the Power BI canvas.