CData Software - Knowledge Base
Recent Articles
-
How to connect and process VWO from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live VWO.
-
Load Hive Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apache Hive to a database.
-
Connect to Ontraport Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Ontraport using standard SQL.
-
Extend Google Sheets with Acumatica Data
Make calls to Acumatica from Google Apps Script via the API Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Workday
Provide connectivity to Workday through an SAP BusinessObjects universe.
-
Use Claude to Talk to Your Google Ad Manager 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 Google Ad Manager for you.
-
How to Visualize Calendly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Calendly in Python.
-
How to Access Live Teamwork Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Teamwork enables you to integrate Teamwork into workflows built using Microsoft Power Automate Desktop.
-
Build Sage 200-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sage 200 Data and create custom apps in Bubble.
-
Building Dynamic Web Pages with Microsoft Teams Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Teams using the CData API Server.
-
Object-Relational Mapping (ORM) with Greenhouse 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 Greenhouse into a Java-based ORM framework, Hibernate.
-
DataBind Controls to Pipeliner CRM Data in C++Builder
DataBind to Pipeliner CRM in C++Builder with standard components and controls.
-
Getting Started with the CData ADO.NET Provider for Salesforce
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Salesforce.
-
Use the CData ODBC Driver for Front from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Front to connect to Front from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Front in Excel.
-
Import and Visualize Omnisend Data in Power View
Create data visualizations based on Omnisend in Excel.
-
Connect to Microsoft Ads Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Ads.
-
Build MariaDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in Cursor to assist with building MariaDB-powered applications.
-
Connect to iContact Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time iContact using standard SQL.
-
Integrate with Couchbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Couchbase to a JSON file on disk.
-
Validate Hubstaff Data with QuerySurge
Access and validate Hubstaff in QuerySurge using the CData JDBC Driver.
-
Automated Continuous Databricks Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Databricks replication to Amazon Redshift.
-
Integrate with Google Translate Data in JReport Designer
Create charts and reports based on Google Translate in JReport Designer.
-
How to Connect to Live Tally Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Tally ERP without replication.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Experience Manager
Provide connectivity to Adobe Experience Manager through an SAP BusinessObjects universe.
-
Integrating Claude Code CLI with Amazon Marketplace 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.
-
Integrating Dataiku with DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live DocuSign.
-
Integrating OpenCode Terminal with Retently 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.
-
Automated Continuous Parquet Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Parquet replication to Google Cloud SQL.
-
How to Connect to & Open Codat Data in Microsoft Excel
This article uses the CData ODBC driver for Codat to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrate Salesforce Pardot Data into Power Automate Desktop using CData Connect
CData Connect for Salesforce Pardot Data enables you to integrate Salesforce Pardot into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Typeform Replication to MySQL
Use CData Sync for automated, continuous, customizable Typeform replication to MySQL.
-
Manage Oracle HCM Cloud Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle HCM Cloud.
-
DataBind Controls to YouTube Analytics Data in C++Builder
DataBind to YouTube Analytics in C++Builder with standard components and controls.
-
A PostgreSQL Interface for Dotmailer Data using the CData ODBC Driver
Use the SQL Gateway and Dotmailer ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to CapsuleCRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time CapsuleCRM using standard SQL.
-
How to connect to Teamgate Data with Squirrel SQL client
Connect to Teamgate and execute queries in the Squirrel SQL Client.
-
Use the CData Software JDBC Driver for Discord in MicroStrategy
Connect to Discord in MicroStrategy Developer using the CData Software JDBC Driver for Discord.
-
Query LDAP Objects as a MySQL Database in Node.js
Execute MySQL queries against LDAP from Node.js.
-
Connect to HubSpot Data in NetBeans
Connect to HubSpot in NetBeans with the data source configuration wizard.
-
Write a Simple Go Application to work with Gorgias Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Gorgias.
-
Analyze JDBC-ODBC Bridge Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JDBC-ODBC Bridge with the CData JDBC Driver for JDBC-ODBC Bridge.
-
Natively Connect to Klipfolio Data in PHP
The CData ODBC driver for Klipfolio enables you to create PHP applications with connectivity to Klipfolio. Leverage the native support for ODBC in PHP.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Active Directory within intelligent workflows.
-
Load Sendwithus Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sendwithus to a database.
-
Access Mailjet Data from MySQL in Amazon QuickSight
Connect to Mailjet and build visualizations of Mailjet using a MySQL Connection in Amazon QuickSight.
-
Import Neo4J Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Neo4J. In this article, you will use the OData format to import Neo4J into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Oracle Sales in SAS for Real-Time Reporting and Analytics
Connect to real-time Oracle Sales in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Oracle Sales.
-
Build AI Agents with SAP SuccessFactors 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 SAP SuccessFactors through CData Connect AI.
-
Connect to REST Data from PowerBuilder via ADO.NET
This article demonstrates how to access REST from Appeon PowerBuilder using the CData ADO.NET Provider for REST.
-
Extract, Transform, and Load Bitbucket Data in Informatica PowerCenter
Create a simple Workflow for Bitbucket in Informatica PowerCenter.
-
Build Dashboards with HubDB Data in DBxtra
Create dynamic dashboards and perform analytics based on HubDB in DBxtra.
-
Automated Continuous DB2 for i Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable DB2 for i replication to OneLake in Microsoft Fabric.
-
Build MariaDB-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for MariaDB to explore live MariaDB Data in Claude Code to assist with building MariaDB-powered applications.
-
Connect to SharePoint Excel Services Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous MySQL Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MySQL replication to Google Cloud SQL.
-
Provide OData Services of Shortcut Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Shortcut by developing a WCF Service Application.
-
Work with Discord Data in FoxPro
Load Discord into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze eBay Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of eBay and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Workable Data in JRuby
Create a simple JRuby app with access to live Workable.
-
How to connect to SendInBlue Data in DBVisualizer
Integrate SendInBlue with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Kiro CLI with Mode 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.
-
Automated Continuous Egnyte Replication to SQLite
Use CData Sync for automated, continuous, customizable Egnyte replication to SQLite.
-
Model Google Campaign Manager 360 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Google Campaign Manager 360, enabling the direct import of real-time Google Campaign Manager 360.
-
Connect Hubstaff to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hubstaff with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for eBay in MicroStrategy Web
Connect to eBay in MicroStrategy Web using the CData Software JDBC Driver for eBay.
-
How to integrate Copper with Apache Airflow
Access and process Copper in Apache Airflow using the CData JDBC Driver.
-
Connect to Vercel Data in NetBeans
Connect to Vercel in NetBeans with the data source configuration wizard.
-
Connecting GenSpark with Elasticsearch Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Elasticsearch without any replication or custom integration required.
-
Access Live Jodoo Data in AWS Lambda
Connect to live Jodoo in AWS Lambda using the CData JDBC Driver.
-
Operational Reporting on ActiveCampaign Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ActiveCampaign.
-
Analyze Google Cloud Storage Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Google Cloud Storage in Microsoft R Open.
-
Query Live SAP Netweaver Gateway 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 Netweaver Gateway directly from the development environment.
-
Connect to CSV Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Getting Started with the CData Connect AI Python SDK for Microsoft OneDrive
Install the CData Connect AI Python SDK to read and write live Microsoft OneDrive with standard DB-API 2.0 Python code.
-
How to import Notion Data into Apache Solr
Use the CData Software JDBC Driver for Notion in Data Import Handler and create an automated import of Notion to Apache Solr Enterprise Search platform.
-
Build Dashboards with PingOne Data in Dundas BI
Create dynamic dashboards and perform analytics based on PingOne in Dundas BI.
-
Connect to Rootly in SpagoBI
Create reports featuring live Rootly in SpagoBI Studio. Host Rootly reports on SpagoBI Server.
-
Create Dynamic BigQuery Grids Using the Infragistics XamDataGrid
Learn how you can connect BigQuery to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Open WebUI with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sugar CRM from within the chat interface.
-
Query Trello Data in DataGrip
Create a Data Source for Trello in DataGrip and use SQL to query live Trello.
-
Integrating GitHub Copilot CLI with Foursquare 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 Datasets from Copper in Domo Workbench and Build Visualizations of Copper Data in Domo
Use the CData Software ODBC Driver for Copper to create datasets from Copper in Domo Workbench and then build visualizations in the Domo service.
-
Build Sage 200-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Sage 200 and build web apps with connectivity to live Sage 200.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP
Provide connectivity to SAP ERP/NetWeaver through an SAP BusinessObjects universe.
-
How to Connect to Live Vault CRM 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 Veeva Vault & Vault CRM for you.
-
Build Apps with Live Printful Data Using the Low-Code Development Platform of Mendix
Connect Printful with Mendix to build apps using the CData API Driver for JDBC.
-
Rapidly Develop Humanity-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 Humanity.
-
Deploy the ADO.NET Provider for WooCommerce on an SSRS Report Server
Connect to WooCommerce from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData Power BI Connector for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Deploy the ADO.NET Provider for Oracle SCM on an SSRS Report Server
Connect to Oracle SCM from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to connect to Keap Data from Spring Boot
Connect to Keap in a Spring Boot Application using the CData API Driver for JDBC
-
Automate HDFS Data Replication to Couchbase
Use CData Sync to Customize and automate Apache HDFS replication to Couchbase.
-
Integrate LibreChat with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live ServiceNow from within the chat interface.
-
Integrate Oracle Sales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Sales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Sales.
-
Getting Started with the CData SSIS Components for eBay
Complete guide to installing, licensing, and connecting with the CData SSIS Components for eBay.
-
Excel Spreadsheet Automation on Teamwork Data with the QUERY Formula
Pull data from Teamwork, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from Salesforce to Snowflake using CData SSIS Components.
Easily push Salesforce & Force.com to Snowflake using the CData SSIS Tasks for Salesforce and Snowflake.
-
Integrate Cursor with Live Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Sugar CRM from within the editor.
-
Use the CData SSIS Components to Insert New or Update Existing Sugar CRM Records from SQL Server
Easily push SQL Server data to Sugar CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sugar CRM or update existing records with data from a SQL Server database.
-
DataBind Controls to CloudConvert Data in C++Builder
DataBind to CloudConvert in C++Builder with standard components and controls.