CData Software - Knowledge Base
Recent Articles
-
Publish HubSpot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live HubSpot.
-
Extract, Transform, and Load Google Analytics Data in Informatica PowerCenter
Create a simple Workflow for Google Analytics in Informatica PowerCenter.
-
Connect to Amplitude Data in DBArtisan
Use wizards in DBArtisan to configure Amplitude as a data source.
-
How to connect to Exact Online Data with Squirrel SQL client
Connect to Exact Online and execute queries in the Squirrel SQL Client.
-
How to Connect to Live Email Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Email for you.
-
Edit and Search External Monday.com Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Monday.com to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Monday.com Data objects that you can access from apps and the dashboard.
-
Manage Amazon DynamoDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Amazon DynamoDB.
-
Access Recurly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Recurly from your Oracle system.
-
Provide OData Services of DB2 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for IBM DB2 by developing a WCF Service Application.
-
Integrate Microsoft Planner Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Planner from Informatica Cloud.
-
Build Data Flows from Xero to SQL Server using SSIS
Easily back up Xero Accounting to SQL Server using the SSIS components for Xero.
-
How to update Sage Cloud Accounting from Excel
This article explains how to transfer data from Excel to Sage Cloud Accounting using the Excel Add-In for Sage Cloud Accounting.
-
Build Visualizations of Exa Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Exa in Birst.
-
Analyze ZohoSubscriptions Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ZohoSubscriptions with the CData JDBC Driver for ZohoSubscriptions.
-
Build RSS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to RSS Feeds and build web apps with connectivity to live RSS Feeds.
-
Publish Supabase-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Supabase.
-
Moving Data from Monday.com to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Monday.com data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with Sendwithus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Sendwithus to a JSON file on disk.
-
How to Connect to & Open Azure Analysis Services Data in Microsoft Excel
This article uses the CData ODBC driver for Azure Analysis Services to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating LlamaIndex with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Zoho Books in real time.
-
Natively Connect to Neo4J Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Neo4J. Leverage the native support for ODBC in PHP.
-
Integrate with Live Raisers Edge NXT Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Raisers Edge NXT from the MuleSoft Anypoint Platform to integrate live Raisers Edge NXT into custom reports and dashboards.
-
Rapidly Develop Authorize.Net-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 Authorize.Net.
-
Visualize Live Adobe Analytics Data in the Power BI Service
Use CData Connect AI to connect to live Adobe Analytics and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live FTP 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 FTP Servers through natural language.
-
How to connect to Elorus Data from Spring Boot
Connect to Elorus in a Spring Boot Application using the CData API Driver for JDBC
-
Create Oracle Eloqua-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Oracle Eloqua Data from Klipfolio and build custom visualizations using live Oracle Eloqua.
-
Build Zoho Creator-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Zoho Creator.
-
Visualize Live Simplesat Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Simplesat using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Grafana Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Grafana from Power Pivot. You will use the Table Import Wizard to load Grafana. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software ODBC Driver for AlloyDB in MicroStrategy Web
Connect to Google AlloyDB in MicroStrategy Web using the CData Software ODBC Driver for AlloyDB.
-
Use Agno to Talk to Your Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Zoho CRM for you.
-
Access Live SingleStore Data in TIBCO Data Virtualization
Use the SingleStore Tibco DV Adapter to create a SingleStore data source in TIBCO Data Virtualization Studio and gain access to live SingleStore from your TDV Server.
-
Analyze SparkPost Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SparkPost in Microsoft R Open.
-
How to connect to SAP HANA Data in DBVisualizer
Integrate SAP HANA with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Reports with Microsoft Exchange Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Exchange.
-
Automated Dynamics 365 Data Replication to Teradata
Use CData Sync to Customize and automate Microsoft Dynamics 365 replication to Teradata.
-
Use the CData ODBC Driver for HDFS from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HDFS to connect to Apache HDFS from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache HDFS in Excel.
-
How to Work with FreshBooks Data in AWS Glue Jobs Using JDBC
Connect to FreshBooks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to load BigQuery data into Elasticsearch via Logstash
Introducing a simple method to load BigQuery data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use Dash to Build Web Apps on Zoho CRM Data via CData Connect AI
Build interactive Dash web apps on live Zoho CRM using pandas and the CData Connect AI Python SDK.
-
Automated Continuous WordPress Replication to MySQL
Use CData Sync for automated, continuous, customizable WordPress replication to MySQL.
-
How to integrate Metabase with Salesforce Marketing Data
Use CData Connect AI to connect to live Salesforce Marketing Cloud and create an interactive dashboard in Metabase from Salesforce Marketing Cloud.
-
How to work with Printify Data in Apache Spark using SQL
Access and process Printify Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with DocuSign 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 create an RPA flow for Hacker News Data in UiPath Studio
Use the Hacker News ODBC Driver to create workflows that access real-time Hacker News without any coding.
-
How to Access Live Bullhorn CRM Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Bullhorn CRM enables you to integrate Bullhorn CRM into workflows built using Microsoft Power Automate Desktop.
-
Analyze Excel Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Excel with the CData JDBC Driver for Excel.
-
Add Beeminder Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Beeminder with the Informatica Enterprise Data Catalog to classify and organize data.
-
Provide OData Services of Jira Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Atlassian Jira by developing a WCF Service Application.
-
Integrate Live Azure Table Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Azure Table Storage to Blue Prism using the CData ODBC Driver for Azure Table to create automated workflows for repetitive business tasks.
-
Create Dynamic Active Directory Grids Using the Infragistics XamDataGrid
Learn how you can connect Active Directory to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Moosend Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Moosend as an External Source in Dremio.
-
Automated Continuous Stack Exchange Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Amazon S3.
-
Getting Started with the CData ADO.NET Provider for Highrise
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Highrise.
-
Integrate LibreChat with Live Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sybase from within the chat interface.
-
Create Dashboards and Visualize Live PayPal Data in Geckoboard
Use CData Connect AI to connect to live PayPal and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use Databricks Agent Bricks to Talk to Your Zoho CRM Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zoho CRM for you.
-
GitLab Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GitLab facts in real time.
-
Manage Missive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Missive.
-
Connect to ZarMoney Data from a Connection Pool in JBoss
Integrate ZarMoney into Java servlets: Use the Management Console in JBoss to install the ZarMoney JDBC Driver.
-
Choosing the Best Method to Connect SAP Business Warehouse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAP Business Warehouse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Add Certinia Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Certinia with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Workday Data Replication to Teradata
Use CData Sync to Customize and automate Workday replication to Teradata.
-
Add Outlook Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Outlook with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Charts to Shippo Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Shippo 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.
-
Connect to MarkLogic Data in DBeaver
Use the CData ODBC Driver to connect to MarkLogic in DBeaver.
-
Build MVC Applications with Connectivity to Beeminder Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Beeminder from an ASP.NET MVC application.
-
Build Todoist-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Todoist and build web apps with connectivity to live Todoist.
-
Connect to SendGrid Data in DBeaver
Use the CData ODBC Driver to connect to SendGrid in DBeaver.
-
Automated Continuous Authorize.Net Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Apache Cassandra.
-
Use Dash to Build Web Apps on Jira Assets Data via CData Connect AI
Build interactive Dash web apps on live Jira Assets using pandas and the CData Connect AI Python SDK.
-
How to Easily Query Teamwork Data in OpenOffice Base
Connect to Teamwork data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate SAP Concur Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAP Concur from Informatica Cloud.
-
How to Create Power BI Visual Reports with Real-Time Strava Data
Use CData Power BI Connectors to visualize Strava in Power BI.
-
Automated Continuous Salesforce CRM Analytics Replication to MongoDB
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to MongoDB.
-
Create SSAS Tabular Models from Moosend Data
How to build a SQL Server Analysis Service Tabular Model from Moosend using CData drivers.
-
Analyze Wistia Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Wistia with the CData JDBC Driver for Wistia.
-
Automate Asana Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Asana and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Load Missive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Missive to a database.
-
How to integrate Metabase with CSV Data
Use CData Connect AI to connect to live CSV/TSV Files and create an interactive dashboard in Metabase from CSV/TSV Files.
-
Use JayDeBeApi to access ZendeskSell Data in Python
Use standard Python scripting and the development environment of your choice to access live ZendeskSell.
-
Connect to Bright Data Data in NetBeans
Connect to Bright Data in NetBeans with the data source configuration wizard.
-
Replicate Microsoft Exchange Data from PowerShell
Write a quick PowerShell script to query Microsoft Exchange. Use connectivity to the live data to replicate Microsoft Exchange to SQL Server.
-
Access Live QuickBooks Online Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live QuickBooks Online from your Excel spreadsheets.
-
Connect to Twilio Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Twilio in Airbyte.
-
How to Visualize Aha! Data in Python with pandas
Use pandas and other modules to analyze and visualize live Aha! in Python.
-
Automate ZarMoney Data Replication to Azure Synapse
Use CData Sync to customize and automate ZarMoney replication to Azure Synapse.
-
Analyze SQL Analysis Services Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SQL Analysis Services in Microsoft R Open.
-
Integrating Claude Code CLI with Demio 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.
-
View Reports on Real-Time SparkPost Data in Power BI Report Server
Use the CData ODBC Driver for SparkPost to visualize SparkPost in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Wave Financial Data in AWS Lambda
Connect to live Wave Financial in AWS Lambda using the CData JDBC Driver.
-
Create SAS xpt-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAS xpt Data from OutSystems and build custom enterprise apps using live SAS XPORT.
-
Import Real-Time Parquet Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Parquet in ColdFusion.
-
DataBind Charts to Adobe Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Adobe Analytics 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.
-
Prepare, Blend, and Analyze Drift Data in Alteryx Designer (ODBC)
Build workflows to access live Drift for self-service data analytics.
-
Automated Continuous Monday.com Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Monday.com replication to IBM DB2.
-
Analyze ShipStation Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ShipStation with the CData JDBC Driver for ShipStation.
-
Write a Simple Go Application to work with Vercel Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Vercel.
-
Use the CData ODBC Driver for Mixpanel in Microsoft Power Query
You can use the CData Mixpanel ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Mixpanel into Microsoft Power Query.