CData Software - Knowledge Base
Recent Articles
-
Visualize Live TigerGraph Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live TigerGraph data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Visualize Microsoft Exchange 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 Microsoft Exchange data in Python.
-
Create Datasets from Clockify in Domo Workbench and Build Visualizations of Clockify Data in Domo
Use the CData Software ODBC Driver for Clockify to create datasets from Clockify data in Domo Workbench and then build visualizations in the Domo service.
-
Connect ZeroBounce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZeroBounce data using the CData Python MCP Server.
-
Integrate Klipfolio Data in Pentaho Data Integration
Build ETL pipelines based on Klipfolio data in the Pentaho Data Integration tool.
-
Build an OLAP Cube in SSAS from MailerLite Data
Establish a connection to MailerLite data data from SQL Server Analysis Services, and use the MailerLite Data Provider to build OLAP cubes for use in analytics and reporting.
-
Import Redshift Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redshift Data and provide access to live Redshift data for custom reports in the Power BI Service.
-
Create Data Visualizations in Cognos BI with WordPress Data
Access WordPress data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Add RabbitMQ Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for RabbitMQ with the Informatica Enterprise Data Catalog to classify and organize data.
-
DataBind Controls to Dotmailer Data in C++Builder
DataBind to Dotmailer data in C++Builder with standard components and controls.
-
Work with Sage Intacct Data in FoxPro
Load Sage Intacct data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build ZohoExpense-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live ZohoExpense data without replication.
-
How to create an RPA flow for Klipfolio Data in UiPath Studio
Use the Klipfolio ODBC Driver to create workflows that access real-time Klipfolio data without any coding.
-
Connecting GenSpark with Campaigner Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Campaigner data without any replication or custom integration required.
-
Build LinkedIn Ads-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for LinkedIn Ads Data and create custom apps in Bubble.
-
Connect to Ontraport Data in NetBeans
Connect to Ontraport data in NetBeans with the data source configuration wizard.
-
Automate Gmail Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Gmail data from PowerShell? This article demonstrates how to utilize the Gmail Cmdlets for tasks like connecting to Gmail data, automating operations, downloading data, and more.
-
How to Connect to Live Smartsheet 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 Smartsheet data without replication.
-
Connect to ServiceNow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceNow and the SQL Gateway to access ServiceNow data from Google Apps Script.
-
Automate Factorial Data Replication to Azure Data Lake
Use CData Sync to customize and automate Factorial data replication to Azure Data Lake.
-
Replicate Access Data to Multiple Databases
Replicate Access data to disparate databases with a point-and-click configuration.
-
Integrating Claude Code with Basecamp Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Basecamp data within assisted coding and automated development workflows.
-
Prepare, Blend, and Analyze SAP Concur Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Concur data for self-service data analytics.
-
Import MarkLogic Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MarkLogic Data and provide access to live MarkLogic data for custom reports in the Power BI Service.
-
Automate Humanity Data Replication to Azure Synapse
Use CData Sync to customize and automate Humanity data replication to Azure Synapse.
-
Automate Square Data Replication to Azure Synapse
Use CData Sync to customize and automate Square data replication to Azure Synapse.
-
Explore Geographical Relationships in Moosend Data with Power Map
Create data visualizations with Moosend data in Power Map.
-
How to Access Live Gmail Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gmail enables you to integrate Gmail data into workflows built using Microsoft Power Automate Desktop.
-
Creating Facebook-Connected Applications in Unqork
You can use CData Connect AI to feed Facebook data to Unqork and build custom business apps.
-
How to Query Live Authorize.Net Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Authorize.Net data data in natural language using Python.
-
Build Azure Data Catalog Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Data Catalog data and build visualizations in Tableau Cloud.
-
Publish Reports with ScrapingBee Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ScrapingBee data.
-
Query Oracle SCM Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle SCM data.
-
Moving Data from Clio to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Clio data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use the CData Software ODBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager data in MicroStrategy Web using the CData Software ODBC Driver for Google Ad Manager.
-
Visualize Live SQL Analysis Services Data in the Power BI Service
Use CData Connect AI to connect to live SQL Analysis Services data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Live Everhour Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Everhour data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Publish Crystal Reports on ChargeOver Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ChargeOver data.
-
Access Live Active Directory Data in Coginiti Pro
Connect to and query live Active Directory data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to SAP BusinessObjects BI Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP BusinessObjects BI data from HeidiSQL.
-
Integrating Cursor with Contentful 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 Campaigner Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Campaigner from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Hugging Face Replication to SingleStore
Use CData Sync for automated, continuous, customizable Hugging Face replication to SingleStore.
-
How to Connect to Live Redis 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 Redis data for you.
-
Build Semantic Layer Views for SAP Business One Data in APOS Live Data Gateway
Use the CData Connector for SAP Business One in APOS Live Data Gateway to build Semantic Layer Views for SAP Business One data.
-
Easily Integrate Sendwithus Data in Lazarus Pascal IDE
Learn how to easily integrate live Sendwithus data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Using the CData Software ODBC Driver for SendGrid in PyCharm
Connect to SendGrid as an ODBC data source in PyCharm using the CData Software ODBC Driver for SendGrid.
-
Create Dynamic OnePageCrm Grids Using the Infragistics XamDataGrid
Learn how you can connect OnePageCrm to Infragistics XamDataGrid to build dynamic grids.
-
Build Apps with Live Greenhouse Data Using the Low-Code Development Platform of Mendix
Connect Greenhouse data with Mendix to build apps using the CData JDBC Driver for Greenhouse.
-
DataBind Controls to Rootly Data in C++Builder
DataBind to Rootly data in C++Builder with standard components and controls.
-
Create Data Visualizations in Cognos BI with SAP BusinessObjects BI Data
Access SAP BusinessObjects BI data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
DataBind Controls to Close Data in Delphi
DataBind to Close data in Delphi with standard data access components and controls.
-
Access Live Airtable Data in Coginiti Pro
Connect to and query live Airtable data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create a Data Access Object for eBay Data using JDBI
A brief overview of creating a SQL Object API for eBay data in JDBI.
-
Integrating Oracle HCM Cloud Data in Talend Cloud Data Management Platform
Connect Oracle HCM Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle HCM Cloud.
-
Automated Continuous LinkedIn Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LinkedIn Ads data replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy
Connect to Twilio data in MicroStrategy Developer using the CData Software JDBC Driver for Twilio.
-
Integrate Google's Antigravity Agent with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Redshift data using the Model Context Protocol.
-
Use the CData Software JDBC Driver for ConvertKit in MicroStrategy Web
Connect to ConvertKit data in MicroStrategy Web using the CData Software JDBC Driver for ConvertKit.
-
Connect to MYOB AccountRight Data in Ruby
Connect to MYOB AccountRight data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Live REST Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live REST data.
-
Access Live NetSuite SuiteAnalytics Data in Excel 365 Online (Excel for the web)
Connect to NetSuite SuiteAnalytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Easily Query Presto Data in OpenOffice Base
Connect to Presto data in OpenOffice Base using the CData ODBC Driver for Presto and generate reports with live data insights.
-
Analyze Dynamics 365 Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dynamics 365 data in Microsoft R Open.
-
Create Reports with Dotmailer Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Dotmailer data.
-
Create Redshift-Connected Business Apps in AppSheet
Connect to Redshift Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Redshift data.
-
How to Connect to Oracle SCM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle SCM data. Leverage the pyodbc module for ODBC in Python.
-
Use Manus AI to Talk to Your Oracle HCM Cloud 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 Oracle HCM Cloud data.
-
Use the CData Software ODBC Driver for Splunk in SAS for Real-Time Reporting and Analytics
Connect to real-time Splunk data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Splunk.
-
Viewing Facebook Data in RAD Studio Data Explorer
How to view Facebook data in RAD Studio Data Explorer using the CData ODBC Driver for Facebook.
-
How to Build an ETL App for PayPal Data in Python with CData Connect AI
Extract and transform live PayPal data in Python with petl and the CData Connect AI Python SDK.
-
Operational Reporting on ChartMogul Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ChartMogul data.
-
Access Cloudflare Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cloudflare data from HeidiSQL.
-
How to Work with Adobe Target Data in ETL Validator JDBC
Connect to Adobe Target from ETL Validator jobs using the CData Software JDBC Driver.
-
DataBind Microsoft Teams Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Teams with the DevExpress Windows Forms and Web controls to provide Microsoft Teams data to a chart.
-
Link Instantly with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Instantly data in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData JDBC Driver for Tavily
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tavily.
-
Build Visualizations of Sugar CRM Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sugar CRM data in Birst.
-
Import and Visualize Mixpanel Data in Power View
Create data visualizations based on Mixpanel data in Excel.
-
Access Live Box Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Box data through MCP integration.
-
Establish a Live Connection with Clari Data using Tableau Bridge
The CData ODBC Driver for Clari enables you to integrate live Clari data into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time Chargebee Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Chargebee data in ColdFusion.
-
Connect to Neo4J Data in Jaspersoft Studio
Execute SQL to remote Neo4J data in Jaspersoft Studio.
-
LINQ to Wistia 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 Wistia Data Provider.
-
Build a PostgreSQL Interface for ConvertAPI Data using the CData JDBC Driver
Use the Remoting features of the ConvertAPI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Reports with Slack Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Slack data.
-
Getting Started with the CData Excel Add-In for Microsoft Entra ID
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Microsoft Entra ID.
-
Import Google Campaign Manager 360 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Campaign Manager 360 Data and provide access to live Google Campaign Manager 360 data for custom reports in the Power BI Service.
-
Connect to Salesforce Pardot Data in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Pardot in FileMaker Pro to connect to Salesforce Pardot and work with Salesforce Pardot data in your FileMaker applications.
-
Analyze MYOB AccountRight Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MYOB AccountRight data and visualize live MYOB AccountRight data in Infragistics Reveal.
-
How to update QuickBooks from Excel
This article explains how to transfer data from Excel to QuickBooks using the Excel Add-In for QuickBooks.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Phoenix
Provide connectivity to Phoenix data through an SAP BusinessObjects universe.
-
Connect to Avalara AvaTax Data in JRuby
Create a simple JRuby app with access to live Avalara AvaTax data.
-
How to Visualize Ontraport Data in Python with pandas
Use pandas and other modules to analyze and visualize live Ontraport data in Python.
-
Visualize Everhour Data in Tableau
The CData ODBC driver for Everhour enables you integrate Everhour data into Tableau dashboards.
-
Create Data Visualizations Based On Smartsheet Data in Mode
Use CData Connect AI to connect to Smartsheet Data from Mode and build visualizations using live Smartsheet data.
-
Use the CData Software ODBC Driver for Adobe Target in SAS for Real-Time Reporting and Analytics
Connect to real-time Adobe Target data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Adobe Target.
-
How to integrate Metabase with Klaviyo Data
Use CData Connect AI to connect to live Klaviyo data and create an interactive dashboard in Metabase from Klaviyo data.
-
View Reports on Real-Time Testmonitor Data in Power BI Report Server
Use the CData ODBC Driver for Testmonitor to visualize Testmonitor data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Zuora to Databricks using CData SSIS Components.
Easily push Zuora data to Databricks using the CData SSIS Tasks for Zuora and Databricks.