CData Software - Knowledge Base
Recent Articles
-
Integrate with Planio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Planio data to a JSON file on disk.
-
Connect to PabblySubscriptions Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PabblySubscriptions data in the Denodo Virtual DataPort Administrator.
-
Integrate with Live MySQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MySQL from the MuleSoft Anypoint Platform to integrate live MySQL data into custom reports and dashboards.
-
Query Google Contacts Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Contacts data from Node.js.
-
Integrate Live SAP SuccessFactors LMS Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP SuccessFactors LMS data to Blue Prism using the CData ODBC Driver for SAP SuccessFactors LMS to create automated workflows for repetitive business tasks.
-
Build Wistia-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Wistia Data and create custom apps in Mendix.
-
Building Dynamic Web Pages with PayPal Data Using AngularJS
Create single-page applications with live connectivity to PayPal using the CData API Server.
-
Build a Singer.io Tap for SAP Netweaver Gateway With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Netweaver Gateway data using the CData Python Connector.
-
Access Live Spark Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Spark data from your Excel spreadsheets.
-
Deploy the ADO.NET Provider for BenchmarkEmail on an SSRS Report Server
Connect to BenchmarkEmail data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate GraphQL with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate GraphQL with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to GraphQL data.
-
Build a Singer.io Tap for Avaza With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Avaza data using the CData Python Connector.
-
How to Visualize SingleStore Data in Python with pandas
Use pandas and other modules to analyze and visualize live SingleStore data in Python.
-
How to Connect to Live SendPulse 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 SendPulse data for you.
-
Creating Microsoft Entra ID-Connected Applications in Unqork
You can use CData Connect AI to feed Microsoft Entra ID data to Unqork and build custom business apps.
-
How to connect to Supabase Data with Squirrel SQL client
Connect to Supabase data and execute queries in the Squirrel SQL Client.
-
Model, Search, and Visualize Live Redshift Data in ThoughtSpot
Use CData Connect AI to connect to live Redshift data for modeling, searching, and visualizing.
-
Integrate with LinkedIn Data in JReport Designer
Create charts and reports based on LinkedIn data in JReport Designer.
-
Integrating Codex with Google Ad Manager 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 the CData Software JDBC Driver for Vimeo in MicroStrategy Desktop
Connect to Vimeo data in MicroStrategy Desktop using the CData Software JDBC Driver for Vimeo.
-
Seamlessly Bring Google Analytics Data into Retool Using CData Connect AI
Integrate Google Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Redis Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Redis data through MCP integration.
-
Analyze SAP Ariba Source Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP Ariba Source data and visualize SAP Ariba Source data in SAP Analytics Cloud.
-
ETL Sybase IQ in Oracle Data Integrator
This article shows how to transfer Sybase IQ data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Salesforce Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce replication to Amazon Redshift.
-
Automated Continuous Foursquare Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Foursquare replication to Apache Cassandra.
-
Query JDBC-ODBC Bridge Data in ColdFusion
Write standard ColdFusion data access code to connect to JDBC-ODBC Bridge data.
-
Connect to ConstantContact Data in Google Apps Script via Connect AI
Use CData Connect AI to access ConstantContact data in Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Browserless
Provide connectivity to Browserless data through an SAP BusinessObjects universe.
-
Connect to Live Blackbaud FE NXT Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Blackbaud FE NXT in CData Connect AI and connect to your Blackbaud FE NXT data from PostgreSQL.
-
Build Visualizations of SAP Business One Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business One data in Birst.
-
Build an OLAP Cube in SSAS from Clockify Data
Establish a connection to Clockify data data from SQL Server Analysis Services, and use the Clockify Data Provider to build OLAP cubes for use in analytics and reporting.
-
A PostgreSQL Interface for Harvest Data (MySQL Remoting via JDBC)
Use the Remoting features of the Harvest JDBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Snapchat Ads Data with Power Map
Create data visualizations with Snapchat Ads data in Power Map.
-
Getting Started with the CData Connect AI Python SDK for Shippo
Install the CData Connect AI Python SDK to read live Shippo data with standard DB-API 2.0 Python code.
-
How to Use a Microsoft Access Database to Update Zoho CRM Data in Real Time
Update Zoho CRM data by creating a linked table in Microsoft Access with the CData Zoho CRM ODBC Driver.
-
Build Agents in Relevance AI with Access to Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CSV data within intelligent agent workflows.
-
Access EmailOctopus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live EmailOctopus data from HeidiSQL.
-
Create Power BI Reports on Real-Time Airtable Data
Use the CData ODBC Driver for Airtable to visualize Airtable data in Power BI Desktop.
-
Build Voice Agents in ElevenLabs with access to Live Basecamp Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Basecamp data.
-
Using the CData Software ODBC Driver for FormSite in PyCharm
Connect to FormSite as an ODBC data source in PyCharm using the CData Software ODBC Driver for FormSite.
-
Getting Started with the CData Python Connector for Hacker News
Learn to install and license the CData Python Connector and configure a connection to live Hacker News data.
-
How to publish and share Oracle SCM Data dashboards with Tableau Server
The CData ODBC driver for Oracle SCM enables you integrate Oracle SCM data into Tableau dashboards.
-
Query Miro Data in ColdFusion
Write standard ColdFusion data access code to connect to Miro data.
-
Access Google Search Results from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Search results from HeidiSQL.
-
DataBind Controls to Salesforce Data 360 Data in C++Builder
DataBind to Salesforce Data 360 data in C++Builder with standard components and controls.
-
How to Easily Query Microsoft Planner Data in OpenOffice Base
Connect to Microsoft Planner data in OpenOffice Base using the CData ODBC Driver for Microsoft Planner and generate reports with live data insights.
-
How to import Instantly Data into Apache Solr
Use the CData Software JDBC Driver for Instantly in Data Import Handler and create an automated import of Instantly data to Apache Solr Enterprise Search platform.
-
How to Access Live Optimizely Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Optimizely enables you to integrate Optimizely data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot data in MicroStrategy Desktop using the CData Software ODBC Driver for HubSpot.
-
Stream Ontraport Data into Apache Kafka Topics
Access and stream Ontraport data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to use SQLAlchemy ORM to access Moosend Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Moosend data.
-
Analyze Optimizely Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Optimizely from Power Pivot. You will use the Table Import Wizard to load Optimizely data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate MarkLogic with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate MarkLogic with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to MarkLogic data.
-
Automated Continuous ConvertKit Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ConvertKit replication to IBM DB2.
-
Enable the Webex JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Webex data.
-
Visualize Live Freshteam Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Freshteam data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics data without replication.
-
DataBind Controls to Reckon Data in C++Builder
DataBind to Reckon data in C++Builder with standard components and controls.
-
Publish Reports with Highrise Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Highrise data.
-
Stream Raisers Edge NXT Data into Apache Kafka Topics
Access and stream Raisers Edge NXT data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Easily Integrate Freshservice Data in Lazarus Pascal IDE
Learn how to easily integrate live Freshservice data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate JotForm Data Replication to Azure Data Lake
Use CData Sync to customize and automate JotForm data replication to Azure Data Lake.
-
Connect to Kintone Data in HULFT Integrate
Connect to Kintone as a JDBC data source in HULFT Integrate
-
How to publish and share Instantly Data dashboards with Tableau Server
The CData ODBC driver for Instantly enables you integrate Instantly data into Tableau dashboards.
-
Build AI/ML Models with Live Foursquare Data using Dataiku
Connect Foursquare Data with Dataiku using the CData API Driver for JDBC.
-
Build an OLAP Cube in SSAS from Todoist Data
Establish a connection to Todoist data data from SQL Server Analysis Services, and use the Todoist Data Provider to build OLAP cubes for use in analytics and reporting.
-
DataBind Controls to Microsoft Entra ID Data in C++Builder
DataBind to Microsoft Entra ID data in C++Builder with standard components and controls.
-
Building Dynamic Web Pages with Odoo Data Using AngularJS
Create single-page applications with live connectivity to Odoo using the CData API Server.
-
Integrating LlamaIndex with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Marketo data in real time.
-
Access Mouseflow Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Mouseflow data from HeidiSQL.
-
How to create Slack federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Slack data in MySQL .
-
How to connect PolyBase to SAP Fieldglass
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP Fieldglass data.
-
Access Oracle Sales Data from MySQL in Amazon QuickSight
Connect to Oracle Sales and build visualizations of Oracle Sales data using a MySQL Connection in Amazon QuickSight.
-
Build Google Spanner Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Google Spanner data and build visualizations in Tableau.
-
Connect to Autopilot Data from a Connection Pool in JBoss
Integrate Autopilot data into Java servlets: Use the Management Console in JBoss to install the Autopilot JDBC Driver.
-
How to Work with Shortcut Data in ETL Validator JDBC
Connect to Shortcut from ETL Validator jobs using the CData Software JDBC Driver.
-
Explore Geographical Relationships in Brex Data with Power Map
Create data visualizations with Brex data in Power Map.
-
Connect to MessageBird Data in DBArtisan
Use wizards in DBArtisan to configure MessageBird data as a data source.
-
How to Connect to Live DB2 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 DB2 data for you.
-
Build Redshift-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Redshift data and build web apps with connectivity to live Redshift data.
-
Query Live Samanage Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Samanage data directly from the development environment.
-
Integrate Bitly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bitly with External Services.
-
Visualize Live PolarTeamPro Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live PolarTeamPro data into custom reports in Power BI.
-
Connect MailerLite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MailerLite data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Provide OData Services of Rootly Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Rootly data by developing a WCF Service Application.
-
Integrate Highrise with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Highrise with External Services.
-
Integrate TigerGraph Data in the Pentaho Report Designer
Publish reports based on TigerGraph data in the Pentaho BI tool.
-
Create Informatica Mappings From/To an ODBC Data Source for Cvent
Create an ODBC connection to Cvent in Informatica and browse and transfer Cvent data.
-
Connect to Zuora Data from a Connection Pool in Jetty
The Zuora JDBC Driver supports connection pooling: This article shows how to connect faster to Zuora data from Web apps in Jetty.
-
How to load MailChimp data into Elasticsearch via Logstash
Introducing a simple method to load MailChimp data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect Flowise AI Agents to Live Trello 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 Trello data without replication.
-
Analyze GetResponse Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GetResponse data in Microsoft R Open.
-
Query Jumpseller Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Jumpseller data from Node.js.
-
Analyze Lakebase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Lakebase data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to Trello Data in PHP
The CData ODBC driver for Trello enables you to create PHP applications with connectivity to Trello data. Leverage the native support for ODBC in PHP.
-
Connect to Marketo Data in Claris FileMaker Pro
Use the CData ODBC Driver for Marketo in FileMaker Pro to connect to Marketo and work with Marketo data in your FileMaker applications.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ConstantContact
Provide connectivity to ConstantContact data through an SAP BusinessObjects universe.
-
Use JayDeBeApi to access SendPulse Data in Python
Use standard Python scripting and the development environment of your choice to access live SendPulse data.
-
How to import PingOne Data into Apache Solr
Use the CData Software JDBC Driver for PingOne in Data Import Handler and create an automated import of PingOne data to Apache Solr Enterprise Search platform.