CData Software - Knowledge Base
Recent Articles
-
Automated Continuous SAP Hybris C4C Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to AlloyDB.
-
Query EnterpriseDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against EnterpriseDB from Node.js.
-
Build Automated MariaDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live MariaDB and build automated workflows in Zapier.
-
Integrate Okta Data in the Pentaho Report Designer
Publish reports based on Okta in the Pentaho BI tool.
-
Build Charts with Customer.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Customer.io in Clear Analytics.
-
Visualize Pinecone Data in Sisense
Create an ElastiCube in Sisense app with access to Pinecone.
-
Connect to BigCommerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for BigCommerce in the Denodo Virtual DataPort Administrator.
-
Replicate Facebook Data to Multiple Databases via the CData Sync CLI
Replicate Facebook to disparate databases with a single configuration.
-
Query Shopify Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Shopify entities in PHP by modeling them as objects.
-
Connect to Testmonitor Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Testmonitor using standard SQL.
-
Connect to Tally Data in ACL Analytics
Connect to Tally ERP via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Tally ERP.
-
Automated Continuous LinkedIn Replication to SingleStore
Use CData Sync for automated, continuous, customizable LinkedIn replication to SingleStore.
-
Build ZohoDesk-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live ZohoDesk Data in Claude Code to assist with building ZohoDesk-powered applications.
-
Work with Live Azure Analysis Services Data in Power Query
Use CData Connect AI to connect to Azure Analysis Services and work with live Azure Analysis Services in Microsoft Power Query.
-
Integrate Live SAP Fieldglass Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Fieldglass from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Fieldglass.
-
Work with Jodoo Data in FoxPro
Load Jodoo into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex CLI with Box 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.
-
Choosing the Best Method to Connect Sage 300 to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Sage 300 from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build MVC Applications with Connectivity to GitHub Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access GitHub from an ASP.NET MVC application.
-
Connect to Harvest Data in JRuby
Create a simple JRuby app with access to live Harvest.
-
A PostgreSQL Interface for Salesforce Data 360 Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce Data 360 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing JotForm Data in RAD Studio Data Explorer
How to view JotForm in RAD Studio Data Explorer using the CData ODBC Driver for JotForm.
-
A PostgreSQL Interface for Bannerbear Data (MySQL Remoting via JDBC)
Use the Remoting features of the Bannerbear JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access BenchmarkEmail Data in Python
Use standard Python scripting and the development environment of your choice to access live BenchmarkEmail.
-
Connect to PayPal Data from AWS Glue
Use CData Connect AI to gain access to live PayPal from your AWS Glue jobs.
-
Excel Spreadsheet Automation on Shortcut Data with the QUERY Formula
Pull data from Shortcut, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live Blackbaud FE NXT 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 Blackbaud FE NXT for you.
-
Integrate Real-Time Access to PingOne in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PingOne in real time.
-
Choosing the Best Method to Connect Shippo to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Shippo from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Claude Code CLI with Pingdom 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.
-
DataBind Charts to Google Cloud Storage Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Cloud Storage from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Automate Mode Data Replication to Couchbase
Use CData Sync to Customize and automate Mode replication to Couchbase.
-
Explore Geographical Relationships in HubDB Data with Power Map
Create data visualizations with HubDB in Power Map.
-
How to Seamlessly Import Float Data into IBM SPSS Modeler
Integrate Float data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query Azure Data Lake Storage Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Azure Data Lake Storage and perform CRUD operations on Azure Data Lake Storage from Node.js.
-
Connect Insightly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Insightly with IBM WebSphere for seamless data integration and connectivity.
-
Automate Presto Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Presto from PowerShell? This article demonstrates how to utilize the Presto Cmdlets for tasks like connecting to Presto, automating operations, downloading data, and more.
-
How to publish and share CampaignMonitor Data dashboards with Tableau Server
The CData ODBC driver for CampaignMonitor enables you integrate CampaignMonitor into Tableau dashboards.
-
Connect to Figshare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Figshare in the Denodo Virtual DataPort Administrator.
-
Excel Spreadsheet Automation on Oracle Financials Cloud Data with the QUERY Formula
Pull data from Oracle Financials Cloud, automate spreadsheets, and more with the QUERY formula.
-
Use JayDeBeApi to access LaunchDarkly Data in Python
Use standard Python scripting and the development environment of your choice to access live LaunchDarkly.
-
Publish Crystal Reports on Exa Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Exa.
-
Build Jira Assets-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Jira Assets Data from Zoho Analytics and import live Jira Assets.
-
Integrating GitHub Copilot CLI with AgileCRM 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.
-
Getting Started with the CData Power BI Connector for RSS
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for RSS.
-
Connect to Close Data from PowerBuilder via JDBC
This article demonstrates how to access Close from PowerBuilder using the Close JDBC Driver.
-
Build SAP BusinessObjects BI-Connected Apps in Choreo
Use CData Connect AI to connect to SAP BusinessObjects BI Data from Choreo and build custom apps using live SAP BusinessObjects BI.
-
Integrating Dataiku with Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Power BI XMLA.
-
Analyze Act-On Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Act-On and visualize live Act-On in Infragistics Reveal.
-
Build HBase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for HBase Data and create custom apps in Bubble.
-
A PostgreSQL Interface for eBay Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the eBay Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Datasets from Notion in Domo Workbench and Build Visualizations of Notion Data in Domo
Use the CData Software ODBC Driver for Notion to create datasets from Notion in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Salesforce Data 360 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Salesforce Data 360.
-
Prepare, Blend, and Analyze Microsoft Teams Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Teams for self-service data analytics.
-
Automate Box Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Box from PowerShell? This article demonstrates how to utilize the Box Cmdlets for tasks like connecting to Box, automating operations, downloading data, and more.
-
Consume Azure DevOps OData Feeds in PowerBuilder
This article demonstrates how to consume Azure DevOps as OData feeds from PowerBuilder using the API Server.
-
Visualize Zoom Data in Tableau
The CData ODBC driver for Zoom enables you integrate Zoom into Tableau dashboards.
-
Connect to Act-On Data in JRuby
Create a simple JRuby app with access to live Act-On.
-
Excel Spreadsheet Automation on Blackbaud FE NXT Data with the QUERY Formula
Pull data from Blackbaud FE NXT, automate spreadsheets, and more with the QUERY formula.
-
How to Create Power BI Visual Reports with Real-Time Short.io Data
Use CData Power BI Connectors to visualize Short.io in Power BI.
-
Visualize Live MySQL Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MySQL into custom reports in Power BI.
-
Build MVC Applications with Connectivity to MySQL Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MySQL from an ASP.NET MVC application.
-
Model Dynamics 365 Business Central Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365 Business Central, enabling the direct import of real-time Dynamics 365 Business Central.
-
Access Live Splunk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Splunk from your Excel spreadsheets.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HCL Domino.
-
Automate Tasks in Power Automate Using the CData API Server
Automate WooCommerce actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
DataBind FreshBooks Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide FreshBooks to a chart.
-
How to create SAP Ariba Procurement federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Ariba Procurement in MySQL .
-
Connecting Agentforce with Hive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Apache Hive for you.
-
Connect to Airtable in SpagoBI
Create reports featuring live Airtable in SpagoBI Studio. Host Airtable reports on SpagoBI Server.
-
Create Facebook Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook Ads data access from reports, embedded analytics, and more.
-
Connect to Live Freshservice Data in MicroStrategy through CData Connect AI
Create a live connection to Freshservice Data in CData Connect AI and connect to your Freshservice from MicroStrategy.
-
Access Helpscout Data from MySQL in PHP
Connect to Helpscout through the standard MySQL libraries in PHP.
-
Import Real-Time Delighted Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Delighted in ColdFusion.
-
Bidirectional Access to Mailgun Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mailgun in Filemaker Pro for Mac or Windows.
-
Integrate Live BambooHR Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to connect to Highrise Data in DBVisualizer
Integrate Highrise CRM with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to SharePoint Data in NetBeans
Connect to Microsoft SharePoint in NetBeans with the data source configuration wizard.
-
How to Visualize Zoho Creator Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoho Creator in Python.
-
Consume Salesforce CRM Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Salesforce CRM Analytics feeds that reflect any changes in SAP Lumira.
-
Create SSAS Tabular Models from OnePageCrm Data
How to build a SQL Server Analysis Service Tabular Model from OnePageCrm using CData drivers.
-
Integrating LangGraph with MySQL Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on MySQL within automated workflows.
-
Integrate Mocean Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mocean from Informatica Cloud.
-
Getting Started with the CData Python Connector for Google Search
Learn to install and license the CData Python Connector
-
Stream LinkedIn Data into Apache Kafka Topics
Access and stream LinkedIn in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Publish Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis.
-
Build Visualizations of SAP HANA XS Advanced Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP HANA XS Advanced in Birst.
-
Deel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Deel facts in real time.
-
Create Power BI Reports on Real-Time PostgreSQL Data
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL in Power BI Desktop.
-
Replicate CapsuleCRM Data to Multiple Databases
Replicate CapsuleCRM to disparate databases with a point-and-click configuration.
-
Bidirectional Access to Sage Intacct Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage Intacct in Filemaker Pro for Mac or Windows.
-
Extend Google Sheets with Anaplan Data
Make calls to Anaplan from Google Apps Script via the API Server.
-
Integrating LangChain with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Acumatica ERP within automated workflows.
-
Migrating data from Suadeo to Databricks using CData SSIS Components.
Easily push Suadeo to Databricks using the CData SSIS Tasks for Suadeo and Databricks.
-
Automate Smartsheet Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Integrating Codex CLI with Ontraport 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 work with Paylocity Data in Apache Spark using SQL
Access and process Paylocity Data in Apache Spark using the CData Software JDBC Driver.
-
Build Sybase-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase Data and create custom apps in Mendix.
-
Visualize Simplesat Data in TIBCO Spotfire through OData
Integrate Simplesat into dashboards in TIBCO Spotfire.
-
Connect to and Visualize Live Klaviyo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Klaviyo.