CData Software - Knowledge Base
Recent Articles
-
Create Dashboards and Visualize Live Amazon Marketplace Data in Geckoboard
Use CData Connect AI to connect to live Amazon Marketplace and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Active Directory Data in Excel 365 Online (Excel for the web)
Connect to Active Directory from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Zoho Books-Connected Apps in Choreo
Use CData Connect AI to connect to Zoho Books Data from Choreo and build custom apps using live Zoho Books.
-
Query Live SQL Analysis Services 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 SQL Analysis Services directly from the development environment.
-
How to Connect to & Open FTP Data in Microsoft Excel
This article uses the CData ODBC driver for FTP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Bugsnag to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Bugsnag using the CData Python MCP Server.
-
Connect to HDFS Data in RazorSQL
Connect to HDFS from wizards and query Apache HDFS from the GUI in the RazorSQL database management tool.
-
How to Query Templated Data in MySQL Workbench
Execute MySQL queries against live Templated from MySQL Workbench.
-
Import Real-Time Pingdom Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Pingdom in ColdFusion.
-
Connect Clockify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Clockify using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Reply.io Data in HULFT Integrate
Connect to Reply.io as a JDBC data source in HULFT Integrate
-
Create Power BI Reports on Real-Time Scrapfly Data
Use the CData ODBC Driver for Scrapfly to visualize Scrapfly in Power BI Desktop.
-
Bind Live Kafka Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Kafka data
-
Automated Continuous CockroachDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CockroachDB replication to Apache Cassandra.
-
Create Hive-Connected Nintex Workflows
Use CData Connect AI to connect to Hive Data from Nintex Workflow Cloud and build custom workflows using live Apache Hive.
-
Integrate eBay Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate eBay Analytics with External Services.
-
Deploy the ADO.NET Provider for Act CRM on an SSRS Report Server
Connect to Act CRM 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.
-
How to Access Live Power BI XMLA Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Power BI XMLA enables you to integrate Power BI XMLA into workflows built using Microsoft Power Automate Desktop.
-
Migrating data from Teamgate to Databricks using CData SSIS Components.
Easily push Teamgate to Databricks using the CData SSIS Tasks for Teamgate and Databricks.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Oracle Sales using the Model Context Protocol.
-
Integrate Cursor with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Exchange from within the editor.
-
Create Yelp Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Yelp from PowerBI.com to create Power BI Dataflows with real-time data.
-
Natively Connect to Landbot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Landbot. Leverage the native support for ODBC in PHP.
-
How to work with Certinia Data in Apache Spark using SQL
Access and process Certinia Data in Apache Spark using the CData Software JDBC Driver.
-
Connecting GenSpark with Tally Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Tally ERP without any replication or custom integration required.
-
Connect WooCommerce Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your WooCommerce using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Stream MailChimp Data into Apache Kafka Topics
Access and stream MailChimp in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate with Live MYOB AccountRight Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from the MuleSoft Anypoint Platform to integrate live MYOB AccountRight into custom reports and dashboards.
-
Automated Continuous Quaderno Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Quaderno replication to Amazon S3.
-
Automated Continuous Google Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Google Ads replication to Amazon S3.
-
Automated Continuous VWO Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable VWO replication to Amazon Redshift.
-
Automated Continuous Clari Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Clari replication to OneLake in Microsoft Fabric.
-
Connect to Cosmos DB Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Cosmos DB to connect to Azure Cosmos DB and execute queries in PowerBuilder.
-
Publish Reports with YouTube Analytics Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date YouTube Analytics.
-
A PostgreSQL Interface for Elorus Data (MySQL Remoting via JDBC)
Use the Remoting features of the Elorus JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with Mistral AI Data in Clear Analytics
Create dynamic charts and perform analytics based on Mistral AI in Clear Analytics.
-
Access Live Monday.com Data in Excel 365 Online (Excel for the web)
Connect to Monday.com from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Automated Continuous HubDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable HubDB replication to IBM DB2.
-
How to Work with Google Campaign Manager 360 Data in AWS Glue Jobs Using JDBC
Connect to Google Campaign Manager 360 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrating Kiro CLI with Impala 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.
-
Create SendGrid-Connected Business Apps in AppSheet
Connect to SendGrid Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SendGrid.
-
Build MVC Applications with Connectivity to LeadDesk Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access LeadDesk from an ASP.NET MVC application.
-
Natively Connect to Mixpanel Data in PHP
The CData ODBC driver for Mixpanel enables you to create PHP applications with connectivity to Mixpanel. Leverage the native support for ODBC in PHP.
-
Query SageHR Data in DataGrip
Create a Data Source for SageHR in DataGrip and use SQL to query live SageHR.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Grafana
Provide connectivity to Grafana through an SAP BusinessObjects universe.
-
Query PabblySubscriptions Data as a MySQL Database in Node.js
Execute MySQL queries against PabblySubscriptions from Node.js.
-
Bridge MYOB AccountRight Connectivity with Apache NiFi
Access and process MYOB AccountRight in Apache NiFi using the CData JDBC Driver.
-
Use the CData ODBC Driver for Microsoft Planner from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft Planner to connect to Microsoft Planner from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Planner in Excel.
-
Deploy the ADO.NET Provider for Excel on an SSRS Report Server
Connect to Microsoft Excel 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.
-
Create Data Visualizations in Cognos BI with HCL Domino Data
Access HCL Domino as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Feed Retently Data into FineReport
How to set Retently as a JDBC data source in FineReport.
-
Access Live Pipeliner CRM Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Pipeliner CRM in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
DataBind Charts to Sendwithus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Sendwithus from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Visualize Live Zoho Projects Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Zoho Projects using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SharePoint-Connected Business Apps in AppSheet
Connect to SharePoint Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Microsoft SharePoint.
-
Connect to Real-Time Highrise Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Highrise and Dataflow to import and use Highrise CRM in Power Apps.
-
Connect to Zoom Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Zoom.
-
Connect to Mouseflow Data in RapidMiner
Integrate Mouseflow with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Excel Add-In for Sage 300
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sage 300.
-
How to connect to SAP HANA XS Advanced Data with Squirrel SQL client
Connect to SAP HANA XS Advanced and execute queries in the Squirrel SQL Client.
-
Access SAP Business Warehouse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for SAP Business Warehouse.
-
Publish Crystal Reports on xBase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date xBase.
-
Connect to Notion Data in Ruby
Connect to Notion in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access Live Odoo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Odoo ERP from your Excel spreadsheets.
-
Build Dashboards with Amazon DynamoDB Data in DBxtra
Create dynamic dashboards and perform analytics based on Amazon DynamoDB in DBxtra.
-
Build AI Agents with MYOB AccountRight 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 MYOB AccountRight through CData Connect AI.
-
Create LDAP Dataflows on PowerBI.com
Connect to the CData Power BI Connector for LDAP from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData SSIS Components for Google Sheets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Sheets.
-
Create a Data Access Object for Excel Online Data using JDBI
A brief overview of creating a SQL Object API for Microsoft Excel Online in JDBI.
-
Create Dashboards and Visualize Live Neo4J Data in Geckoboard
Use CData Connect AI to connect to live Neo4J and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Prepare, Blend, and Analyze Cosmos DB Data in Alteryx Designer (ODBC)
Build workflows to access live Azure Cosmos DB for self-service data analytics.
-
Establish a Live Connection with ChartMogul Data using Tableau Bridge
The CData ODBC Driver for ChartMogul enables you to integrate live ChartMogul into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData JDBC Driver for ServiceNow
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ServiceNow.
-
Visualize Sage Intacct Data in Sisense
Create an ElastiCube in Sisense app with access to Sage Intacct.
-
Automate REST Data Replication to Couchbase
Use CData Sync to Customize and automate REST replication to Couchbase.
-
Connect to CSV Data in Jaspersoft Studio
Execute SQL to remote CSV/TSV Files in Jaspersoft Studio.
-
How to Connect to xBase Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to xBase. Leverage the pyodbc module for ODBC in Python.
-
View Reports on Real-Time ServiceNow Data in Power BI Report Server
Use the CData ODBC Driver for ServiceNow to visualize ServiceNow in Power BI Desktop and then publish them to Power BI Report Server.
-
Building Dynamic Web Pages with Microsoft Exchange Data Using AngularJS
Create single-page applications with live connectivity to Microsoft Exchange using the CData API Server.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle HCM Cloud within intelligent workflows.
-
How to Query Live Square Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Square data in natural language using Python.
-
Automated Continuous AgileCRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable AgileCRM replication to SingleStore.
-
Connect to Xero Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.
-
Build Office 365-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Office 365 Data from Zoho Analytics and import live Microsoft Office 365.
-
How to connect to Perplexity Data in DBVisualizer
Integrate Perplexity with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to and Query SpaceX Data in QlikView over ODBC
Create data visualizations with SpaceX in QlikView.
-
Access Live Simplesat Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Simplesat in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Scrapfly Data in ColdFusion
Write standard ColdFusion data access code to connect to Scrapfly.
-
Integrate Live Superchat Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Superchat to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
DataBind Charts to Google Campaign Manager 360 Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Campaign Manager 360 from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Analyze Pipedrive Data in Cognos Analytics
Use CData Connect AI to connect to Pipedrive Data from Cognos Analytics and analyze live Pipedrive.
-
How to Connect to Live Power BI XMLA 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 Power BI XMLA for you.
-
Automated Continuous BenchmarkEmail Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to Azure SQL Database.
-
Work with MariaDB Data in FoxPro
Load MariaDB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from Coinbase to Databricks using CData SSIS Components.
Easily push Coinbase to Databricks using the CData SSIS Tasks for Coinbase and Databricks.
-
How to Connect to Live Twitter Ads 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 Twitter Ads for you.
-
Access Live Google Sheets Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Google Sheets from your Excel spreadsheets.
-
Build Automated SAP Ariba Procurement-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Ariba Procurement and build automated workflows in Zapier.
-
Natively Connect to LightSpeedRetail Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to LightSpeedRetail. Leverage the native support for ODBC in PHP.
-
Connecting Mastra with Hive 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 Apache Hive, no replication required.