CData Software - Knowledge Base
Recent Articles
-
Connecting GenSpark with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Business ByDesign without any replication or custom integration required.
-
Build Hive-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Apache Hive to explore live Hive Data in Cursor to assist with building Hive-powered applications.
-
Connect to Google Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Ads in the Denodo Virtual DataPort Administrator.
-
Create Google Directory-Connected Applications in Appsmith
Connect to Google Directory Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Directory.
-
Integrating Kiro CLI with LinkedIn Ads 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 Zoom Replication to MySQL
Use CData Sync for automated, continuous, customizable Zoom replication to MySQL.
-
How to Connect to Live Airtable Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Airtable securely in real time.
-
Connect to Greenhouse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Greenhouse and the Script function in FileMaker Pro to connect to Greenhouse and work with Greenhouse in your FileMaker application.
-
ETL OpenWeatherMap in Oracle Data Integrator
This article shows how to transfer OpenWeatherMap into a data warehouse using Oracle Data Integrator.
-
Integrating Codex CLI with Avaza 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.
-
Provide OData Services of Stack Exchange Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Stack Exchange by developing a WCF Service Application.
-
Integrate Raisers Edge NXT Data in the Pentaho Report Designer
Publish reports based on Raisers Edge NXT in the Pentaho BI tool.
-
Query Excel Data in DataGrip
Create a Data Source for Excel in DataGrip and use SQL to query live Microsoft Excel.
-
Integrating Dataiku with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Pivotal GreenPlum.
-
Use the CData ODBC Driver for Dotmailer in Microsoft Power Query
You can use the CData Dotmailer ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dotmailer into Microsoft Power Query.
-
Integrating Dataiku with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Marketplace.
-
Getting Started with the CData Python Connector for CouchDB
Learn to install and license the CData Python Connector
-
Access Live Dotmailer Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dotmailer into the statistical analysis tools available in SAS JMP. This article shows how to use Dotmailer in the Graph Builder and Query Builder.
-
Automated Continuous MariaDB Replication to Oracle
Use CData Sync for automated, continuous, customizable MariaDB replication to Oracle.
-
Getting Started with the CData ADO.NET Provider for Stack Exchange
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData ODBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Recurly.
-
Integrate Adobe Analytics Data in the Pentaho Report Designer
Publish reports based on Adobe Analytics in the Pentaho BI tool.
-
Automate SAP HANA XS Advanced Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA XS Advanced replication to Azure Data Lake.
-
How to Visualize Amplitude Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amplitude in Python.
-
Connect to Airtable Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Airtable.
-
Creating Avro-Connected Applications in Unqork
You can use CData Connect AI to feed Apache Avro to Unqork and build custom business apps.
-
Provide OData Services of Zoho Projects Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Projects by developing a WCF Service Application.
-
How to connect SharePoint with Facebook Data through external lists
Provide Facebook to SharePoint users as an external list.
-
Replicate Avalara AvaTax Data in Heroku for Use in Salesforce Connect
Replicate Avalara AvaTax to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Pinterest Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinterest replication to SQLite.
-
Getting Started with the CData SSIS Components for Google Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Directory.
-
Connect to Wave Financial from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wave Financial to connect to Wave Financial from Web applications running on WebLogic.
-
Migrating data from WooCommerce to Google BigQuery using CData SSIS Components.
Easily push WooCommerce to Google BigQuery using the CData SSIS Tasks for WooCommerce and Google BigQuery.
-
How to Connect the Power BI Service to Autopilot: Complete Guide
Connect to the CData Software Power BI Connector for Autopilot from PowerBI.com to provide real-time Autopilot across the organization.
-
Connect to SurveyMonkey Data from a Connection Pool in JBoss
Integrate SurveyMonkey into Java servlets: Use the Management Console in JBoss to install the SurveyMonkey JDBC Driver.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Web
Connect to Square in MicroStrategy Web using the CData Software JDBC Driver for Square.
-
Build MVC Applications with Connectivity to Workday Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workday from an ASP.NET MVC application.
-
Build Quaderno-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Quaderno and build web apps with connectivity to live Quaderno.
-
How to Query Live Testmonitor Data in Perplexity MacOS Desktop
Connect to and query live Testmonitor Data in Perplexity Desktop using CData MCP Server.
-
Integrating OpenCode Terminal with Autopilot 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 Gorgias Replication to Oracle
Use CData Sync for automated, continuous, customizable Gorgias replication to Oracle.
-
Integrate Real-Time Access to Impala in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Impala in real time.
-
Import Xero Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Xero Data and provide access to live Xero Accounting for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to Excel Online through SSIS
Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.
-
Automated Continuous ShipEngine Replication to Oracle
Use CData Sync for automated, continuous, customizable ShipEngine replication to Oracle.
-
How to load Sugar CRM data into Elasticsearch via Logstash
Introducing a simple method to load Sugar CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To an ODBC Data Source for eBay Analytics
Create an ODBC connection to eBay Analytics in Informatica and browse and transfer eBay Analytics.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS and execute queries in PowerBuilder.
-
DataBind Charts to ClickTime Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ClickTime 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.
-
Use Dash to Build to Web Apps on SAP SuccessFactors Data
Create Python applications that use pandas and Dash to build SAP SuccessFactors-connected web apps.
-
Connect to ScrapingBee from Asprova with CData Software ODBC Driver for ScrapingBee
This article shows how to connect faster to ScrapingBee data from Asprova.
-
Access Live Google Translate Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Google Translate data source in TIBCO Data Virtualization Studio and gain access to live Google Translate from your TDV Server.
-
Connect to Oracle Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle Database from HeidiSQL.
-
How to Connect to Live IBM Informix 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 IBM Informix through natural language.
-
Connect to Unbounce Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Unbounce.
-
Visualize PayPal Data in TIBCO Spotfire through OData
Integrate PayPal into dashboards in TIBCO Spotfire.
-
Integrate Oracle SCM Data in Pentaho Data Integration
Build ETL pipelines based on Oracle SCM in the Pentaho Data Integration tool.
-
Connect to Attio Data in HULFT Integrate
Connect to Attio as a JDBC data source in HULFT Integrate
-
Migrating data from Greenplum to Google BigQuery using CData SSIS Components.
Easily push Pivotal GreenPlum to Google BigQuery using the CData SSIS Tasks for Greenplum and Google BigQuery.
-
Connect to Live Cosmos DB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Cosmos DB in CData Connect AI and connect to your Azure Cosmos DB from PostgreSQL.
-
How to connect to Tally Data from Spring Boot
Connect to Tally in a Spring Boot Application using the CData JDBC Driver for Tally
-
DataBind Controls to Paylocity Data in C++Builder
DataBind to Paylocity in C++Builder with standard components and controls.
-
Import Real-Time Autopilot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Autopilot in ColdFusion.
-
Easily Integrate Clockify Data in Lazarus Pascal IDE
Learn how to easily integrate live Clockify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting GenSpark with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Amazon Redshift without any replication or custom integration required.
-
Explore Geographical Relationships in CapsuleCRM Data with Power Map
Create data visualizations with CapsuleCRM in Power Map.
-
Integrating Cursor CLI with Trello 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 Dynamic Toggl Grids Using the Infragistics XamDataGrid
Learn how you can connect Toggl to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Parquet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Parquet.
-
Integrating Boomi Agentstudio with Oracle HCM Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle HCM Cloud, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build QuickBooks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to QuickBooks Desktop and build web apps with connectivity to live QuickBooks Desktop.
-
How to Build an ETL App for Google Search Results in Python with CData
Create ETL applications and real-time data pipelines for Google Search in Python with petl.
-
Connect and Query Live Amazon Marketplace Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Amazon Marketplace into Databricks
-
Create Dynamic PivotalTracker Grids Using the Infragistics XamDataGrid
Learn how you can connect PivotalTracker to Infragistics XamDataGrid to build dynamic grids.
-
Automate Freshsales Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Freshsales and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Access Live Marketo Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Marketo from your Google Sheets.
-
Natively Connect to Klipfolio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Klipfolio. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for Datadog
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Datadog.
-
Integrate Live OData Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Analyze Azure Data Catalog Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Data Catalog and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM for you.
-
Build a Simple VCL Application for SAP Ariba Procurement Data
How to build a simple VCL Application to view SAP Ariba Procurement in RAD Studio using the CData ODBC Driver for SAP Ariba Procurement.
-
Choosing the Best Method to Connect PabblySubscriptions to SQL Server: 5 Options Explained
Discover multiple ways to connect and use PabblySubscriptions from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect to Live Google Drive Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Drive for you.
-
Prepare, Blend, and Analyze Gorgias Data in Alteryx Designer (ODBC)
Build workflows to access live Gorgias for self-service data analytics.
-
Establish a Live Connection with Google Tasks Data using Tableau Bridge
The CData ODBC Driver for Google Tasks enables you to integrate live Google Tasks into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live Templated Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Templated to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use Biml to Build SSIS Tasks to Replicate Insightly Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Insightly to SQL Server.
-
Provide OData Services of Klaviyo Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Klaviyo by developing a WCF Service Application.
-
Build MessageBird-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live MessageBird Data in Claude Code to assist with building MessageBird-powered applications.
-
How to Connect MarkLogic Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MarkLogic data in real time using natural language.
-
Connect to Guru Data from PowerBuilder via JDBC
This article demonstrates how to access Guru from PowerBuilder using the Guru JDBC Driver.
-
Create Data Visualizations Based On Amazon S3 Data in Mode
Use CData Connect AI to connect to Amazon S3 Data from Mode and build visualizations using live
-
How to Connect to Live Jira 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 Atlassian Jira through natural language.
-
How to connect PolyBase to Facebook Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads.
-
Query QuickBooks Online Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Online.
-
Integrate AgileCRM Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live AgileCRM from Informatica Cloud.
-
How to Query Live Oracle Eloqua Data in Perplexity MacOS Desktop
Connect to and query live Oracle Eloqua Data in Perplexity Desktop using CData MCP Server.
-
Provide OData Services of PagerDuty Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for PagerDuty by developing a WCF Service Application.
-
Automate Microsoft Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Ads from PowerShell? This article demonstrates how to utilize the Microsoft Ads Cmdlets for tasks like connecting to Microsoft Ads, automating operations, downloading data, and more.