CData Software - Knowledge Base
Recent Articles
-
Build FreshBooks Visualizations in Tableau Cloud
Use CData Connect AI to connect to live FreshBooks and build visualizations in Tableau Cloud.
-
Automate Microsoft Dataverse Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Dataverse (CDS) replication to Azure Synapse.
-
Build Marketo-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Marketo Data and create custom apps in Bubble.
-
Establish a Live Connection with ZeroBounce Data using Tableau Bridge
The CData ODBC Driver for ZeroBounce enables you to integrate live ZeroBounce into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous QuickBooks Online Replication to Oracle
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Oracle.
-
Bridge NASA Connectivity with Apache NiFi
Access and process NASA in Apache NiFi using the CData JDBC Driver.
-
Analyze Salesforce Pardot Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Pardot with the CData JDBC Driver for Salesforce Pardot.
-
How to Connect to Live Tally 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 Tally ERP for you.
-
Integrate Real-Time Access to Excel Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Excel Online in real time.
-
Analyze Amazon DynamoDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon DynamoDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Real-Time Egnyte Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Egnyte in Power Apps.
-
How to connect PolyBase to MySQL
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MySQL.
-
Use the CData Software JDBC Driver for Grafana in MicroStrategy
Connect to Grafana in MicroStrategy Developer using the CData Software JDBC Driver for Grafana.
-
Use the CData ODBC Driver for Sage Intacct in Microsoft Power Query
You can use the CData Sage Intacct ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage Intacct into Microsoft Power Query.
-
Integrating GitHub Copilot CLI with Moosend 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.
-
Access Live Facebook Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Facebook data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Datasets from Drift in Domo Workbench and Build Visualizations of Drift Data in Domo
Use the CData Software ODBC Driver for Drift to create datasets from Drift in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Salesforce Marketing Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to delimited files (CSV/TSV).
-
Getting Started with the CData Tableau Connector for Microsoft OneDrive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Microsoft OneDrive.
-
Enable the Teamgate JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Teamgate.
-
Connect to API Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live API.
-
Access Live Google Sheets Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Sheets into the statistical analysis tools available in SAS JMP. This article shows how to use Google Sheets in the Graph Builder and Query Builder.
-
Integrate Open WebUI with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live LinkedIn from within the chat interface.
-
Load Active Directory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Active Directory to a database.
-
Build Semantic Layer Views for Azure Table Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Table Storage.
-
How to import Snowflake Data into Apache Solr
Use the CData Software JDBC Driver for Snowflake in Data Import Handler and create an automated import of Snowflake to Apache Solr Enterprise Search platform.
-
Create Freshdesk-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Freshdesk Data from OutSystems and build custom enterprise apps using live Freshdesk.
-
Access FTP Data from MySQL in PHP
Connect to FTP through the standard MySQL libraries in PHP.
-
Create Power BI Reports on Real-Time Oracle Eloqua Reporting Data
Use the CData ODBC Driver for Oracle Eloqua Reporting to visualize Oracle Eloqua Reporting in Power BI Desktop.
-
LINQ to Paymo 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 Paymo Data Provider.
-
Integrate Live Sage Cloud Accounting Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to load Delighted data into Elasticsearch via Logstash
Introducing a simple method to load Delighted data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Replicate SAP Ariba Procurement Data in Heroku for Use in Salesforce Connect
Replicate SAP Ariba Procurement to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Apify Data in Ruby
Connect to Apify in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Sybase-Connected Applications in Appsmith
Connect to Sybase Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sybase.
-
Access Productboard 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 Productboard.
-
Build ServiceNow-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ServiceNow Data and create custom apps in Mendix.
-
Natively Connect to FHIR Data in PHP
The CData ODBC driver for FHIR enables you to create PHP applications with connectivity to FHIR. Leverage the native support for ODBC in PHP.
-
Object-Relational Mapping (ORM) with Discord 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 Discord into a Java-based ORM framework, Hibernate.
-
Access ShipEngine Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ShipEngine from your Oracle system.
-
Bidirectional Access to Vault CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Veeva Vault & Vault CRM in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData Tableau Connector for Act-On
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Act-On.
-
Visualize Azure Table Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Table Storage.
-
Integrating Kiro CLI with SAP Ariba Source 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 CSV in MicroStrategy Desktop
Connect to CSV/TSV Files in MicroStrategy Desktop using the CData Software ODBC Driver for CSV.
-
Access Avaza 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 Avaza.
-
How to work with SAP Fieldglass Data in Apache Spark using SQL
Access and process SAP Fieldglass Data in Apache Spark using the CData Software JDBC Driver.
-
Automated Continuous SAP Fieldglass Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to OneLake in Microsoft Fabric.
-
Automate Dynamics 365 Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dynamics 365 and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Getting Started with the CData Tableau Connector for Billsby
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to Build an ETL App for Email Data in Python with CData
Create ETL applications and real-time data pipelines for Email in Python with petl.
-
Moving Data from Oracle SCM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Oracle SCM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with SAP Business One 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 SAP Business One through CData Connect AI.
-
Consume SAP Business One OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Business One feeds that reflect any changes in SAP Lumira.
-
Access Raisers Edge NXT Data from MySQL in Amazon QuickSight
Connect to Raisers Edge NXT and build visualizations of Raisers Edge NXT using a MySQL Connection in Amazon QuickSight.
-
Connecting Agentforce with GitLab 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 GitLab for you.
-
Use the CData Software JDBC Driver for Outlook in MicroStrategy Web
Connect to Outlook in MicroStrategy Web using the CData Software JDBC Driver for Outlook.
-
Analyze Klaviyo Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Klaviyo and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Object-Relational Mapping (ORM) with CSV 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 CSV/TSV Files into a Java-based ORM framework, Hibernate.
-
How to use SQLAlchemy ORM to access Shippo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shippo.
-
Bridge Pinterest Connectivity with Apache NiFi
Access and process Pinterest in Apache NiFi using the CData JDBC Driver.
-
How to Access SingleStore Data Using Entity Framework
This article shows how to access SingleStore using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Dynamics 365 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Dynamics 365 from your Oracle system.
-
Build Apps with Live Couchbase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Couchbase into the Adalo platform and build custom mobile and web applications with real-time Couchbase.
-
Use the CData Software ODBC Driver for GraphQL in MicroStrategy
Connect to GraphQL in MicroStrategy Developer using the CData Software ODBC Driver for GraphQL.
-
Connect to Mixpanel Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Mixpanel and work with Mixpanel in your FileMaker application.
-
Connect Cloudant Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your IBM Cloudant using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData JDBC Driver for CouchDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CouchDB.
-
How to Import Data from CSV into Google Sheets
Import CSV/TSV Files into a Google spreadsheet that is automatically refreshed.
-
Automate Twitter Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Twitter Ads replication to Azure Synapse.
-
Build Semantic Layer Views for PostgreSQL Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for PostgreSQL.
-
How to Access Live GetResponse Data in Power Automate Desktop via ODBC
The CData ODBC Driver for GetResponse enables you to integrate GetResponse into workflows built using Microsoft Power Automate Desktop.
-
Publish ZohoSubscriptions-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZohoSubscriptions.
-
Getting Started with the CData Power BI Connector for Greenplum
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Greenplum.
-
Integrating Codex CLI with GitHub 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.
-
Integrate Cline with Live Excel Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Excel Online from within your IDE.
-
Enable the Sage 300 JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sage 300.
-
Using the CData Software ODBC Driver for Nethunt in PyCharm
Connect to Nethunt as an ODBC data source in PyCharm using the CData Software ODBC Driver for Nethunt.
-
Model, Search, and Visualize Live Elasticsearch Data in ThoughtSpot
Use CData Connect AI to connect to live Elasticsearch for modeling, searching, and visualizing.
-
How to Create Power BI Visual Reports with Real-Time Demio Data
Use CData Power BI Connectors to visualize Demio in Power BI.
-
Provide OData Services of Microsoft Teams Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Teams by developing a WCF Service Application.
-
Integrate Yelp Data in Pentaho Data Integration
Build ETL pipelines based on Yelp in the Pentaho Data Integration tool.
-
Visualize Live Qualaroo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Qualaroo.
-
Connect to Apollo Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Apollo.
-
View Reports on Real-Time Pingdom Data in Power BI Report Server
Use the CData ODBC Driver for Pingdom to visualize Pingdom in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Access Live Tanda Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Tanda enables you to integrate Tanda into workflows built using Microsoft Power Automate Desktop.
-
Integrate Live SAP Ariba Source Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to SAP Ariba Source from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live SAP Ariba Source.
-
Access Live Exact Online Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Exact Online into the statistical analysis tools available in SAS JMP. This article shows how to use Exact Online in the Graph Builder and Query Builder.
-
Connect to Okta Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Okta using standard SQL.
-
How to Connect to Live Google Spanner Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Spanner for you.
-
Connect to Jira Data in Jaspersoft Studio
Execute SQL to remote Atlassian Jira in Jaspersoft Studio.
-
Feed MailerLite Data into FineReport
How to set MailerLite as a JDBC data source in FineReport.
-
Import Real-Time SAP Hybris C4C Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Hybris C4C in ColdFusion.
-
Build Automated Pipedrive-Connected Workflows in Zapier
Use CData Connect AI to connect to live Pipedrive and build automated workflows in Zapier.
-
How to connect to Clockify Data from IntelliJ
Integrate connectivity to Clockify with wizards in IntelliJ.
-
How to create Perplexity federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Perplexity in MySQL .
-
Visualize ShipStation Data in TIBCO Spotfire through OData
Integrate ShipStation into dashboards in TIBCO Spotfire.
-
Connect to Outreach.io Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Outreach.io and the Script function in FileMaker Pro to connect to Outreach.io and work with Outreach.io in your FileMaker application.
-
Create Dynamic Tavily Grids Using the Infragistics XamDataGrid
Learn how you can connect Tavily to Infragistics XamDataGrid to build dynamic grids.
-
Build Amazon Marketplace-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Amazon Marketplace to explore live Amazon Marketplace Data in Gemini Code Assist to assist with building Amazon Marketplace-powered applications.