CData Software - Knowledge Base
Recent Articles
-
Supporting OAuth for Embedded Use Cases with CData Connectors
How CData connectors support OAuth for embedded use cases, covering grant types, InitiateOAuth, automatic token refresh, the Authorization Code flow for web and desktop applications, and creating a custom OAuth app.
-
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.
-
Visualize ZendeskSell Data in TIBCO Spotfire through ADO.NET
Integrate ZendeskSell data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Elasticsearch Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Elasticsearch data for you.
-
Automated Continuous Miro Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Miro replication to Google Cloud SQL.
-
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.
-
Connect to SurveyMonkey Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SurveyMonkey data from Filemaker Pro on Mac.
-
Automated Continuous Email Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Email data replication to OneLake in Microsoft Fabric.
-
Analyze CouchDB Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CouchDB data with the CData JDBC Driver for CouchDB.
-
Operational Reporting on Vimeo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vimeo data.
-
Automated Continuous ADP Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ADP replication to Amazon Redshift.
-
Connect to Printify Data in Jaspersoft Studio
Execute SQL to remote Printify data in Jaspersoft Studio.
-
Explore Geographical Relationships in Amazon Marketplace Data with Power Map
Create data visualizations with Amazon Marketplace data in Power Map.
-
Visualize Live Coda Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Coda data into custom reports in Power BI.
-
Use the CData Software ODBC Driver for Cloudflare in SAS for Real-Time Reporting and Analytics
Connect to real-time Cloudflare data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cloudflare.
-
Access Live Figshare 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 Figshare data through MCP integration.
-
Viewing Gumroad Data in RAD Studio Data Explorer
How to view Gumroad data in RAD Studio Data Explorer using the CData ODBC Driver for Gumroad.
-
Build Semantic Layer Views for Outreach.io Data in APOS Live Data Gateway
Use the CData Connector for Outreach.io in APOS Live Data Gateway to build Semantic Layer Views for Outreach.io data.
-
Connect to Real-Time ActiveCampaign Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for ActiveCampaign and Dataflow to import and use ActiveCampaign data in Power Apps.
-
Integrate with ZohoMarketingHub Data in JReport Designer
Create charts and reports based on ZohoMarketingHub data in JReport Designer.
-
DataBind Controls to Xero Data in Delphi
DataBind to Xero data in Delphi with standard data access components and controls.
-
Connecting Mastra with Neo4J Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Neo4J data, no replication required.
-
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 Printful from a Connection Pool in WebLogic
Use the CData JDBC Driver for Printful to connect to Printful data from Web applications running on WebLogic.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy
Connect to Aircall data in MicroStrategy Developer using the CData Software JDBC Driver for Aircall.
-
Use the CData ODBC Driver for CloudConvert in Microsoft Power Query
You can use the CData CloudConvert ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import CloudConvert data into Microsoft Power Query.
-
How to connect to Salesforce Data 360 Data in DBVisualizer
Integrate Salesforce Data 360 data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Perigon Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Perigon data from HeidiSQL.
-
Operational Reporting on Sage Intacct Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage Intacct data.
-
Automated Continuous Notion Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Notion replication to IBM DB2.
-
Build AI/ML Models with Live Odoo Data using Dataiku
Connect Odoo Data with Dataiku using the CData JDBC Driver for Odoo.
-
Access Live Zoho Creator Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zoho Creator data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Theia IDE with Live WordPress 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 WordPress data from within the development environment.
-
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 Semantic Layer Views for Salesforce CRM Analytics Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Salesforce CRM Analytics data.
-
How to Connect DBeaver to Exact Online via a JDBC Driver
Manage Exact Online data with visual tools in DBeaver like the query browser.
-
Connect to and Query Qualaroo Data in QlikView over ODBC
Create data visualizations with Qualaroo data in QlikView.
-
Connecting Pipedream with Google Spanner Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Google Spanner data in real time.
-
Create Informatica Mappings From/To an ODBC Data Source for xBase
Create an ODBC connection to xBase in Informatica and browse and transfer xBase data.
-
Connect Aircall Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Aircall data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Adobe Commerce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Adobe Commerce data and build Adobe Commerce-connected web apps with Axios.
-
Analyze Live ClickUp Data in SAS Viya
Use CData Connect AI to connect to ClickUp data from SAS Viya and deploy self-service analytics using live ClickUp data.
-
How to Visualize Parallel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Parallel data in Python.
-
Connect to Oracle Eloqua Reporting Data from a Connection Pool in Jetty
The Oracle Eloqua Reporting JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle Eloqua Reporting data from Web apps in Jetty.
-
How to create Retently federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Retently data in MySQL .
-
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.
-
Migrating data from SAP ByDesign to Databricks using CData SSIS Components.
Easily push SAP ByDesign data to Databricks using the CData SSIS Tasks for SAP ByDesign and Databricks.
-
How to connect to SuiteCRM Data from IntelliJ
Integrate connectivity to SuiteCRM data with wizards in IntelliJ.
-
Natively Connect to Reckon Accounts Hosted Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Reckon Accounts Hosted data. Leverage the native support for ODBC in PHP.
-
Replicate Multiple Marketo Accounts via the CData Sync CLI
Replicate multiple Marketo accounts to one or many databases.
-
How to Access Live NetSuite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for NetSuite enables you to integrate NetSuite data into workflows built using Microsoft Power Automate Desktop.
-
Build Square-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Square data.
-
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.
-
Integrate Live Acumatica Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Acumatica data to Blue Prism using the CData ODBC Driver for Acumatica to create automated workflows for repetitive business tasks.
-
Natively Connect to BigQuery Data in PHP
The CData ODBC driver for BigQuery enables you to create PHP applications with connectivity to BigQuery data. Leverage the native support for ODBC in PHP.
-
Connect to Databricks Data in CloverDX (formerly CloverETL)
Transfer Databricks data using the visual workflow in the CloverDX data integration tool.
-
Import Twilio Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Twilio Data and provide access to live Twilio data for custom reports in the Power BI Service.
-
Connecting Agentforce with Excel Online Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Excel Online data for you.
-
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.
-
Getting Started with the CData SSIS Components for Rebilly
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Rebilly.
-
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.
-
Replicate Multiple AgileCRM Accounts via the CData Sync CLI
Replicate multiple AgileCRM accounts to one or many databases.
-
Manage Apollo Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Apollo.
-
Create Cassandra Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Cassandra data access from reports, embedded analytics, and more.
-
Operational Reporting on Everhour Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Everhour data.
-
Access Live Jira Assets 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 Jira Assets data through MCP integration.
-
Replicate Trello Data from PowerShell
Write a quick PowerShell script to query Trello data. Use connectivity to the live data to replicate Trello data to SQL Server.
-
How to Connect to Live ADP Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your ADP data for you.
-
Migrating data from Freshservice to Snowflake using CData SSIS Components.
Easily push Freshservice data to Snowflake using the CData SSIS Tasks for Freshservice and Snowflake.
-
Connect to Zoho Creator Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Creator data using standard SQL.
-
Connect to Everhour from Asprova with CData Software ODBC Driver for Everhour
This article shows how to connect faster to Everhour data from Asprova.
-
Connect to Float Data in RazorSQL
Connect to Float from wizards and query Float data from the GUI in the RazorSQL database management tool.
-
Visualize Adobe Commerce Data in Sisense
Create an ElastiCube in Sisense app with access to Adobe Commerce data.
-
Query ShipStation Data in DataGrip
Create a Data Source for ShipStation in DataGrip and use SQL to query live ShipStation data.
-
Connect to Parquet Data in Claris FileMaker Pro
Use the CData ODBC Driver for Parquet in FileMaker Pro to connect to Parquet and work with Parquet data in your FileMaker applications.
-
Migrating data from HubSpot to Google BigQuery using CData SSIS Components.
Easily push HubSpot data to Google BigQuery using the CData SSIS Tasks for HubSpot and Google BigQuery.
-
Use Databricks Agent Bricks to Talk to Your Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Freshdesk data for you.
-
Connect to Guru Data from HeidiSQL
Use CData Connect AI to connect to and query live Guru data from HeidiSQL.
-
Connect to Jumpseller Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Jumpseller as an External Source in Dremio.
-
Build Charts with Sage 300 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 300 data in Clear Analytics.
-
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.
-
How to publish and share Dynamics 365 Business Central Data dashboards with Tableau Server
The CData ODBC driver for Dynamics 365 Business Central enables you integrate Dynamics 365 Business Central data into Tableau dashboards.
-
Automate Acumatica Data Replication to Couchbase
Use CData Sync to Customize and automate Acumatica data replication to Couchbase.
-
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.
-
Automated Continuous Onfleet Replication to MongoDB
Use CData Sync for automated, continuous, customizable Onfleet replication to MongoDB.
-
Use Agno to Talk to Your ZohoInvoice 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 ZohoInvoice data for you.
-
How to publish and share Simplesat Data dashboards with Tableau Server
The CData ODBC driver for Simplesat enables you integrate Simplesat data into Tableau dashboards.
-
Build Agents in Relevance AI with Access to Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Freshdesk data within intelligent agent workflows.
-
Edit and Search External Xero Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Xero data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero Data objects that you can access from apps and the dashboard.
-
Use the CData Software JDBC Driver for Billsby in MicroStrategy Desktop
Connect to Billsby data in MicroStrategy Desktop using the CData Software JDBC Driver for Billsby.
-
A PostgreSQL Interface for Omnisend Data (MySQL Remoting via JDBC)
Use the Remoting features of the Omnisend JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Customer.io Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Customer.io data from HeidiSQL.
-
Integrate Live SageHR Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SageHR data and integrate live SageHR data into apps built in Microsoft Power Apps.
-
Access Optimizely 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 Optimizely data.
-
Use JayDeBeApi to access Microsoft Planner Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Planner data.
-
Getting Started with the CData Excel Add-In for Clio
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clio.
-
Create SAP Ariba Procurement Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Ariba Procurement data access from reports, embedded analytics, and more.