CData Software - Knowledge Base
Recent Articles
-
Connect to WooCommerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from WooCommerce, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to integrate Supabase with Apache Airflow
Access and process Supabase in Apache Airflow using the CData JDBC Driver.
-
Migrating data from Microsoft Ads to Databricks using CData SSIS Components.
Easily push Microsoft Ads to Databricks using the CData SSIS Tasks for Microsoft Ads and Databricks.
-
Build Snapchat Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Snapchat Ads Data from Zoho Analytics and import live Snapchat Ads.
-
Integrate SAP Concur with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Concur with External Services.
-
Integrating LangChain with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Eloqua within automated workflows.
-
Use Dash to Build to Web Apps on Gmail Data
Create Python applications that use pandas and Dash to build Gmail-connected web apps.
-
Build a Singer.io Tap for Box With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Box data using
-
Visualize Samanage 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 Samanage into TIBCO Spotfire.
-
How to Connect the Power BI Service to PingOne: Complete Guide
Connect to the CData Software Power BI Connector for PingOne from PowerBI.com to provide real-time PingOne across the organization.
-
How to Connect to Live Workday 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 Workday for you.
-
Connect to eBay Analytics Data in RazorSQL
Connect to eBay Analytics from wizards and query eBay Analytics from the GUI in the RazorSQL database management tool.
-
How to integrate AfterShip with Apache Airflow
Access and process AfterShip in Apache Airflow using the CData JDBC Driver.
-
Connect to Oracle Financials Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Financials Cloud as a data source.
-
Analyze SAP HANA Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP HANA in Microsoft R Open.
-
Query Phoenix Data as a SQL Server Database in Node.js
Execute SQL Server queries against Apache Phoenix from Node.js.
-
ETL Avalara AvaTax in Oracle Data Integrator
This article shows how to transfer Avalara AvaTax into a data warehouse using Oracle Data Integrator.
-
How to connect PolyBase to CSV
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CSV/TSV Files.
-
Connect to Testmonitor Data from PowerBuilder via ADO.NET
This article demonstrates how to access Testmonitor from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy
Connect to Google Sheets in MicroStrategy Developer using the CData Software JDBC Driver for Google Sheets.
-
Explore Geographical Relationships in Microsoft Entra ID Data with Power Map
Create data visualizations with Microsoft Entra ID in Power Map.
-
Integrate ConvertKit with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ConvertKit with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ConvertKit.
-
Provide OData Services of Reckon Accounts Hosted Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Reckon Accounts Hosted by developing a WCF Service Application.
-
Integrating Cursor CLI with Active Directory 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.
-
Connect to Google Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Ads Data and connect to Google Ads in Akorbi Digital RunMyProcess.
-
Access Live Harvest Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Harvest in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build AI/ML Models with Live Google Ad Manager Data using Dataiku
Connect Google Ad Manager Data with Dataiku using the CData JDBC Driver for Google Ad Manager.
-
Integrating GitHub Copilot CLI with GitHub 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.
-
Automated Continuous CockroachDB Replication to Oracle
Use CData Sync for automated, continuous, customizable CockroachDB replication to Oracle.
-
Replicate FormSite Data in Heroku for Use in Salesforce Connect
Replicate FormSite to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Explore Geographical Relationships in LeadDesk Data with Power Map
Create data visualizations with LeadDesk in Power Map.
-
Migrating data from Phoenix to Google BigQuery using CData SSIS Components.
Easily push Apache Phoenix to Google BigQuery using the CData SSIS Tasks for Phoenix and Google BigQuery.
-
Build a Simple VCL Application for Parallel Data
How to build a simple VCL Application to view Parallel in RAD Studio using the CData ODBC Driver for Parallel.
-
Automated Continuous Oracle Sales Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Sales replication to SQLite.
-
Integrate Live Excel Online Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Access Live PolarTeamPro Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PolarTeamPro into the statistical analysis tools available in SAS JMP. This article shows how to use PolarTeamPro in the Graph Builder and Query Builder.
-
Analyze Freshdesk Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Freshdesk with the CData JDBC Driver for Freshdesk.
-
Access Live Hive 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 Apache Hive through MCP integration.
-
Build a PostgreSQL Interface for Perplexity Data using the CData JDBC Driver
Use the Remoting features of the Perplexity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live CockroachDB 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 CockroachDB through MCP integration.
-
Visualize Power BI XMLA Data in Sisense
Create an ElastiCube in Sisense app with access to Power BI XMLA.
-
Build Avro-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Avro Data from Zoho Analytics and import live Apache Avro.
-
Manage Bright Data Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bright Data.
-
Create Monday.com-Connected Applications in Appsmith
Connect to Monday.com Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Monday.com.
-
Use Dash to Build to Web Apps on Stack Exchange Data
Create Python applications that use pandas and Dash to build Stack Exchange-connected web apps.
-
Integrating Claude Code with Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Klaviyo within assisted coding and automated development workflows.
-
Build Charts with Zoom Data in Clear Analytics
Create dynamic charts and perform analytics based on Zoom in Clear Analytics.
-
Analyze SAP HANA XS Advanced Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP HANA XS Advanced in Microsoft R Open.
-
Automated Continuous Azure Synapse Replication to SQL Server
Use CData Sync for automated, continuous, customizable Azure Synapse replication to SQL Server.
-
Use the CData Software JDBC Driver for Asana in MicroStrategy Desktop
Connect to Asana in MicroStrategy Desktop using the CData Software JDBC Driver for Asana.
-
Validate Dynamics 365 Data with QuerySurge
Access and validate Microsoft Dynamics 365 in QuerySurge using the CData JDBC Driver.
-
Configure the CData JDBC Driver for BigQuery in a Connection Pool in Tomcat
Connect to Google BigQuery from a connection pool in Tomcat.
-
Automate Parquet Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Parquet replication to SAP HANA.
-
How to Connect Dynamics CRM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Dynamics CRM data in real time using natural language.
-
Access AlloyDB 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 Google AlloyDB.
-
View Reports on Real-Time SAS Data Sets Data in Power BI Report Server
Use the CData ODBC Driver for SAS Data Sets to visualize SAS Data Sets in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate with Contentful Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Contentful to a JSON file on disk.
-
Create Jira-Connected Nintex Workflows
Use CData Connect AI to connect to Jira Data from Nintex Workflow Cloud and build custom workflows using live Atlassian Jira.
-
Connect to Helpscout Data from PowerBuilder via ADO.NET
This article demonstrates how to access Helpscout from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build MVC Applications with Connectivity to SAP HANA XS Advanced Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP HANA XS Advanced from an ASP.NET MVC application.
-
Object-Relational Mapping (ORM) with Oracle Eloqua Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Oracle Eloqua into a Java-based ORM framework, Hibernate.
-
How to update Bitbucket from Excel
This article explains how to transfer data from Excel to Bitbucket using the Excel Add-In for Bitbucket.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LeadDesk
Provide connectivity to LeadDesk through an SAP BusinessObjects universe.
-
Replicate Microsoft Ads Data to Multiple Databases
Replicate Microsoft Ads to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in Dropbox Data with Power Map
Create data visualizations with Dropbox in Power Map.
-
Connect and Query Live Power BI XMLA Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Power BI XMLA into Databricks
-
Excel Spreadsheet Automation on Paddle Data with the QUERY Formula
Pull data from Paddle, automate spreadsheets, and more with the QUERY formula.
-
Import Workday Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Workday. In this article, you will use the OData format to import Workday into Microsoft Power Query.
-
Automated Continuous Google Directory Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Directory replication to PostgreSQL.
-
Connect to LaunchDarkly Data in DBArtisan
Use wizards in DBArtisan to configure LaunchDarkly as a data source.
-
How to Access Spark Data Using Entity Framework
This article shows how to access Apache Spark SQL using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to and Query Bannerbear Data in QlikView over ODBC
Create data visualizations with Bannerbear in QlikView.
-
Analyze Twilio Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Twilio and visualize live Twilio in Infragistics Reveal.
-
Connect AfterShip Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your AfterShip using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish Crystal Reports on Teamgate Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Teamgate.
-
Query SAP Ariba Source Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SAP Ariba Source entities in PHP by modeling them as objects.
-
Enable the SAS xpt JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAS XPORT.
-
Working with Codat Data in LINQPad
Execute LINQ queries to Codat in LINQPad.
-
Access Amazon S3 Data from MySQL in PHP
Connect to Amazon S3 through the standard MySQL libraries in PHP.
-
Query DocuSign Data as a SQL Server Database in Node.js
Execute SQL Server queries against DocuSign from Node.js.
-
Connect to Live Freshservice Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Freshservice in CData Connect AI and connect to your Freshservice from PostgreSQL.
-
Create Data Visualizations Based On SAP ByDesign Data in Mode
Use CData Connect AI to connect to SAP ByDesign Data from Mode and build visualizations using live
-
Create Power BI Reports on Real-Time Printify Data
Use the CData ODBC Driver for Printify to visualize Printify in Power BI Desktop.
-
Create Datasets from Twilio in Domo Workbench and Build Visualizations of Twilio Data in Domo
Use the CData Software ODBC Driver for Twilio to create datasets from Twilio in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with Pushbullet Data in Clear Analytics
Create dynamic charts and perform analytics based on Pushbullet in Clear Analytics.
-
DataBind Controls to Jira Data in C++Builder
DataBind to Atlassian Jira in C++Builder with standard components and controls.
-
Automated Continuous Outreach.io Replication to MySQL
Use CData Sync for automated, continuous, customizable Outreach.io replication to MySQL.
-
Bind Live Teradata Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Teradata data
-
Object-Relational Mapping (ORM) with Rebilly Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Rebilly into a Java-based ORM framework, Hibernate.
-
Integrating Dataiku with Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Splunk.
-
Operational Reporting on Odoo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Odoo ERP.
-
Publish ZeroBounce-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZeroBounce.
-
Connect Dotmailer to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dotmailer with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Open WebUI with Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Sheets from within the chat interface.
-
Getting Started with the CData JDBC Driver for SFTP
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SFTP.
-
Automate Guru Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Guru from PowerShell? This article demonstrates how to utilize the Guru Cmdlets for tasks like connecting to Guru, automating operations, downloading data, and more.
-
Getting Started with the CData Power BI Connector for Invoiced
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Integrate Open WebUI with Live Splunk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Splunk from within the chat interface.
-
Use the CData ODBC Driver for LeadDesk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for LeadDesk to connect to LeadDesk from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring LeadDesk in Excel.
-
Access Opsgenie Data from MySQL in Amazon QuickSight
Connect to Opsgenie and build visualizations of Opsgenie using a MySQL Connection in Amazon QuickSight.