CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Oracle HCM Cloud Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to AlloyDB.
-
Integrate Real-Time Access to MySQL in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MySQL in real time.
-
Getting Started with the CData ODBC Driver for Teamgate
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamgate.
-
How to connect PolyBase to Office 365
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Office 365.
-
Zoho CRM Reporting in OBIEE with the Zoho CRM JDBC Driver
Deploy the Zoho CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Adobe Commerce
Provide connectivity to Adobe Commerce through an SAP BusinessObjects universe.
-
Explore Geographical Relationships in Pushbullet Data with Power Map
Create data visualizations with Pushbullet in Power Map.
-
Natively Connect to Certinia Data in PHP
The CData ODBC driver for Certinia enables you to create PHP applications with connectivity to Certinia. Leverage the native support for ODBC in PHP.
-
Visualize Couchbase Data in TIBCO Spotfire through ADO.NET
Integrate Couchbase into dashboards in TIBCO Spotfire.
-
How to import SAS Data Sets Data into Apache Solr
Use the CData Software JDBC Driver for SAS Data Sets in Data Import Handler and create an automated import of SAS Data Sets to Apache Solr Enterprise Search platform.
-
Publish Reports with Planio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Planio.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy Web
Connect to GitHub in MicroStrategy Web using the CData Software ODBC Driver for GitHub.
-
Prepare, Blend, and Analyze Figshare Data in Alteryx Designer (ODBC)
Build workflows to access live Figshare for self-service data analytics.
-
How to import Salesforce Data 360 Data into Apache Solr
Use the CData Software JDBC Driver for Salesforce Data 360 in Data Import Handler and create an automated import of Salesforce Data 360 to Apache Solr Enterprise Search platform.
-
Connect to ZohoMarketingHub Data in RapidMiner
Integrate ZohoMarketingHub with standard components and data source configuration wizards in RapidMiner Studio.
-
Import Real-Time Discourse Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Discourse in ColdFusion.
-
Connect to Live Azure Table Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Table Data in CData Connect AI and connect to your Azure Table Storage from MicroStrategy.
-
Make API Requests with a Custom Shopify Admin API Token Using the CData Shopify Driver
Make secure API requests to Shopify using a custom Admin API access token with the CData Shopify JDBC Driver for seamless integration.
-
Build Voice Agents in ElevenLabs with access to Live IBM Cloud Object Storage Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live IBM Cloud Object Storage.
-
How to create an RPA flow for ZohoInvoice Data in UiPath Studio
Use the ZohoInvoice ODBC Driver to create workflows that access real-time ZohoInvoice without any coding.
-
Query Recurly Data in DataGrip
Create a Data Source for Recurly in DataGrip and use SQL to query live Recurly.
-
Connect to Sybase Data in JRuby
Create a simple JRuby app with access to live Sybase.
-
Facebook Ads Reporting in OBIEE with the Facebook Ads JDBC Driver
Deploy the Facebook Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Instagram using the Model Context Protocol.
-
Integrate Open WebUI with Live Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Act CRM from within the chat interface.
-
Validate ShipEngine Data with QuerySurge
Access and validate ShipEngine in QuerySurge using the CData JDBC Driver.
-
Replicate Clari Data to Multiple Databases
Replicate Clari to disparate databases with a point-and-click configuration.
-
Automated Continuous Cloudflare Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Cloudflare replication to PostgreSQL.
-
Import and Visualize Todoist Data in Power View
Create data visualizations based on Todoist in Excel.
-
Provide OData Services of ElevenLabs Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ElevenLabs by developing a WCF Service Application.
-
Deploy the ADO.NET Provider for Codat on an SSRS Report Server
Connect to Codat 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.
-
Access Sugar CRM Data from MySQL in Amazon QuickSight
Connect to Sugar CRM and build visualizations of Sugar CRM using a MySQL Connection in Amazon QuickSight.
-
Use Manus AI to Talk to Your MarkLogic 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 MarkLogic.
-
Connect to Google Tasks Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Tasks as an External Source in Dremio.
-
Access Eventbrite Data from MySQL in Amazon QuickSight
Connect to Eventbrite and build visualizations of Eventbrite using a MySQL Connection in Amazon QuickSight.
-
Connect to Acumatica Data in DBArtisan
Use wizards in DBArtisan to configure Acumatica ERP as a data source.
-
Use Microsoft Copilot Studio to talk to your Sugar CRM 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 Sugar CRM for you.
-
Analyze Vimeo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Vimeo with the CData JDBC Driver for Vimeo.
-
Build Visualizations of OData Services in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of OData in Birst.
-
Prepare, Blend, and Analyze Sugar CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Sugar CRM for self-service data analytics.
-
Integrating Claude Code CLI with Invoiced 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 Salesloft-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesloft to explore live Salesloft Data in Cursor to assist with building Salesloft-powered applications.
-
Connect to JDBC-ODBC Bridge Data from PowerBuilder via JDBC
This article demonstrates how to access JDBC-ODBC Bridge from PowerBuilder using the JDBC-ODBC Bridge JDBC Driver.
-
Enable the SAP SuccessFactors JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP SuccessFactors.
-
Automated Continuous SAP HANA Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP HANA replication to AlloyDB.
-
Connect to Codat from Asprova with CData Software ODBC Driver for Codat
This article shows how to connect faster to Codat data from Asprova.
-
Paddle Reporting in OBIEE with the Paddle JDBC Driver
Deploy the Paddle JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build GitLab-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live GitLab.
-
Process & Analyze PDFMonkey Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PDFMonkey Data.
-
Integrating Claude Code with DB2 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on IBM DB2 within assisted coding and automated development workflows.
-
Query MYOB AccountRight Data from Node.js
Use the OData endpoint of the CData API Server to connect to your MYOB AccountRight and perform CRUD operations on MYOB AccountRight from Node.js.
-
Analyze Demio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Demio in Microsoft R Open.
-
Integrating OpenCode Terminal with Aha! 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.
-
Create Datasets from Oracle SCM in Domo Workbench and Build Visualizations of Oracle SCM Data in Domo
Use the CData Software ODBC Driver for Oracle SCM to create datasets from Oracle SCM in Domo Workbench and then build visualizations in the Domo service.
-
Rapidly Develop Splunk-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 Splunk.
-
Analyze Microsoft Exchange Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Microsoft Exchange in Microsoft R Open.
-
Connect to Oracle Financials Cloud Data in ACL Analytics
Connect to Oracle Financials Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Financials Cloud.
-
A PostgreSQL Interface for Klipfolio Data using the CData ODBC Driver
Use the SQL Gateway and Klipfolio ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access Mixpanel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mixpanel.
-
Connect to Workable Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Workable.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for OneNote
Provide connectivity to Microsoft OneNote through an SAP BusinessObjects universe.
-
How to Build an ETL App for Google Directory Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Directory in Python with petl and the CData Connect AI Python SDK.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Dataverse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Dataverse (CDS) to SQL Server.
-
Write a Simple Go Application to work with LightSpeedRetail Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LightSpeedRetail.
-
Stream Trello Data into Apache Kafka Topics
Access and stream Trello in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to and Query Jodoo Data in QlikView over ODBC
Create data visualizations with Jodoo in QlikView.
-
Connect to Campaigner Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Campaigner and work with Campaigner in your FileMaker applications.
-
Integrating LangGraph with Sybase IQ Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Sybase IQ within automated workflows.
-
Access Shopify Data from MySQL in Amazon QuickSight
Connect to Shopify and build visualizations of Shopify using a MySQL Connection in Amazon QuickSight.
-
Analyze Reckon Accounts Hosted Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Reckon Accounts Hosted and visualize live Reckon Accounts Hosted in Infragistics Reveal.
-
How to Seamlessly Import MailerSend Data into IBM SPSS Modeler
Integrate MailerSend data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Google Calendar Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Calendar using standard SQL.
-
Query Snowflake Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Snowflake from Node.js.
-
Connect to Printful in SpagoBI
Create reports featuring live Printful in SpagoBI Studio. Host Printful reports on SpagoBI Server.
-
Getting Started with the CData JDBC Driver for GitHub
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for GitHub.
-
Natively Connect to Google Contacts Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Contacts. Leverage the native support for ODBC in PHP.
-
Automated Continuous SAP Ariba Procurement Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to OneLake in Microsoft Fabric.
-
Query Hugging Face Data as a MySQL Database in Node.js
Execute MySQL queries against Hugging Face from Node.js.
-
Use the CData Software ODBC Driver for Cloudant in MicroStrategy Desktop
Connect to IBM Cloudant in MicroStrategy Desktop using the CData Software ODBC Driver for Cloudant.
-
Connect to Azure Table 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 Azure Table Storage.
-
How to Access Live Tickspot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tickspot enables you to integrate Tickspot into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code with GitLab Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on GitLab within assisted coding and automated development workflows.
-
Create Redis Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Redis data access from reports, embedded analytics, and more.
-
How to Connect to Live Adobe Analytics 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 Adobe Analytics for you.
-
Automate Mouseflow Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mouseflow from PowerShell? This article demonstrates how to utilize the Mouseflow Cmdlets for tasks like connecting to Mouseflow, automating operations, downloading data, and more.
-
Automated Continuous Adobe Target Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Adobe Target replication to Google BigQuery.
-
Connect to Elasticsearch Data in JRuby
Create a simple JRuby app with access to live Elasticsearch.
-
Operational Reporting on Hacker News Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Hacker News.
-
Use the CData Software JDBC Driver for ElevenLabs in MicroStrategy
Connect to ElevenLabs in MicroStrategy Developer using the CData Software JDBC Driver for ElevenLabs.
-
Visualize Unbounce Data in Sisense
Create an ElastiCube in Sisense app with access to Unbounce.
-
Validate HBase Data with QuerySurge
Access and validate Apache HBase in QuerySurge using the CData JDBC Driver.
-
How to import Asana Data into Apache Solr
Use the CData Software JDBC Driver for Asana in Data Import Handler and create an automated import of Asana to Apache Solr Enterprise Search platform.
-
Use Microsoft Copilot Studio to talk to your eBay 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 eBay for you.
-
Load Google Contacts Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Contacts to a database.
-
How to Connect DB2 Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live DB2 data in real time using natural language.
-
Use the CData Software JDBC Driver for Drift in MicroStrategy Desktop
Connect to Drift in MicroStrategy Desktop using the CData Software JDBC Driver for Drift.
-
How to Connect to & Open Microsoft Teams Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Teams to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Dashboards with CSV Data in DBxtra
Create dynamic dashboards and perform analytics based on CSV/TSV Files in DBxtra.
-
Build Dashboards with Freshservice Data in DBxtra
Create dynamic dashboards and perform analytics based on Freshservice in DBxtra.
-
Migrating data from Printful to Snowflake using CData SSIS Components.
Easily push Printful to Snowflake using the CData SSIS Tasks for Printful and Snowflake.