CData Software - Knowledge Base
Recent Articles
-
Access Front Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Front data.
-
How to connect PolyBase to Strava
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Strava data.
-
Create Sage 200-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage 200 Data from OutSystems and build custom enterprise apps using live Sage 200 data.
-
Natively Connect to Optimizely Data in PHP
The CData ODBC driver for Optimizely enables you to create PHP applications with connectivity to Optimizely data. Leverage the native support for ODBC in PHP.
-
Automated Continuous VWO Replication to MySQL
Use CData Sync for automated, continuous, customizable VWO replication to MySQL.
-
Use the CData Software ODBC Driver for ClickUp in MicroStrategy Desktop
Connect to ClickUp data in MicroStrategy Desktop using the CData Software ODBC Driver for ClickUp.
-
Automated Continuous Gumroad Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Gumroad replication to Azure SQL Database.
-
Automated Continuous Campaigner Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Campaigner replication to Azure SQL Database.
-
Build Mistral AI-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Mistral AI data.
-
Create Attio-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Attio Data from Klipfolio and build custom visualizations using live Attio data.
-
Automate Vercel Data Replication to SAP HANA
Use CData Sync to customize and automate Vercel data replication to SAP HANA.
-
Integrate Dify with Live YouTube Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live YouTube Analytics data.
-
Create Data Visualizations Based On Redshift Data in Mode
Use CData Connect AI to connect to Redshift Data from Mode and build visualizations using live Redshift data.
-
Manage Hugging Face Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hugging Face.
-
Connect to ScrapingBee Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ScrapingBee as an External Source in Dremio.
-
Integrate Greenplum Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Greenplum data and integrate live Greenplum data into your Power Automate tasks.
-
Access Snapchat Ads Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Snapchat Ads data from your Oracle system.
-
Integrate with AfterShip Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy AfterShip data to a JSON file on disk.
-
Use Dash to Build to Web Apps on Confluence Data
Create Python applications that use pandas and Dash to build Confluence-connected web apps.
-
How to Connect the Power BI Service to Redis: Complete Guide
Connect to the CData Software Power BI Connector for Redis from PowerBI.com to provide real-time Redis data across the organization.
-
SAP ByDesign Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP ByDesign facts in real time.
-
Getting Started with the CData Python Connector for Google Directory
Learn to install and license the CData Python Connector and configure a connection to live Google Directory data.
-
How to connect Amazon QuickSight to Salesforce Pardot Data
Create a connection to Salesforce Pardot data in CData Connect AI and insert Salesforce Pardot data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrate Google Drive with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Drive with External Services.
-
How to Connect to Live Airtable 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 Airtable data through natural language.
-
Query Google Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Google Analytics data from Node.js.
-
Build Dashboards with Microsoft Dataverse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Dataverse data in Dundas BI.
-
Getting Started with the CData ODBC Driver for ChargeOver
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ChargeOver.
-
Connecting GenSpark with GitHub Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to GitHub data without any replication or custom integration required.
-
Automated Continuous Excel Replication to SQLite
Use CData Sync for automated, continuous, customizable Excel replication to SQLite.
-
Automated Continuous EmailOctopus Replication to Databricks
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Databricks.
-
Object-Relational Mapping (ORM) with SAP Ariba Source 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 SAP Ariba Source data into a Java-based ORM framework, Hibernate.
-
How to Work with Google Contacts Data in AWS Glue Jobs Using JDBC
Connect to Google Contacts from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Data Visualizations Based On Typeform Data in Mode
Use CData Connect AI to connect to Typeform Data from Mode and build visualizations using live Typeform data.
-
Connect to Dynamics 365 Data in Ruby
Connect to Dynamics 365 data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with ChargeOver Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ChargeOver data to a JSON file on disk.
-
Add Hacker News Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Hacker News with the Informatica Enterprise Data Catalog to classify and organize data.
-
Replicate Multiple Snapchat Ads Accounts
Replicate multiple Snapchat Ads accounts to one or many databases.
-
LINQ to Perplexity 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 Perplexity Data Provider.
-
How to Connect to & Open Google Contacts Data in Microsoft Excel
This article uses the CData ODBC driver for Google Contacts to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Work with Dynamics 365 Data in FoxPro
Load Dynamics 365 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Pinterest Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pinterest replication to Azure SQL Database.
-
Automated Continuous Drip Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Drip replication to IBM DB2.
-
Connect to Live Tally Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Tally in CData Connect AI and connect to your Tally data from PostgreSQL.
-
Use the CData Software JDBC Driver for ZendeskSell in MicroStrategy Web
Connect to ZendeskSell data in MicroStrategy Web using the CData Software JDBC Driver for ZendeskSell.
-
Integrate Pipedrive Data into Power Automate Desktop using CData Connect
CData Connect for Pipedrive Data enables you to integrate Pipedrive data into workflows built using Microsoft Power Automate Desktop.
-
Query ClickTime Data in ColdFusion
Write standard ColdFusion data access code to connect to ClickTime data.
-
Provide OData Services of QuickBooks Online Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for QuickBooks Online data by developing a WCF Service Application.
-
Work with Live Mode Data in Power Query
Use CData Connect AI to connect to Mode data and work with live Mode data in Microsoft Power Query.
-
Connect to DB2 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 DB2 data.
-
Use the CData Software JDBC Driver for NASA in MicroStrategy Desktop
Connect to NASA data in MicroStrategy Desktop using the CData Software JDBC Driver for NASA.
-
Bind Live Microsoft Entra ID Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Entra ID data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate Google's Vertex AI Agent with Live SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SharePoint data within intelligent workflows.
-
Choosing the Best Method to Connect ActiveCampaign to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ActiveCampaign data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous RSS Replication to MySQL
Use CData Sync for automated, continuous, customizable RSS replication to MySQL.
-
Integrate Open WebUI with Live Mailgun Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Mailgun data from within the chat interface.
-
Create Reports from Procore Data in Looker Studio
Use CData Connect AI to gain access to live Procore data and create custom reports in Looker Studio.
-
How to load Billsby data into Elasticsearch via Logstash
Introducing a simple method to load Billsby data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Google Search-Connected Dashboards in Grafana
Connect to Google Search Results via CData Connect AI in Grafana and create custom business dashboards with real-time access to Google Search results.
-
How to create an RPA flow for Perplexity Data in UiPath Studio
Use the Perplexity ODBC Driver to create workflows that access real-time Perplexity data without any coding.
-
Pipedrive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Pipedrive facts in real time.
-
Integrating Claude Code CLI with Quaderno 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 REST-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to REST data and build web apps with connectivity to live REST data.
-
Automated Continuous Vault CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Vault CRM replication to Apache Cassandra.
-
Build Charts with Confluence Data in Clear Analytics
Create dynamic charts and perform analytics based on Confluence data in Clear Analytics.
-
Access Live Optimizely 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 Optimizely data through MCP integration.
-
Automated Continuous Calendly Replication to Snowflake
Use CData Sync for automated, continuous, customizable Calendly replication to Snowflake.
-
Integrate with Webflow Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Webflow data to a JSON file on disk.
-
Connect to Real-Time PabblySubscriptions Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PabblySubscriptions data in Power Apps.
-
Connect to and Visualize Live SAP Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP data.
-
Build Visualizations of Amazon DynamoDB Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon DynamoDB data in Birst.
-
Integrate Theia IDE with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Vault CRM data from within the development environment.
-
Access Live Teradata 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 Teradata data through MCP integration.
-
Automated Continuous SendInBlue Replication to SQLite
Use CData Sync for automated, continuous, customizable SendInBlue replication to SQLite.
-
Replicate Multiple Amazon Athena Accounts
Replicate multiple Amazon Athena accounts to one or many databases.
-
Access Avaza Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Avaza data from your Oracle system.
-
Integrate Theia IDE with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Salesloft data from within the development environment.
-
Use the CData Software JDBC Driver for Beeminder in MicroStrategy Web
Connect to Beeminder data in MicroStrategy Web using the CData Software JDBC Driver for Beeminder.
-
Build AI Agents with Kintone 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 Kintone data through CData Connect AI.
-
CData SAP Driver Deep Dive: Access SAP S/4HANA CDS Views as OData Services
A simple guide for exposing SAP S/4HANA CDS Views to access them as OData Services using the CData SAP Driver.
-
Connect to Front Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Front.
-
Access Live Sage Cloud Accounting 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 Sage Cloud Accounting data through MCP integration.
-
Create Datasets from Zoho Creator in Domo Workbench and Build Visualizations of Zoho Creator Data in Domo
Use the CData Software ODBC Driver for Zoho Creator to create datasets from Zoho Creator data in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Controls to Lakebase Data in C++Builder
DataBind to Lakebase data in C++Builder with standard components and controls.
-
Connect to Real-Time Salesforce Pardot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Pardot and Dataflow to import and use Salesforce Pardot data in Power Apps.
-
Query Live Azure Table Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Azure Table data through a conversational interface.
-
Create MessageBird Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MessageBird from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect Miro to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Miro data using the CData Python MCP Server.
-
Integrate Google's Antigravity Agent with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Amazon Athena data using the Model Context Protocol.
-
Connect to and Query Optimizely Data in QlikView over ODBC
Create data visualizations with Optimizely data in QlikView.
-
Connect to MessageBird Data in RapidMiner
Integrate MessageBird data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Square Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Square.
-
Access Live Klipfolio 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 Klipfolio data through MCP integration.
-
Use the CData SSIS Components to Insert New or Update Existing Highrise Records from SQL Server
Easily push SQL Server data to Highrise using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Highrise or update existing records with data from a SQL Server database.
-
How to Query Live AgileCRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live AgileCRM data data in natural language using Python.
-
DataBind Controls to Amazon S3 Data in Delphi
DataBind to Amazon S3 data in Delphi with standard data access components and controls.
-
Using the CData Software ODBC Driver for Discord in PyCharm
Connect to Discord as an ODBC data source in PyCharm using the CData Software ODBC Driver for Discord.
-
Automated Continuous Snapchat Ads Replication to Databricks
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Databricks.
-
Visualize Redshift Data in Sisense
Create an ElastiCube in Sisense app with access to Redshift data.
-
Build AI/ML Models with Live FreshBooks Data using Dataiku
Connect FreshBooks Data with Dataiku using the CData API Driver for JDBC.