CData Software - Knowledge Base
Recent Articles
-
Build AI/ML Models with Live GitHub Data using Dataiku
Connect GitHub Data with Dataiku using the CData JDBC Driver for GitHub.
-
Connect to Ontraport Data in DBArtisan
Use wizards in DBArtisan to configure Ontraport as a data source.
-
Integrate with Jira Assets Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Jira Assets to a JSON file on disk.
-
How to Query Live PingOne Data in Claude Desktop
Connect to and query live PingOne Data in Claude Desktop using CData MCP Server.
-
How to Connect to Live Zendesk 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 Zendesk without replication.
-
Using the CData Software ODBC Driver for Oracle Financials Cloud in PyCharm
Connect to Oracle Financials Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Use the CData SSIS Components to Insert New or Update Existing MongoDB Records from SQL Server
Easily push SQL Server data to MongoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MongoDB or update existing records with data from a SQL Server database.
-
Getting Started with the CData JDBC Driver for Gorgias
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gorgias.
-
LINQ to GitHub Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the GitHub Data Provider.
-
Connect to Parallel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parallel using standard SQL.
-
Work with Browserless Data in FoxPro
Load Browserless into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extend Google Sheets with Azure Data Lake Storage Data
Make calls to Azure Data Lake Storage from Google Apps Script via the API Server.
-
Use the CData SSIS Components to Insert New or Update Existing Outreach.io Records from SQL Server
Easily push SQL Server data to Outreach.io using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Outreach.io or update existing records with data from a SQL Server database.
-
Connect to FreeAgent Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreeAgent and work with FreeAgent in your FileMaker applications.
-
Access GitHub Data from MySQL in PHP
Connect to GitHub through the standard MySQL libraries in PHP.
-
Connect to Sage 200 Data from a Connection Pool in JBoss
Integrate Sage 200 into Java servlets: Use the Management Console in JBoss to install the Sage 200 JDBC Driver.
-
Connect to Moosend Data from a Connection Pool in JBoss
Integrate Moosend into Java servlets: Use the Management Console in JBoss to install the Moosend JDBC Driver.
-
Build Google Calendar-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Calendar.
-
Connect ZohoInvoice to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoInvoice using the CData Python MCP Server.
-
How to Import Data from SharePoint Excel Services into Google Sheets
Import SharePoint Excel Services into a Google spreadsheet that is automatically refreshed.
-
Integrating OpenCode Terminal with Reckon 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 Microsoft Exchange-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Mendix.
-
Natively Connect to FreshBooks Data in PHP
The CData ODBC driver for FreshBooks enables you to create PHP applications with connectivity to FreshBooks. Leverage the native support for ODBC in PHP.
-
Build Automated Workflows with Live SAP Business One Data in Workato
Use CData Connect AI to connect to live SAP Business One and build automated workflows in Workato.
-
Connect to SAP Ariba Procurement from Asprova with CData Software ODBC Driver for SAP Ariba Procurement
This article shows how to connect faster to SAP Ariba Procurement data from Asprova.
-
Create Data Visualizations in Cognos BI with Twilio Data
Access Twilio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Theia IDE with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Real-Time Access to Spark in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Spark SQL in real time.
-
Automated Continuous Sage Cloud Accounting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.
-
Connect to Mocean Data in CloverDX (formerly CloverETL)
Transfer Mocean using the visual workflow in the CloverDX data integration tool.
-
Connect to SAP Business One 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 SAP Business One.
-
Access Live Microsoft Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Ads through MCP integration.
-
Visualize Live Pipeline CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pipeline CRM.
-
Import Microsoft Dataverse Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dataverse (CDS). In this article, you will use the OData format to import Microsoft Dataverse (CDS) into Microsoft Power Query.
-
Connect to Sybase IQ Data in JRuby
Create a simple JRuby app with access to live Sybase IQ.
-
Integrating Codex CLI with Qualaroo 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.
-
Integrate Aha! Data in the Pentaho Report Designer
Publish reports based on Aha! in the Pentaho BI tool.
-
Connect to Strava Data in Ruby
Connect to Strava in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Acumatica Replication to Databricks
Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.
-
Connect to Greenplum Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Pivotal GreenPlum and execute queries in PowerBuilder.
-
Integrating Claude Code CLI with Campaigner 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.
-
Automate LDAP Objects Replication to SAP HANA
Use CData Sync to customize and automate LDAP replication to SAP HANA.
-
Visualize Hive Data in TIBCO Spotfire through ADO.NET
Integrate Apache Hive into dashboards in TIBCO Spotfire.
-
Access Live Raisers Edge NXT Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Raisers Edge NXT through MCP integration.
-
How to Query Live Hugging Face Data in Perplexity MacOS Desktop
Connect to and query live Hugging Face Data in Perplexity Desktop using CData MCP Server.
-
Provide OData Services of Telegram Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Telegram by developing a WCF Service Application.
-
Model, Search, and Visualize Live Google Cloud Storage Data in ThoughtSpot
Use CData Connect AI to connect to live Google Cloud Storage for modeling, searching, and visualizing.
-
Bridge Zoho CRM Connectivity with Apache NiFi
Access and process Zoho CRM in Apache NiFi using the CData JDBC Driver.
-
Connect to ConvertAPI Data in RapidMiner
Integrate ConvertAPI with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Build an ETL App for Quaderno Data in Python with CData
Create ETL applications and real-time data pipelines for Quaderno in Python with petl.
-
Automated Continuous CockroachDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CockroachDB replication to IBM DB2.
-
Create Dynamics CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Spark Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Spark SQL.
-
Integrating Antigravity CLI with Asana via CData CLI
Connect Asana to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Easily Integrate Front Data in Lazarus Pascal IDE
Learn how to easily integrate live Front in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Translate Data in DBArtisan
Use wizards in DBArtisan to configure Google Translate as a data source.
-
Visualize FHIR Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FHIR.
-
Deploy the ADO.NET Provider for SuiteCRM on an SSRS Report Server
Connect to SuiteCRM 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 Suadeo Data in DBVisualizer
Integrate Suadeo with visual data analysis tools and data connection wizards in DBVisualizer
-
Getting Started with the CData Power BI Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SendGrid.
-
Access Live Freshsales Data in Coginiti Pro
Connect to and query live Freshsales from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAP SuccessFactors LMS Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP SuccessFactors LMS Data and connect to SAP SuccessFactors LMS in Akorbi Digital RunMyProcess.
-
Connect to Telegram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Telegram using standard SQL.
-
Integrate Zoho Books Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Books and integrate live Zoho Books into your Power Automate tasks.
-
Integrate Live Certinia Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass in MicroStrategy Developer using the CData Software ODBC Driver for SAP Fieldglass.
-
Analyze Planio Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Planio and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Visualize Billsby Data in TIBCO Spotfire through ADO.NET
Integrate Billsby into dashboards in TIBCO Spotfire.
-
Build a PostgreSQL Interface for Vault CRM Data using the CData JDBC Driver
Use the Remoting features of the Vault CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Theia IDE with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Access Live CapsuleCRM Data in AWS Lambda
Connect to live CapsuleCRM in AWS Lambda using the CData JDBC Driver.
-
Build Highrise Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Highrise CRM and build visualizations in Tableau Cloud.
-
Connect to and Visualize Live SAP HANA XS Advanced Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP HANA XS Advanced.
-
Connect to Onfleet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Onfleet to connect to Onfleet and execute queries in PowerBuilder.
-
Automated Continuous ClickUp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ClickUp replication to IBM DB2.
-
Connect to Optimizely from Asprova with CData Software ODBC Driver for Optimizely
This article shows how to connect faster to Optimizely data from Asprova.
-
Getting Started with the CData Excel Add-In for Marketo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Marketo.
-
Integrate Cursor with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Campaign Manager 360 from within the editor.
-
Build Pipedrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Bubble.
-
Connect to Testmonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Testmonitor and work with Testmonitor in your FileMaker applications.
-
Connect to Splunk Data in RapidMiner
Integrate Splunk with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect the Power BI Service to ShipStation: Complete Guide
Connect to the CData Software Power BI Connector for ShipStation from PowerBI.com to provide real-time ShipStation across the organization.
-
Integrate with Klaviyo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Klaviyo in SnapLogic.
-
How to publish and share SAP Hybris C4C Data dashboards with Tableau Server
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.
-
Connect to Excel Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Excel Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connecting Pipedream with Zoom 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 Zoom data in real time.
-
Create ADP-Connected Business Apps in AppSheet
Connect to ADP Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ADP.
-
Choosing the Best Method to Connect ZendeskSell to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZendeskSell from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Zoho Projects Data in Tableau
The CData ODBC driver for Zoho Projects enables you integrate Zoho Projects into Tableau dashboards.
-
Creating Cosmos DB-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Cosmos DB to Unqork and build custom business apps.
-
Access Live Todoist Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Todoist data source in TIBCO Data Virtualization Studio and gain access to live Todoist from your TDV Server.
-
Integrate PingOne with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PingOne with External Services.
-
How to connect to Facebook Data from IntelliJ
Integrate connectivity to Facebook with wizards in IntelliJ.
-
How to Import Data from Tavily into Google Sheets
Import Tavily into a Google spreadsheet that is automatically refreshed.
-
How to work with QuickBooks Online Data in Apache Spark using SQL
Access and process QuickBooks Online Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ODBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Analysis Services.
-
Automated Continuous Xero Replication to Databricks
Use CData Sync for automated, continuous, customizable Xero replication to Databricks.
-
Build QuickBooks Online-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live QuickBooks Online.
-
Replicate ShipEngine Data to Multiple Databases
Replicate ShipEngine to disparate databases with a point-and-click configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads through an SAP BusinessObjects universe.