CData Software - Knowledge Base
Recent Articles
-
Import Odoo Data Using Azure Data Factory
Use CData Connect AI to connect to Odoo Data from Azure Data Factory and import live Odoo data.
-
Create Email-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Email Data from Klipfolio and build custom visualizations using live Email data.
-
Import Real-Time Sugar CRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Sugar CRM data in ColdFusion.
-
Connect to Vercel Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Vercel as an External Source in Dremio.
-
Operational Reporting on Greenplum Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Greenplum data.
-
Integrating Antigravity CLI with PabblySubscriptions data via CData CLI
Connect PabblySubscriptions data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect the Power BI Service to Placid: Complete Guide
Connect to the CData Software Power BI Connector for Placid from PowerBI.com to provide real-time Placid data across the organization.
-
Build Pipelines with Live Zoho Books Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Zoho Books from Google Cloud Data Fusion, enabling the integration of live Zoho Books data into the building and management of effective data pipelines.
-
Integrate Cursor with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Paymo data from within the editor.
-
How to Connect to Live NetSuite 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 NetSuite data without replication.
-
Getting Started with the CData Excel Add-In for Humanity
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Humanity.
-
How to connect PolyBase to Zoho Recruit
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Recruit data.
-
Connect to Eventbrite in SpagoBI
Create reports featuring live Eventbrite data in SpagoBI Studio. Host Eventbrite reports on SpagoBI Server.
-
Integrate Theia IDE with Live GraphQL 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 GraphQL data from within the development environment.
-
Integrate Live Bannerbear Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Bannerbear data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to Connect to & Open Zoho Projects Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Projects to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Semantic Layer Views for OData Services in APOS Live Data Gateway
Use the CData Connector for OData in APOS Live Data Gateway to build Semantic Layer Views for OData services.
-
Automate Unbounce Data Replication to SAP HANA
Use CData Sync to customize and automate Unbounce data replication to SAP HANA.
-
Add Mouseflow Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mouseflow with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Asana Data in Pentaho Data Integration
Build ETL pipelines based on Asana data in the Pentaho Data Integration tool.
-
Visualize SurveyMonkey Data in TIBCO Spotfire through ADO.NET
Integrate SurveyMonkey data into dashboards in TIBCO Spotfire.
-
How to create Google Spanner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Spanner data in MySQL .
-
Build Charts with Microsoft Dataverse Data in Clear Analytics
Create dynamic charts and perform analytics based on Microsoft Dataverse data in Clear Analytics.
-
Create Dashboards and Visualize Live Google Campaign Manager 360 Data in Geckoboard
Use CData Connect AI to connect to live Google Campaign Manager 360 data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Publish Printful-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Printful data.
-
How to connect to Sentry Data from Spring Boot
Connect to Sentry in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Open WebUI with Live Phoenix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Phoenix data from within the chat interface.
-
Visualize Unbounce Data in Tableau
The CData ODBC driver for Unbounce enables you integrate Unbounce data into Tableau dashboards.
-
How to Seamlessly Import Lakebase Data into IBM SPSS Modeler
Integrate Lakebase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Sugar CRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Sugar CRM replication to Apache Cassandra.
-
Build Bright Data-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Bright Data Data from Zoho Analytics and import live Bright Data data.
-
Write a Simple Go Application to work with Oracle Eloqua Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle Eloqua data.
-
How to Visualize LinkedIn Ads 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 LinkedIn Ads data in Python.
-
Create Dashboards and Visualize Live ClickUp Data in Geckoboard
Use CData Connect AI to connect to live ClickUp data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create Data Visualizations in Cognos BI with Pipeline CRM Data
Access Pipeline CRM data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate QuickBooks Online Data in Heroku for Use in Salesforce Connect
Replicate QuickBooks Online data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Dynamic Shopify Grids Using the Infragistics XamDataGrid
Learn how you can connect Shopify to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Google Sheets in SpagoBI
Create reports featuring live Google Sheets data in SpagoBI Studio. Host Google Sheets reports on SpagoBI Server.
-
Visualize Live CockroachDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live CockroachDB data into custom reports in Power BI.
-
Build Dashboards with Klaviyo Data in DBxtra
Create dynamic dashboards and perform analytics based on Klaviyo data in DBxtra.
-
Connect to Dropbox Data in RapidMiner
Integrate Dropbox data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrating Antigravity CLI with ChartMogul data via CData CLI
Connect ChartMogul data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connecting Pipedream with Amazon Athena 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 Amazon Athena data in real time.
-
Prepare, Blend, and Analyze Qualaroo Data in Alteryx Designer (ODBC)
Build workflows to access live Qualaroo data for self-service data analytics.
-
Create Active Directory Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Active Directory from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software JDBC Driver for Foursquare in MicroStrategy Desktop
Connect to Foursquare data in MicroStrategy Desktop using the CData Software JDBC Driver for Foursquare.
-
Connect and Visualize Live Avalara AvaTax Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Avalara AvaTax data into the Databricks platform and create visualization dashboards with real-time Avalara AvaTax data.
-
Integrate with Cloudflare Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Cloudflare data to a JSON file on disk.
-
Connect Xero Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Xero data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Active Directory Data Using Azure Data Factory
Use CData Connect AI to connect to Active Directory Data from Azure Data Factory and import live Active Directory data.
-
Connect Hugging Face Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Hugging Face data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Build an ETL App for LDAP Objects in Python with CData
Create ETL applications and real-time data pipelines for LDAP objects in Python with petl.
-
Query, Visualize, and Share live Trello Data in Redash
Use CData Connect AI to connect to live Trello data in Redash for querying, visualizing, and sharing.
-
Connect SAP Netweaver Gateway to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Netweaver Gateway data using the CData Python MCP Server.
-
Explore Geographical Relationships in Email Data with Power Map
Create data visualizations with Email data in Power Map.
-
Analyze Outreach.io Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Outreach.io data and visualize Outreach.io data in SAP Analytics Cloud.
-
Integrate Real-Time Access to AlloyDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to AlloyDB data in real time.
-
Connect to MailerLite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MailerLite as an External Source in Dremio.
-
Analyze Bannerbear Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bannerbear data and visualize Bannerbear data in SAP Analytics Cloud.
-
Connect to Google Sheets Data in NetBeans
Connect to Google Sheets data in NetBeans with the data source configuration wizard.
-
Visualize Monday.com Data in TIBCO Spotfire through ADO.NET
Integrate Monday.com data into dashboards in TIBCO Spotfire.
-
Import Office 365 Data Using Azure Data Factory
Use CData Connect AI to connect to Office 365 Data from Azure Data Factory and import live Office 365 data.
-
Import and Visualize Autopilot Data in Power View
Create data visualizations based on Autopilot data in Excel.
-
How to integrate Metabase with SAP Business One Data
Use CData Connect AI to connect to live SAP Business One data and create an interactive dashboard in Metabase from SAP Business One data.
-
How to Connect to Live PostgreSQL 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 PostgreSQL data for you.
-
How to integrate Aha! with Apache Airflow
Access and process Aha! data in Apache Airflow using the CData JDBC Driver.
-
Integrate Rebilly Data in the Pentaho Report Designer
Publish reports based on Rebilly data in the Pentaho BI tool.
-
Use JayDeBeApi to access Square Data in Python
Use standard Python scripting and the development environment of your choice to access live Square data.
-
How to connect to Rebilly Data from Spring Boot
Connect to Rebilly in a Spring Boot Application using the CData API Driver for JDBC
-
Analyze BenchmarkEmail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for BenchmarkEmail from Power Pivot. You will use the Table Import Wizard to load BenchmarkEmail data. You can visually build the import query or use any SQL supported by the driver.
-
Work with Live SAP HANA Data in Power Query
Use CData Connect AI to connect to SAP HANA data and work with live SAP HANA data in Microsoft Power Query.
-
How to load Foursquare data into Elasticsearch via Logstash
Introducing a simple method to load Foursquare data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to update eBay from Excel
This article explains how to transfer data from Excel to eBay using the Excel Add-In for eBay.
-
Build Oracle Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle data and build visualizations in Tableau.
-
Getting Started with the CData Python Connector for Sugar CRM
Learn to install and license the CData Python Connector and configure a connection to live Sugar CRM data.
-
Connect to Todoist Data in Jaspersoft Studio
Execute SQL to remote Todoist data in Jaspersoft Studio.
-
Connect and Query Live Phoenix Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Phoenix data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to and Visualize Live CapsuleCRM Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CapsuleCRM data.
-
Import Redis Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redis Data and provide access to live Redis data for custom reports in the Power BI Service.
-
Add Azure Data Catalog Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure Data Catalog with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connecting Moonlit Workflow with Zoho Creator Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho Creator data in real time.
-
Bridge Perigon Connectivity with Apache NiFi
Access and process Perigon data in Apache NiFi using the CData JDBC Driver.
-
Integrate EmailOctopus Data in Pentaho Data Integration
Build ETL pipelines based on EmailOctopus data in the Pentaho Data Integration tool.
-
Easily Integrate Salesforce Data 360 Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce Data 360 data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Extract, Transform, and Load Campaigner Data in Informatica PowerCenter
Create a simple Workflow for Campaigner data in Informatica PowerCenter.
-
Create ZohoSubscriptions-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to ZohoSubscriptions Data from OutSystems and build custom enterprise apps using live ZohoSubscriptions data.
-
Connect to Excel Data in RapidMiner
Integrate Excel data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Live MailChimp Data in MicroStrategy through CData Connect AI
Create a live connection to MailChimp Data in CData Connect AI and connect to your MailChimp data from MicroStrategy.
-
Use the CData Software ODBC Driver for Keap in MicroStrategy Desktop
Connect to Keap data in MicroStrategy Desktop using the CData Software ODBC Driver for Keap.
-
Connect to MarkLogic Data from PowerBuilder via JDBC
This article demonstrates how to access MarkLogic data from PowerBuilder using the MarkLogic JDBC Driver.
-
Getting Started with the CData Tableau Connector for Close
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Dashboards with Figshare Data in Dundas BI
Create dynamic dashboards and perform analytics based on Figshare data in Dundas BI.
-
Seamlessly Bring Active Directory Data into Retool Using CData Connect AI
Integrate Active Directory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Visualizations of VWO Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of VWO data in Birst.
-
How to connect SharePoint with Blackbaud FE NXT Data through external lists
Provide Blackbaud FE NXT data to SharePoint users as an external list.
-
Using the CData Software ODBC Driver for ZohoExpense in PyCharm
Connect to ZohoExpense as an ODBC data source in PyCharm using the CData Software ODBC Driver for ZohoExpense.
-
Add TigerGraph Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for TigerGraph with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate with Wave Financial Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Wave Financial data to a JSON file on disk.
-
Visualize Live ZeroBounce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZeroBounce data.
-
Connect to Notion Data in RazorSQL
Connect to Notion from wizards and query Notion data from the GUI in the RazorSQL database management tool.