CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Foursquare Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Foursquare in ColdFusion.
-
How to connect to Stack Exchange Data from IntelliJ
Integrate connectivity to Stack Exchange with wizards in IntelliJ.
-
Edit and Search Perplexity External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Perplexity to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Perplexity objects that you can access from apps and the dashboard.
-
Build ZohoMarketingHub-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live ZohoMarketingHub Data in Cursor to assist with building ZohoMarketingHub-powered applications.
-
Build ServiceNow-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to ServiceNow Data from Zoho Analytics and import live ServiceNow.
-
Access Live Telegram Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Telegram data source in TIBCO Data Virtualization Studio and gain access to live Telegram from your TDV Server.
-
Access Live Sage 200 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Sage 200 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Design BIRT Reports on Impala Data
Provide current Apache Impala to your embedded analytics.
-
Connect to EnterpriseDB Data in Claris FileMaker Pro
Use the CData ODBC Driver for EnterpriseDB in FileMaker Pro to connect to EnterpriseDB and work with EnterpriseDB in your FileMaker applications.
-
Integrating Gumloop with Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Twitter Ads within automated workflows.
-
Connect to EnterpriseDB Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time EnterpriseDB using standard SQL.
-
Getting Started with the CData SSIS Components for Elasticsearch
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Elasticsearch.
-
Integrating LangChain with Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act-On within automated workflows.
-
Consume Supabase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Supabase feeds that reflect any changes in SAP Lumira.
-
Create Informatica Mappings From/To an ODBC Data Source for Sugar CRM
Create an ODBC connection to Sugar CRM in Informatica and browse and transfer Sugar CRM.
-
Moving Data from Figshare to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Figshare data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Brex-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Brex.
-
Automated Continuous Sage 200 Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Sage 200 replication to delimited files (CSV/TSV).
-
How to create an RPA flow for Blackbaud FE NXT Data in UiPath Studio
Use the Blackbaud FE NXT ODBC Driver to create workflows that access real-time Blackbaud FE NXT without any coding.
-
How to integrate Short.io with Apache Airflow
Access and process Short.io in Apache Airflow using the CData JDBC Driver.
-
Access Live Azure DevOps 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 Azure DevOps through MCP integration.
-
Integrate Azure Data Catalog Data in Pentaho Data Integration
Build ETL pipelines based on Azure Data Catalog in the Pentaho Data Integration tool.
-
Use the CData ODBC Driver for Adobe Commerce in Microsoft Power Query
You can use the CData Adobe Commerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Commerce into Microsoft Power Query.
-
Creating SAP Netweaver Gateway-Connected Applications in Unqork
You can use CData Connect AI to feed SAP Netweaver Gateway to Unqork and build custom business apps.
-
A PostgreSQL Interface for Zoho CRM Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Zoho Creator Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Zoho Creator as an External Source in Dremio.
-
Analyze LightSpeedRetail Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for LightSpeedRetail from Power Pivot. You will use the Table Import Wizard to load LightSpeedRetail. You can visually build the import query or use any SQL supported by the driver.
-
Easily Integrate Browserless Data in Lazarus Pascal IDE
Learn how to easily integrate live Browserless in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import Sybase Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Sybase. In this article, you will use the OData format to import Sybase into Microsoft Power Query.
-
Build a PostgreSQL Interface for Sybase IQ Data using the CData JDBC Driver
Use the Remoting features of the Sybase IQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
Object-Relational Mapping (ORM) with Zoho Projects 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 Zoho Projects into a Java-based ORM framework, Hibernate.
-
Integrate Real-Time Access to Shippo in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Shippo in real time.
-
How to Connect Flowise AI Agents to Live MariaDB 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 MariaDB without replication.
-
Use Claude to Talk to Your Zoho Inventory 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 Zoho Inventory for you.
-
Import Real-Time SageHR Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SageHR in ColdFusion.
-
Connect to BigCommerce Data from HeidiSQL
Use CData Connect AI to connect to and query live BigCommerce from HeidiSQL.
-
Getting Started with the CData Excel Add-In for Azure Table
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Azure Table.
-
Build Charts with Azure Synapse Data in Clear Analytics
Create dynamic charts and perform analytics based on Azure Synapse in Clear Analytics.
-
Automate Zuora Data Replication to SAP HANA
Use CData Sync to customize and automate Zuora replication to SAP HANA.
-
DataBind Controls to Apollo Data in Delphi
DataBind to Apollo in Delphi with standard data access components and controls.
-
Access Live Zoom Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Zoom data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connecting Pipedream with Spark Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Spark data in real time.
-
Automate Twilio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Twilio replication to Azure Data Lake.
-
Publish Reports with Amazon DynamoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon DynamoDB.
-
Connect to LightSpeedRetail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LightSpeedRetail using standard SQL.
-
Build SharePoint Excel Services-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SharePoint Excel Services to explore live SharePoint Excel Services Data in Claude Code to assist with building SharePoint Excel Services-powered applications.
-
Model, Search, and Visualize Live Shopify Data in ThoughtSpot
Use CData Connect AI to connect to live Shopify for modeling, searching, and visualizing.
-
Import Azure Data Lake Storage Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Data Lake Storage Data from Azure Data Factory and import live Azure Data Lake Storage.
-
Build Semantic Layer Views for SAP ByDesign Data in APOS Live Data Gateway
Use the CData Connector for SAP ByDesign in APOS Live Data Gateway to build Semantic Layer Views for SAP Business ByDesign.
-
Build Semantic Layer Views for Phoenix Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Apache Phoenix.
-
Build MVC Applications with Connectivity to CircleCI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CircleCI from an ASP.NET MVC application.
-
How to Create Power BI Visual Reports with Real-Time Zendesk Data
Use CData Power BI Connectors to visualize Zendesk in Power BI.
-
Build Charts with Sage 200 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 200 in Clear Analytics.
-
LINQ to SingleStore 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 SingleStore Data Provider.
-
Automated Continuous Pingdom Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pingdom replication to Apache Kafka.
-
How to Create Power BI Visual Reports with Real-Time PostgreSQL Data
Use CData Power BI Connectors to visualize PostgreSQL in Power BI.
-
Access ConvertAPI 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 ConvertAPI.
-
Create Dynamic GraphQL Grids Using the Infragistics XamDataGrid
Learn how you can connect GraphQL to Infragistics XamDataGrid to build dynamic grids.
-
Connecting Mastra with JSON Services 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 JSON, no replication required.
-
Use the CData Software JDBC Driver for Google Cloud Storage in MicroStrategy
Connect to Google Cloud Storage in MicroStrategy Developer using the CData Software JDBC Driver for Google Cloud Storage.
-
Operational Reporting on SharePoint Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft SharePoint.
-
Query Pushbullet Data in ColdFusion
Write standard ColdFusion data access code to connect to Pushbullet.
-
Automated Continuous GitLab Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable GitLab replication to Azure SQL Database.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Creator within intelligent workflows.
-
How to Query Live OnePageCrm Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OnePageCrm data in natural language using Python.
-
Integrate Rootly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Rootly with External Services.
-
Publish Reports with Auth0 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Auth0.
-
Build Data Flows from Excel Online to SQL Server using SSIS
Easily back up Microsoft Excel Online to SQL Server using the SSIS components for Excel Online.
-
Create Data Visualizations in Cognos BI with MailerLite Data
Access MailerLite as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Bind Live Square Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Square data
-
Connect to Google Ad Manager Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Ad Manager.
-
SendGrid Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendGrid facts in real time.
-
Analyze Sage Intacct Data in Cognos Analytics
Use CData Connect AI to connect to Sage Intacct Data from Cognos Analytics and analyze live Sage Intacct.
-
Create Dynamic Phoenix Grids Using the Infragistics XamDataGrid
Learn how you can connect Phoenix to Infragistics XamDataGrid to build dynamic grids.
-
Use Grok to Talk to Your Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Amazon S3 for you.
-
Build Zoho CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Zoho CRM and build visualizations in Tableau Cloud.
-
Replicate SendPulse Data in Heroku for Use in Salesforce Connect
Replicate SendPulse to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to import Stripe Data into Apache Solr
Use the CData Software JDBC Driver for Stripe in Data Import Handler and create an automated import of Stripe to Apache Solr Enterprise Search platform.
-
Build Dashboards with Timely Data in DBxtra
Create dynamic dashboards and perform analytics based on Timely in DBxtra.
-
Build an OLAP Cube in SSAS from WordPress Data
Establish a connection to WordPress data from SQL Server Analysis Services, and use the WordPress Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create a Data Access Object for Nethunt Data using JDBI
A brief overview of creating a SQL Object API for Nethunt in JDBI.
-
Analyze Oracle Eloqua Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Eloqua from Power Pivot. You will use the Table Import Wizard to load Oracle Eloqua. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Okta Data in Sisense
Create an ElastiCube in Sisense app with access to Okta.
-
Build Excel Online-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Excel Online to explore live Excel Online Data in Gemini Code Assist to assist with building Excel Online-powered applications.
-
Automated Continuous SAP BusinessObjects BI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to delimited files (CSV/TSV).
-
How to Connect Flowise AI Agents to Live WooCommerce 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 WooCommerce without replication.
-
How to Easily Query Billsby Data in OpenOffice Base
Connect to Billsby data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Enable the SAP Ariba Procurement JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Procurement.
-
How to Create Power BI Visual Reports with Real-Time PabblySubscriptions Data
Use CData Power BI Connectors to visualize PabblySubscriptions in Power BI.
-
Visualize Sybase IQ Data in TIBCO Spotfire through OData
Integrate Sybase IQ into dashboards in TIBCO Spotfire.
-
Feed Hubstaff Data into FineReport
How to set Hubstaff as a JDBC data source in FineReport.
-
How to publish and share Toggl Data dashboards with Tableau Server
The CData ODBC driver for Toggl enables you integrate Toggl into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for Hugging Face
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automated Continuous Reckon Replication to Oracle
Use CData Sync for automated, continuous, customizable Reckon replication to Oracle.
-
Build Dashboards with Blackbaud FE NXT Data in Dundas BI
Create dynamic dashboards and perform analytics based on Blackbaud FE NXT in Dundas BI.
-
Automated Continuous Toggl Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Toggl replication to Google Cloud SQL.
-
Analyze ShipStation Data in Cognos Analytics
Use CData Connect AI to connect to ShipStation Data from Cognos Analytics and analyze live ShipStation.
-
Access Excel Online Data from MySQL in Amazon QuickSight
Connect to Excel Online and build visualizations of Microsoft Excel Online using a MySQL Connection in Amazon QuickSight.
-
Analyze Supabase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Supabase from Power Pivot. You will use the Table Import Wizard to load Supabase. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SAP BusinessObjects BI Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP BusinessObjects BI Data and connect to SAP BusinessObjects BI in Akorbi Digital RunMyProcess.