CData Software - Knowledge Base
Recent Articles
-
View Reports on Real-Time OData Services in Power BI Report Server
Use the CData ODBC Driver for OData to visualize OData in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Agno to Talk to Your Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Oracle Financials Cloud for you.
-
Integrate Brex Data in the Pentaho Report Designer
Publish reports based on Brex in the Pentaho BI tool.
-
Add MongoDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for MongoDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Create Power BI Visual Reports with Real-Time Supabase Data
Use CData Power BI Connectors to visualize Supabase in Power BI.
-
Connect to and Visualize Live Parquet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Apache Parquet.
-
How to integrate Gumroad with Apache Airflow
Access and process Gumroad in Apache Airflow using the CData JDBC Driver.
-
Viewing ScrapingBee Data in RAD Studio Data Explorer
How to view ScrapingBee in RAD Studio Data Explorer using the CData ODBC Driver for ScrapingBee.
-
Connect to HBase Data from PowerBuilder via JDBC
This article demonstrates how to access Apache HBase from PowerBuilder using the HBase JDBC Driver.
-
Automate Lakebase Data Replication to SAP HANA
Use CData Sync to customize and automate Lakebase replication to SAP HANA.
-
Automated Continuous Bannerbear Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Bannerbear replication to AlloyDB.
-
Replicate Harvest Data to Multiple Databases
Replicate Harvest to disparate databases with a point-and-click configuration.
-
Create CouchDB-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to CouchDB Data from OutSystems and build custom enterprise apps using live Apache CouchDB.
-
How to connect to Retently Data from Spring Boot
Connect to Retently in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Teamwork Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Teamwork and the SQL Gateway to access Teamwork from Google Apps Script.
-
How to publish and share SFTP Data dashboards with Tableau Server
The CData ODBC driver for SFTP enables you integrate SFTP into Tableau dashboards.
-
Connect to Sage Intacct Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Sage Intacct using standard SQL.
-
Create Apps from NetSuite SuiteAnalytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data and build apps from live NetSuite SuiteAnalytics in Qlik Sense Cloud.
-
Mixpanel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mixpanel facts in real time.
-
Use the CData Software ODBC Driver for CouchDB in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache CouchDB in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for CouchDB.
-
Prepare, Blend, and Analyze Discourse Data in Alteryx Designer (ODBC)
Build workflows to access live Discourse for self-service data analytics.
-
Use Manus AI to Talk to Your Kintone 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 Kintone.
-
Integrate with live Sybase IQ Data in Jitterbit
Use CData Connect AI to connect to and integrate live Sybase IQ in Jitterbit.
-
Access Live Airtable Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Airtable into the statistical analysis tools available in SAS JMP. This article shows how to use Airtable in the Graph Builder and Query Builder.
-
Visualize Live Sendwithus Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sendwithus using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect and Visualize Live Freshservice Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Freshservice into the Databricks platform and create visualization dashboards with real-time Freshservice.
-
Connect to Chargebee from Asprova with CData Software ODBC Driver for Chargebee
This article shows how to connect faster to Chargebee data from Asprova.
-
Getting Started with the CData JDBC Driver for Tanda
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Tanda.
-
How to work with Drip Data in Apache Spark using SQL
Access and process Drip Data in Apache Spark using the CData Software JDBC Driver.
-
Use Databricks Agent Bricks to Talk to Your Greenplum Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Pivotal GreenPlum for you.
-
Getting Started with the CData Tableau Connector for Bright Data
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Build Google Calendar-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Calendar Data and create custom apps in Mendix.
-
Automated Continuous xBase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable xBase replication to AlloyDB.
-
Query Klaviyo Data in DataGrip
Create a Data Source for Klaviyo in DataGrip and use SQL to query live Klaviyo.
-
Analyze Authorize.Net Data in Cognos Analytics
Use CData Connect AI to connect to Authorize.Net Data from Cognos Analytics and analyze live Authorize.Net.
-
Build Tickspot-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Tickspot Data in Gemini Code Assist to assist with building Tickspot-powered applications.
-
Replicate Google Directory Data from PowerShell
Write a quick PowerShell script to query Google Directory. Use connectivity to the live data to replicate Google Directory to SQL Server.
-
Getting Started with the CData Python Connector for Parquet
Learn to install and license the CData Python Connector
-
A PostgreSQL Interface for Sybase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sybase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Parallel Data in HULFT Integrate
Connect to Parallel as a JDBC data source in HULFT Integrate
-
Pipedrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Pipedrive through CData Connect AI using different applications and tools.
-
Access Printful 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 Printful.
-
Troubleshooting Column Size Restrictions in Microsoft Query
Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.
-
How to connect and process Cloudflare from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cloudflare.
-
How to Connect to & Open Onfleet Data in Microsoft Excel
This article uses the CData ODBC driver for Onfleet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect Oracle Sales 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 Oracle Sales data in real time using natural language.
-
Build Visualizations of Cvent Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Cvent in Birst.
-
Using the CData Software ODBC Driver for SAP HANA in PyCharm
Connect to SAP HANA as an ODBC data source in PyCharm using the CData Software ODBC Driver for SAP HANA.
-
Build Apps with Live Invoiced Data Using the Low-Code Development Platform of Mendix
Connect Invoiced with Mendix to build apps using the CData API Driver for JDBC.
-
Use JayDeBeApi to access Outreach.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Outreach.io.
-
Create SSAS Tabular Models from SAP ByDesign Data
How to build a SQL Server Analysis Service Tabular Model from SAP Business ByDesign using CData drivers.
-
Integrate LinkedIn Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn Ads and integrate live LinkedIn Ads into your Power Automate tasks.
-
Build Webex-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Webex Data in Cursor to assist with building Webex-powered applications.
-
Analyze Freshdesk Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Freshdesk and visualize Freshdesk in SAP Analytics Cloud.
-
Deploy the ADO.NET Provider for SendPulse on an SSRS Report Server
Connect to SendPulse 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.
-
How to Connect to & Open MariaDB Data in Microsoft Excel
This article uses the CData ODBC driver for MariaDB to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SSAS Tabular Models from Highrise Data
How to build a SQL Server Analysis Service Tabular Model from Highrise CRM using CData drivers.
-
How to use SQLAlchemy ORM to access Azure DevOps Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure DevOps.
-
How to connect PolyBase to FTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FTP Servers.
-
Model, Search, and Visualize Live SurveyMonkey Data in ThoughtSpot
Use CData Connect AI to connect to live SurveyMonkey for modeling, searching, and visualizing.
-
Connect to Salesforce Data 360 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce Data 360 as an External Source in Dremio.
-
How to Build an ETL App for Avalara AvaTax Data in Python with CData
Create ETL applications and real-time data pipelines for Avalara AvaTax in Python with petl.
-
Visualize Marketo Data in Tableau
The CData ODBC driver for Marketo enables you integrate Marketo into Tableau dashboards.
-
Visualize Live OData Services in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live OData into custom reports in Power BI.
-
Connect to LDAP Objects from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for LDAP to connect to LDAP and execute queries in PowerBuilder.
-
DataBind Controls to Yelp Data in C++Builder
DataBind to Yelp in C++Builder with standard components and controls.
-
Connect to Real-Time Mistral AI Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mistral AI in Power Apps.
-
Visualize Microsoft OneDrive Data in TIBCO Spotfire through ADO.NET
Integrate Microsoft OneDrive into dashboards in TIBCO Spotfire.
-
Use Dash to Build to Web Apps on Microsoft Ads Data
Create Python applications that use pandas and Dash to build Microsoft Ads-connected web apps.
-
How to Query LeadDesk Data in MySQL Workbench
Execute MySQL queries against live LeadDesk from MySQL Workbench.
-
Automated Continuous Greenplum Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Greenplum replication to Google BigQuery.
-
Create Cassandra Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Cassandra from PowerBI.com to create Power BI Dataflows with real-time data.
-
Access Live Square Data in TIBCO Data Virtualization
Use the Square Tibco DV Adapter to create a Square data source in TIBCO Data Virtualization Studio and gain access to live Square from your TDV Server.
-
DataBind Controls to Calendly Data in C++Builder
DataBind to Calendly in C++Builder with standard components and controls.
-
Build AI Agents with Monday.com Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Monday.com through CData Connect AI.
-
Automate Google Analytics Data Replication to SAP HANA
Use CData Sync to customize and automate Google Analytics replication to SAP HANA.
-
Build Data Flows from xBase to SQL Server using SSIS
Easily back up xBase to SQL Server using the SSIS components for xBase.
-
Bind Live ShipStation Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live ShipStation data
-
Create Redis Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Redis from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Workday Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Workday in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Mouseflow Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Mouseflow replication to Google BigQuery.
-
How to Query Asana Data in MySQL Workbench
Execute MySQL queries against live Asana from MySQL Workbench.
-
How to connect to Factorial Data from Spring Boot
Connect to Factorial in a Spring Boot Application using the CData API Driver for JDBC
-
Excel Spreadsheet Automation on QuickBooks Online Data with the QUERY Formula
Pull data from QuickBooks Online, automate spreadsheets, and more with the QUERY formula.
-
ETL iContact in Oracle Data Integrator
This article shows how to transfer iContact into a data warehouse using Oracle Data Integrator.
-
Analyze Sendwithus Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Sendwithus and visualize live Sendwithus in Infragistics Reveal.
-
Migrating data from Productboard to Snowflake using CData SSIS Components.
Easily push Productboard to Snowflake using the CData SSIS Tasks for Productboard and Snowflake.
-
Automated Continuous Nethunt Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Nethunt replication to PostgreSQL.
-
Connect to SAS Data Sets Data in HULFT Integrate
Connect to SAS Data Sets as a JDBC data source in HULFT Integrate
-
Use the CData API Server to Access Apollo Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apollo in the Power Pivot business intelligence tool.
-
Integrating OpenCode Terminal with Google Ads 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 ODBC Driver for Microsoft Teams in Microsoft Power Query
You can use the CData Microsoft Teams ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Microsoft Teams into Microsoft Power Query.
-
Build Automated Jira Assets-Connected Workflows in Zapier
Use CData Connect AI to connect to live Jira Assets and build automated workflows in Zapier.
-
Analyze eBay Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze eBay with the CData JDBC Driver for eBay.
-
Add Mocean Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Mocean with the Informatica Enterprise Data Catalog to classify and organize data.
-
Provide OData Services of Stripe Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Stripe by developing a WCF Service Application.
-
ETL Gmail in Oracle Data Integrator
This article shows how to transfer Gmail into a data warehouse using Oracle Data Integrator.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for BigQuery
Provide connectivity to Google BigQuery through an SAP BusinessObjects universe.
-
Access Live Zoom Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Zoom from your Excel spreadsheets.
-
Migrating data from Testmonitor to Snowflake using CData SSIS Components.
Easily push Testmonitor to Snowflake using the CData SSIS Tasks for Testmonitor and Snowflake.