CData Software - Knowledge Base
Recent Articles
-
Provide OData Services of SAP Ariba Source Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Ariba Source data by developing a WCF Service Application.
-
Import and Visualize Beeminder Data in Power View
Create data visualizations based on Beeminder data in Excel.
-
Access Microsoft Ads Data from MySQL in Amazon QuickSight
Connect to Microsoft Ads and build visualizations of Microsoft Ads data using a MySQL Connection in Amazon QuickSight.
-
How to Access Live Moosend Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Moosend enables you to integrate Moosend data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Codex with Vimeo 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 Salesforce Data 360 in SpagoBI
Create reports featuring live Salesforce Data 360 data in SpagoBI Studio. Host Salesforce Data 360 reports on SpagoBI Server.
-
Connect to Egnyte Data in CloverDX (formerly CloverETL)
Transfer Egnyte data using the visual workflow in the CloverDX data integration tool.
-
Query Live Cosmos DB Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Cosmos DB data directly from the development environment.
-
Connect to Nethunt from Asprova with CData Software ODBC Driver for Nethunt
This article shows how to connect faster to Nethunt data from Asprova.
-
Design BIRT Reports on Monday.com Data
Provide current Monday.com data to your embedded analytics.
-
Create Dynamic Coda Grids Using the Infragistics XamDataGrid
Learn how you can connect Coda to Infragistics XamDataGrid to build dynamic grids.
-
How to create Oracle federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle data in MySQL .
-
DataBind ZohoInvoice Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZohoInvoice data to a chart.
-
Use Dash to Build to Web Apps on BambooHR Data
Create Python applications that use pandas and Dash to build BambooHR-connected web apps.
-
Automated Continuous Freshdesk Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Freshdesk replication to Apache Kafka.
-
Rapidly Develop FormSite-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 FormSite.
-
Create Reports with Zoho Inventory Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Zoho Inventory data.
-
View Reports on Real-Time LeadDesk Data in Power BI Report Server
Use the CData ODBC Driver for LeadDesk to visualize LeadDesk data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Mistral AI Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mistral AI replication to SingleStore.
-
Connect to and Query Access Data in QlikView over ODBC
Create data visualizations with Access data in QlikView.
-
Connect to Dynamics NAV Data in RazorSQL
Connect to Dynamics NAV from wizards and query Dynamics NAV data from the GUI in the RazorSQL database management tool.
-
Use Dash to Build Web Apps on Cloudant Data via CData Connect AI
Build interactive Dash web apps on live Cloudant data using pandas and the CData Connect AI Python SDK.
-
Replicate ZohoPeople Data in Heroku for Use in Salesforce Connect
Replicate ZohoPeople data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Automated Blackbaud FE NXT-Connected Workflows in Zapier
Use CData Connect AI to connect to live Blackbaud FE NXT data and build automated workflows in Zapier.
-
Build Zuora-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Zuora Data and create custom apps in Bubble.
-
Load Vimeo Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vimeo data to a database.
-
How to Connect to Live Salesforce Data 360 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 Salesforce Data 360 data for you.
-
Integrate with Oracle Sales Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle Sales data in SnapLogic.
-
Use the CData Software ODBC Driver for Flowlu in MicroStrategy Web
Connect to Flowlu data in MicroStrategy Web using the CData Software ODBC Driver for Flowlu.
-
Build a PostgreSQL Interface for Marketo Data using the CData JDBC Driver
Use the Remoting features of the Marketo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on eBay Analytics data within automated workflows.
-
Enable the Elorus JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Elorus data.
-
Rapidly Develop Cloudflare-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 Cloudflare.
-
How to update Gmail from Excel
This article explains how to transfer data from Excel to Gmail using the Excel Add-In for Gmail.
-
Connect to Live SAP ByDesign Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP ByDesign in CData Connect AI and connect to your SAP ByDesign data from PostgreSQL.
-
Use Grok to Talk to Your Moosend 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 Moosend data for you.
-
Use JayDeBeApi to access Factorial Data in Python
Use standard Python scripting and the development environment of your choice to access live Factorial data.
-
Automate MongoDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MongoDB data replication to Azure Synapse.
-
Connect to ZohoMarketingHub Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoMarketingHub data in the Denodo Virtual DataPort Administrator.
-
Use the CData ODBC Driver for Bullhorn CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Bullhorn CRM to connect to Bullhorn CRM data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Bullhorn CRM data in Excel.
-
Prepare, Blend, and Analyze Campaigner Data in Alteryx Designer (Connect AI)
Build workflows to access live Campaigner data for self-service data analytics.
-
Connect to Live Zuora Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zuora in CData Connect AI and connect to your Zuora data from PostgreSQL.
-
Add Guru Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Guru with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Workday Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Workday data from PowerShell? This article demonstrates how to utilize the Workday Cmdlets for tasks like connecting to Workday data, automating operations, downloading data, and more.
-
Connecting Moonlit Workflow with PolarTeamPro Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your PolarTeamPro data in real time.
-
Getting Started with the CData ODBC Driver for Adobe Experience Manager
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Adobe Experience Manager.
-
How to Connect to Live Oracle Sales Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Sales data securely in real time.
-
How to Work with HelloSign Data in ETL Validator JDBC
Connect to HelloSign from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Email Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Email data for you.
-
Seamlessly Bring Avalara AvaTax Data into Retool Using CData Connect AI
Integrate Avalara AvaTax data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous YouTube Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to Amazon Redshift.
-
Integrate Real-Time Access to Google Ads in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Ads data in real time.
-
Build PabblySubscriptions-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to PabblySubscriptions data and build web apps with connectivity to live PabblySubscriptions data.
-
Configure the CData JDBC Driver for Access in a Connection Pool in Tomcat
Connect to Access data from a connection pool in Tomcat.
-
Perform Batch Operations with Jira Assets Data in Apache NiFi
Connect to Jira Assets data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Connect to Oracle Sales Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle Sales data using standard SQL.
-
How to create an RPA flow for Microsoft Ads Data in UiPath Studio
Use the Microsoft Ads ODBC Driver to create workflows that access real-time Microsoft Ads data without any coding.
-
Query Bitbucket Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Bitbucket entities in PHP by modeling them as objects.
-
Consume ShipStation OData Feeds in PowerBuilder
This article demonstrates how to consume ShipStation data as OData feeds from PowerBuilder using the API Server.
-
Establish a Live Connection with Printful Data using Tableau Bridge
The CData ODBC Driver for Printful enables you to integrate live Printful data into Tableau Cloud dashboards using the Tableau Bridge.
-
Migrating data from SpaceX to Snowflake using CData SSIS Components.
Easily push SpaceX data to Snowflake using the CData SSIS Tasks for SpaceX and Snowflake.
-
Integrate Datadog Data in the Pentaho Report Designer
Publish reports based on Datadog data in the Pentaho BI tool.
-
Use the CData ODBC Driver for Power BI XMLA from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Power BI XMLA data in Excel.
-
Access BambooHR Data from MySQL in Amazon QuickSight
Connect to BambooHR and build visualizations of BambooHR data using a MySQL Connection in Amazon QuickSight.
-
How to Visualize Egnyte Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Egnyte data in Python.
-
Create SSAS Tabular Models from FreeAgent Data
How to build a SQL Server Analysis Service Tabular Model from FreeAgent data using CData drivers.
-
Work with Box Data in FoxPro
Load Box data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Devin with Live Apollo Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Apollo data.
-
Automated Continuous Miro Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Miro replication to Azure SQL Database.
-
Publish DB2-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live DB2 data.
-
Automated Continuous Google Directory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Directory replication to Google BigQuery.
-
Connect to Freshservice in SpagoBI
Create reports featuring live Freshservice data in SpagoBI Studio. Host Freshservice reports on SpagoBI Server.
-
Replicate Multiple Oracle Accounts
Replicate multiple Oracle accounts to one or many databases.
-
Connect to Sage 300 Data from HeidiSQL
Use CData Connect AI to connect to and query live Sage 300 data from HeidiSQL.
-
Design BIRT Reports on Splunk Data
Provide current Splunk data to your embedded analytics.
-
A PostgreSQL Interface for SAP Ariba Source Data using the CData ODBC Driver
Use the SQL Gateway and SAP Ariba Source ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Telegram Data from MySQL in Amazon QuickSight
Connect to Telegram and build visualizations of Telegram data using a MySQL Connection in Amazon QuickSight.
-
How to connect PolyBase to Hive
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Hive data.
-
Integrate Devin with Live SuiteCRM Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live SuiteCRM data.
-
Integrate Live Zendesk Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zendesk data and integrate live Zendesk data into apps built in Microsoft Power Apps.
-
Automated Continuous Cosmos DB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Google Cloud SQL.
-
Automated Continuous Campaigner Replication to Vertica
Use CData Sync for automated, continuous, customizable Campaigner replication to Vertica.
-
How to create Visio diagrams from Azure Synapse Data
Automatically update Azure Synapse data with the changes you make to Visio master shapes.
-
Feed FreeAgent Data into FineReport
How to set FreeAgent data as a JDBC data source in FineReport.
-
Access Amplitude Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Amplitude data from HeidiSQL.
-
Connect to Gmail Data in Ruby
Connect to Gmail data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to connect PolyBase to Customer.io
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Customer.io data.
-
Use CData Connect AI to Access Exact Online Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Exact Online data in the Power Pivot business intelligence tool.
-
Automated Continuous OneNote Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable OneNote replication to Google BigQuery.
-
How to Access Omnisend Data Using Entity Framework
This article shows how to access Omnisend data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Quickbase Data in Aqua Data Studio
Access Quickbase data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Bidirectional Access to Freshdesk Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Freshdesk data in Filemaker Pro for Mac or Windows.
-
Use Dash to Build to Web Apps on Google Calendar Data
Create Python applications that use pandas and Dash to build Google Calendar-connected web apps.
-
Access Vimeo Data from MySQL in PHP
Connect to Vimeo through the standard MySQL libraries in PHP.
-
Integrating GitHub Copilot with Oracle 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.
-
Integrating Gumloop with BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BenchmarkEmail data within automated workflows.
-
Getting Started with the CData ADO.NET Provider for Dynamics NAV
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Dynamics NAV.
-
Connect to RSS Feeds from a Connection Pool in Jetty
The RSS JDBC Driver supports connection pooling: This article shows how to connect faster to RSS feeds from Web apps in Jetty.
-
Build Dashboards with HDFS Data in DBxtra
Create dynamic dashboards and perform analytics based on HDFS data in DBxtra.
-
Integrate Cline with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Twitter Ads data from within your IDE.