CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for FTP in MicroStrategy
Connect to FTP Servers in MicroStrategy Developer using the CData Software JDBC Driver for FTP.
-
Create Datasets from Blackbaud FE NXT in Domo Workbench and Build Visualizations of Blackbaud FE NXT Data in Domo
Use the CData Software ODBC Driver for Blackbaud FE NXT to create datasets from Blackbaud FE NXT in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData SSIS Components for SAP Fieldglass
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Fieldglass.
-
Getting Started with the CData ODBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Qualaroo.
-
Integrate with Dynamics 365 Business Central Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Dynamics 365 Business Central to a JSON file on disk.
-
Edit and Search OnePageCrm External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of OnePageCrm to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create OnePageCrm objects that you can access from apps and the dashboard.
-
Connect to and Query Blackbaud FE NXT Data in QlikView over ODBC
Create data visualizations with Blackbaud FE NXT in QlikView.
-
Visualize Workday 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 Workday into TIBCO Spotfire.
-
Build Charts with Attio Data in Clear Analytics
Create dynamic charts and perform analytics based on Attio in Clear Analytics.
-
Import Onfleet Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Onfleet. In this article, you will use the OData format to import Onfleet into Microsoft Power Query.
-
Provide OData Services of LinkedIn Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LinkedIn Ads by developing a WCF Service Application.
-
Use the CData ODBC Driver for Avro from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Avro to connect to Apache Avro from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Avro in Excel.
-
Getting Started with the CData ODBC Driver for FreeAgent
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FreeAgent.
-
DataBind Controls to MarkLogic Data in Delphi
DataBind to MarkLogic in Delphi with standard data access components and controls.
-
Connect to SQL Analysis Services Data in Google Apps Script via Connect AI
Use CData Connect AI to access SQL Analysis Services in Google Apps Script.
-
How to Use a Microsoft Access Database to Update Kintone Data in Real Time
Update Kintone data by creating a linked table in Microsoft Access with the CData Kintone ODBC Driver.
-
Build MVC Applications with Connectivity to Testmonitor Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Testmonitor from an ASP.NET MVC application.
-
Build Dashboards with Coinbase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Coinbase in Dundas BI.
-
Getting Started with the CData Excel Add-In for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft OneDrive.
-
Integrate with MongoDB Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy MongoDB to a JSON file on disk.
-
Analyze Google Campaign Manager 360 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Campaign Manager 360 and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with VWO Data in JReport Designer
Create charts and reports based on VWO in JReport Designer.
-
Consume Azure Table OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Table feeds that reflect any changes in SAP Lumira.
-
Connect to Real-Time Amazon Marketplace Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Amazon Marketplace and Dataflow to import and use Amazon Marketplace in Power Apps.
-
Import Real-Time Splunk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Splunk in ColdFusion.
-
Build Impala-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache Impala.
-
Use Dash to Build to Web Apps on Spotify Data
Create Python applications that use pandas and Dash to build Spotify-connected web apps.
-
Automated YouTube Analytics Data Replication to Teradata
Use CData Sync to Customize and automate YouTube Analytics replication to Teradata.
-
Build Data Flows from PingOne to SQL Server using SSIS
Easily back up PingOne to SQL Server using the SSIS components for PingOne.
-
Moving Data from Tanda to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Tanda data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Perplexity Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Perplexity from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create SSAS Tabular Models from Mailjet Data
How to build a SQL Server Analysis Service Tabular Model from Mailjet using CData drivers.
-
Build Visualizations of Amazon Marketplace Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Marketplace in Birst.
-
Automated Continuous Keap Replication to Vertica
Use CData Sync for automated, continuous, customizable Keap replication to Vertica.
-
Use Biml to Build SSIS Tasks to Replicate Sybase IQ Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sybase IQ to SQL Server.
-
How to Use a Microsoft Access Database to Update Dynamics 365 Data in Real Time
Update Dynamics 365 data by creating a linked table in Microsoft Access with the CData Dynamics 365 ODBC Driver.
-
How to Connect to Live API Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live API securely in real time.
-
Use the CData Software ODBC Driver for eBay Analytics in MicroStrategy
Connect to eBay Analytics in MicroStrategy Developer using the CData Software ODBC Driver for eBay Analytics.
-
Analyze Invoiced Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Invoiced and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Microsoft OneDrive Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft OneDrive Data enables you to integrate Microsoft OneDrive into workflows built using Microsoft Power Automate Desktop.
-
Build Salesloft-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Salesloft to explore live Salesloft Data in Claude Code to assist with building Salesloft-powered applications.
-
Create Reports from HCL Domino Data in Looker Studio
Use CData Connect AI to gain access to live HCL Domino and create custom reports in Looker Studio.
-
Connect to Salesforce Marketing from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce Marketing to connect to Salesforce Marketing Cloud from Web applications running on WebLogic.
-
Visualize SendGrid Data in Sisense
Create an ElastiCube in Sisense app with access to SendGrid.
-
Feed CouchDB Data into FineReport
How to set Apache CouchDB as a JDBC data source in FineReport.
-
Access Live FHIR Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live FHIR data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Use Grok to Talk to Your Redshift 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 Amazon Redshift for you.
-
Design BIRT Reports on Microsoft Dataverse Data
Provide current Microsoft Dataverse (CDS) to your embedded analytics.
-
Stream Zoho Books Data into Apache Kafka Topics
Access and stream Zoho Books in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parquet
Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.
-
Connect to Strava Data in JRuby
Create a simple JRuby app with access to live Strava.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for xBase
Provide connectivity to xBase through an SAP BusinessObjects universe.
-
How to load JobNimbus data into Elasticsearch via Logstash
Introducing a simple method to load JobNimbus data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect Amazon QuickSight to DB2 Data
Create a connection to IBM DB2 in CData Connect AI and insert IBM DB2 into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Work with SAP Ariba Procurement Data in AWS Glue Jobs Using JDBC
Connect to SAP Ariba Procurement from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Building Dynamic Web Pages with Cassandra Data Using AngularJS
Create single-page applications with live connectivity to Cassandra using the CData API Server.
-
Build Box-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Box Data from Zoho Analytics and import live Box.
-
Connect to Delighted Data in Jaspersoft Studio
Execute SQL to remote Delighted in Jaspersoft Studio.
-
Visualize Live Azure Analysis Services Data in the Power BI Service
Use CData Connect AI to connect to live Azure Analysis Services and create custom reports in the Power BI Service through the On-Premises Gateway.
-
DataBind Controls to JotForm Data in C++Builder
DataBind to JotForm in C++Builder with standard components and controls.
-
Connect to YouTube Analytics Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Easily Integrate Superchat Data in Lazarus Pascal IDE
Learn how to easily integrate live Superchat in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
A PostgreSQL Interface for Sage Cloud Accounting Data using the CData ODBC Driver
Use the SQL Gateway and Sage Cloud Accounting ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Vault CRM Data Replication to Azure Synapse
Use CData Sync to customize and automate Veeva Vault & Vault CRM replication to Azure Synapse.
-
Connect to Pingdom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pingdom to connect to Pingdom and execute queries in PowerBuilder.
-
Automated Continuous CockroachDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable CockroachDB replication to Google Cloud SQL.
-
Visualize Live Cvent Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Cvent using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Email Data to Multiple Databases
Replicate Email to disparate databases with a point-and-click configuration.
-
Build Charts with Instagram Data in Clear Analytics
Create dynamic charts and perform analytics based on Instagram in Clear Analytics.
-
View Reports on Real-Time ChartMogul Data in Power BI Report Server
Use the CData ODBC Driver for ChartMogul to visualize ChartMogul in Power BI Desktop and then publish them to Power BI Report Server.
-
View Reports on Real-Time VWO Data in Power BI Report Server
Use the CData ODBC Driver for VWO to visualize VWO in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect MailChimp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MailChimp using the CData Python MCP Server.
-
Connect to SingleStore Data in RapidMiner
Integrate SingleStore with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SAP HANA XS Advanced Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SAP HANA XS Advanced in the Denodo Virtual DataPort Administrator.
-
Integrating Cursor CLI with Humanity 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.
-
Prepare, Blend, and Analyze YouTube Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live YouTube Analytics for self-service data analytics.
-
Natively Connect to Cloudant Data in PHP
The CData ODBC driver for Cloudant enables you to create PHP applications with connectivity to IBM Cloudant. Leverage the native support for ODBC in PHP.
-
How to Connect to Live Microsoft Planner 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 Microsoft Planner for you.
-
Integrating Redis Data in Talend Cloud Data Management Platform
Connect Redis Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Redis.
-
Integrate Azure Data Lake Storage Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Data Lake Storage and integrate live Azure Data Lake Storage into your Power Automate tasks.
-
Connect to Oracle Eloqua Reporting Data in RazorSQL
Connect to Oracle Eloqua Reporting from wizards and query Oracle Eloqua Reporting from the GUI in the RazorSQL database management tool.
-
How to create an RPA flow for Tavily Data in UiPath Studio
Use the Tavily ODBC Driver to create workflows that access real-time Tavily without any coding.
-
Automate ZeroBounce Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZeroBounce from PowerShell? This article demonstrates how to utilize the ZeroBounce Cmdlets for tasks like connecting to ZeroBounce, automating operations, downloading data, and more.
-
Create Datasets from Klipfolio in Domo Workbench and Build Visualizations of Klipfolio Data in Domo
Use the CData Software ODBC Driver for Klipfolio to create datasets from Klipfolio in Domo Workbench and then build visualizations in the Domo service.
-
How to connect SharePoint with Aircall Data through external lists
Provide Aircall to SharePoint users as an external list.
-
How to connect and process ZendeskSell from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ZendeskSell.
-
Getting Started with the CData Power BI Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize ChartMogul Data in TIBCO Spotfire through ADO.NET
Integrate ChartMogul into dashboards in TIBCO Spotfire.
-
Build Voice Agents in ElevenLabs with access to Live SingleStore Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SingleStore.
-
Connect to Dynamics 365 Data in HULFT Integrate
Connect to Dynamics 365 as a JDBC data source in HULFT Integrate
-
Integrating Cursor CLI with SurveyMonkey 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.
-
Use the CData Software ODBC Driver for Adobe Commerce in MicroStrategy
Connect to Adobe Commerce in MicroStrategy Developer using the CData Software ODBC Driver for Adobe Commerce.
-
How to Access Live Flowlu Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Flowlu enables you to integrate Flowlu into workflows built using Microsoft Power Automate Desktop.
-
Extend Google Sheets with Harvest Data
Make calls to Harvest from Google Apps Script via the API Server.
-
How to load Retently data into Elasticsearch via Logstash
Introducing a simple method to load Retently data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build AI Agents with FTP 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 FTP Servers through CData Connect AI.
-
DataBind Controls to Amazon S3 Data in C++Builder
DataBind to Amazon S3 in C++Builder with standard components and controls.
-
Connect to Avalara AvaTax Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Avalara AvaTax from Filemaker Pro on Mac.
-
Use Azure AI Foundry to Talk to Your Impala 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 Apache Impala for you.
-
Analyze Microsoft Planner Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Planner and visualize live Microsoft Planner in Infragistics Reveal.