CData Software - Knowledge Base
Recent Articles
-
Automated Continuous XML Replication to IBM DB2
Use CData Sync for automated, continuous, customizable XML replication to IBM DB2.
-
How to Query Live Mouseflow Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mouseflow data in natural language using Python.
-
Access Live Rootly Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Rootly into the statistical analysis tools available in SAS JMP. This article shows how to use Rootly in the Graph Builder and Query Builder.
-
Prepare, Blend, and Analyze WooCommerce Data in Alteryx Designer (Connect AI)
Build workflows to access live WooCommerce for self-service data analytics.
-
Use the CData Software ODBC Driver for Amazon Marketplace in SAS for Real-Time Reporting and Analytics
Connect to real-time Amazon Marketplace in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Amazon Marketplace.
-
Use the CData ODBC Driver for EnterpriseDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for EnterpriseDB to connect to EnterpriseDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring EnterpriseDB in Excel.
-
Build Voice Agents in ElevenLabs with access to Live Vault CRM Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Veeva Vault & Vault CRM.
-
Integrate Onfleet Data in Pentaho Data Integration
Build ETL pipelines based on Onfleet in the Pentaho Data Integration tool.
-
Connect to Act CRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Act CRM as an External Source in Dremio.
-
Automated Continuous Printful Replication to MongoDB
Use CData Sync for automated, continuous, customizable Printful replication to MongoDB.
-
Access Live MariaDB Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate MariaDB into the statistical analysis tools available in SAS JMP. This article shows how to use MariaDB in the Graph Builder and Query Builder.
-
Visualize Live Sentry Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sentry using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Postmark 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 Postmark.
-
Visualize AfterShip 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 AfterShip into TIBCO Spotfire.
-
How to Build an ETL App for Azure DevOps Data in Python with CData
Create ETL applications and real-time data pipelines for Azure DevOps in Python with petl.
-
Connect to ZohoInvoice Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoInvoice as an External Source in Dremio.
-
Designing a Dynamic UI for Establishing Connections using CData Embedded Connectors
Build dynamic connection UIs using CData Embedded sys_connection_props and sys_connection_hierarchy system tables for seamless integration.
-
Import and Visualize GitHub Data in Power View
Create data visualizations based on GitHub in Excel.
-
Getting Started with the CData SSIS Components for CircleCI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for CircleCI.
-
Access Live HDFS Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Apache HDFS into the statistical analysis tools available in SAS JMP. This article shows how to use Apache HDFS in the Graph Builder and Query Builder.
-
Build Visualizations of Salesloft Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Salesloft in Birst.
-
Build Apps with Live Greenplum Data Using the Low-Code Development Platform of Mendix
Connect Pivotal GreenPlum with Mendix to build apps using the CData JDBC Driver for Greenplum.
-
Visualize Live Bugsnag Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bugsnag using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailChimp
Provide connectivity to MailChimp through an SAP BusinessObjects universe.
-
How to import SAP Hybris C4C Data into Apache Solr
Use the CData Software JDBC Driver for SAP Hybris C4C in Data Import Handler and create an automated import of SAP Hybris C4C to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Power BI Connector for Suadeo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Suadeo.
-
Use the CData Software ODBC Driver for NetSuite in MicroStrategy Desktop
Connect to NetSuite CRM & ERP in MicroStrategy Desktop using the CData Software ODBC Driver for NetSuite.
-
Automated Continuous Sugar CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Sugar CRM replication to MySQL.
-
Seamlessly Bring Oracle HCM Cloud Data into Retool Using CData Connect AI
Integrate Oracle HCM Cloud data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Build Visualizations of ServiceDesk Plus Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ServiceDesk Plus in Birst.
-
Working with Quickbase Data in LINQPad
Execute LINQ queries to Quickbase in LINQPad.
-
Visualize ActiveCampaign Data in Tableau
The CData ODBC driver for ActiveCampaign enables you integrate ActiveCampaign into Tableau dashboards.
-
Access Live Bullhorn CRM Data in TIBCO Data Virtualization
Use the Bullhorn CRM Tibco DV Adapter to create a Bullhorn CRM data source in TIBCO Data Virtualization Studio and gain access to live Bullhorn CRM from your TDV Server.
-
How to connect to Avalara AvaTax Data from Spring Boot
Connect to Avalara AvaTax in a Spring Boot Application using the CData JDBC Driver for Avalara AvaTax
-
How to work with LightSpeedRetail Data in Apache Spark using SQL
Access and process LightSpeedRetail Data in Apache Spark using the CData Software JDBC Driver.
-
Use the CData SSIS Components to Insert New or Update Existing MongoDB Records from SQL Server
Easily push SQL Server data to MongoDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into MongoDB or update existing records with data from a SQL Server database.
-
Connect to Oracle HCM Cloud Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle HCM Cloud in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData JDBC Driver for Gorgias
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Gorgias.
-
Build Microsoft Exchange-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Exchange to explore live Microsoft Exchange Data in Cursor to assist with building Microsoft Exchange-powered applications.
-
Integrate Templated Data in the Pentaho Report Designer
Publish reports based on Templated in the Pentaho BI tool.
-
Access Live Microsoft Entra ID Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Entra ID from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access GitHub Data from MySQL in PHP
Connect to GitHub through the standard MySQL libraries in PHP.
-
Connect to Sage 200 Data from a Connection Pool in JBoss
Integrate Sage 200 into Java servlets: Use the Management Console in JBoss to install the Sage 200 JDBC Driver.
-
Build Google Calendar-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Calendar.
-
Analyze WooCommerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze WooCommerce with the CData JDBC Driver for WooCommerce.
-
Access SAP SuccessFactors Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access SAP SuccessFactors from your Oracle system.
-
Integrating Antigravity CLI with Mocean via CData CLI
Connect Mocean to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Natively Connect to FreshBooks Data in PHP
The CData ODBC driver for FreshBooks enables you to create PHP applications with connectivity to FreshBooks. Leverage the native support for ODBC in PHP.
-
Connect to Missive Data in CloverDX (formerly CloverETL)
Transfer Missive using the visual workflow in the CloverDX data integration tool.
-
Create SQL Analysis Services-Connected Dashboards in Grafana
Connect to SQL Analysis Services Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SQL Analysis Services.
-
Build Automated Workflows with Live SAP Business One Data in Workato
Use CData Connect AI to connect to live SAP Business One and build automated workflows in Workato.
-
Connect to and Visualize Live RabbitMQ Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live RabbitMQ.
-
Choosing the Best Method to Connect Box to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Box from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Mocean Data in CloverDX (formerly CloverETL)
Transfer Mocean using the visual workflow in the CloverDX data integration tool.
-
Migrating data from Helpscout to Databricks using CData SSIS Components.
Easily push Helpscout to Databricks using the CData SSIS Tasks for Helpscout and Databricks.
-
Connect to SAP Business One 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 SAP Business One.
-
Access Live Microsoft Ads Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Microsoft Ads through MCP integration.
-
Visualize Live Pipeline CRM Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pipeline CRM.
-
Import Microsoft Dataverse Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft Dataverse (CDS). In this article, you will use the OData format to import Microsoft Dataverse (CDS) into Microsoft Power Query.
-
Connect to Sybase IQ Data in JRuby
Create a simple JRuby app with access to live Sybase IQ.
-
LINQ to Webex 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 Webex Data Provider.
-
Integrating Claude Code CLI with Campaigner 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.
-
Automate LDAP Objects Replication to SAP HANA
Use CData Sync to customize and automate LDAP replication to SAP HANA.
-
Build Semantic Layer Views for QuickBooks Data in APOS Live Data Gateway
Use the CData Connector for QuickBooks in APOS Live Data Gateway to build Semantic Layer Views for QuickBooks Desktop.
-
Build Dashboards with Typeform Data in Dundas BI
Create dynamic dashboards and perform analytics based on Typeform in Dundas BI.
-
Visualize Hive Data in TIBCO Spotfire through ADO.NET
Integrate Apache Hive into dashboards in TIBCO Spotfire.
-
Access Live Monday.com Data in TIBCO Data Virtualization
Use the Monday.com Tibco DV Adapter to create a Monday.com data source in TIBCO Data Virtualization Studio and gain access to live Monday.com from your TDV Server.
-
Access Live Raisers Edge NXT 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 Raisers Edge NXT through MCP integration.
-
Create Informatica Mappings From/To a JDBC Data Source for SharePoint Excel Services
Create SharePoint Excel Services data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Provide OData Services of Telegram Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Telegram by developing a WCF Service Application.
-
Bridge Zoho CRM Connectivity with Apache NiFi
Access and process Zoho CRM in Apache NiFi using the CData JDBC Driver.
-
How to Build an ETL App for Quaderno Data in Python with CData
Create ETL applications and real-time data pipelines for Quaderno in Python with petl.
-
Use the CData Software JDBC Driver for iContact in MicroStrategy
Connect to iContact in MicroStrategy Developer using the CData Software JDBC Driver for iContact.
-
Automated Continuous CockroachDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CockroachDB replication to IBM DB2.
-
Stream Auth0 Data into Apache Kafka Topics
Access and stream Auth0 in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect to ZohoSubscriptions Data with Squirrel SQL client
Connect to ZohoSubscriptions and execute queries in the Squirrel SQL Client.
-
Coinbase Reporting in OBIEE with the Coinbase JDBC Driver
Deploy the Coinbase JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Antigravity CLI with Asana via CData CLI
Connect Asana to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize FHIR Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to FHIR.
-
How to connect to Suadeo Data in DBVisualizer
Integrate Suadeo with visual data analysis tools and data connection wizards in DBVisualizer
-
Use Databricks Agent Bricks to Talk to Your FreshBooks Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your FreshBooks for you.
-
Connect to SAP SuccessFactors LMS Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP SuccessFactors LMS Data and connect to SAP SuccessFactors LMS in Akorbi Digital RunMyProcess.
-
Connect Perplexity to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Perplexity with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Live Certinia Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
DataBind Controls to BigCommerce Data in Delphi
DataBind to BigCommerce in Delphi with standard data access components and controls.
-
Automated Continuous CouchDB Replication to Databricks
Use CData Sync for automated, continuous, customizable CouchDB replication to Databricks.
-
Integrate Rebilly Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Rebilly from Informatica Cloud.
-
Build a PostgreSQL Interface for Vault CRM Data using the CData JDBC Driver
Use the Remoting features of the Vault CRM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze Freshsales Data in Alteryx Designer (ODBC)
Build workflows to access live Freshsales for self-service data analytics.
-
Integrate Theia IDE with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Build Highrise Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Highrise CRM and build visualizations in Tableau Cloud.
-
Automated Continuous ClickUp Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ClickUp replication to IBM DB2.
-
Visualize Live Coda Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Coda.
-
Connect to Optimizely from Asprova with CData Software ODBC Driver for Optimizely
This article shows how to connect faster to Optimizely data from Asprova.
-
Integrate Cursor with Live Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Campaign Manager 360 from within the editor.
-
Connect to Testmonitor Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Testmonitor and work with Testmonitor in your FileMaker applications.
-
How to Connect the Power BI Service to ShipStation: Complete Guide
Connect to the CData Software Power BI Connector for ShipStation from PowerBI.com to provide real-time ShipStation across the organization.
-
Migrating data from Productboard to Google BigQuery using CData SSIS Components.
Easily push Productboard to Google BigQuery using the CData SSIS Tasks for Productboard and Google BigQuery.
-
Integrate with Klaviyo Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Klaviyo in SnapLogic.
-
How to Build an ETL App for CouchDB Data in Python with CData
Create ETL applications and real-time data pipelines for Apache CouchDB in Python with petl.