CData Software - Knowledge Base
Recent Articles
-
Operational Reporting on Procore Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Procore data.
-
Working with LeadDesk Data in LINQPad
Execute LINQ queries to LeadDesk data in LINQPad.
-
Connect to Azure Analysis Services Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Azure Analysis Services data.
-
Stream Azure Synapse Data into Apache Kafka Topics
Access and stream Azure Synapse data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Live Azure Synapse Data in MicroStrategy through CData Connect AI
Create a live connection to Azure Synapse Data in CData Connect AI and connect to your Azure Synapse data from MicroStrategy.
-
How to Connect to & Open IBM Cloud Object Storage Data in Microsoft Excel
This article uses the CData ODBC driver for IBM Cloud Object Storage to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Charts with Basecamp Data in Clear Analytics
Create dynamic charts and perform analytics based on Basecamp data in Clear Analytics.
-
Access ServiceNow Data from MySQL in PHP
Connect to ServiceNow through the standard MySQL libraries in PHP.
-
Query Keap Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Keap data from Node.js.
-
Automated Continuous Dynamics NAV Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to Amazon S3.
-
How to Connect to Live Google Directory 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 Google Directory data for you.
-
Edit and Search External Spark Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Spark data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Spark Data objects that you can access from apps and the dashboard.
-
Extract, Transform, and Load Sage Intacct Data in Informatica PowerCenter
Create a simple Workflow for Sage Intacct data in Informatica PowerCenter.
-
Use the CData Software ODBC Driver for SAP Business Warehouse in MicroStrategy Desktop
Connect to SAP Business Warehouse data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Business Warehouse.
-
Connect to Google Directory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Google Directory and the SQL Gateway to access Google Directory data from Google Apps Script.
-
DataBind BigCommerce Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for BigCommerce with the DevExpress Windows Forms and Web controls to provide BigCommerce data to a chart.
-
How to Visualize FreeAgent Data in Python with pandas
Use pandas and other modules to analyze and visualize live FreeAgent data in Python.
-
Connect to Teradata Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Teradata and the Script function in FileMaker Pro to connect to Teradata and work with Teradata data in your FileMaker application.
-
Manage Mixpanel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Mixpanel.
-
Use the CData Software JDBC Driver for CampaignMonitor in MicroStrategy
Connect to CampaignMonitor data in MicroStrategy Developer using the CData Software JDBC Driver for CampaignMonitor.
-
Build Oracle HCM Cloud-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Oracle HCM Cloud data and build web apps with connectivity to live Oracle HCM Cloud data.
-
Connecting Pipedream with GitLab 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 GitLab data in real time.
-
Connect to Adobe Analytics Data from PowerBuilder via ADO.NET
This article demonstrates how to access Adobe Analytics data from Appeon PowerBuilder using the CData ADO.NET Provider for Adobe Analytics.
-
Build Flowlu-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Flowlu data and build web apps with connectivity to live Flowlu data.
-
Integrate Live YouTube Analytics Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to YouTube Analytics data and integrate live YouTube Analytics data into apps built in Microsoft Power Apps.
-
Connect to Gorgias in SpagoBI
Create reports featuring live Gorgias data in SpagoBI Studio. Host Gorgias reports on SpagoBI Server.
-
Replicate Discourse Data in Heroku for Use in Salesforce Connect
Replicate Discourse data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to & Open eBay Data in Microsoft Excel
This article uses the CData ODBC driver for eBay to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Square-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Square Data from Klipfolio and build custom visualizations using live Square data.
-
A PostgreSQL Interface for Foursquare Data (MySQL Remoting via JDBC)
Use the Remoting features of the Foursquare JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to Live Klaviyo 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 Klaviyo data for you.
-
Connecting Moonlit Workflow with HCL Domino Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your HCL Domino data in real time.
-
Viewing Adobe Target Data in RAD Studio Data Explorer
How to view Adobe Target data in RAD Studio Data Explorer using the CData ODBC Driver for Adobe Target.
-
How to Connect to Live Outreach.io 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 Outreach.io data for you.
-
How to Connect to Live SparkPost 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 SparkPost data for you.
-
Integrate Live Quickbase Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Quickbase data from within the IDE.
-
Publish IBM Informix-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live IBM Informix data.
-
Build Apps with Live HubDB data in Adalo using CData Connect AI
Use CData Connect AI to integrate live HubDB data into the Adalo platform and build custom mobile and web applications with real-time HubDB data.
-
How to Connect DBeaver to WordPress via a JDBC Driver
Manage WordPress data with visual tools in DBeaver like the query browser.
-
Visualize Live Tickspot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Tickspot data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Goose with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ADP data from within the local AI agent.
-
Manage Salesforce Pardot Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Salesforce Pardot.
-
Build MVC Applications with Connectivity to Wave Financial Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Wave Financial from an ASP.NET MVC application.
-
Connect to Strava Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Strava and work with Strava data in your FileMaker application.
-
Use the CData Software ODBC Driver for MySQL in MicroStrategy Web
Connect to MySQL data in MicroStrategy Web using the CData Software ODBC Driver for MySQL.
-
Connect to Wistia Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wistia data in the Denodo Virtual DataPort Administrator.
-
Connect to Twilio Data in ACL Analytics
Connect to Twilio data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Twilio data.
-
Replicate PayPal Data from PowerShell
Write a quick PowerShell script to query PayPal data. Use connectivity to the live data to replicate PayPal data to SQL Server.
-
How to import Accelo Data into Apache Solr
Use the CData Software JDBC Driver for Accelo in Data Import Handler and create an automated import of Accelo data to Apache Solr Enterprise Search platform.
-
Create Reckon Accounts Hosted-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Reckon Accounts Hosted Data from OutSystems and build custom enterprise apps using live Reckon Accounts Hosted data.
-
Analyze Live CapsuleCRM Data in SAS Viya
Use CData Connect AI to connect to CapsuleCRM data from SAS Viya and deploy self-service analytics using live CapsuleCRM data.
-
Connect and Visualize Live Airtable Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Airtable data into the Databricks platform and create visualization dashboards with real-time Airtable data.
-
How to connect to Procore Data in DBVisualizer
Integrate Procore data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Trello Data to Multiple Databases via the CData Sync CLI
Replicate Trello data to disparate databases with a single configuration.
-
Integrate Google's Antigravity Agent with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Microsoft Teams data using the Model Context Protocol.
-
Access Live Google Spanner Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Spanner data from your Excel spreadsheets.
-
Build CampaignMonitor-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live CampaignMonitor data.
-
Work with Workable Data in FoxPro
Load Workable data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Databricks Agent Bricks to Talk to Your Sybase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Sybase data for you.
-
Connect to and Query Jumpseller Data in QlikView over ODBC
Create data visualizations with Jumpseller data in QlikView.
-
Integrate Live NetSuite SuiteAnalytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to NetSuite SuiteAnalytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live NetSuite SuiteAnalytics data.
-
Automated Continuous Authorize.Net Replication to SQLite
Use CData Sync for automated, continuous, customizable Authorize.Net replication to SQLite.
-
Load WooCommerce Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load WooCommerce data to a database.
-
Replicate Reckon Data to Multiple Databases
Replicate Reckon data to disparate databases with a point-and-click configuration.
-
Build Pipelines with Live Apollo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Apollo from Google Cloud Data Fusion, enabling the integration of live Apollo data into the building and management of effective data pipelines.
-
Connect to Acumatica Data from HeidiSQL
Use CData Connect AI to connect to and query live Acumatica data from HeidiSQL.
-
How to import VWO Data into Apache Solr
Use the CData Software JDBC Driver for VWO in Data Import Handler and create an automated import of VWO data to Apache Solr Enterprise Search platform.
-
Replicate Perigon Data to Multiple Databases via the CData Sync CLI
Replicate Perigon data to disparate databases with a single configuration.
-
Build a Singer.io Tap for PhantomBuster With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PhantomBuster data using the CData Python Connector.
-
Integrating Cursor with Keap 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.
-
Integrating Boomi Agentstudio with Slack Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Slack data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Import and Visualize SurveyMonkey Data in Power View
Create data visualizations based on SurveyMonkey data in Excel.
-
Connect to and Visualize Live Gumroad Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Gumroad data.
-
Build Data Flows from SQL Server to FTP through SSIS
Easily push SQL Server data to FTP using the CData SSIS Tasks for FTP.
-
Access Live Browserless Data in Coginiti Pro
Connect to and query live Browserless data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Seamlessly Import FormSite Data into IBM SPSS Modeler
Integrate FormSite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
DataBind Okta Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Okta with the DevExpress Windows Forms and Web controls to provide Okta data to a chart.
-
How to Connect Flowise AI Agents to Live Sybase IQ 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 Sybase IQ data without replication.
-
Connect GitHub to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect GitHub with IBM WebSphere for seamless data integration and connectivity.
-
Integrate OpenCode with Live Printify Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Printify data from within your AI coding agent.
-
Analyze Paymo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Paymo data in Microsoft R Open.
-
Automate Pingdom Data Replication to Azure Synapse
Use CData Sync to customize and automate Pingdom data replication to Azure Synapse.
-
How to Work with Sage Cloud Accounting Data in ETL Validator JDBC
Connect to Sage Cloud Accounting from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Data Flows from ConstantContact to SQL Server using SSIS
Easily back up ConstantContact data to SQL Server using the SSIS components for ConstantContact.
-
Seamlessly Bring Freshservice Data into Retool Using CData Connect AI
Integrate Freshservice data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Accelo Data in Sisense
Create an ElastiCube in Sisense app with access to Accelo data.
-
Avaza Reporting in OBIEE with the Avaza JDBC Driver
Deploy the Avaza JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Create Dynamic Printify Grids Using the Infragistics XamDataGrid
Learn how you can connect Printify to Infragistics XamDataGrid to build dynamic grids.
-
Migrating data from Clari to Snowflake using CData SSIS Components.
Easily push Clari data to Snowflake using the CData SSIS Tasks for Clari and Snowflake.
-
Connect to Act-On Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Act-On data.
-
How to Build an ETL App for JobNimbus Data in Python with CData
Create ETL applications and real-time data pipelines for JobNimbus data in Python with petl.
-
Visualize Live Shortcut Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Shortcut data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Ariba Source data within automated workflows.
-
Integrate Live SendPulse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SendPulse data and integrate live SendPulse data into apps built in Microsoft Power Apps.
-
Build MVC Applications with Connectivity to Aweber Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Aweber from an ASP.NET MVC application.
-
Query Airtable Data in ColdFusion
Write standard ColdFusion data access code to connect to Airtable data.
-
Build Semantic Layer Views for PolarTeamPro Data in APOS Live Data Gateway
Use the CData Connector for PolarTeamPro in APOS Live Data Gateway to build Semantic Layer Views for PolarTeamPro data.
-
Connect to LinkedIn Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for LinkedIn Data and connect to LinkedIn data in Akorbi Digital RunMyProcess.
-
A PostgreSQL Interface for Figshare Data using the CData ODBC Driver
Use the SQL Gateway and Figshare ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to connect to Cohere Data in DBVisualizer
Integrate Cohere data with visual data analysis tools and data connection wizards in DBVisualizer