CData Software - Knowledge Base
Recent Articles
-
Build Power BI XMLA-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Power BI XMLA to explore live Power BI XMLA Data in Claude Code to assist with building Power BI XMLA-powered applications.
-
Build an OLAP Cube in SSAS from Optimizely Data
Establish a connection to Optimizely data from SQL Server Analysis Services, and use the Optimizely Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to PDFMonkey Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PDFMonkey using standard SQL.
-
Create SSAS Tabular Models from Webex Data
How to build a SQL Server Analysis Service Tabular Model from Webex using CData drivers.
-
Connect Oracle Sales to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Oracle Sales with IBM WebSphere for seamless data integration and connectivity.
-
Connect to LeadDesk Data in HULFT Integrate
Connect to LeadDesk as a JDBC data source in HULFT Integrate
-
Connect to Google Tasks Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Tasks.
-
Integrating Cursor CLI with BenchmarkEmail 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Flowlu
Create an ODBC connection to Flowlu in Informatica and browse and transfer Flowlu.
-
A PostgreSQL Interface for Attio Data using the CData ODBC Driver
Use the SQL Gateway and Attio ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build a PostgreSQL Interface for Postmark Data using the CData JDBC Driver
Use the Remoting features of the Postmark JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze MailChimp Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MailChimp in Microsoft R Open.
-
Bind Live Microsoft OneDrive Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft OneDrive data
-
Build Raisers Edge NXT-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Raisers Edge NXT to explore live Raisers Edge NXT Data in Gemini Code Assist to assist with building Raisers Edge NXT-powered applications.
-
Analyze Sybase IQ Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sybase IQ in Microsoft R Open.
-
View Reports on Real-Time Webflow Data in Power BI Report Server
Use the CData ODBC Driver for Webflow to visualize Webflow in Power BI Desktop and then publish them to Power BI Report Server.
-
Getting Started with the CData Excel Add-In for Contentful
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Contentful.
-
Integrating Kiro CLI with iContact 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 ODBC Driver for Freshservice in MicroStrategy
Connect to Freshservice in MicroStrategy Developer using the CData Software ODBC Driver for Freshservice.
-
Visualize Live Google Drive Data in the Power BI Service
Use CData Connect AI to connect to live Google Drive and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to QuickBooks Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the QuickBooks Data Provider.
-
Natively Connect to Parquet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Parquet. Leverage the native support for ODBC in PHP.
-
Use the CData Software ODBC Driver for Jumpseller in MicroStrategy
Connect to Jumpseller in MicroStrategy Developer using the CData Software ODBC Driver for Jumpseller.
-
Enable the Oracle Sales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle Sales.
-
Provide OData Services of Gorgias Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gorgias by developing a WCF Service Application.
-
How to Build an ETL App for OData Services in Python with CData
Create ETL applications and real-time data pipelines for OData in Python with petl.
-
Integrate Bannerbear Data in the Pentaho Report Designer
Publish reports based on Bannerbear in the Pentaho BI tool.
-
How to Access Live Timely Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Timely enables you to integrate Timely into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Kintone Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Kintone replication to Amazon Redshift.
-
Visualize Amazon S3 Data in Tableau
The CData ODBC driver for Amazon S3 enables you integrate Amazon S3 into Tableau dashboards.
-
Automated Continuous Facebook Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Facebook replication to AlloyDB.
-
How to Connect to BigCommerce Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to BigCommerce. Leverage the pyodbc module for ODBC in Python.
-
Bridge Discord Connectivity with Apache NiFi
Access and process Discord in Apache NiFi using the CData JDBC Driver.
-
Query BambooHR Data as a SQL Server Database in Node.js
Execute SQL Server queries against BambooHR from Node.js.
-
Integrating Codex CLI with GraphQL 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.
-
How to Connect to Live FHIR Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your FHIR for you.
-
Visualize Live Monday.com Data in the Power BI Service
Use CData Connect AI to connect to live Monday.com and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create Apify federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apify in MySQL .
-
Build Dashboards with Toggl Data in DBxtra
Create dynamic dashboards and perform analytics based on Toggl in DBxtra.
-
GetResponse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GetResponse facts in real time.
-
Build ADP-Connected Apps in Choreo
Use CData Connect AI to connect to ADP Data from Choreo and build custom apps using live ADP.
-
Integrate Vercel Data in the Pentaho Report Designer
Publish reports based on Vercel in the Pentaho BI tool.
-
Import Real-Time Asana Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Asana in ColdFusion.
-
Getting Started with the CData ADO.NET Provider for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Authorize.Net.
-
Write a Simple Go Application to work with ShipEngine Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipEngine.
-
How to connect to Google Campaign Manager 360 Data from IntelliJ
Integrate connectivity to Google Campaign Manager 360 with wizards in IntelliJ.
-
Getting Started with the CData Python Connector for Omnisend
Learn to install and license the CData Python Connector
-
How to Connect the Power BI Service to Planio: Complete Guide
Connect to the CData Software Power BI Connector for Planio from PowerBI.com to provide real-time Planio across the organization.
-
Build Data Flows from Instagram to SQL Server using SSIS
Easily back up Instagram to SQL Server using the SSIS components for Instagram.
-
Connect to Eventbrite Data in Jaspersoft Studio
Execute SQL to remote Eventbrite in Jaspersoft Studio.
-
Create Reports with eBay Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay.
-
LINQ to Discord Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Discord Data Provider.
-
How to Easily Query HCL Domino Data in OpenOffice Base
Connect to HCL Domino data in OpenOffice Base using the CData ODBC Driver for HCL Domino and generate reports with live data insights.
-
Use the CData Software ODBC Driver for Bright Data in MicroStrategy
Connect to Bright Data in MicroStrategy Developer using the CData Software ODBC Driver for Bright Data.
-
Build Semantic Layer Views for Square Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Square.
-
How to Query Live Parquet Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Apache Parquet data in natural language using Python.
-
How to Work with HBase Data in AWS Glue Jobs Using JDBC
Connect to HBase from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Automated Continuous GitLab Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable GitLab replication to Amazon Redshift.
-
Build Dashboards with GitLab Data in DBxtra
Create dynamic dashboards and perform analytics based on GitLab in DBxtra.
-
Integrating Claude Code CLI with Optimizely 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 Missive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Missive with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Avro Data in Looker
Use CData Connect AI to connect to Avro Data from Looker and build custom apps using live Apache Avro.
-
Analyze ActiveCampaign Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of ActiveCampaign and visualize live ActiveCampaign in Infragistics Reveal.
-
Connect to Shopify in SpagoBI
Create reports featuring live Shopify in SpagoBI Studio. Host Shopify reports on SpagoBI Server.
-
How to Connect to Live Presto 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 Presto for you.
-
How to integrate SAP Hybris C4C with Apache Airflow
Access and process SAP Hybris C4C in Apache Airflow using the CData JDBC Driver.
-
Connect to Salesforce CRM Analytics Data in NetBeans
Connect to Salesforce CRM Analytics in NetBeans with the data source configuration wizard.
-
Integrate Quickbase Data into Power Automate Desktop using CData Connect
CData Connect for Quickbase Data enables you to integrate Quickbase into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software JDBC Driver for Freshsales in MicroStrategy Desktop
Connect to Freshsales in MicroStrategy Desktop using the CData Software JDBC Driver for Freshsales.
-
Viewing Foursquare Data in RAD Studio Data Explorer
How to view Foursquare in RAD Studio Data Explorer using the CData ODBC Driver for Foursquare.
-
Connect to Browserless Data in RazorSQL
Connect to Browserless from wizards and query Browserless from the GUI in the RazorSQL database management tool.
-
Use Manus AI to Talk to Your Google Drive 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 Google Drive.
-
Build Semantic Layer Views for PhantomBuster Data in APOS Live Data Gateway
Use the CData Connector for PhantomBuster in APOS Live Data Gateway to build Semantic Layer Views for PhantomBuster.
-
Connect to Google Calendar Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Google Calendar Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Analyze SingleStore Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SingleStore and visualize live SingleStore in Infragistics Reveal.
-
Integrating Kiro CLI with SAP Ariba Procurement 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 Dash to Build to Web Apps on HDFS Data
Create Python applications that use pandas and Dash to build HDFS-connected web apps.
-
Automated Continuous Unbounce Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Unbounce replication to Google Cloud SQL.
-
Automate Exact Online Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Exact Online from PowerShell? This article demonstrates how to utilize the Exact Online Cmdlets for tasks like connecting to Exact Online, automating operations, downloading data, and more.
-
Automate CSV Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live CSV/TSV Files and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Build MVC Applications with Connectivity to Retently Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Retently from an ASP.NET MVC application.
-
Process & Analyze Facebook Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Facebook Data.
-
How to Connect to Live Sugar CRM 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 Sugar CRM for you.
-
Connect to Zendesk Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zendesk as an External Source in Dremio.
-
Access Live OData Services in AWS Lambda
Connect to live OData in AWS Lambda using the CData JDBC Driver.
-
How to import NASA Data into Apache Solr
Use the CData Software JDBC Driver for NASA in Data Import Handler and create an automated import of NASA to Apache Solr Enterprise Search platform.
-
Replicate Jodoo Data in Heroku for Use in Salesforce Connect
Replicate Jodoo to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Presto Replication to Vertica
Use CData Sync for automated, continuous, customizable Presto replication to Vertica.
-
How to Connect Flowise AI Agents to Live SAP Concur Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live SAP Concur without replication.
-
Access Live Zoho Inventory Data in AWS Lambda
Connect to live Zoho Inventory in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Azure Table in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure Table Storage in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure Table.
-
DataBind Controls to Tally Data in C++Builder
DataBind to Tally ERP in C++Builder with standard components and controls.
-
Connect Hive Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Hive using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData Software JDBC Driver for Wave Financial in MicroStrategy
Connect to Wave Financial in MicroStrategy Developer using the CData Software JDBC Driver for Wave Financial.
-
Rapidly Develop Slack-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Slack.
-
Integrating LlamaIndex with SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Business ByDesign in real time.
-
Validate Omnisend Data with QuerySurge
Access and validate Omnisend in QuerySurge using the CData JDBC Driver.
-
Visualize Brex 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 Brex into TIBCO Spotfire.
-
Getting Started with the CData Python Connector for Adobe Commerce
Learn to install and license the CData Python Connector
-
Explore Geographical Relationships in Pinecone Data with Power Map
Create data visualizations with Pinecone in Power Map.