CData Software - Knowledge Base
Recent Articles
-
How to Query Live Blackbaud FE NXT Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Blackbaud FE NXT data in natural language using Python.
-
Use the CData ODBC Driver for Confluence in Microsoft Power Query
You can use the CData Confluence ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Atlassian Confluence into Microsoft Power Query.
-
Analyze Aweber Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Aweber from Power Pivot. You will use the Table Import Wizard to load Aweber. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Google Contacts Data in Excel 365 Online (Excel for the web)
Connect to Google Contacts from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect to & Open Avaza Data in Microsoft Excel
This article uses the CData ODBC driver for Avaza to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Work with Recurly Data in FoxPro
Load Recurly into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to MySQL Data in CloverDX (formerly CloverETL)
Transfer MySQL using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData Power BI Connector for BambooHR
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrating LangChain with Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle HCM Cloud within automated workflows.
-
Automated Continuous Freshsales Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Freshsales replication to Apache Cassandra.
-
Create SSAS Tabular Models from ChartMogul Data
How to build a SQL Server Analysis Service Tabular Model from ChartMogul using CData drivers.
-
How to Connect to Live Tally Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Tally ERP for you.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Analytics to Power BI dashboards. Simply drag and drop Google Analytics into data visuals on the Power BI canvas.
-
Prepare, Blend, and Analyze WooCommerce Data in Alteryx Designer (ODBC)
Build workflows to access live WooCommerce for self-service data analytics.
-
Connect to Google Sheets Data in Ruby
Connect to Google Sheets in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Timely Data from PowerBuilder via ADO.NET
This article demonstrates how to access Timely from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Connect to Blackbaud FE NXT Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Blackbaud FE NXT and the SQL Gateway to access Blackbaud FE NXT from Google Apps Script.
-
Integrating Claude Code CLI with HubDB 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.
-
Use the CData Software JDBC Driver for SAP Business One in MicroStrategy
Connect to SAP Business One in MicroStrategy Developer using the CData Software JDBC Driver for SAP Business One.
-
Visualize Airtable Data in TIBCO Spotfire through OData
Integrate Airtable into dashboards in TIBCO Spotfire.
-
Use Dash to Build to Web Apps on MailChimp Data
Create Python applications that use pandas and Dash to build MailChimp-connected web apps.
-
Edit and Search Oracle Eloqua Reporting External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Oracle Eloqua Reporting to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Oracle Eloqua Reporting objects that you can access from apps and the dashboard.
-
Integrate Google Calendar with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Google Calendar with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Google Calendar.
-
Analyze Strava Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Strava from Power Pivot. You will use the Table Import Wizard to load Strava. You can visually build the import query or use any SQL supported by the driver.
-
Use Claude to Talk to Your Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Procore for you.
-
Integrate Salesforce CRM Analytics Data into Power Automate Desktop using CData Connect
CData Connect for Salesforce CRM Analytics Data enables you to integrate Salesforce CRM Analytics into workflows built using Microsoft Power Automate Desktop.
-
Connect to Missive Data in DBArtisan
Use wizards in DBArtisan to configure Missive as a data source.
-
Use the CData Software ODBC Driver for DB2 in SAS for Real-Time Reporting and Analytics
Connect to real-time IBM DB2 in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for DB2.
-
How to connect and process SendGrid from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SendGrid.
-
Build Agents in Relevance AI with Access to Live IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Cloud Object Storage within intelligent agent workflows.
-
How to Build an ETL App for Rebilly Data in Python with CData
Create ETL applications and real-time data pipelines for Rebilly in Python with petl.
-
Automated Continuous Elasticsearch Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Elasticsearch replication to delimited files (CSV/TSV).
-
Connect to ElevenLabs Data in HULFT Integrate
Connect to ElevenLabs as a JDBC data source in HULFT Integrate
-
Connect to Odoo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Odoo ERP in Airbyte.
-
Getting Started with the CData Excel Add-In for Gong
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Gong.
-
Automated Continuous SendPulse Replication to Oracle
Use CData Sync for automated, continuous, customizable SendPulse replication to Oracle.
-
Build Charts with Reckon Data in Clear Analytics
Create dynamic charts and perform analytics based on Reckon in Clear Analytics.
-
Visualize Live Adobe Experience Manager Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Adobe Experience Manager using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build MVC Applications with Connectivity to Guru Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Guru from an ASP.NET MVC application.
-
Connect to Real-Time Autopilot Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Autopilot in Power Apps.
-
Automated Continuous Opsgenie Replication to SQL Server
Use CData Sync for automated, continuous, customizable Opsgenie replication to SQL Server.
-
Access Live Google Sheets 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 Google Sheets through MCP integration.
-
Access Live MySQL Data in Coginiti Pro
Connect to and query live MySQL from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Multiple SAP Fieldglass Accounts via the CData Sync CLI
Replicate multiple SAP Fieldglass accounts to one or many databases.
-
Viewing WordPress Data in RAD Studio Data Explorer
How to view WordPress in RAD Studio Data Explorer using the CData ODBC Driver for WordPress.
-
Getting Started with the CData SSIS Components for Paymo
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Paymo.
-
Create Reports from Oracle Financials Cloud Data in Looker Studio
Use CData Connect AI to gain access to live Oracle Financials Cloud and create custom reports in Looker Studio.
-
Connect to MessageBird Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time MessageBird using standard SQL.
-
Access Live Airtable Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Airtable through MCP integration.
-
Consume Microsoft Ads OData Feeds in PowerBuilder
This article demonstrates how to consume Microsoft Ads as OData feeds from PowerBuilder using the API Server.
-
Build Data Flows from SQL Server to Zoho Projects through SSIS
Easily push SQL Server data to Zoho Projects using the CData SSIS Tasks for Zoho Projects.
-
Integrating GitHub Copilot CLI with Jumpseller 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.
-
Connect to and Query Excel Data in QlikView over ODBC
Create data visualizations with Microsoft Excel in QlikView.
-
How to Work with Oracle Data in AWS Glue Jobs Using JDBC
Connect to Oracle from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous Avro Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Avro replication to delimited files (CSV/TSV).
-
Use the CData Software JDBC Driver for OData in MicroStrategy
Connect to OData in MicroStrategy Developer using the CData Software JDBC Driver for OData.
-
Connect to Redis Data from PowerBuilder via JDBC
This article demonstrates how to access Redis from PowerBuilder using the Redis JDBC Driver.
-
Build Visualizations of Foursquare Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Foursquare in Birst.
-
Connect to Float Data in NetBeans
Connect to Float in NetBeans with the data source configuration wizard.
-
Connect to Yelp Data in NetBeans
Connect to Yelp in NetBeans with the data source configuration wizard.
-
Postmark Reporting in OBIEE with the Postmark JDBC Driver
Deploy the Postmark JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Analyze Parquet Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Apache Parquet with the CData JDBC Driver for Parquet.
-
Import Real-Time Discord Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Discord in ColdFusion.
-
Query WooCommerce Data in DataGrip
Create a Data Source for WooCommerce in DataGrip and use SQL to query live WooCommerce.
-
Import Zoho Creator Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Zoho Creator Data and provide access to live Zoho Creator for custom reports in the Power BI Service.
-
Use the CData Software ODBC Driver for Paymo in MicroStrategy Web
Connect to Paymo in MicroStrategy Web using the CData Software ODBC Driver for Paymo.
-
Build Dashboards with Invoiced Data in DBxtra
Create dynamic dashboards and perform analytics based on Invoiced in DBxtra.
-
Integrate with live Azure Data Lake Storage Data in Jitterbit
Use CData Connect AI to connect to and integrate live Azure Data Lake Storage in Jitterbit.
-
Visualize Live Square Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Square.
-
Work with Short.io Data in FoxPro
Load Short.io into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous Trello Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Trello replication to Apache Kafka.
-
How to Connect to Live Splunk 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 Splunk for you.
-
How to create an RPA flow for DocuSign Data in UiPath Studio
Use the DocuSign ODBC Driver to create workflows that access real-time DocuSign without any coding.
-
Automated Continuous Mouseflow Replication to Databricks
Use CData Sync for automated, continuous, customizable Mouseflow replication to Databricks.
-
Query, Visualize, and Share live Google Contacts Data in Redash
Use CData Connect AI to connect to live Google Contacts in Redash for querying, visualizing, and sharing.
-
Visualize Live Google Directory Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google Directory.
-
Viewing FormSite Data in RAD Studio Data Explorer
How to view FormSite in RAD Studio Data Explorer using the CData ODBC Driver for FormSite.
-
Publish Jira Assets-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Jira Assets.
-
Automate Access Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Access replication to Azure Synapse.
-
Choosing the Best Method to Connect SAS xpt to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAS XPORT from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software JDBC Driver for Clockify in MicroStrategy
Connect to Clockify in MicroStrategy Developer using the CData Software JDBC Driver for Clockify.
-
Connect to Freshservice Data from a Connection Pool in Jetty
The Freshservice JDBC Driver supports connection pooling: This article shows how to connect faster to Freshservice from Web apps in Jetty.
-
Connect Supabase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Supabase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Sage 200 Data in Pentaho Data Integration
Build ETL pipelines based on Sage 200 in the Pentaho Data Integration tool.
-
Integrate Telegram with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Telegram with External Services.
-
Visualize Productboard 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 Productboard into TIBCO Spotfire.
-
Integrate with Reckon Accounts Hosted Data in JReport Designer
Create charts and reports based on Reckon Accounts Hosted in JReport Designer.
-
Connect to PhantomBuster Data in NetBeans
Connect to PhantomBuster in NetBeans with the data source configuration wizard.
-
Build TaxJar-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to TaxJar and build web apps with connectivity to live TaxJar.
-
Connect to ChargeOver Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ChargeOver as an External Source in Dremio.
-
Connect to Zuora Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zuora using standard SQL.
-
How to publish and share SendPulse Data dashboards with Tableau Server
The CData ODBC driver for SendPulse enables you integrate SendPulse into Tableau dashboards.
-
Use Microsoft Copilot Studio to talk to your MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your MarkLogic for you.
-
Build Apps with Live Salesforce Marketing Cloud in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce Marketing Cloud into the Adalo platform and build custom mobile and web applications with real-time Salesforce Marketing Cloud.
-
Connect to SQL Server Data from a Connection Pool in Jetty
The SQL Server JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft SQL Server from Web apps in Jetty.
-
Connect SAP BusinessObjects BI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP BusinessObjects BI with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Intercom in SpagoBI
Create reports featuring live Intercom in SpagoBI Studio. Host Intercom reports on SpagoBI Server.
-
Connect to Optimizely Data in DBeaver
Use the CData ODBC Driver to connect to Optimizely in DBeaver.
-
Publish Tickspot-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Tickspot.
-
Use the CData Software JDBC Driver for Bitly in MicroStrategy Desktop
Connect to Bitly in MicroStrategy Desktop using the CData Software JDBC Driver for Bitly.