CData Software - Knowledge Base
Recent Articles
-
How to connect to SingleStore Data with Squirrel SQL client
Connect to SingleStore data and execute queries in the Squirrel SQL Client.
-
Publish Salesloft-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Salesloft data.
-
Publish Nethunt-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Nethunt data.
-
Oracle Sales Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Sales facts in real time.
-
Integrate with Pushbullet Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Pushbullet data to a JSON file on disk.
-
Connect to Splunk from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Splunk data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate Theia IDE with Live HCL Domino 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 HCL Domino data from within the development environment.
-
Access OData Services from MySQL in PHP
Connect to OData through the standard MySQL libraries in PHP.
-
Choosing the Best Method to Connect SurveyMonkey to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SurveyMonkey data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Live MarkLogic Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MarkLogic data into custom reports in Power BI.
-
Connect to SendPulse Data from AWS Glue
Use CData Connect AI to gain access to live SendPulse data from your AWS Glue jobs.
-
Establish a Live Connection with Paddle Data using Tableau Bridge
The CData ODBC Driver for Paddle enables you to integrate live Paddle data into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Outlook Replication to Snowflake
Use CData Sync for automated, continuous, customizable Outlook replication to Snowflake.
-
Build Automated Kintone-Connected Workflows in Zapier
Use CData Connect AI to connect to live Kintone data and build automated workflows in Zapier.
-
Connect to Sybase Data from PowerBuilder via JDBC
This article demonstrates how to access Sybase data from PowerBuilder using the Sybase JDBC Driver.
-
DataBind Controls to Sybase IQ Data in C++Builder
DataBind to Sybase IQ data in C++Builder with standard components and controls.
-
Integrating Boomi Agentstudio with Google Ad Manager Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Google Ad Manager data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Xero Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Xero replication to Amazon Redshift.
-
Rapidly Develop Deel-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 Deel.
-
Creating Azure Synapse-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Synapse data to Unqork and build custom business apps.
-
Integrate Open WebUI with Live Zoho Creator Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zoho Creator data from within the chat interface.
-
How to import BambooHR Data into Apache Solr
Use the CData Software JDBC Driver for BambooHR in Data Import Handler and create an automated import of BambooHR data to Apache Solr Enterprise Search platform.
-
Seamlessly Bring Excel Online Data into Retool Using CData Connect AI
Integrate Excel Online data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Import Real-Time QuickBooks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use QuickBooks data in ColdFusion.
-
Integrate HelloSign with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate HelloSign with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to HelloSign data.
-
Operational Reporting on Vimeo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vimeo data.
-
DataBind Controls to Kintone Data in C++Builder
DataBind to Kintone data in C++Builder with standard components and controls.
-
Create Spark-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Spark Data from Klipfolio and build custom visualizations using live Spark data.
-
How to connect to Google Tasks Data with Squirrel SQL client
Connect to Google Tasks data and execute queries in the Squirrel SQL Client.
-
Connect to Azure Analysis Services from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Analysis Services data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Samanage Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Samanage and the SQL Gateway to access Samanage data from Google Apps Script.
-
Interact with Live Oracle Sales Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle Sales data.
-
How to Connect DBeaver to Drip via a JDBC Driver
Manage Drip data with visual tools in DBeaver like the query browser.
-
How to connect PolyBase to Zoho Projects
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Projects data.
-
Automated Continuous Chargebee Replication to MongoDB
Use CData Sync for automated, continuous, customizable Chargebee replication to MongoDB.
-
Use the CData ODBC Driver for Freshservice in Microsoft Power Query
You can use the CData Freshservice ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Freshservice data into Microsoft Power Query.
-
Connect to Splunk Data from HeidiSQL
Use CData Connect AI to connect to and query live Splunk data from HeidiSQL.
-
Integrate Goose with Live Databricks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Databricks data from within the local AI agent.
-
Connect to HDFS Data from PowerBuilder via ADO.NET
This article demonstrates how to access HDFS data from Appeon PowerBuilder using the CData ADO.NET Provider for HDFS.
-
Integrate with LDAP Objects using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LDAP objects to a JSON file on disk.
-
Query Sage 300 Data in DataGrip
Create a Data Source for Sage 300 in DataGrip and use SQL to query live Sage 300 data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sybase
Provide connectivity to Sybase data through an SAP BusinessObjects universe.
-
Automate Dynamics 365 Business Central Data Replication to Azure Data Lake
Use CData Sync to customize and automate Dynamics 365 Business Central data replication to Azure Data Lake.
-
Build a Singer.io Tap for Missive With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Missive data using the CData Python Connector.
-
Automated Continuous Harvest Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Harvest replication to Apache Cassandra.
-
Build AI/ML Models with Live Odoo Data using Dataiku
Connect Odoo Data with Dataiku using the CData JDBC Driver for Odoo.
-
Work with Live Pinterest Data in Power Query
Use CData Connect AI to connect to Pinterest data and work with live Pinterest data in Microsoft Power Query.
-
Build an OLAP Cube in SSAS from Klaviyo Data
Establish a connection to Klaviyo data data from SQL Server Analysis Services, and use the Klaviyo Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Snapchat Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Snapchat Ads data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Snapchat Ads.
-
Access Live Couchbase 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 Couchbase data through MCP integration.
-
View Reports on Real-Time OneNote Data in Power BI Report Server
Use the CData ODBC Driver for OneNote to visualize OneNote data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Aweber Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Aweber data securely in real time.
-
Rapidly Develop Attio-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 Attio.
-
How to connect and process Smartsheet data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Smartsheet data.
-
Getting Started with the CData Python Connector for QuickBooks Time
Learn to install and license the CData Python Connector and configure a connection to live QuickBooks Time data.
-
Connect to Highrise Data from a Connection Pool in JBoss
Integrate Highrise data into Java servlets: Use the Management Console in JBoss to install the Highrise JDBC Driver.
-
How to connect SharePoint with Bullhorn CRM Data through external lists
Provide Bullhorn CRM data to SharePoint users as an external list.
-
How to load Miro data into Elasticsearch via Logstash
Introducing a simple method to load Miro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Mailjet Data from HeidiSQL
Use CData Connect AI to connect to and query live Mailjet data from HeidiSQL.
-
Connect to Live Paylocity Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Paylocity in CData Connect AI and connect to your Paylocity data from PostgreSQL.
-
Build a PostgreSQL Interface for BenchmarkEmail Data using the CData JDBC Driver
Use the Remoting features of the BenchmarkEmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Search External Cloudflare Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Cloudflare data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cloudflare Data objects that you can access from apps and the dashboard.
-
Use Azure AI Foundry to Talk to Your Optimizely 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 Optimizely data for you.
-
Connect to Sendwithus Data in DBArtisan
Use wizards in DBArtisan to configure Sendwithus data as a data source.
-
Connect to Salesforce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Salesforce data in the Denodo Virtual DataPort Administrator.
-
Connect to Landbot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Landbot.
-
Getting Started with the CData Tableau Connector for Google Calendar
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Calendar.
-
Connect to Odoo Data in HULFT Integrate
Connect to Odoo as a JDBC data source in HULFT Integrate
-
Use Dash to Build Web Apps on CSV Data via CData Connect AI
Build interactive Dash web apps on live CSV data using pandas and the CData Connect AI Python SDK.
-
Getting Started with the CData ADO.NET Provider for Bugsnag
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
eBay Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to eBay Analytics data through CData Connect AI using different applications and tools.
-
Getting Started with the CData Excel Add-In for GitLab
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitLab.
-
How to Connect Flowise AI Agents to Live Vault CRM 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 Vault CRM data without replication.
-
How to Visualize YouTube Analytics Data in Python with pandas
Use pandas and other modules to analyze and visualize live YouTube Analytics data in Python.
-
Visualize Toggl Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Toggl data into TIBCO Spotfire.
-
Build ZohoDesk-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live ZohoDesk data.
-
How to Visualize Outlook Data in Python with pandas
Use pandas and other modules to analyze and visualize live Outlook data in Python.
-
Build Dashboards with FHIR Data in Dundas BI
Create dynamic dashboards and perform analytics based on FHIR data in Dundas BI.
-
Analyze Live Zuora Data in SAS Viya
Use CData Connect AI to connect to Zuora data from SAS Viya and deploy self-service analytics using live Zuora data.
-
Access Dynamics NAV Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Dynamics NAV data.
-
Use Microsoft Copilot Studio to talk to your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data for you.
-
Connect to Google Ad Manager Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Ad Manager and the Script function in FileMaker Pro to connect to Google Ad Manager and work with Google Ad Manager data in your FileMaker application.
-
Integrate AgileCRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AgileCRM with External Services.
-
Query ShipStation Data in DataGrip
Create a Data Source for ShipStation in DataGrip and use SQL to query live ShipStation data.
-
Use Grok to Talk to Your QuickBooks Online 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 QuickBooks Online data for you.
-
Use Grok to Talk to Your Raisers Edge NXT 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 Raisers Edge NXT data for you.
-
Access Live Couchbase Data in Coginiti Pro
Connect to and query live Couchbase data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Guru Data from HeidiSQL
Use CData Connect AI to connect to and query live Guru data from HeidiSQL.
-
Query MailerLite Data as a MySQL Database in Node.js
Execute MySQL queries against MailerLite data from Node.js.
-
Import Real-Time Keap Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Keap data in ColdFusion.
-
Build Webex-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Webex data.
-
Connect to HubSpot Data from PowerBuilder via ADO.NET
This article demonstrates how to access HubSpot data from Appeon PowerBuilder using the CData ADO.NET Provider for HubSpot.
-
Creating Aweber-Connected Applications in Unqork
You can use CData Connect AI to feed Aweber data to Unqork and build custom business apps.
-
Integrate Google Ads Data into Power Automate Desktop using CData Connect
CData Connect for Google Ads Data enables you to integrate Google Ads data into workflows built using Microsoft Power Automate Desktop.
-
Connect to SAP Fieldglass Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP Fieldglass Data and connect to SAP Fieldglass data in Akorbi Digital RunMyProcess.
-
Creating Salesforce Marketing-Connected Applications in Unqork
You can use CData Connect AI to feed Salesforce Marketing data to Unqork and build custom business apps.
-
Create Bitbucket-Connected Nintex Workflows
Use CData Connect AI to connect to Bitbucket Data from Nintex Workflow Cloud and build custom workflows using live Bitbucket data.
-
Replicate Kintone Data to Multiple Databases via the CData Sync CLI
Replicate Kintone data to disparate databases with a single configuration.
-
Connect to Oracle HCM Cloud 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 Oracle HCM Cloud data.
-
How to Connect to Live Guru 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 Guru data without replication.