CData Software - Knowledge Base
Recent Articles
-
Create QuickBooks Time Dataflows on PowerBI.com
Connect to the CData Power BI Connector for QuickBooks Time from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Databricks Data as a SQL Server Database in Node.js
Execute SQL Server queries against Databricks data from Node.js.
-
Integrate Cline with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Projects data from within your IDE.
-
Connect to Freshteam Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Freshteam and the SQL Gateway to access Freshteam data from Google Apps Script.
-
Visualize Printful Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Printful data.
-
Access Live Google Calendar 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 Google Calendar data through MCP integration.
-
Use the CData ODBC Driver for EnterpriseDB in Microsoft Power Query
You can use the CData EnterpriseDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import EnterpriseDB data into Microsoft Power Query.
-
How to connect Amazon QuickSight to LDAP Objects
Create a connection to LDAP objects in CData Connect AI and insert LDAP objects into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect to Google Forms Data from IntelliJ
Integrate connectivity to Google Forms data with wizards in IntelliJ.
-
Analyze Xero Data in Cognos Analytics
Use CData Connect AI to connect to Xero Data from Cognos Analytics and analyze live Xero data.
-
How to connect and process Power BI XMLA data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Power BI XMLA data.
-
Connect to Vault CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vault CRM data using standard SQL.
-
Integrate OpenCode with Live MarkLogic Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live MarkLogic data from within your AI coding agent.
-
Automated Continuous XML Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable XML data replication to OneLake in Microsoft Fabric.
-
Connect to Short.io Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Short.io.
-
Integrating SAP Ariba Procurement Data in Talend Cloud Data Management Platform
Connect SAP Ariba Procurement Data with Talend Cloud Data Management Platform using the CData JDBC Driver for SAP Ariba Procurement.
-
Automated Continuous Apollo Replication to Oracle
Use CData Sync for automated, continuous, customizable Apollo replication to Oracle.
-
View Reports on Real-Time Mouseflow Data in Power BI Report Server
Use the CData ODBC Driver for Mouseflow to visualize Mouseflow data in Power BI Desktop and then publish them to Power BI Report Server.
-
Configure the CData JDBC Driver for SharePoint Excel Services in a Connection Pool in Tomcat
Connect to SharePoint Excel Services data from a connection pool in Tomcat.
-
Use the CData ODBC Driver for SAP Business One from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP Business One to connect to SAP Business One data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP Business One data in Excel.
-
Replicate Multiple QuickBooks Time Accounts via the CData Sync CLI
Replicate multiple QuickBooks Time accounts to one or many databases.
-
Access eBay Data from MySQL in PHP
Connect to eBay through the standard MySQL libraries in PHP.
-
Automated Continuous Workday Replication to Snowflake
Use CData Sync for automated, continuous, customizable Workday replication to Snowflake.
-
Build an OLAP Cube in SSAS from Calendly Data
Establish a connection to Calendly data data from SQL Server Analysis Services, and use the Calendly Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to PingOne Data in RapidMiner
Integrate PingOne data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to create an RPA flow for Telegram Data in UiPath Studio
Use the Telegram ODBC Driver to create workflows that access real-time Telegram data without any coding.
-
Publish Crystal Reports on VWO Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date VWO data.
-
Getting Started with the CData Tableau Connector for Samanage
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Create Informatica Mappings From/To an ODBC Data Source for AgileCRM
Create an ODBC connection to AgileCRM in Informatica and browse and transfer AgileCRM data.
-
Build Asana-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Asana Data and create custom apps in Mendix.
-
Automated Continuous Trello Replication to Databricks
Use CData Sync for automated, continuous, customizable Trello replication to Databricks.
-
Analyze Klaviyo Data in Looker
Use CData Connect AI to connect to Klaviyo Data from Looker and build custom apps using live Klaviyo data.
-
Connect to SendPulse Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SendPulse data.
-
Automated Continuous Samanage Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Samanage replication to Azure SQL Database.
-
DataBind Controls to Mode Data in Delphi
DataBind to Mode data in Delphi with standard data access components and controls.
-
Use Databricks Agent Bricks to Talk to Your Omnisend Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Omnisend data for you.
-
Integrating Kiro with Bitly 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 Coda-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Coda data and build Coda-connected web apps with Axios.
-
Build Discourse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Discourse data and build web apps with connectivity to live Discourse data.
-
Integrating LangGraph with Notion Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Notion data within automated workflows.
-
How to Connect DBeaver to LightSpeedRetail via a JDBC Driver
Manage LightSpeedRetail data with visual tools in DBeaver like the query browser.
-
Create Datasets from Gorgias in Domo Workbench and Build Visualizations of Gorgias Data in Domo
Use the CData Software ODBC Driver for Gorgias to create datasets from Gorgias data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Real-Time Pingdom Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Pingdom data in Power Apps.
-
Integrate Open WebUI with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SAP Ariba Source data from within the chat interface.
-
Build Charts with PabblySubscriptions Data in Clear Analytics
Create dynamic charts and perform analytics based on PabblySubscriptions data in Clear Analytics.
-
Connect Asana Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Asana data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect SharePoint with Cloudant Data through external lists
Provide Cloudant data to SharePoint users as an external list.
-
Connect to Stripe Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Stripe Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
View Reports on Real-Time HubSpot Data in Power BI Report Server
Use the CData ODBC Driver for HubSpot to visualize HubSpot data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to and Visualize Live Azure Analysis Services Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Analysis Services data.
-
Query Live Azure Analysis Services Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Azure Analysis Services data through a conversational interface.
-
Visualize Jira 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 Jira data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Tanda in MicroStrategy Web
Connect to Tanda data in MicroStrategy Web using the CData Software JDBC Driver for Tanda.
-
Getting Started with the CData ADO.NET Provider for Shopify
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Shopify.
-
Automated Continuous Wave Financial Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Wave Financial replication to Google BigQuery.
-
Use Microsoft Copilot Studio to talk to your Dynamics 365 Business Central 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 Dynamics 365 Business Central data for you.
-
Connect to Sugar CRM Data in Jaspersoft Studio
Execute SQL to remote Sugar CRM data in Jaspersoft Studio.
-
Integrating Kiro with Beeminder 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.
-
Back Up Mistral AI data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Mistral AI data data.
-
Automated Continuous QuickBooks Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks replication to Apache Cassandra.
-
Build Azure Data Lake Storage Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Data Lake Storage data and build visualizations in Tableau Cloud.
-
Validate Azure Table Data with QuerySurge
Access and validate Azure Table data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous SAP Ariba Source Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Google BigQuery.
-
Validate SAP Ariba Source Data with QuerySurge
Access and validate SAP Ariba Source data in QuerySurge using the CData JDBC Driver.
-
Analyze Paylocity Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Paylocity data and visualize Paylocity data in SAP Analytics Cloud.
-
Create Datasets from Cloudflare in Domo Workbench and Build Visualizations of Cloudflare Data in Domo
Use the CData Software ODBC Driver for Cloudflare to create datasets from Cloudflare data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Goose with Live Quickbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Quickbase data from within the local AI agent.
-
Building Dynamic Web Pages with Monday.com Data Using AngularJS
Create single-page applications with live connectivity to Monday.com using the CData API Server.
-
Work with Jira Assets Data in FoxPro
Load Jira Assets data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Spotify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Spotify to connect to Spotify data from Web applications running on WebLogic.
-
Connect to Oracle HCM Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle HCM Cloud Data and connect to Oracle HCM Cloud data in Akorbi Digital RunMyProcess.
-
Integrate Trae with Live Email Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Email data from within the AI-powered IDE.
-
Integrate with Access Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Access data to a JSON file on disk.
-
Access Bugsnag Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bugsnag data from HeidiSQL.
-
Work with Live Active Directory Data in Power Query
Use CData Connect AI to connect to Active Directory data and work with live Active Directory data in Microsoft Power Query.
-
Build a PostgreSQL Interface for Landbot Data using the CData JDBC Driver
Use the Remoting features of the Landbot JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create HCL Domino-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HCL Domino Data from Klipfolio and build custom visualizations using live HCL Domino data.
-
Build Pinterest-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Pinterest data without replication.
-
Automated Continuous Wrike Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Wrike replication to Apache Cassandra.
-
Connect to Tavily Data from PowerBuilder via JDBC
This article demonstrates how to access Tavily data from PowerBuilder using the Tavily JDBC Driver.
-
Use ChatGPT to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your BigCommerce data for you.
-
How to connect PolyBase to Nethunt
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Nethunt data.
-
Import Real-Time CouchDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CouchDB data in ColdFusion.
-
Automated Continuous Workable Replication to Snowflake
Use CData Sync for automated, continuous, customizable Workable replication to Snowflake.
-
Publish SpaceX-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SpaceX data.
-
Write a Simple Go Application to work with ActiveCampaign Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ActiveCampaign data.
-
Create Power BI Reports on Real-Time SAP SuccessFactors Data
Use the CData ODBC Driver for SAP SuccessFactors to visualize SAP SuccessFactors data in Power BI Desktop.
-
Publish Reports with Zoho Projects Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Projects data.
-
Automated Continuous LinkedIn Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Google BigQuery.
-
Visualize Live Sage 300 Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sage 300 data into custom reports in Power BI.
-
Connect to Microsoft Entra ID Data from a Connection Pool in JBoss
Integrate Microsoft Entra ID data into Java servlets: Use the Management Console in JBoss to install the Microsoft Entra ID JDBC Driver.
-
Automated Continuous SendGrid Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SendGrid replication to PostgreSQL.
-
Establish a Live Connection with SAP Data using Tableau Bridge
The CData ODBC Driver for SAP enables you to integrate live SAP data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrating LangChain with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Snapchat Ads data within automated workflows.
-
Create Teradata-Connected Business Apps in AppSheet
Connect to Teradata Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Teradata data.
-
Automated Continuous FreshBooks Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable FreshBooks replication to Google BigQuery.
-
Connect to Azure DevOps Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure DevOps data in Google Apps Script.
-
How to connect SharePoint with SingleStore Data through external lists
Provide SingleStore data to SharePoint users as an external list.
-
Use JayDeBeApi to access Authorize.Net Data in Python
Use standard Python scripting and the development environment of your choice to access live Authorize.Net data.
-
Use the CData Software ODBC Driver for Helpscout in MicroStrategy
Connect to Helpscout data in MicroStrategy Developer using the CData Software ODBC Driver for Helpscout.