CData Software - Knowledge Base
Recent Articles
-
Validate eBay Analytics Data with QuerySurge
Access and validate eBay Analytics in QuerySurge using the CData JDBC Driver.
-
Replicate Multiple ZohoExpense Accounts via the CData Sync CLI
Replicate multiple ZohoExpense accounts to one or many databases.
-
How to Connect to & Open MailChimp Data in Microsoft Excel
This article uses the CData ODBC driver for MailChimp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Figshare Data Replication to Couchbase
Use CData Sync to Customize and automate Figshare replication to Couchbase.
-
Build Microsoft Dataverse-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Microsoft Dataverse (CDS).
-
Access Live Salesforce Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce & Force.com from your Excel spreadsheets.
-
How to Visualize Cloudant Data in Python with pandas
Use pandas and other modules to analyze and visualize live IBM Cloudant in Python.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Atlassian Confluence using the Model Context Protocol.
-
Create Dynamic FHIR Grids Using the Infragistics XamDataGrid
Learn how you can connect FHIR to Infragistics XamDataGrid to build dynamic grids.
-
Integrating Antigravity CLI with Facebook Ads via CData CLI
Connect Facebook Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to SAP HANA Data in RazorSQL
Connect to SAP HANA from wizards and query SAP HANA from the GUI in the RazorSQL database management tool.
-
Build AI/ML Models with Live BambooHR Data using Dataiku
Connect BambooHR Data with Dataiku using the CData API Driver for JDBC.
-
How to Create Power BI Visual Reports with Real-Time Greenhouse Data
Use CData Power BI Connectors to visualize Greenhouse in Power BI.
-
Connect to Autopilot Data in HULFT Integrate
Connect to Autopilot as a JDBC data source in HULFT Integrate
-
Build Data Flows from Templated to SQL Server using SSIS
Easily back up Templated to SQL Server using the SSIS components for Templated.
-
Access Live Microsoft Dataverse Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Dataverse (CDS) from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Real-Time LinkedIn Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for LinkedIn and Dataflow to import and use LinkedIn in Power Apps.
-
Access Templated Data from MySQL in Amazon QuickSight
Connect to Templated and build visualizations of Templated using a MySQL Connection in Amazon QuickSight.
-
Query Live Spark 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 Apache Spark SQL directly from the development environment.
-
Build Certinia Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Certinia and build visualizations in Tableau.
-
Visualize ZarMoney Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load ZarMoney into TIBCO Spotfire.
-
Create SSAS Tabular Models from Salesforce Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce & Force.com using CData drivers.
-
Replicate ZohoInvoice Data to Multiple Databases
Replicate ZohoInvoice to disparate databases with a point-and-click configuration.
-
Create Google Drive Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Drive from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData API Server to Access Cosmos DB Data in Microsoft PowerPivot
Use the CData API Server to connect to live Azure Cosmos DB in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Excel in MicroStrategy Web
Connect to Microsoft Excel in MicroStrategy Web using the CData Software ODBC Driver for Excel.
-
Access Live SurveyMonkey 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 SurveyMonkey through MCP integration.
-
Connect to Real-Time Hacker News Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Hacker News in Power Apps.
-
Create SSAS Tabular Models from JotForm Data
How to build a SQL Server Analysis Service Tabular Model from JotForm using CData drivers.
-
Connect to Outreach.io Data in DBeaver
Use the CData ODBC Driver to connect to Outreach.io in DBeaver.
-
Automated Continuous Lakebase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Lakebase replication to Amazon Redshift.
-
Automated Continuous VWO Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable VWO replication to Azure SQL Database.
-
Integrate Cursor with Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ActiveCampaign from within the editor.
-
How to use SQLAlchemy ORM to access CouchDB Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Apache CouchDB.
-
Build Semantic Layer Views for Missive Data in APOS Live Data Gateway
Use the CData Connector for Missive in APOS Live Data Gateway to build Semantic Layer Views for Missive.
-
Build Google Tasks-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Google Tasks and build web apps with connectivity to live Google Tasks.
-
Create Informatica Mappings From/To a JDBC Data Source for OData
Create OData data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live BigQuery Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google BigQuery from your Google Sheets.
-
Build a Simple VCL Application for Shopify Data
How to build a simple VCL Application to view Shopify in RAD Studio using the CData ODBC Driver for Shopify.
-
Bridge Bullhorn CRM Connectivity with Apache NiFi
Access and process Bullhorn CRM in Apache NiFi using the CData JDBC Driver.
-
Connecting Mastra with Spark 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 Spark SQL, no replication required.
-
Replicate Multiple Databricks Accounts
Replicate multiple Databricks accounts to one or many databases.
-
Integrating Kiro CLI with Presto 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 with Live Google Analytics Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Analytics from the MuleSoft Anypoint Platform to integrate live Google Analytics into custom reports and dashboards.
-
Deploy the ADO.NET Provider for Avalara AvaTax on an SSRS Report Server
Connect to Avalara AvaTax 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.
-
Visualize Oracle Eloqua Reporting Data in TIBCO Spotfire through OData
Integrate Oracle Eloqua Reporting into dashboards in TIBCO Spotfire.
-
How to Work with Clockify Data in ETL Validator JDBC
Connect to Clockify from ETL Validator jobs using the CData Software JDBC Driver.
-
Establish a Live Connection with ADP Data using Tableau Bridge
The CData ODBC Driver for ADP enables you to integrate live ADP into Tableau Cloud dashboards using the Tableau Bridge.
-
Import Real-Time Demio Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Demio in ColdFusion.
-
How to connect to Slack Data with Squirrel SQL client
Connect to Slack and execute queries in the Squirrel SQL Client.
-
Edit and Search External SurveyMonkey Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SurveyMonkey 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.
-
Explore Geographical Relationships in Google Tasks Data with Power Map
Create data visualizations with Google Tasks in Power Map.
-
Use the CData Software ODBC Driver for Redshift in MicroStrategy
Connect to Amazon Redshift in MicroStrategy Developer using the CData Software ODBC Driver for Redshift.
-
How to connect SharePoint with Reckon Accounts Hosted Data through external lists
Provide Reckon Accounts Hosted to SharePoint users as an external list.
-
Viewing Clari Data in RAD Studio Data Explorer
How to view Clari in RAD Studio Data Explorer using the CData ODBC Driver for Clari.
-
Integrate Attio with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Attio with External Services.
-
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 Mistral AI Data from Spring Boot
Connect to Mistral AI in a Spring Boot Application using the CData API Driver for JDBC
-
Use Manus AI to Talk to Your GitLab 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 GitLab.
-
Access Bitbucket Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Bitbucket from your Oracle system.
-
Connect to Real-Time JobNimbus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use JobNimbus in Power Apps.
-
Connect to Live SQL Analysis Services Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SQL Analysis Services in CData Connect AI and connect to your SQL Analysis Services from PostgreSQL.
-
Analyze ClickUp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ClickUp in Microsoft R Open.
-
Enable the MySQL JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with MySQL.
-
Automate Redis Data Replication to Azure Data Lake
Use CData Sync to customize and automate Redis replication to Azure Data Lake.
-
Feed Harvest Data into FineReport
How to set Harvest as a JDBC data source in FineReport.
-
Build Excel-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft Excel.
-
How to Connect DBeaver to HubSpot via a JDBC Driver
Manage HubSpot with visual tools in DBeaver like the query browser.
-
Visualize Rebilly Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Rebilly.
-
Using the CData Software ODBC Driver for ChargeOver in PyCharm
Connect to ChargeOver as an ODBC data source in PyCharm using the CData Software ODBC Driver for ChargeOver.
-
Provide OData Services of Nuclia Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Nuclia by developing a WCF Service Application.
-
Access Rootly Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Rootly from your Oracle system.
-
Integrating Antigravity CLI with LaunchDarkly via CData CLI
Connect LaunchDarkly to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Simple VCL Application for Mailgun Data
How to build a simple VCL Application to view Mailgun in RAD Studio using the CData ODBC Driver for Mailgun.
-
Explore Geographical Relationships in RabbitMQ Data with Power Map
Create data visualizations with RabbitMQ in Power Map.
-
Integrate Amplitude Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amplitude from Informatica Cloud.
-
Build MVC Applications with Connectivity to Salesforce CRM Analytics Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesforce CRM Analytics from an ASP.NET MVC application.
-
Use Dash to Build Web Apps on Oracle Sales Data via CData Connect AI
Build interactive Dash web apps on live Oracle Sales using pandas and the CData Connect AI Python SDK.
-
Enable the ServiceDesk Plus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ServiceDesk Plus.
-
Extract, Transform, and Load Box Data in Informatica PowerCenter
Create a simple Workflow for Box in Informatica PowerCenter.
-
Automated Continuous Opsgenie Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Opsgenie replication to delimited files (CSV/TSV).
-
Operational Reporting on Deel Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Deel.
-
Build Dashboards with Bullhorn CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Bullhorn CRM in DBxtra.
-
Extract, Transform, and Load Exact Online Data in Informatica PowerCenter
Create a simple Workflow for Exact Online in Informatica PowerCenter.
-
Analyze Azure Table Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Table Storage and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Automate Google Spanner Data Replication to Couchbase
Use CData Sync to Customize and automate Google Spanner replication to Couchbase.
-
Migrating data from Google Ad Manager to Databricks using CData SSIS Components.
Easily push Google Ad Manager to Databricks using the CData SSIS Tasks for Google Ad Manager and Databricks.
-
Visualize Live Dynamics NAV Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Dynamics NAV.
-
Connect to FreshBooks Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for FreshBooks in Airbyte.
-
Build Dashboards with Zoho Creator Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Creator in DBxtra.
-
Create SSAS Tabular Models from Foursquare Data
How to build a SQL Server Analysis Service Tabular Model from Foursquare using CData drivers.
-
Create Reports from Slack Data in Looker Studio
Use CData Connect AI to gain access to live Slack and create custom reports in Looker Studio.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Ads to SQL Server.
-
Connect to BenchmarkEmail Data from PowerBuilder via JDBC
This article demonstrates how to access BenchmarkEmail from PowerBuilder using the BenchmarkEmail JDBC Driver.
-
How to connect to Airtable Data from IntelliJ
Integrate connectivity to Airtable with wizards in IntelliJ.
-
Connect to HBase in SpagoBI
Create reports featuring live Apache HBase in SpagoBI Studio. Host HBase reports on SpagoBI Server.
-
Build Dashboards with SAP Fieldglass Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Fieldglass in Dundas BI.
-
Creating Redis-Connected Applications in Unqork
You can use CData Connect AI to feed Redis to Unqork and build custom business apps.
-
Natively Connect to SAS xpt Data in PHP
The CData ODBC driver for SAS xpt enables you to create PHP applications with connectivity to SAS XPORT. Leverage the native support for ODBC in PHP.
-
Access Aha! Data from MySQL in PHP
Connect to Aha! through the standard MySQL libraries in PHP.