CData Software - Knowledge Base
Recent Articles
-
Connect to Spark Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Spark SQL from Filemaker Pro on Mac.
-
How to Connect the Power BI Service to Square: Complete Guide
Connect to the CData Software Power BI Connector for Square from PowerBI.com to provide real-time Square across the organization.
-
Integrating OpenCode Terminal with LDAP Objects 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.
-
Replicate Oracle Financials Cloud Data in Heroku for Use in Salesforce Connect
Replicate Oracle Financials Cloud to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Sugar CRM Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Snowflake.
-
Automated Continuous Adobe Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to SingleStore.
-
Provide OData Services of LightSpeedRetail Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for LightSpeedRetail by developing a WCF Service Application.
-
How to Connect to Live ShipStation 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 ShipStation for you.
-
Connect to JobNimbus Data from a Connection Pool in JBoss
Integrate JobNimbus into Java servlets: Use the Management Console in JBoss to install the JobNimbus JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Spanner
Create an ODBC connection to Google Spanner in Informatica and browse and transfer Google Spanner.
-
Establish a Live Connection with SAP SuccessFactors LMS Data using Tableau Bridge
The CData ODBC Driver for SAP SuccessFactors LMS enables you to integrate live SAP SuccessFactors LMS into Tableau Cloud dashboards using the Tableau Bridge.
-
Use CData Connect AI to Access LinkedIn Ads Data in Microsoft Power Pivot
Use CData Connect AI to connect to live LinkedIn Ads in the Power Pivot business intelligence tool.
-
How to connect and process Deel from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Deel.
-
Analyze Phoenix Data in Looker
Use CData Connect AI to connect to Phoenix Data from Looker and build custom apps using live Apache Phoenix.
-
Create Dynamic Microsoft Ads Grids Using the Infragistics XamDataGrid
Learn how you can connect Microsoft Ads to Infragistics XamDataGrid to build dynamic grids.
-
Getting Started with the CData Python Connector for Auth0
Learn to install and license the CData Python Connector
-
Visualize Live LinkedIn Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LinkedIn using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect SharePoint with MailChimp Data through external lists
Provide MailChimp to SharePoint users as an external list.
-
Automate Oracle Sales Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle Sales replication to Couchbase.
-
Create Informatica Mappings From/To a JDBC Data Source for ChargeOver
Create ChargeOver data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Live QuickBooks Online 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 QuickBooks Online directly from the development environment.
-
Build a Singer.io Tap for Amazon DynamoDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon DynamoDB data using
-
Connect to Salesforce CRM Analytics Data in ACL Analytics
Connect to Salesforce CRM Analytics via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce CRM Analytics.
-
Connect to FTP Data from HeidiSQL
Use CData Connect AI to connect to and query live FTP Servers from HeidiSQL.
-
Getting Started with the CData Python Connector for Nethunt
Learn to install and license the CData Python Connector
-
How to Query Live Azure Analysis Services Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Azure Analysis Services data in natural language using Python.
-
Access Live Azure Table 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 Azure Table Storage through MCP integration.
-
Connect to Apify Data in HULFT Integrate
Connect to Apify as a JDBC data source in HULFT Integrate
-
Use Claude to Talk to Your Greenplum 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 Pivotal GreenPlum for you.
-
How to Connect to Live Google Ads Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Ads without replication.
-
Build Apps with Live Amazon Athena in Adalo using CData Connect AI
Use CData Connect AI to integrate live Amazon Athena into the Adalo platform and build custom mobile and web applications with real-time Amazon Athena.
-
Visualize Wave Financial Data in TIBCO Spotfire through OData
Integrate Wave Financial into dashboards in TIBCO Spotfire.
-
Replicate Instagram Data to Multiple Databases via the CData Sync CLI
Replicate Instagram to disparate databases with a single configuration.
-
Connect to Reckon Accounts Hosted Data in DBArtisan
Use wizards in DBArtisan to configure Reckon Accounts Hosted as a data source.
-
Connect to Twilio Data from HeidiSQL
Use CData Connect AI to connect to and query live Twilio from HeidiSQL.
-
Build AI/ML Models with Live Copper Data using Dataiku
Connect Copper Data with Dataiku using the CData API Driver for JDBC.
-
Create Google Contacts-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Contacts Data from Klipfolio and build custom visualizations using live Google Contacts.
-
Migrating data from Dropbox to Snowflake using CData SSIS Components.
Easily push Dropbox to Snowflake using the CData SSIS Tasks for Dropbox and Snowflake.
-
Model Monday.com Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Monday.com, enabling the direct import of real-time Monday.com.
-
Query PDFMonkey Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PDFMonkey entities in PHP by modeling them as objects.
-
Build Voice Agents in ElevenLabs with access to Live Adobe Analytics Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Adobe Analytics.
-
Build VWO-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live VWO Data in Gemini Code Assist to assist with building VWO-powered applications.
-
Connect to Moosend Data in DBeaver
Use the CData ODBC Driver to connect to Moosend in DBeaver.
-
Connect and Visualize Live MYOB AccountRight Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MYOB AccountRight into the Databricks platform and create visualization dashboards with real-time MYOB AccountRight.
-
Connect to Typeform Data in RapidMiner
Integrate Typeform with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Stack Exchange Data in ColdFusion
Write standard ColdFusion data access code to connect to Stack Exchange.
-
Automated Continuous Teradata Replication to Snowflake
Use CData Sync for automated, continuous, customizable Teradata replication to Snowflake.
-
LINQ to Retently 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 Retently Data Provider.
-
Create Datasets from Tickspot in Domo Workbench and Build Visualizations of Tickspot Data in Domo
Use the CData Software ODBC Driver for Tickspot to create datasets from Tickspot in Domo Workbench and then build visualizations in the Domo service.
-
Easily Integrate HelloSign Data in Lazarus Pascal IDE
Learn how to easily integrate live HelloSign in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Power BI XMLA Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Power BI XMLA data access from reports, embedded analytics, and more.
-
Visualize Live FTP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FTP Servers using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect Flowise AI Agents to Live SAP ByDesign 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 SAP Business ByDesign without replication.
-
Automated MessageBird Data Replication to Teradata
Use CData Sync to Customize and automate MessageBird replication to Teradata.
-
Build Azure DevOps-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure DevOps and build Azure DevOps-connected web apps with Axios.
-
Connect to Pipeline CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pipeline CRM to connect to Pipeline CRM and execute queries in PowerBuilder.
-
Use JayDeBeApi to access Anaplan Data in Python
Use standard Python scripting and the development environment of your choice to access live Anaplan.
-
How to Access Live HubSpot Data in Power Automate Desktop via ODBC
The CData ODBC Driver for HubSpot enables you to integrate HubSpot into workflows built using Microsoft Power Automate Desktop.
-
How to use SQLAlchemy ORM to access Anaplan Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Anaplan.
-
Integrating Apollo Data in Talend Cloud Data Management Platform
Connect Apollo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Operational Reporting on ElevenLabs Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ElevenLabs.
-
Connect to and Query Redis Data in QlikView over ODBC
Create data visualizations with Redis in QlikView.
-
Build MVC Applications with Connectivity to Trello Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Trello from an ASP.NET MVC application.
-
Integrating Dataiku with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Books.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy
Connect to Apache CouchDB in MicroStrategy Developer using the CData Software JDBC Driver for CouchDB.
-
Build Apps with Live Grafana Data Using the Low-Code Development Platform of Mendix
Connect Grafana with Mendix to build apps using the CData API Driver for JDBC.
-
Build Dashboards with Placid Data in DBxtra
Create dynamic dashboards and perform analytics based on Placid in DBxtra.
-
Build FreshBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FreshBooks and build visualizations in Tableau Cloud.
-
Replicate Sybase Data to Multiple Databases
Replicate Sybase to disparate databases with a point-and-click configuration.
-
Analyze Adobe Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Analytics and visualize live Adobe Analytics in Infragistics Reveal.
-
Integrate Real-Time Access to Hive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Hive in real time.
-
Automated Continuous QuickBooks Online Replication to Oracle
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Oracle.
-
Replicate CouchDB Data to Multiple Databases via the CData Sync CLI
Replicate Apache CouchDB to disparate databases with a single configuration.
-
Bridge NASA Connectivity with Apache NiFi
Access and process NASA in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Printful in MicroStrategy Desktop
Connect to Printful in MicroStrategy Desktop using the CData Software ODBC Driver for Printful.
-
Analyze Salesforce Pardot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Pardot with the CData JDBC Driver for Salesforce Pardot.
-
Analyze Amazon DynamoDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon DynamoDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Real-Time Egnyte Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Egnyte in Power Apps.
-
Connect to Billsby Data in RazorSQL
Connect to Billsby from wizards and query Billsby from the GUI in the RazorSQL database management tool.
-
How to connect PolyBase to MySQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MySQL.
-
Integrate with Quickbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Quickbase to a JSON file on disk.
-
Automate Codat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Codat from PowerShell? This article demonstrates how to utilize the Codat Cmdlets for tasks like connecting to Codat, automating operations, downloading data, and more.
-
Rapidly Develop Sybase-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 Sybase.
-
Enable the Microsoft Exchange JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Exchange.
-
Perform Batch Operations with Xero Data in Apache NiFi
Connect to Xero Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating GitHub Copilot CLI with Moosend 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.
-
Access Live Facebook Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Facebook data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Getting Started with the CData Tableau Connector for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft OneDrive.
-
Enable the Teamgate JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teamgate.
-
Integrate Open WebUI with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live LinkedIn from within the chat interface.
-
Build Semantic Layer Views for Azure Table Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Table Storage.
-
Integrate Marketo Data in the Pentaho Report Designer
Publish reports based on Marketo in the Pentaho BI tool.
-
Access FTP Data from MySQL in PHP
Connect to FTP through the standard MySQL libraries in PHP.
-
Integrate Live Sage Cloud Accounting Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Replicate SAP Ariba Procurement Data in Heroku for Use in Salesforce Connect
Replicate SAP Ariba Procurement to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Apify Data in Ruby
Connect to Apify in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build ServiceNow-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ServiceNow Data and create custom apps in Mendix.
-
Publish LionDesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LionDesk.
-
Enable the OnePageCrm JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OnePageCrm.
-
Automated Twitter Ads Data Replication to Teradata
Use CData Sync to Customize and automate Twitter Ads replication to Teradata.