CData Software - Knowledge Base
Recent Articles
-
Build Acumatica-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Acumatica Data from Zoho Analytics and import live Acumatica ERP.
-
Build Automated Azure Table-Connected Workflows in Zapier
Use CData Connect AI to connect to live Azure Table Storage and build automated workflows in Zapier.
-
Create Datasets from Avaza in Domo Workbench and Build Visualizations of Avaza Data in Domo
Use the CData Software ODBC Driver for Avaza to create datasets from Avaza in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData ODBC Driver for Splunk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Splunk.
-
Integrating Cursor CLI with Aweber 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 Charts with Access Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Access in Clear Analytics.
-
Connect to Humanity 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 Humanity and work with Humanity in your FileMaker application.
-
Establish a Live Connection with Google Directory Data using Tableau Bridge
The CData ODBC Driver for Google Directory enables you to integrate live Google Directory into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software ODBC Driver for MailerSend in MicroStrategy Web
Connect to MailerSend in MicroStrategy Web using the CData Software ODBC Driver for MailerSend.
-
Visualize Live XML Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live XML Files.
-
Automated Continuous Timely Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Timely replication to Google BigQuery.
-
Manage Spotify Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Spotify.
-
Excel Spreadsheet Automation on Campaigner Data with the QUERY Formula
Pull data from Campaigner, automate spreadsheets, and more with the QUERY formula.
-
Query Live Snowflake 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 Snowflake directly from the development environment.
-
Automated Continuous Oracle SCM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Oracle SCM replication to IBM DB2.
-
Access Live Procore Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Procore into the statistical analysis tools available in SAS JMP. This article shows how to use Procore in the Graph Builder and Query Builder.
-
Replicate SparkPost Data to Multiple Databases via the CData Sync CLI
Replicate SparkPost to disparate databases with a single configuration.
-
Use Grok to Talk to Your YouTube Analytics 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 YouTube Analytics for you.
-
Automated Continuous SharePoint Excel Services Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Azure SQL Database.
-
Build MVC Applications with Connectivity to NASA Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access NASA from an ASP.NET MVC application.
-
Connect Sybase to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sybase using the CData Python MCP Server.
-
Connect to Snowflake Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snowflake to connect to Snowflake and execute queries in PowerBuilder.
-
Create Office 365-Connected Nintex Workflows
Use CData Connect AI to connect to Office 365 Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Office 365.
-
How to Connect Flowise AI Agents to Live BigQuery 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 Google BigQuery without replication.
-
Visualize Live API Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live API into custom reports in Power BI.
-
Use ChatGPT to Talk to Your Act-On 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 Act-On for you.
-
Connect to MailerSend from Asprova with CData Software ODBC Driver for MailerSend
This article shows how to connect faster to MailerSend data from Asprova.
-
How to publish and share Oracle Service Cloud Data dashboards with Tableau Server
The CData ODBC driver for Oracle Service Cloud enables you integrate Oracle Service Cloud into Tableau dashboards.
-
Extract, Transform, and Load Azure Table Data in Informatica PowerCenter
Create a simple Workflow for Azure Table Storage in Informatica PowerCenter.
-
Getting Started with the CData Excel Add-In for Okta
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Okta.
-
Visualize Live Marketo Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Marketo into custom reports in Power BI.
-
Integrating Boomi Agentstudio with Databricks Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Databricks, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Google Campaign Manager 360 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Campaign Manager 360 and the Script function in FileMaker Pro to connect to Google Campaign Manager 360 and work with Google Campaign Manager 360 in your FileMaker application.
-
Validate SendPulse Data with QuerySurge
Access and validate SendPulse in QuerySurge using the CData JDBC Driver.
-
Use JayDeBeApi to access Azure Data Lake Storage Data in Python
Use standard Python scripting and the development environment of your choice to access live Azure Data Lake Storage.
-
Integrating Dataiku with Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Facebook Ads.
-
Automated Continuous Facebook Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Facebook replication to PostgreSQL.
-
Write a Simple Go Application to work with Acumatica Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Acumatica ERP.
-
Getting Started with the CData Excel Add-In for Billsby
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Billsby.
-
Getting Started with the CData Power BI Connector for Tanda
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Build AI/ML Models with Live MessageBird Data using Dataiku
Connect MessageBird Data with Dataiku using the CData API Driver for JDBC.
-
Connect to Adobe Experience Manager Data in RazorSQL
Connect to Adobe Experience Manager from wizards and query Adobe Experience Manager from the GUI in the RazorSQL database management tool.
-
How to import Gong Data into Apache Solr
Use the CData Software JDBC Driver for Gong in Data Import Handler and create an automated import of Gong to Apache Solr Enterprise Search platform.
-
Bidirectional Access to Azure Synapse Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Azure Synapse in Filemaker Pro for Mac or Windows.
-
Connect to Redis Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Redis in the Denodo Virtual DataPort Administrator.
-
Visualize Gorgias Data in Sisense
Create an ElastiCube in Sisense app with access to Gorgias.
-
Connect to Microsoft OneDrive Data in RapidMiner
Integrate Microsoft OneDrive with standard components and data source configuration wizards in RapidMiner Studio.
-
Consume eBay Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on eBay Analytics feeds that reflect any changes in SAP Lumira.
-
Excel Spreadsheet Automation on LinkedIn Ads Data with the QUERY Formula
Pull data from LinkedIn Ads, automate spreadsheets, and more with the QUERY formula.
-
How to connect to Azure Synapse Data in DBVisualizer
Integrate Azure Synapse with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to Live Procore 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 Procore for you.
-
Natively Connect to Oracle Financials Cloud Data in PHP
The CData ODBC driver for Oracle Financials Cloud enables you to create PHP applications with connectivity to Oracle Financials Cloud. Leverage the native support for ODBC in PHP.
-
How to connect PolyBase to Telegram
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Telegram.
-
Integrate SAP HANA XS Advanced with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP HANA XS Advanced with External Services.
-
Replicate Databricks Data to Multiple Databases via the CData Sync CLI
Replicate Databricks to disparate databases with a single configuration.
-
Model Reckon Accounts Hosted Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Reckon Accounts Hosted, enabling the direct import of real-time Reckon Accounts Hosted.
-
Build Voice Agents in ElevenLabs with access to Live Zoom Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Zoom.
-
How to Seamlessly Import Microsoft Ads Data into IBM SPSS Modeler
Integrate Microsoft Ads data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Biml to Build SSIS Tasks to Replicate Sage Intacct Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage Intacct to SQL Server.
-
How to Connect the Power BI Service to Delighted: Complete Guide
Connect to the CData Software Power BI Connector for Delighted from PowerBI.com to provide real-time Delighted across the organization.
-
BigCommerce Reporting in OBIEE with the BigCommerce JDBC Driver
Deploy the BigCommerce JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use ChatGPT to Talk to Your Instagram 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 Instagram for you.
-
Prepare, Blend, and Analyze Beeminder Data in Alteryx Designer (ODBC)
Build workflows to access live Beeminder for self-service data analytics.
-
Prepare, Blend, and Analyze ZarMoney Data in Alteryx Designer (ODBC)
Build workflows to access live ZarMoney for self-service data analytics.
-
Automated Continuous Sage 300 Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage 300 replication to Amazon S3.
-
How to Easily Query Salesforce CRM Analytics Data in OpenOffice Base
Connect to Salesforce CRM Analytics data in OpenOffice Base using the CData ODBC Driver for Salesforce CRM Analytics and generate reports with live data insights.
-
Viewing Browserless Data in RAD Studio Data Explorer
How to view Browserless in RAD Studio Data Explorer using the CData ODBC Driver for Browserless.
-
Enable the Freshservice JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshservice.
-
Build Reckon Accounts Hosted-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Reckon Accounts Hosted to explore live Reckon Accounts Hosted Data in Gemini Code Assist to assist with building Reckon Accounts Hosted-powered applications.
-
Connect to Highrise Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Highrise CRM in Airbyte.
-
Integrate Live Spark Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Connect the Power BI Service to Sugar CRM: Complete Guide
Connect to the CData Software Power BI Connector for Sugar CRM from PowerBI.com to provide real-time Sugar CRM across the organization.
-
Connect to FreshBooks Data in Google Apps Script via Connect AI
Use CData Connect AI to access FreshBooks in Google Apps Script.
-
Wrike Reporting in OBIEE with the Wrike JDBC Driver
Deploy the Wrike JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Twilio Data in MySQL Workbench
Execute MySQL queries against live Twilio from MySQL Workbench.
-
How to Connect to Live Xero Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Xero Accounting through natural language.
-
Integrating GitHub Copilot CLI with ZohoMarketingHub 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.
-
Extend Google Sheets with SingleStore Data
Make calls to SingleStore from Google Apps Script via the API Server.
-
Query Salesforce Data 360 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Salesforce Data 360 entities in PHP by modeling them as objects.
-
Integrate Theia IDE with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build SAP ByDesign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP Business ByDesign and build visualizations in Tableau Cloud.
-
Access Live Greenplum 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 Pivotal GreenPlum through MCP integration.
-
How to create Adobe Commerce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Commerce in MySQL .
-
Integrate with Live Oracle SCM Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Oracle SCM from the MuleSoft Anypoint Platform to integrate live Oracle SCM into custom reports and dashboards.
-
Access Google Drive Data from MySQL in Amazon QuickSight
Connect to Google Drive and build visualizations of Google Drive using a MySQL Connection in Amazon QuickSight.
-
Query, Visualize, and Share live FreshBooks Data in Redash
Use CData Connect AI to connect to live FreshBooks in Redash for querying, visualizing, and sharing.
-
Integrating Claude Code CLI with eBay Analytics 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.
-
Access Elorus Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Elorus from HeidiSQL.
-
Getting Started with the CData SSIS Components for AfterShip
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AfterShip.
-
LINQ to Spotify 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 Spotify Data Provider.
-
Getting Started with the CData SSIS Components for Email
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Email.
-
MailChimp Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MailChimp facts in real time.
-
Use Agno to Talk to Your eBay 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 eBay for you.
-
Access Live Placid Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Placid in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous LightSpeedRetail Replication to MySQL
Use CData Sync for automated, continuous, customizable LightSpeedRetail replication to MySQL.
-
Import Real-Time Excel Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Microsoft Excel in ColdFusion.
-
Automated Continuous Adobe Target Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Adobe Target replication to IBM DB2.
-
DataBind Controls to Acumatica Data in Delphi
DataBind to Acumatica ERP in Delphi with standard data access components and controls.
-
Build Apps with Live Gong in Adalo using CData Connect AI
Use CData Connect AI to integrate live Gong into the Adalo platform and build custom mobile and web applications with real-time Gong.
-
Connect and Visualize Live Neo4J Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Neo4J into the Databricks platform and create visualization dashboards with real-time Neo4J.