CData Software - Knowledge Base
Recent Articles
-
Connect to Foursquare from a Connection Pool in WebLogic
Use the CData JDBC Driver for Foursquare to connect to Foursquare data from Web applications running on WebLogic.
-
Connect to Real-Time Superchat Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Superchat data in Power Apps.
-
Getting Started with the CData Power BI Connector for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP Ariba Source.
-
Integrating Gumloop with Samanage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Samanage data within automated workflows.
-
Import Real-Time Google Forms Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Forms data in ColdFusion.
-
Automated Continuous Billsby Replication to MongoDB
Use CData Sync for automated, continuous, customizable Billsby replication to MongoDB.
-
Configure the CData JDBC Driver for Pinecone in a Connection Pool in Tomcat
Connect to Pinecone data from a connection pool in Tomcat.
-
Integrate Theia IDE with Live SharePoint 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 SharePoint data from within the development environment.
-
Automated Continuous PDFMonkey Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Apache Kafka.
-
How to Access Live Square Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Square enables you to integrate Square data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live xBase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live xBase data from within the IDE.
-
Build a Singer.io Tap for Salesforce CRM Analytics With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Salesforce CRM Analytics data using the CData Python Connector.
-
Work with Front Data in FoxPro
Load Front data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Build an ETL App for ZohoDesk Data in Python with CData Connect AI
Extract and transform live ZohoDesk data in Python with petl and the CData Connect AI Python SDK.
-
Use Grok to Talk to Your Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Bitly data for you.
-
Build an OLAP Cube in SSAS from Access Data
Establish a connection to Access data data from SQL Server Analysis Services, and use the Access Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Tally from a Connection Pool in WebLogic
Use the CData JDBC Driver for Tally to connect to Tally data from Web applications running on WebLogic.
-
Connect to Spotify Data from a Connection Pool in Jetty
The Spotify JDBC Driver supports connection pooling: This article shows how to connect faster to Spotify data from Web apps in Jetty.
-
Work with Live MailerLite Data in Power Query
Use CData Connect AI to connect to MailerLite data and work with live MailerLite data in Microsoft Power Query.
-
Query XML Data through ODBC in Node.js
Use node-odbc to execute SQL queries against XML data from Node.js.
-
Visualize SAP Ariba Procurement Data in TIBCO Spotfire through ADO.NET
Integrate SAP Ariba Procurement data into dashboards in TIBCO Spotfire.
-
Moving Data from Brex to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Brex data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import and Visualize Google Analytics Data in Power View
Create data visualizations based on Google Analytics data in Excel.
-
How to connect to Nuclia Data from Spring Boot
Connect to Nuclia in a Spring Boot Application using the CData API Driver for JDBC
-
How to create Visio diagrams from Pipedrive Data
Automatically update Pipedrive data with the changes you make to Visio master shapes.
-
Migrating data from SurveyMonkey to Google BigQuery using CData SSIS Components.
Easily push SurveyMonkey data to Google BigQuery using the CData SSIS Tasks for SurveyMonkey and Google BigQuery.
-
Query Box Data as a SQL Server Database in Node.js
Execute SQL Server queries against Box data from Node.js.
-
Use Databricks Agent Bricks to Talk to Your Raisers Edge NXT Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Raisers Edge NXT data for you.
-
Natively Connect to WordPress Data in PHP
The CData ODBC driver for WordPress enables you to create PHP applications with connectivity to WordPress data. Leverage the native support for ODBC in PHP.
-
Create Dynamic Figshare Grids Using the Infragistics XamDataGrid
Learn how you can connect Figshare to Infragistics XamDataGrid to build dynamic grids.
-
Integrating GitHub Copilot with Printful 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.
-
Use Grok to Talk to Your ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your ActiveCampaign data for you.
-
Getting Started with the CData ADO.NET Provider for Sendwithus
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Query eBay Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume eBay entities in PHP by modeling them as objects.
-
Integrate with Google Analytics Data in JReport Designer
Create charts and reports based on Google Analytics data in JReport Designer.
-
Create Dashboards and Visualize Live Reckon Data in Geckoboard
Use CData Connect AI to connect to live Reckon data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Informatica Mappings From/To a JDBC Data Source for CampaignMonitor
Create CampaignMonitor data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Connect to Live ZohoPeople Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live ZohoPeople data without replication.
-
Integrate Devin with Live VWO Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live VWO data.
-
A PostgreSQL Interface for Spark Data (MySQL Remoting via JDBC)
Use the Remoting features of the Spark JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate Amazon S3 Data in Pentaho Data Integration
Build ETL pipelines based on Amazon S3 data in the Pentaho Data Integration tool.
-
LINQ to Phoenix 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 Phoenix Data Provider.
-
Integrate ZohoMarketingHub Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ZohoMarketingHub data from Informatica Cloud.
-
Integrating Dataiku with Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Shippo data.
-
Connecting Moonlit Workflow with IBM Informix Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your IBM Informix data in real time.
-
Analyze LightSpeedRetail Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LightSpeedRetail data in Microsoft R Open.
-
Getting Started with the CData Power BI Connector for Elorus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to Live SAP Hybris C4C Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP Hybris C4C in CData Connect AI and connect to your SAP Hybris C4C data from PostgreSQL.
-
Prepare, Blend, and Analyze Postmark Data in Alteryx Designer (ODBC)
Build workflows to access live Postmark data for self-service data analytics.
-
How to Work with SAP Concur Data in AWS Glue Jobs Using JDBC
Connect to SAP Concur from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Object-Relational Mapping (ORM) with WooCommerce 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 WooCommerce data into a Java-based ORM framework, Hibernate.
-
How to import CapsuleCRM Data into Apache Solr
Use the CData Software JDBC Driver for CapsuleCRM in Data Import Handler and create an automated import of CapsuleCRM data to Apache Solr Enterprise Search platform.
-
How to connect to Twilio Data in DBVisualizer
Integrate Twilio data with visual data analysis tools and data connection wizards in DBVisualizer
-
Query Presto Data as a SQL Server Database in Node.js
Execute SQL Server queries against Presto data from Node.js.
-
Integrating LlamaIndex with Printify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Printify data in real time.
-
Migrating data from GitLab to Google BigQuery using CData SSIS Components.
Easily push GitLab data to Google BigQuery using the CData SSIS Tasks for GitLab and Google BigQuery.
-
Consume Kintone OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Kintone feeds that reflect any changes in SAP Lumira.
-
Automated Continuous Coda Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Coda replication to AlloyDB.
-
Hive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Hive facts in real time.
-
Use Microsoft Copilot Studio to talk to your Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Authorize.Net data for you.
-
Analyze Paymo Data in Cognos Analytics
Use CData Connect AI to connect to Paymo Data from Cognos Analytics and analyze live Paymo data.
-
Using the CData Software ODBC Driver for Splunk in PyCharm
Connect to Splunk as an ODBC data source in PyCharm using the CData Software ODBC Driver for Splunk.
-
Access Live CapsuleCRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live CapsuleCRM data from your Excel spreadsheets.
-
Trigger Dynamics 365 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Dynamics 365 with standard wizards in Logic Apps.
-
Create Acumatica-Connected Applications in Appsmith
Connect to Acumatica Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Acumatica data.
-
How to Create Power BI Visual Reports with Real-Time Apify Data
Use CData Power BI Connectors to visualize Apify data in Power BI.
-
Integrate with live Google Drive Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google Drive data in Jitterbit.
-
Connect to Salesloft Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesloft data in the Denodo Virtual DataPort Administrator.
-
Connect to Kintone Data from PowerBuilder via ADO.NET
This article demonstrates how to access Kintone data from Appeon PowerBuilder using the CData ADO.NET Provider for Kintone.
-
Build Coda-Connected Apps in Choreo
Use CData Connect AI to connect to Coda Data from Choreo and build custom apps using live Coda data.
-
Create SharePoint-Connected Applications in Appsmith
Connect to SharePoint Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SharePoint data.
-
Integrating Cursor with eBay 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.
-
Connect to Tickspot Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Tickspot data.
-
Analyze Excel Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Excel Online data with the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Tableau Connector for Scrapfly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Stripe-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Stripe Data from Zoho Analytics and import live Stripe data.
-
Use Azure AI Foundry to Talk to Your Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Amazon Athena data for you.
-
How to Connect to Live LDAP Objects from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your LDAP objects for you.
-
Integrate Trae with Live YouTube Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live YouTube Analytics data from within the AI-powered IDE.
-
Integrate with ClickTime Data in JReport Designer
Create charts and reports based on ClickTime data in JReport Designer.
-
DataBind Controls to OnePageCrm Data in Delphi
DataBind to OnePageCrm data in Delphi with standard data access components and controls.
-
Automate Zoom Data Replication to Couchbase
Use CData Sync to Customize and automate Zoom data replication to Couchbase.
-
Building Dynamic Web Pages with YouTube Analytics Data Using AngularJS
Create single-page applications with live connectivity to YouTube Analytics using the CData API Server.
-
Microsoft Ads Reporting in OBIEE with the Microsoft Ads JDBC Driver
Deploy the Microsoft Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Lakebase Data in Google Apps Script via Connect AI
Use CData Connect AI to access Lakebase data in Google Apps Script.
-
Connect to and Visualize Live Jira Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Jira data.
-
Create Power BI Reports on Real-Time Cvent Data
Use the CData ODBC Driver for Cvent to visualize Cvent data in Power BI Desktop.
-
Replicate WooCommerce Data from PowerShell
Write a quick PowerShell script to query WooCommerce data. Use connectivity to the live data to replicate WooCommerce data to SQL Server.
-
How to Visualize Azure Data Catalog Data in Python with pandas
Use pandas and other modules to analyze and visualize live Azure Data Catalog data in Python.
-
Manage Vault CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Vault CRM.
-
How to Connect Flowise AI Agents to Live Figshare Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Figshare data without replication.
-
Connect to Salesforce Marketing Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce Marketing data in the Denodo Virtual DataPort Administrator.
-
DataBind Controls to Spark Data in Delphi
DataBind to Spark data in Delphi with standard data access components and controls.
-
Build Dashboards with Beeminder Data in Dundas BI
Create dynamic dashboards and perform analytics based on Beeminder data in Dundas BI.
-
Visualize Pinecone Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pinecone data.
-
Use the CData Software JDBC Driver for Excel Online in MicroStrategy
Connect to Excel Online data in MicroStrategy Developer using the CData Software JDBC Driver for Excel Online.
-
Connect Billsby Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Billsby data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Simple VCL Application for Discord Data
How to build a simple VCL Application to view Discord data in RAD Studio using the CData ODBC Driver for Discord.
-
Build a PostgreSQL Interface for Blackbaud FE NXT Data using the CData JDBC Driver
Use the Remoting features of the Blackbaud FE NXT JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze MongoDB Data in Cognos Analytics
Use CData Connect AI to connect to MongoDB Data from Cognos Analytics and analyze live MongoDB data.