CData Software - Knowledge Base
Recent Articles
-
How to Connect to Live Cosmos DB 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 Cosmos DB data for you.
-
Migrating data from Insightly to Snowflake using CData SSIS Components.
Easily push Insightly data to Snowflake using the CData SSIS Tasks for Insightly and Snowflake.
-
Access Live Workable Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Workable data into the statistical analysis tools available in SAS JMP. This article shows how to use Workable data in the Graph Builder and Query Builder.
-
Build an OLAP Cube in SSAS from Clio Data
Establish a connection to Clio data data from SQL Server Analysis Services, and use the Clio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Semantic Layer Views for Zoho CRM Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Zoho CRM data.
-
Connect Vault CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Vault CRM data using the CData Python MCP Server.
-
Analyze Dynamics 365 Business Central Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Dynamics 365 Business Central from Power Pivot. You will use the Table Import Wizard to load Dynamics 365 Business Central data. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Customer.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Customer.io data.
-
Integrate Theia IDE with Live Act-On 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 Act-On data from within the development environment.
-
Use the CData ODBC Driver for Square in Microsoft Power Query
You can use the CData Square ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Square data into Microsoft Power Query.
-
Migrating data from Box to Google BigQuery using CData SSIS Components.
Easily push Box data to Google BigQuery using the CData SSIS Tasks for Box and Google BigQuery.
-
Access Phoenix Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Phoenix data from HeidiSQL.
-
Analyze Snowflake Data in Looker
Use CData Connect AI to connect to Snowflake Data from Looker and build custom apps using live Snowflake data.
-
Natively Connect to Sage 300 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sage 300 data. Leverage the native support for ODBC in PHP.
-
Query Quaderno Data in DataGrip
Create a Data Source for Quaderno in DataGrip and use SQL to query live Quaderno data.
-
Publish Crystal Reports on Sage 200 Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Sage 200 data.
-
A PostgreSQL Interface for Bugsnag Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bugsnag JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Real-Time Salesforce Data 360 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce Data 360 and Dataflow to import and use Salesforce Data 360 data in Power Apps.
-
Integrate Live Harvest Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Harvest data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Egnyte Data in RapidMiner
Integrate Egnyte data with standard components and data source configuration wizards in RapidMiner Studio.
-
Building Dynamic Web Pages with Salesforce Data 360 Data Using AngularJS
Create single-page applications with live connectivity to Salesforce Data 360 using the CData API Server.
-
How to Connect the Power BI Service to MySQL: Complete Guide
Connect to the CData Software Power BI Connector for MySQL from PowerBI.com to provide real-time MySQL data across the organization.
-
Create SSAS Tabular Models from ConvertKit Data
How to build a SQL Server Analysis Service Tabular Model from ConvertKit data using CData drivers.
-
Consume Google Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Google Ads data as OData feeds from PowerBuilder using the API Server.
-
Connect and Query Live SQL Server Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SQL Server data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate Devin with Live Power BI XMLA Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Power BI XMLA data.
-
Access Bitly Data from MySQL in Amazon QuickSight
Connect to Bitly and build visualizations of Bitly data using a MySQL Connection in Amazon QuickSight.
-
Integrate with Live AlloyDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to AlloyDB from the MuleSoft Anypoint Platform to integrate live AlloyDB data into custom reports and dashboards.
-
How to connect to Teamgate Data from Spring Boot
Connect to Teamgate in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating GitHub Copilot with JDBC-ODBC Bridge 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.
-
Integrate Goose with Live RSS Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live RSS feeds from within the local AI agent.
-
Create Reports with Microsoft Dataverse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Dataverse data.
-
Automated Continuous OnePageCrm Replication to Amazon S3
Use CData Sync for automated, continuous, customizable OnePageCrm replication to Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Sheets
Provide connectivity to Google Sheets data through an SAP BusinessObjects universe.
-
View Reports on Real-Time Azure Synapse Data in Power BI Report Server
Use the CData ODBC Driver for Azure Synapse to visualize Azure Synapse data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Azure AI Foundry to Talk to Your Exa Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Exa data for you.
-
Automated Continuous Mixpanel Replication to MongoDB
Use CData Sync for automated, continuous, customizable Mixpanel replication to MongoDB.
-
Query Teamwork Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Teamwork data from Node.js.
-
Moving Data from Splunk to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Splunk data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Cloudflare Data from AWS Glue
Use CData Connect AI to gain access to live Cloudflare data from your AWS Glue jobs.
-
Integrating Codex with Typeform 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.
-
How to connect and process Sybase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sybase data.
-
Automated Continuous Qualaroo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Qualaroo replication to Google BigQuery.
-
Build Microsoft Dataverse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Dataverse data.
-
Automated Continuous Placid Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Placid replication to Azure SQL Database.
-
Consume Raisers Edge NXT OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Raisers Edge NXT feeds that reflect any changes in SAP Lumira.
-
Extract, Transform, and Load Marketo Data in Informatica PowerCenter
Create a simple Workflow for Marketo data in Informatica PowerCenter.
-
Create Dynamic FHIR Grids Using the Infragistics XamDataGrid
Learn how you can connect FHIR to Infragistics XamDataGrid to build dynamic grids.
-
Deploy the ADO.NET Provider for Active Directory on an SSRS Report Server
Connect to Active Directory data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build AI/ML Models with Live BambooHR Data using Dataiku
Connect BambooHR Data with Dataiku using the CData API Driver for JDBC.
-
Operational Reporting on Contentful Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Contentful data.
-
Visualize SendInBlue Data in Tableau
The CData ODBC driver for SendInBlue enables you integrate SendInBlue data into Tableau dashboards.
-
Import Real-Time Gmail Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gmail data in ColdFusion.
-
Replicate ZohoInvoice Data to Multiple Databases
Replicate ZohoInvoice data to disparate databases with a point-and-click configuration.
-
Establish a Live Connection with SendInBlue Data using Tableau Bridge
The CData ODBC Driver for SendInBlue enables you to integrate live SendInBlue data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Visualize Power BI XMLA Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Power BI XMLA data in Python.
-
Analyze Typeform Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Typeform data and visualize live Typeform data in Infragistics Reveal.
-
Automate JotForm Integration Tasks from PowerShell
Are you in search of a quick and easy way to access JotForm data from PowerShell? This article demonstrates how to utilize the JotForm Cmdlets for tasks like connecting to JotForm data, automating operations, downloading data, and more.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Keap
Provide connectivity to Keap data through an SAP BusinessObjects universe.
-
How to Connect to Live Azure DevOps 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 Azure DevOps data for you.
-
Use the CData Software ODBC Driver for Stack Exchange in SAS for Real-Time Reporting and Analytics
Connect to real-time Stack Exchange data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Stack Exchange.
-
Automate SQL Server Data Replication to Azure Data Lake
Use CData Sync to customize and automate SQL Server data replication to Azure Data Lake.
-
How to Access Epicor Kinetic Data Using Entity Framework
This article shows how to access Epicor Kinetic data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Viewing Workday Data in RAD Studio Data Explorer
How to view Workday data in RAD Studio Data Explorer using the CData ODBC Driver for Workday.
-
ETL Oracle Sales in Oracle Data Integrator
This article shows how to transfer Oracle Sales data into a data warehouse using Oracle Data Integrator.
-
Automated Continuous Adobe Commerce Replication to SQL Server
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to SQL Server.
-
Connecting Pipedream with Timely 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 Timely data in real time.
-
Visualize DocuSign Data in Sisense
Create an ElastiCube in Sisense app with access to DocuSign data.
-
Access MariaDB Data from MySQL in Amazon QuickSight
Connect to MariaDB and build visualizations of MariaDB data using a MySQL Connection in Amazon QuickSight.
-
Integrating Antigravity CLI with iContact data via CData CLI
Connect iContact data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build Google Tasks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Tasks data and build web apps with connectivity to live Google Tasks data.
-
Write a Simple Go Application to work with Excel Online Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Excel Online data.
-
Bridge Bullhorn CRM Connectivity with Apache NiFi
Access and process Bullhorn CRM data in Apache NiFi using the CData JDBC Driver.
-
Connecting Mastra with Blackbaud FE NXT 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 Blackbaud FE NXT data, no replication required.
-
Connect to Splunk Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Splunk and the Script function in FileMaker Pro to connect to Splunk and work with Splunk data in your FileMaker application.
-
Getting Started with the CData JDBC Driver for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Oracle Sales.
-
Visualize Oracle Eloqua Reporting Data in TIBCO Spotfire through OData
Integrate Oracle Eloqua Reporting data into dashboards in TIBCO Spotfire.
-
How to connect to Phoenix Data from IntelliJ
Integrate connectivity to Phoenix data with wizards in IntelliJ.
-
Search External SurveyMonkey Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SurveyMonkey data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SurveyMonkey Data objects that you can access from apps and the dashboard.
-
Integrate Live ConstantContact Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to ConstantContact data and integrate live ConstantContact data into apps built in Microsoft Power Apps.
-
Automated Continuous ZeroBounce Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZeroBounce replication to delimited files (CSV/TSV).
-
Analyze Impala Data in Looker
Use CData Connect AI to connect to Impala Data from Looker and build custom apps using live Impala data.
-
Integrating Kiro with Salesforce CRM 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.
-
Visualize Live Google Ad Manager Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Ad Manager data.
-
Analyze Zendesk Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zendesk from Power Pivot. You will use the Table Import Wizard to load Zendesk data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating OpenCode with Snowflake 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.
-
Getting Started with the CData Tableau Connector for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Connect to Live WooCommerce Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your WooCommerce data for you.
-
Link Webex with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Webex data in Filemaker Pro for Mac or Windows.
-
Automated Continuous Parallel Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Parallel replication to AlloyDB.
-
Create Sage Cloud Accounting-Connected Applications in Appsmith
Connect to Sage Cloud Accounting Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sage Cloud Accounting data.
-
Import and Visualize PDFMonkey Data in Power View
Create data visualizations based on PDFMonkey data in Excel.
-
Integrate Cursor with Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Toggl data from within the editor.
-
Import Real-Time ZohoDesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoDesk data in ColdFusion.
-
Automate Excel Online Data Replication to Azure Synapse
Use CData Sync to customize and automate Excel Online data replication to Azure Synapse.
-
How to Seamlessly Import CouchDB Data into IBM SPSS Modeler
Integrate CouchDB data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Dynamic CockroachDB Grids Using the Infragistics XamDataGrid
Learn how you can connect CockroachDB to Infragistics XamDataGrid to build dynamic grids.
-
Connect to LeadDesk Data from PowerBuilder via ADO.NET
This article demonstrates how to access LeadDesk data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrating GitHub Copilot with PabblySubscriptions 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.
-
Getting Started with the CData ADO.NET Provider for Presto
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Presto.