CData Software - Knowledge Base
Recent Articles
-
Validate PolarTeamPro Data with QuerySurge
Access and validate PolarTeamPro data in QuerySurge using the CData JDBC Driver.
-
Access Live Google Analytics Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Analytics data from your Excel spreadsheets.
-
Connect to Dropbox Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Dropbox and the Script function in FileMaker Pro to connect to Dropbox and work with Dropbox data in your FileMaker application.
-
Connect Excel Online Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Excel Online data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live SAP SuccessFactors 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 SAP SuccessFactors data without replication.
-
Query HDFS Data in DataGrip
Create a Data Source for HDFS in DataGrip and use SQL to query live HDFS data.
-
Use the CData Software ODBC Driver for Zoom in MicroStrategy Web
Connect to Zoom data in MicroStrategy Web using the CData Software ODBC Driver for Zoom.
-
Work with Zoom Data in FoxPro
Load Zoom data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Claude Code CLI with Workday 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.
-
Validate Productboard Data with QuerySurge
Access and validate Productboard data in QuerySurge using the CData JDBC Driver.
-
Model, Search, and Visualize Live Klaviyo Data in ThoughtSpot
Use CData Connect AI to connect to live Klaviyo data for modeling, searching, and visualizing.
-
Automated Continuous Coda Replication to Snowflake
Use CData Sync for automated, continuous, customizable Coda replication to Snowflake.
-
Analyze Live Adobe Analytics Data in SAS Viya
Use CData Connect AI to connect to Adobe Analytics data from SAS Viya and deploy self-service analytics using live Adobe Analytics data.
-
Replicate Onfleet Data to Multiple Databases via the CData Sync CLI
Replicate Onfleet data to disparate databases with a single configuration.
-
Create Power BI Reports on Real-Time Pipedrive Data
Use the CData ODBC Driver for Pipedrive to visualize Pipedrive data in Power BI Desktop.
-
Analyze Square Data in Cognos Analytics
Use CData Connect AI to connect to Square Data from Cognos Analytics and analyze live Square data.
-
Natively Connect to Nuclia Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Nuclia data. Leverage the native support for ODBC in PHP.
-
Access Live ShipEngine Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ShipEngine data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Connect to Live SAP Business Warehouse Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Business Warehouse data for you.
-
Integrating Claude Code with GraphQL Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on GraphQL data within assisted coding and automated development workflows.
-
Create Salesloft-Connected Dashboards in Grafana
Connect to Salesloft Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesloft data.
-
Build Voice Agents in ElevenLabs with access to Live ConstantContact Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live ConstantContact data.
-
Integrate Sybase IQ Data into Power Automate Desktop using CData Connect
CData Connect for Sybase IQ Data enables you to integrate Sybase IQ data into workflows built using Microsoft Power Automate Desktop.
-
Connect Float Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Float data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
View Reports on Real-Time Foursquare Data in Power BI Report Server
Use the CData ODBC Driver for Foursquare to visualize Foursquare data in Power BI Desktop and then publish them to Power BI Report Server.
-
Rapidly Develop Gorgias-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 Gorgias.
-
How to integrate Metabase with Microsoft Dataverse Data
Use CData Connect AI to connect to live Microsoft Dataverse data and create an interactive dashboard in Metabase from Microsoft Dataverse data.
-
Rapidly Develop ServiceDesk Plus-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 ServiceDesk Plus.
-
Query HBase Data in DataGrip
Create a Data Source for HBase in DataGrip and use SQL to query live HBase data.
-
Access Live Bullhorn CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Bullhorn CRM data into the statistical analysis tools available in SAS JMP. This article shows how to use Bullhorn CRM data in the Graph Builder and Query Builder.
-
Build Visualizations of Cloudflare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cloudflare data in Birst.
-
Build an OLAP Cube in SSAS from HubSpot Data
Establish a connection to HubSpot data data from SQL Server Analysis Services, and use the HubSpot Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Build an ETL App for Coinbase Data in Python with CData
Create ETL applications and real-time data pipelines for Coinbase data in Python with petl.
-
Integrating LangGraph with Moosend Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Moosend data within automated workflows.
-
Integrating Boomi Agentstudio with Sage Intacct Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sage Intacct data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Email Data with Squirrel SQL client
Connect to Email data and execute queries in the Squirrel SQL Client.
-
Visualize Customer.io Data in Tableau
The CData ODBC driver for Customer.io enables you integrate Customer.io data into Tableau dashboards.
-
Import and Visualize SAS xpt Data in Power View
Create data visualizations based on SAS xpt data in Excel.
-
Getting Started with the CData ODBC Driver for Xero
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Xero.
-
Automated Continuous Sage Cloud Accounting Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Amazon Redshift.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Calendar data.
-
Replicate Salesforce Pardot Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce Pardot data to disparate databases with a single configuration.
-
Automate AlloyDB Data Replication to Couchbase
Use CData Sync to Customize and automate AlloyDB data replication to Couchbase.
-
Analyze SharePoint Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SharePoint data and visualize SharePoint data in SAP Analytics Cloud.
-
Access Live Dynamics CRM Data in TIBCO Data Virtualization
Use the Dynamics CRM Tibco DV Adapter to create a Dynamics CRM data data source in TIBCO Data Virtualization Studio and gain access to live Dynamics CRM data from your TDV Server.
-
Easily Integrate Cohere Data in Lazarus Pascal IDE
Learn how to easily integrate live Cohere data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to connect to HBase Data with Squirrel SQL client
Connect to HBase data and execute queries in the Squirrel SQL Client.
-
Connect to Jumpseller from a Connection Pool in WebLogic
Use the CData JDBC Driver for Jumpseller to connect to Jumpseller data from Web applications running on WebLogic.
-
Connect to SAP BusinessObjects BI Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SAP BusinessObjects BI Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automated Continuous Hive Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hive replication to SQL Server.
-
Automated Continuous Google Translate Replication to Vertica
Use CData Sync for automated, continuous, customizable Google Translate replication to Vertica.
-
Analyze Authorize.Net Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Authorize.Net data and visualize live Authorize.Net data in Infragistics Reveal.
-
Connect to BigQuery Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BigQuery data in the Denodo Virtual DataPort Administrator.
-
Connect to VWO from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from VWO data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Informatica Mappings From/To an ODBC Data Source for Instagram
Create an ODBC connection to Instagram in Informatica and browse and transfer Instagram data.
-
Use Manus AI to Talk to Your MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on MongoDB data.
-
Connect to Snapchat Ads Data from a Connection Pool in Jetty
The Snapchat Ads JDBC Driver supports connection pooling: This article shows how to connect faster to Snapchat Ads data from Web apps in Jetty.
-
Validate Insightly Data with QuerySurge
Access and validate Insightly data in QuerySurge using the CData JDBC Driver.
-
Import and Visualize Campaigner Data in Power View
Create data visualizations based on Campaigner data in Excel.
-
Create Datasets from PolarTeamPro in Domo Workbench and Build Visualizations of PolarTeamPro Data in Domo
Use the CData Software ODBC Driver for PolarTeamPro to create datasets from PolarTeamPro data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect to Live Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Use the CData Software ODBC Driver for Vimeo in MicroStrategy
Connect to Vimeo data in MicroStrategy Developer using the CData Software ODBC Driver for Vimeo.
-
Viewing Egnyte Data in RAD Studio Data Explorer
How to view Egnyte data in RAD Studio Data Explorer using the CData ODBC Driver for Egnyte.
-
Visualize Clio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clio data.
-
Visualize Live Clari Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Clari data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import YouTube Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to YouTube Analytics Data and provide access to live YouTube Analytics data for custom reports in the Power BI Service.
-
Visualize Live Authorize.Net Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Authorize.Net data.
-
Use the CData Software ODBC Driver for Optimizely in MicroStrategy
Connect to Optimizely data in MicroStrategy Developer using the CData Software ODBC Driver for Optimizely.
-
Replicate Jira Data from PowerShell
Write a quick PowerShell script to query Jira data. Use connectivity to the live data to replicate Jira data to SQL Server.
-
Integrate with Live Figshare Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Figshare from the MuleSoft Anypoint Platform to integrate live Figshare data into custom reports and dashboards.
-
Build Visualizations of Pipeline CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pipeline CRM data in Birst.
-
Build ZohoDesk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ZohoDesk data and build web apps with connectivity to live ZohoDesk data.
-
Natively Connect to Authorize.Net Data in PHP
The CData ODBC driver for Authorize.Net enables you to create PHP applications with connectivity to Authorize.Net data. Leverage the native support for ODBC in PHP.
-
How to connect to WooCommerce Data in DBVisualizer
Integrate WooCommerce data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Xero Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Xero replication to delimited files (CSV/TSV).
-
Viewing Facebook Ads Data in RAD Studio Data Explorer
How to view Facebook Ads data in RAD Studio Data Explorer using the CData ODBC Driver for Facebook Ads.
-
Getting Started with the CData Python Connector for Tavily
Learn to install and license the CData Python Connector and configure a connection to live Tavily data.
-
Connect to Act-On Data from HeidiSQL
Use CData Connect AI to connect to and query live Act-On data from HeidiSQL.
-
Wave Financial Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Wave Financial facts in real time.
-
Use the CData SSIS Components to Insert New or Update Existing SharePoint Records from SQL Server
Easily push SQL Server data to SharePoint using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SharePoint or update existing records with data from a SQL Server database.
-
Build an OLAP Cube in SSAS from Greenhouse Data
Establish a connection to Greenhouse data data from SQL Server Analysis Services, and use the Greenhouse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Access Live Instagram Data in TIBCO Data Virtualization
Use the Instagram Tibco DV Adapter to create a Instagram data data source in TIBCO Data Virtualization Studio and gain access to live Instagram data from your TDV Server.
-
How to Connect to Live Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
How to connect Amazon QuickSight to HCL Domino Data
Create a connection to HCL Domino data in CData Connect AI and insert HCL Domino data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Invoiced
Provide connectivity to Invoiced data through an SAP BusinessObjects universe.
-
Publish Reports with Gumroad Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gumroad data.
-
Connect to Real-Time Azure DevOps Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure DevOps and Dataflow to import and use Azure DevOps data in Power Apps.
-
Replicate JSON Services to Multiple Databases
Replicate JSON services to disparate databases with a point-and-click configuration.
-
Build Visualizations of Oracle HCM Cloud Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Oracle HCM Cloud data in Birst.
-
Design BIRT Reports on CampaignMonitor Data
Provide current CampaignMonitor data to your embedded analytics.
-
Create Reports with ADP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ADP data.
-
How to connect to ZohoExpense Data from Spring Boot
Connect to ZohoExpense in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Theia IDE with Live Epicor Kinetic 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 Epicor Kinetic data from within the development environment.
-
Connect to Snapchat Ads Data in RazorSQL
Connect to Snapchat Ads from wizards and query Snapchat Ads data from the GUI in the RazorSQL database management tool.
-
Build AI Agents with Cloudflare Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Cloudflare data through CData Connect AI.
-
Access Gorgias Data from MySQL in PHP
Connect to Gorgias through the standard MySQL libraries in PHP.
-
DataBind HDFS Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for HDFS with the DevExpress Windows Forms and Web controls to provide HDFS data to a chart.
-
Import and Visualize Notion Data in Power View
Create data visualizations based on Notion data in Excel.
-
Build SAP Fieldglass-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Fieldglass Data from Choreo and build custom apps using live SAP Fieldglass data.
-
Automated Continuous Clio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Clio replication to Google Cloud SQL.