CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Monday.com Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Monday.com replication to Google Cloud SQL.
-
Connect to Egnyte from a Connection Pool in WebLogic
Use the CData JDBC Driver for Egnyte to connect to Egnyte data from Web applications running on WebLogic.
-
How to Connect Flowise AI Agents to Live SQL Server 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 SQL Server data without replication.
-
Visualize Wistia Data in TIBCO Spotfire through ADO.NET
Integrate Wistia data into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for JotForm from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for JotForm to connect to JotForm data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring JotForm data in Excel.
-
Extract, Transform, and Load Tanda Data in Informatica PowerCenter
Create a simple Workflow for Tanda data in Informatica PowerCenter.
-
Query Adobe Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Analytics data from Node.js.
-
Integrate Devin with Live CouchDB 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 CouchDB data.
-
Create Informatica Mappings From/To an ODBC Data Source for Bannerbear
Create an ODBC connection to Bannerbear in Informatica and browse and transfer Bannerbear data.
-
Create Informatica Mappings From/To a JDBC Data Source for REST
Create REST data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData JDBC Driver for Phoenix
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Phoenix.
-
How to Access Google Spanner Data Using Entity Framework
This article shows how to access Google Spanner data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate PabblySubscriptions Data from PowerShell
Write a quick PowerShell script to query PabblySubscriptions data. Use connectivity to the live data to replicate PabblySubscriptions data to SQL Server.
-
How to Connect Flowise AI Agents to Live MailerLite 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 MailerLite data without replication.
-
Automated Continuous Neo4J Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Neo4J replication to Amazon S3.
-
Connect to SAP BusinessObjects BI from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP BusinessObjects BI data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Jira Assets Data from MySQL in Amazon QuickSight
Connect to Jira Assets and build visualizations of Jira Assets data using a MySQL Connection in Amazon QuickSight.
-
Build MVC Applications with Connectivity to LightSpeedRetail Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LightSpeedRetail from an ASP.NET MVC application.
-
Access Live Google Drive Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Drive data from your Google Sheets.
-
Create Data Visualizations in Cognos BI with Printful Data
Access Printful data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Query SAP ByDesign Data in QlikView over ODBC
Create data visualizations with SAP ByDesign data in QlikView.
-
Connect to Oracle Financials Cloud Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Financials Cloud Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze ZohoPeople Data in Cognos Analytics
Use CData Connect AI to connect to ZohoPeople Data from Cognos Analytics and analyze live ZohoPeople data.
-
How to Connect DBeaver to Amazon DynamoDB via a JDBC Driver
Manage Amazon DynamoDB data with visual tools in DBeaver like the query browser.
-
Integrate Cline with Live Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Dynamics CRM data from within your IDE.
-
Interact with Live HBase Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live HBase data.
-
Add Autopilot Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Autopilot with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous FormSite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FormSite replication to AlloyDB.
-
Connect to LinkedIn Ads Data in ACL Analytics
Connect to LinkedIn Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to LinkedIn Ads data.
-
Connect to and Visualize Live Mixpanel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mixpanel data.
-
How to Connect to Live Egnyte Data 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 Egnyte data for you.
-
How to create Visio diagrams from Access Data
Automatically update Access data with the changes you make to Visio master shapes.
-
Integrate Sage 200 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage 200 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage 200 data.
-
Integrating OData Services in Talend Cloud Data Management Platform
Connect OData Services with Talend Cloud Data Management Platform using the CData JDBC Driver for OData.
-
How to Visualize Monday.com Data in Python with pandas
Use pandas and other modules to analyze and visualize live Monday.com data in Python.
-
Analyze IBM Informix Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of IBM Informix data and visualize IBM Informix data in SAP Analytics Cloud.
-
Use Manus AI to Talk to Your SAP Business One 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 SAP Business One data.
-
Integrating Claude Code with HubDB Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on HubDB data within assisted coding and automated development workflows.
-
Connect to Pinterest Data in Aqua Data Studio
Access Pinterest data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Microsoft Planner Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Planner data from HeidiSQL.
-
Connect to eBay Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for eBay data.
-
DataBind Controls to Azure DevOps Data in Delphi
DataBind to Azure DevOps data in Delphi with standard data access components and controls.
-
Connect to Guru Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Guru data from Filemaker Pro on Mac.
-
Manage Couchbase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Couchbase.
-
Integrate Bugsnag Data in the Pentaho Report Designer
Publish reports based on Bugsnag data in the Pentaho BI tool.
-
Process & Analyze Guru Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Guru Data.
-
Use Claude to Talk to Your SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SAS xpt data for you.
-
Design BIRT Reports on PayPal Data
Provide current PayPal data to your embedded analytics.
-
Building Dynamic Web Pages with ShipStation Data Using AngularJS
Create single-page applications with live connectivity to ShipStation using the CData API Server.
-
Automated Continuous Adobe Analytics Replication to MySQL
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to MySQL.
-
Integrating LangChain with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Power BI XMLA data within automated workflows.
-
Consume Zoho Inventory OData Feeds in PowerBuilder
This article demonstrates how to consume Zoho Inventory data as OData feeds from PowerBuilder using the API Server.
-
Replicate Bannerbear Data to Multiple Databases via the CData Sync CLI
Replicate Bannerbear data to disparate databases with a single configuration.
-
Rapidly Develop Zuora-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Zuora.
-
Connect to SAP Business Warehouse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP Business Warehouse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Create Data Visualizations in Cognos BI with FormSite Data
Access FormSite data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Boomi Agentstudio with Google Drive Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Drive data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Voice Agents in ElevenLabs with access to Live SparkPost Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SparkPost data.
-
Import and Visualize Webflow Data in Power View
Create data visualizations based on Webflow data in Excel.
-
Connect to Freshservice Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshservice data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot with RSS feeds 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.
-
Getting Started with the CData SSIS Components for DB2
Complete guide to installing, licensing, and connecting with the CData SSIS Components for DB2.
-
Connect to AgileCRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time AgileCRM data using standard SQL.
-
Access Hubstaff Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Hubstaff data from HeidiSQL.
-
Bridge Google Translate Connectivity with Apache NiFi
Access and process Google Translate data in Apache NiFi using the CData JDBC Driver.
-
Integrate with GetResponse Data in SnapLogic
Use CData Connect AI to connect to and integrate with live GetResponse data in SnapLogic.
-
Process & Analyze Salesforce Marketing Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Salesforce Marketing Data.
-
Use Agno to Talk to Your PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your PolarTeamPro data for you.
-
Moving Data from Marketo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Marketo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with SAP SuccessFactors LMS Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAP SuccessFactors LMS data to a JSON file on disk.
-
Connect to Browserless from Asprova with CData Software ODBC Driver for Browserless
This article shows how to connect faster to Browserless data from Asprova.
-
Connect to Basecamp Data in NetBeans
Connect to Basecamp data in NetBeans with the data source configuration wizard.
-
Moving Data from Twitter Ads to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Twitter Ads data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Microsoft Teams-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Teams data.
-
Query Tavily Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Tavily data from Node.js.
-
Bind Live ServiceNow Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ServiceNow data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Work with Rebilly Data in FoxPro
Load Rebilly data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Avaza-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Avaza data.
-
Connect to Highrise from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Highrise data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Paylocity Data in CloverDX (formerly CloverETL)
Transfer Paylocity data using the visual workflow in the CloverDX data integration tool.
-
Manage Gumroad Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Gumroad.
-
How to Query Live Harvest Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Harvest data data in natural language using Python.
-
Connect to ActiveCampaign Data in NetBeans
Connect to ActiveCampaign data in NetBeans with the data source configuration wizard.
-
Integrating Antigravity CLI with Reckon Accounts Hosted data via CData CLI
Connect Reckon Accounts Hosted data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create a Data Access Object for Jumpseller Data using JDBI
A brief overview of creating a SQL Object API for Jumpseller data in JDBI.
-
Integrate ZohoDesk Data into Power Automate Desktop using CData Connect
CData Connect for ZohoDesk Data enables you to integrate ZohoDesk data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous SparkPost Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SparkPost replication to Google Cloud SQL.
-
Publish Trello-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Trello data.
-
Automated Continuous Copper Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Copper replication to delimited files (CSV/TSV).
-
Automated Continuous Pushbullet Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pushbullet replication to Apache Cassandra.
-
Connect to SendPulse Data from a Connection Pool in JBoss
Integrate SendPulse data into Java servlets: Use the Management Console in JBoss to install the SendPulse JDBC Driver.
-
Access Live Auth0 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Auth0 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Freshdesk Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshdesk data. Leverage the pyodbc module for ODBC in Python.
-
Use Dash to Build to Web Apps on Microsoft Dataverse Data
Create Python applications that use pandas and Dash to build Microsoft Dataverse-connected web apps.
-
Connect to Moosend Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Moosend data using standard SQL.
-
Use the CData ODBC Driver for Pinecone in Microsoft Power Query
You can use the CData Pinecone ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pinecone data into Microsoft Power Query.
-
Connect EmailOctopus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect EmailOctopus with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SAP Hybris C4C Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to delimited files (CSV/TSV).
-
Configure the CData JDBC Driver for Outlook in a Connection Pool in Tomcat
Connect to Outlook data from a connection pool in Tomcat.
-
Use the CData Software ODBC Driver for Authorize.Net in MicroStrategy Desktop
Connect to Authorize.Net data in MicroStrategy Desktop using the CData Software ODBC Driver for Authorize.Net.