CData Software - Knowledge Base
Recent Articles
-
Connect to Elasticsearch Data in RapidMiner
Integrate Elasticsearch with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze DB2 Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of IBM DB2 and visualize live IBM DB2 in Infragistics Reveal.
-
Build Pipelines with Live Spark Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Spark from Google Cloud Data Fusion, enabling the integration of live Apache Spark SQL into the building and management of effective data pipelines.
-
Build Visualizations of Google Sheets Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Sheets in Birst.
-
Access Live Amazon DynamoDB 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 Amazon DynamoDB through MCP integration.
-
Analyze Hubstaff Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hubstaff in Microsoft R Open.
-
DataBind Controls to Freshdesk Data in Delphi
DataBind to Freshdesk in Delphi with standard data access components and controls.
-
Build SageHR-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live SageHR Data in Cursor to assist with building SageHR-powered applications.
-
Use the CData Software ODBC Driver for Mode in MicroStrategy Web
Connect to Mode in MicroStrategy Web using the CData Software ODBC Driver for Mode.
-
Build Gmail-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Gmail to explore live Gmail Data in GitHub Copilot to assist with building Gmail-powered applications.
-
Build an OLAP Cube in SSAS from ClickTime Data
Establish a connection to ClickTime data from SQL Server Analysis Services, and use the ClickTime Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Onfleet Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Onfleet from HeidiSQL.
-
Integrate LibreChat with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Entra ID from within the chat interface.
-
Connect to SparkPost Data in Jaspersoft Studio
Execute SQL to remote SparkPost in Jaspersoft Studio.
-
Trigger CouchDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CouchDB with standard wizards in Logic Apps.
-
Using the CData Software ODBC Driver for AdRoll in PyCharm
Connect to AdRoll as an ODBC data source in PyCharm using the CData Software ODBC Driver for AdRoll.
-
Visualize Harvest Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Harvest.
-
Automated Continuous Klipfolio Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Klipfolio replication to Apache Cassandra.
-
Integrate with ServiceDesk Plus Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ServiceDesk Plus to a JSON file on disk.
-
Integrate PolarTeamPro Data in Pentaho Data Integration
Build ETL pipelines based on PolarTeamPro in the Pentaho Data Integration tool.
-
LINQ to Reply.io 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 Reply.io Data Provider.
-
Access Live DB2 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live IBM DB2 from your Excel spreadsheets.
-
Build PagerDuty-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live PagerDuty Data in GitHub Copilot to assist with building PagerDuty-powered applications.
-
Access Oracle SCM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Oracle SCM from HeidiSQL.
-
How to Work with SparkPost Data in AWS Glue Jobs Using JDBC
Connect to SparkPost from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate Multiple Zoho Inventory Accounts via the CData Sync CLI
Replicate multiple Zoho Inventory accounts to one or many databases.
-
Feed JDBC-ODBC Bridge Data into FineReport
How to set JDBC-ODBC Bridge as a JDBC data source in FineReport.
-
Automated Continuous Amazon DynamoDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to IBM DB2.
-
How to Query Live SFTP Data in Perplexity MacOS Desktop
Connect to and query live SFTP Data in Perplexity Desktop using CData MCP Server.
-
Add ShipEngine Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ShipEngine with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live SAP Business One 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 SAP Business One for you.
-
How to Use a Microsoft Access Database to Update Paylocity Data in Real Time
Update Paylocity data by creating a linked table in Microsoft Access with the CData Paylocity ODBC Driver.
-
Build MVC Applications with Connectivity to BigQuery Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigQuery from an ASP.NET MVC application.
-
Analyze Microsoft Dataverse Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Dataverse (CDS) and visualize live Microsoft Dataverse (CDS) in Infragistics Reveal.
-
Automated Continuous Codat Replication to SQLite
Use CData Sync for automated, continuous, customizable Codat replication to SQLite.
-
Integrating Boomi Agentstudio with Excel Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Excel Online, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import Impala Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apache Impala. In this article, you will use the OData format to import Apache Impala into Microsoft Power Query.
-
How to Work with Zoho Creator Data in AWS Glue Jobs Using JDBC
Connect to Zoho Creator from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Parquet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parquet and the SQL Gateway to access Apache Parquet from Google Apps Script.
-
Automated Continuous SAP Business One Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Business One replication to Snowflake.
-
Write a Simple Go Application to work with GraphQL Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GraphQL.
-
Consume Pushbullet OData Feeds in PowerBuilder
This article demonstrates how to consume Pushbullet as OData feeds from PowerBuilder using the API Server.
-
How to Query Live ConstantContact Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConstantContact data in natural language using Python.
-
Getting Started with the CData Power BI Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Facebook Ads.
-
Operational Reporting on Google Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Analytics.
-
Analyze Live Oracle Eloqua Data in SAS Viya
Use CData Connect AI to connect to Oracle Eloqua from SAS Viya and deploy self-service analytics using live Oracle Eloqua.
-
Use the CData Software ODBC Driver for Factorial in MicroStrategy
Connect to Factorial in MicroStrategy Developer using the CData Software ODBC Driver for Factorial.
-
Connect to Active Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Active Directory and the Script function in FileMaker Pro to connect to Active Directory and work with Active Directory in your FileMaker application.
-
Automated Continuous Autopilot Replication to MongoDB
Use CData Sync for automated, continuous, customizable Autopilot replication to MongoDB.
-
Model, Search, and Visualize Live SAP BusinessObjects BI Data in ThoughtSpot
Use CData Connect AI to connect to live SAP BusinessObjects BI for modeling, searching, and visualizing.
-
Natively Connect to Procore Data in PHP
The CData ODBC driver for Procore enables you to create PHP applications with connectivity to Procore. Leverage the native support for ODBC in PHP.
-
How to load SAP Business One data into Elasticsearch via Logstash
Introducing a simple method to load SAP Business One data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to connect and process Facebook from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook.
-
Connect Recurly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Recurly with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Neo4J Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Neo4J.
-
Moving Data from BenchmarkEmail to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BenchmarkEmail data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Jumpseller Data in TIBCO Spotfire through OData
Integrate Jumpseller into dashboards in TIBCO Spotfire.
-
Import Real-Time Float Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Float in ColdFusion.
-
Write a Simple Go Application to work with Cosmos DB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Azure Cosmos DB.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed FTP Servers to Power BI dashboards. Simply drag and drop FTP Servers into data visuals on the Power BI canvas.
-
Integrating OpenCode Terminal with Outlook 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 a Singer.io Tap for SendPulse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendPulse data using
-
Back Up Tickspot to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Tickspot data.
-
Getting Started with the CData Excel Add-In for Freshservice
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshservice.
-
How to integrate PDFMonkey with Apache Airflow
Access and process PDFMonkey in Apache Airflow using the CData JDBC Driver.
-
Access Live Mocean Data in AWS Lambda
Connect to live Mocean in AWS Lambda using the CData JDBC Driver.
-
How to Easily Query MySQL Data in OpenOffice Base
Connect to MySQL data in OpenOffice Base using the CData ODBC Driver for MySQL and generate reports with live data insights.
-
Use Manus AI to Talk to Your Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Active Directory.
-
Integrating Gumloop with Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Ads within automated workflows.
-
How to connect SharePoint with OpenWeatherMap Data through external lists
Provide OpenWeatherMap to SharePoint users as an external list.
-
How to connect to MongoDB Data with Squirrel SQL client
Connect to MongoDB and execute queries in the Squirrel SQL Client.
-
Manage Timely Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Timely.
-
How to Query Mouseflow Data in MySQL Workbench
Execute MySQL queries against live Mouseflow from MySQL Workbench.
-
Access LinkedIn Data from MySQL in PHP
Connect to LinkedIn through the standard MySQL libraries in PHP.
-
Migrating data from ScrapingBee to Snowflake using CData SSIS Components.
Easily push ScrapingBee to Snowflake using the CData SSIS Tasks for ScrapingBee and Snowflake.
-
Automated Continuous Mouseflow Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Mouseflow replication to OneLake in Microsoft Fabric.
-
Connect to Google Tasks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Tasks using standard SQL.
-
How to Build an ETL App for Cloudflare Data in Python with CData
Create ETL applications and real-time data pipelines for Cloudflare in Python with petl.
-
Build Apollo-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Apollo Data in Claude Code to assist with building Apollo-powered applications.
-
Object-Relational Mapping (ORM) with Autopilot 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 Autopilot into a Java-based ORM framework, Hibernate.
-
Analyze Live SingleStore Data in SAS Viya
Use CData Connect AI to connect to SingleStore from SAS Viya and deploy self-service analytics using live SingleStore.
-
Build QuickBooks Time-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Time Data and create custom apps in Bubble.
-
Replicate Multiple Figshare Accounts via the CData Sync CLI
Replicate multiple Figshare accounts to one or many databases.
-
Use the CData ODBC Driver for BenchmarkEmail in Microsoft Power Query
You can use the CData BenchmarkEmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BenchmarkEmail into Microsoft Power Query.
-
Connect to QuickBooks Data in RapidMiner
Integrate QuickBooks Desktop with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Databricks Data in Jaspersoft Studio
Execute SQL to remote Databricks in Jaspersoft Studio.
-
Use Dash to Build to Web Apps on Sage Cloud Accounting Data
Create Python applications that use pandas and Dash to build Sage Cloud Accounting-connected web apps.
-
Easily Integrate Zuora Data in Lazarus Pascal IDE
Learn how to easily integrate live Zuora in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Back Up Aha! to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Aha! data.
-
Access Live Dropbox Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Dropbox data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Migrating data from Adobe Experience Manager to Google BigQuery using CData SSIS Components.
Easily push Adobe Experience Manager to Google BigQuery using the CData SSIS Tasks for Adobe Experience Manager and Google BigQuery.
-
Integrate Live Tanda Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tanda to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Amazon DynamoDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon DynamoDB from Filemaker Pro on Mac.
-
Automated Continuous Front Replication to SQLite
Use CData Sync for automated, continuous, customizable Front replication to SQLite.
-
Model, Search, and Visualize Live Snowflake Data in ThoughtSpot
Use CData Connect AI to connect to live Snowflake for modeling, searching, and visualizing.
-
Publish Productboard-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Productboard.
-
Build AI Agents with Adobe Commerce 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 Adobe Commerce through CData Connect AI.
-
Query Suadeo Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Suadeo entities in PHP by modeling them as objects.
-
Explore Geographical Relationships in JotForm Data with Power Map
Create data visualizations with JotForm in Power Map.
-
Publish PolarTeamPro-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live PolarTeamPro.