CData Software - Knowledge Base
Recent Articles
-
How to connect to Sendwithus Data from Spring Boot
Connect to Sendwithus in a Spring Boot Application using the CData API Driver for JDBC
-
View Reports on Real-Time QuickBooks Time Data in Power BI Report Server
Use the CData ODBC Driver for QuickBooks Time to visualize QuickBooks Time in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Real-Time Salesforce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce and Dataflow to import and use Salesforce & Force.com in Power Apps.
-
Connect to MongoDB Data from HeidiSQL
Use CData Connect AI to connect to and query live MongoDB from HeidiSQL.
-
Connect to Salesforce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Salesforce & Force.com, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live ZohoInvoice Data in AWS Lambda
Connect to live ZohoInvoice in AWS Lambda using the CData JDBC Driver.
-
Model, Search, and Visualize Live HubSpot Data in ThoughtSpot
Use CData Connect AI to connect to live HubSpot for modeling, searching, and visualizing.
-
Connect to Access from a Connection Pool in WebLogic
Use the CData JDBC Driver for Access to connect to Microsoft Access from Web applications running on WebLogic.
-
Connect to Freshdesk Data in ACL Analytics
Connect to Freshdesk via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Freshdesk.
-
Configure the CData JDBC Driver for Salesforce Pardot in a Connection Pool in Tomcat
Connect to Salesforce Pardot from a connection pool in Tomcat.
-
How to Query Live Sage Intacct Data in Claude Desktop
Connect to and query live Sage Intacct Data in Claude Desktop using CData MCP Server.
-
Build Voice Agents in ElevenLabs with access to Live Confluence Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Atlassian Confluence.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Omnisend
Provide connectivity to Omnisend through an SAP BusinessObjects universe.
-
Automated Continuous SparkPost Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SparkPost replication to AlloyDB.
-
How to load Basecamp data into Elasticsearch via Logstash
Introducing a simple method to load Basecamp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Coinbase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Coinbase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Certinia Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Visualize Raisers Edge NXT Data in Python with pandas
Use pandas and other modules to analyze and visualize live Raisers Edge NXT in Python.
-
Build Dashboards with Cloudflare Data in DBxtra
Create dynamic dashboards and perform analytics based on Cloudflare in DBxtra.
-
Connect to Google Spanner Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Spanner as an External Source in Dremio.
-
Use ChatGPT to Talk to Your Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Basecamp for you.
-
Build Automated Workflows with Live SQL Analysis Services Data in Workato
Use CData Connect AI to connect to live SQL Analysis Services and build automated workflows in Workato.
-
Visualize Teradata Data in TIBCO Spotfire through ADO.NET
Integrate Teradata into dashboards in TIBCO Spotfire.
-
Automated Continuous Power BI XMLA Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to Google Cloud SQL.
-
Connect to Adobe Target Data in NetBeans
Connect to Adobe Target in NetBeans with the data source configuration wizard.
-
Connect to Testmonitor Data from a Connection Pool in JBoss
Integrate Testmonitor into Java servlets: Use the Management Console in JBoss to install the Testmonitor JDBC Driver.
-
Create Data Visualizations in Cognos BI with Cosmos DB Data
Access Azure Cosmos DB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Pinterest Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Pinterest from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Smartsheet Replication to Oracle
Use CData Sync for automated, continuous, customizable Smartsheet replication to Oracle.
-
Connect to Scrapfly Data from a Connection Pool in JBoss
Integrate Scrapfly into Java servlets: Use the Management Console in JBoss to install the Scrapfly JDBC Driver.
-
Automated Continuous Unbounce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Unbounce replication to Azure SQL Database.
-
Integrating Mouseflow Data in Talend Cloud Data Management Platform
Connect Mouseflow Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Query Live Elasticsearch Data in Claude Desktop
Connect to and query live Elasticsearch Data in Claude Desktop using CData MCP Server.
-
Query CapsuleCRM Data in ColdFusion
Write standard ColdFusion data access code to connect to CapsuleCRM.
-
Connect to Rebilly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Rebilly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Slack Replication to SingleStore
Use CData Sync for automated, continuous, customizable Slack replication to SingleStore.
-
Perform Batch Operations with Microsoft Ads Data in Apache NiFi
Connect to Microsoft Ads and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Instagram
Provide connectivity to Instagram through an SAP BusinessObjects universe.
-
Automated Continuous ConvertKit Replication to MySQL
Use CData Sync for automated, continuous, customizable ConvertKit replication to MySQL.
-
Build AI/ML Models with Live Optimizely Data using Dataiku
Connect Optimizely Data with Dataiku using the CData API Driver for JDBC.
-
Query Live SAP SuccessFactors LMS Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live SAP SuccessFactors LMS directly from the development environment.
-
Connect Dynamics 365 Business Central to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Dynamics 365 Business Central using the CData Python MCP Server.
-
Getting Started with the CData ADO.NET Provider for Spotify
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Rapidly Develop ScrapingBee-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 ScrapingBee.
-
Automate API Data Replication to Azure Data Lake
Use CData Sync to customize and automate API replication to Azure Data Lake.
-
Create Informatica Mappings From/To an ODBC Data Source for Wrike
Create an ODBC connection to Wrike in Informatica and browse and transfer Wrike.
-
Integrate Coinbase Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Coinbase from Informatica Cloud.
-
Connect to SAP Ariba Source Data in DBArtisan
Use wizards in DBArtisan to configure SAP Ariba Source as a data source.
-
DataBind Controls to Bullhorn CRM Data in Delphi
DataBind to Bullhorn CRM in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Office 365 in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft Office 365 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Office 365.
-
Build Oracle Eloqua Reporting-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle Eloqua Reporting to explore live Oracle Eloqua Reporting Data in GitHub Copilot to assist with building Oracle Eloqua Reporting-powered applications.
-
Integrating OpenCode Terminal with Freshdesk 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.
-
Create Reports with Foursquare Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Foursquare.
-
Query Acumatica Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Acumatica entities in PHP by modeling them as objects.
-
Use Claude to Talk to Your NetSuite 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 NetSuite CRM & ERP for you.
-
Integrate ClickUp Data in Pentaho Data Integration
Build ETL pipelines based on ClickUp in the Pentaho Data Integration tool.
-
Query, Visualize, and Share live SAS xpt Data in Redash
Use CData Connect AI to connect to live SAS XPORT in Redash for querying, visualizing, and sharing.
-
How to Connect to Live CouchDB 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 Apache CouchDB through natural language.
-
Manage LaunchDarkly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for LaunchDarkly.
-
Connect to Odoo Data in RazorSQL
Connect to Odoo from wizards and query Odoo ERP from the GUI in the RazorSQL database management tool.
-
How to Query Live AfterShip Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live AfterShip data in natural language using Python.
-
Seamlessly Bring LinkedIn Ads Data into Retool Using CData Connect AI
Integrate LinkedIn Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Stream Postmark Data into Apache Kafka Topics
Access and stream Postmark in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Missive Data from MySQL in PHP
Connect to Missive through the standard MySQL libraries in PHP.
-
Import Real-Time WooCommerce Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use WooCommerce in ColdFusion.
-
Explore Geographical Relationships in Stack Exchange Data with Power Map
Create data visualizations with Stack Exchange in Power Map.
-
How to update Sybase from Excel
This article explains how to transfer data from Excel to Sybase using the Excel Add-In for Sybase.
-
Extract, Transform, and Load AlloyDB Data in Informatica PowerCenter
Create a simple Workflow for Google AlloyDB in Informatica PowerCenter.
-
Integrating Claude Code CLI with Aircall 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 Simple VCL Application for Customer.io Data
How to build a simple VCL Application to view Customer.io in RAD Studio using the CData ODBC Driver for Customer.io.
-
Automated Splunk Data Replication to Teradata
Use CData Sync to Customize and automate Splunk replication to Teradata.
-
Import Real-Time Planio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Planio in ColdFusion.
-
How to connect to Perplexity Data from IntelliJ
Integrate connectivity to Perplexity with wizards in IntelliJ.
-
How to connect to Calendly Data from IntelliJ
Integrate connectivity to Calendly with wizards in IntelliJ.
-
Access Sage 200 Data from MySQL in PHP
Connect to Sage 200 through the standard MySQL libraries in PHP.
-
How to connect to Campaigner Data from Spring Boot
Connect to Campaigner in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Box Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Box data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Build Blackbaud FE NXT-Connected Apps in Choreo
Use CData Connect AI to connect to Blackbaud FE NXT Data from Choreo and build custom apps using live Blackbaud FE NXT.
-
Access Bitly 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 Bitly.
-
Build Visualizations of Deel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Deel in Birst.
-
Integrating Kiro CLI with Webex 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.
-
Connecting Pipedream with Google Sheets 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 Google Sheets data in real time.
-
Analyze Bright Data Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Bright Data with the CData JDBC Driver for Bright Data.
-
Create Datasets from Mistral AI in Domo Workbench and Build Visualizations of Mistral AI Data in Domo
Use the CData Software ODBC Driver for Mistral AI to create datasets from Mistral AI in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Workday in MicroStrategy Desktop
Connect to Workday in MicroStrategy Desktop using the CData Software ODBC Driver for Workday.
-
How to Visualize Microsoft OneDrive Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft OneDrive in Python.
-
Use Databricks Agent Bricks to Talk to Your Google Calendar Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Google Calendar for you.
-
Create SSAS Tabular Models from FHIR Data
How to build a SQL Server Analysis Service Tabular Model from FHIR using CData drivers.
-
Create Apps from Zoho CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho CRM Data and build apps from live Zoho CRM in Qlik Sense Cloud.
-
Access SageHR 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 SageHR.
-
Integrating Claude Code CLI with SAP Netweaver Gateway 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.
-
Getting Started with the CData Excel Add-In for Exa
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Exa.
-
Connect to SFTP Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SFTP and the Script function in FileMaker Pro to connect to SFTP and work with SFTP in your FileMaker application.
-
Establish a Live Connection with Exa Data using Tableau Bridge
The CData ODBC Driver for Exa enables you to integrate live Exa into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Reckon Accounts Hosted Data in JRuby
Create a simple JRuby app with access to live Reckon Accounts Hosted.
-
Visualize IBM Informix Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load IBM Informix into TIBCO Spotfire.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for BigQuery
Provide connectivity to Google BigQuery through an SAP BusinessObjects universe.
-
Using the CData Software ODBC Driver for Authorize.Net in PyCharm
Connect to Authorize.Net as an ODBC data source in PyCharm using the CData Software ODBC Driver for Authorize.Net.
-
Connect to Helpscout Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Helpscout.
-
How to connect PolyBase to Okta
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Okta.