CData Software - Knowledge Base
Recent Articles
-
Troubleshooting Common Licensing Issues
Follow these instructions to resolve common licensing issues.
-
Connect to Google Spanner Data in HULFT Integrate
Connect to Google Spanner as a JDBC data source in HULFT Integrate
-
Integrating OpenCode Terminal with MongoDB 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.
-
Natively Connect to Dynamics CRM Data in PHP
The CData ODBC driver for Dynamics CRM enables you to create PHP applications with connectivity to Microsoft Dynamics CRM. Leverage the native support for ODBC in PHP.
-
Deploy the ADO.NET Provider for ZohoDesk on an SSRS Report Server
Connect to ZohoDesk from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Explore Geographical Relationships in NASA Data with Power Map
Create data visualizations with NASA in Power Map.
-
Build Charts with CircleCI Data in Clear Analytics
Create dynamic charts and perform analytics based on CircleCI in Clear Analytics.
-
Connect to SAP Fieldglass Data in NetBeans
Connect to SAP Fieldglass in NetBeans with the data source configuration wizard.
-
How to connect to Printful Data from Spring Boot
Connect to Printful in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect SharePoint with Slack Data through external lists
Provide Slack to SharePoint users as an external list.
-
Integrate Bullhorn CRM with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Bullhorn CRM with External Services.
-
Getting Started with the CData SSIS Components for RSS
Complete guide to installing, licensing, and connecting with the CData SSIS Components for RSS.
-
How to connect and process MailerLite from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MailerLite.
-
Use the CData Software ODBC Driver for Parquet in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache Parquet in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Parquet.
-
Getting Started with the CData ODBC Driver for Perplexity
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Perplexity.
-
Validate Zoho Recruit Data with QuerySurge
Access and validate Zoho Recruit in QuerySurge using the CData JDBC Driver.
-
LINQ to ZohoMarketingHub 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 ZohoMarketingHub Data Provider.
-
Query Facebook Ads Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Facebook Ads and perform CRUD operations on Facebook Ads from Node.js.
-
Import Real-Time Copper Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Copper in ColdFusion.
-
Visualize Live QuickBooks Online Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live QuickBooks Online.
-
Analyze SQL Server Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft SQL Server and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Semantic Layer Views for ActiveCampaign Data in APOS Live Data Gateway
Use the CData Connector for ActiveCampaign in APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign.
-
Feed ElevenLabs Data into FineReport
How to set ElevenLabs as a JDBC data source in FineReport.
-
Rapidly Develop FreshBooks-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 FreshBooks.
-
Use Grok to Talk to Your DocuSign 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 DocuSign for you.
-
Create SAP HANA-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP HANA Data from Klipfolio and build custom visualizations using live SAP HANA.
-
Automated Continuous Zoho CRM Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zoho CRM replication to SQL Server.
-
How to Connect to Live DB2 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 IBM DB2 for you.
-
Connect to Printful Data in Ruby
Connect to Printful in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Sybase Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Sybase and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Getting Started with the CData SSIS Components for SFTP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SFTP.
-
Connect to Microsoft Exchange Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Exchange in the Denodo Virtual DataPort Administrator.
-
Automated Continuous Acumatica Replication to SQLite
Use CData Sync for automated, continuous, customizable Acumatica replication to SQLite.
-
Connect to Exact Online Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Exact Online Data and connect to Exact Online in Akorbi Digital RunMyProcess.
-
Query Workday Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Workday and perform CRUD operations on Workday from Node.js.
-
Create Power BI Reports on Real-Time Marketo Data
Use the CData ODBC Driver for Marketo to visualize Marketo in Power BI Desktop.
-
Connect to Azure Analysis Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Azure Analysis Services in the Denodo Virtual DataPort Administrator.
-
How to work with SQL Server Data in Apache Spark using SQL
Access and process SQL Server Data in Apache Spark using the CData Software JDBC Driver.
-
How to connect to Sage 200 Data with Squirrel SQL client
Connect to Sage 200 and execute queries in the Squirrel SQL Client.
-
Build Salesforce Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesforce & Force.com and build visualizations in Tableau Cloud.
-
Creating Cvent-Connected Applications in Unqork
You can use CData Connect AI to feed Cvent to Unqork and build custom business apps.
-
Configure the CData JDBC Driver for Google Sheets in a Connection Pool in Tomcat
Connect to Google Sheets from a connection pool in Tomcat.
-
Connect to Rebilly Data from PowerBuilder via JDBC
This article demonstrates how to access Rebilly from PowerBuilder using the Rebilly JDBC Driver.
-
Migrating data from Odoo to Google BigQuery using CData SSIS Components.
Easily push Odoo ERP to Google BigQuery using the CData SSIS Tasks for Odoo and Google BigQuery.
-
Create SSAS Tabular Models from Azure Analysis Services Data
How to build a SQL Server Analysis Service Tabular Model from Azure Analysis Services using CData drivers.
-
Use Dash to Build to Web Apps on MongoDB Data
Create Python applications that use pandas and Dash to build MongoDB-connected web apps.
-
How to Connect to Live Microsoft Entra ID 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 Microsoft Entra ID for you.
-
Operational Reporting on Zoom Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zoom.
-
How to Work with ShipEngine Data in AWS Glue Jobs Using JDBC
Connect to ShipEngine from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Azure DevOps Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure DevOps. In this article, you will use the OData format to import Azure DevOps into Microsoft Power Query.
-
Access Live Salesloft Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesloft in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Query Live Mocean Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mocean data in natural language using Python.
-
Bidirectional Access to FormSite Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FormSite in Filemaker Pro for Mac or Windows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Excel
Provide connectivity to Microsoft Excel through an SAP BusinessObjects universe.
-
How to connect to Elorus Data with Squirrel SQL client
Connect to Elorus and execute queries in the Squirrel SQL Client.
-
Automated Continuous Oracle HCM Cloud Replication to MongoDB
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to MongoDB.
-
Building Dynamic Web Pages with GitHub Data Using AngularJS
Create single-page applications with live connectivity to GitHub using the CData API Server.
-
Connect to HCL Domino Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with HCL Domino Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to use SQLAlchemy ORM to access Okta Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Okta.
-
Use Dash to Build to Web Apps on Missive Data
Create Python applications that use pandas and Dash to build Missive-connected web apps.
-
Build Data Flows from Beeminder to SQL Server using SSIS
Easily back up Beeminder to SQL Server using the SSIS components for Beeminder.
-
Connect to ZohoInvoice Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoInvoice in the Denodo Virtual DataPort Administrator.
-
Visualize Live Zoho Creator Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Creator.
-
Create Power BI Reports on Real-Time Rootly Data
Use the CData ODBC Driver for Rootly to visualize Rootly in Power BI Desktop.
-
Access OData Services as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access OData from your Oracle system.
-
Use CData Connect AI to Access Procore Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Procore in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Adobe Experience Manager
Create Adobe Experience Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to connect to Google Translate Data from Spring Boot
Connect to Google Translate in a Spring Boot Application using the CData API Driver for JDBC
-
Connect Redshift to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Redshift with IBM WebSphere for seamless data integration and connectivity.
-
Import and Visualize Salesforce Pardot Data in Power View
Create data visualizations based on Salesforce Pardot in Excel.
-
Connect to and Visualize Live Optimizely Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Optimizely.
-
Automated Continuous MySQL Replication to MongoDB
Use CData Sync for automated, continuous, customizable MySQL replication to MongoDB.
-
Create Gmail-Connected Business Apps in AppSheet
Connect to Gmail Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Gmail.
-
Bridge Tickspot Connectivity with Apache NiFi
Access and process Tickspot in Apache NiFi using the CData JDBC Driver.
-
Integrate Google Calendar Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Calendar and integrate live Google Calendar into your Power Automate tasks.
-
Getting Started with the CData SSIS Components for OneNote
Complete guide to installing, licensing, and connecting with the CData SSIS Components for OneNote.
-
Integrate with Reckon Data in JReport Designer
Create charts and reports based on Reckon in JReport Designer.
-
Build Voice Agents in ElevenLabs with access to Live Azure DevOps Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Azure DevOps.
-
How to Connect Flowise AI Agents to Live Stripe 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 Stripe without replication.
-
Connect to Humanity Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Humanity and work with Humanity in your FileMaker applications.
-
Connect to SFTP Data in HULFT Integrate
Connect to SFTP as a JDBC data source in HULFT Integrate
-
How to load Mistral AI data into Elasticsearch via Logstash
Introducing a simple method to load Mistral AI data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Datasets from ZohoInvoice in Domo Workbench and Build Visualizations of ZohoInvoice Data in Domo
Use the CData Software ODBC Driver for ZohoInvoice to create datasets from ZohoInvoice in Domo Workbench and then build visualizations in the Domo service.
-
Build HDFS-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apache HDFS.
-
Add Aircall Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Aircall with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Cursor CLI with Dynamics 365 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.
-
How to Connect the Power BI Service to Hacker News: Complete Guide
Connect to the CData Software Power BI Connector for Hacker News from PowerBI.com to provide real-time Hacker News across the organization.
-
Build Semantic Layer Views for ConvertKit Data in APOS Live Data Gateway
Use the CData Connector for ConvertKit in APOS Live Data Gateway to build Semantic Layer Views for ConvertKit.
-
Build Semantic Layer Views for Humanity Data in APOS Live Data Gateway
Use the CData Connector for Humanity in APOS Live Data Gateway to build Semantic Layer Views for Humanity.
-
Connect to ConstantContact Data from a Connection Pool in JBoss
Integrate ConstantContact into Java servlets: Use the Management Console in JBoss to install the ConstantContact JDBC Driver.
-
Access Freshteam Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Freshteam from your Oracle system.
-
Publish Confluence-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Atlassian Confluence.
-
Automated Continuous Google Cloud Storage Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to delimited files (CSV/TSV).
-
Connect to Ontraport Data in Ruby
Connect to Ontraport in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Dynamic Foursquare Grids Using the Infragistics XamDataGrid
Learn how you can connect Foursquare to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Dotmailer Data from PowerShell
Write a quick PowerShell script to query Dotmailer. Use connectivity to the live data to replicate Dotmailer to SQL Server.
-
Xero Reporting in OBIEE with the Xero JDBC Driver
Deploy the Xero JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Live SAP Business Warehouse Data in Perplexity MacOS Desktop
Connect to and query live SAP Business Warehouse Data in Perplexity Desktop using CData MCP Server.
-
Build AI/ML Models with Live Microsoft Dataverse Data using Dataiku
Connect Microsoft Dataverse Data with Dataiku using the CData JDBC Driver for Microsoft Dataverse.
-
Use Manus AI to Talk to Your Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Smartsheet.