CData Software - Knowledge Base
Recent Articles
-
Build Automated Workflows with Live Oracle SCM Data in Workato
Use CData Connect AI to connect to live Oracle SCM data and build automated workflows in Workato.
-
Build Apps with Live Supabase Data Using the Low-Code Development Platform of Mendix
Connect Supabase data with Mendix to build apps using the CData API Driver for JDBC.
-
How to work with QuickBooks Data in Apache Spark using SQL
Access and process QuickBooks Data in Apache Spark using the CData Software JDBC Driver.
-
Object-Relational Mapping (ORM) with Retently 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 Retently data into a Java-based ORM framework, Hibernate.
-
Automated Continuous Tanda Replication to Vertica
Use CData Sync for automated, continuous, customizable Tanda replication to Vertica.
-
Visualize Omnisend Data in Sisense
Create an ElastiCube in Sisense app with access to Omnisend data.
-
Connect to Procore in SpagoBI
Create reports featuring live Procore data in SpagoBI Studio. Host Procore reports on SpagoBI Server.
-
Query PhantomBuster Data in ColdFusion
Write standard ColdFusion data access code to connect to PhantomBuster data.
-
Publish Dynamics 365-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Dynamics 365 data.
-
Integrate Trae with Live BigQuery Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live BigQuery data from within the AI-powered IDE.
-
Create BenchmarkEmail-Connected Dashboards in Grafana
Connect to BenchmarkEmail Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to BenchmarkEmail data.
-
Bind Live Google Search Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Search data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect and process Guru data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Guru data.
-
How to Connect to Live Monday.com Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Monday.com data securely in real time.
-
Connect ZohoPeople to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoPeople data using the CData Python MCP Server.
-
Quaderno Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Quaderno facts in real time.
-
Build Apps with Live Epicor Kinetic Data Using the Low-Code Development Platform of Mendix
Connect Epicor Kinetic data with Mendix to build apps using the CData JDBC Driver for Epicor Kinetic.
-
Process & Analyze Pipedrive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Pipedrive Data.
-
How to integrate Google Analytics with Apache Airflow
Access and process Google Analytics data in Apache Airflow using the CData JDBC Driver.
-
Query Splunk Data in ColdFusion
Write standard ColdFusion data access code to connect to Splunk data.
-
Create Power BI Reports on Real-Time Browserless Data
Use the CData ODBC Driver for Browserless to visualize Browserless data in Power BI Desktop.
-
Publish Bright Data-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Bright Data data.
-
How to Connect the Power BI Service to Mocean: Complete Guide
Connect to the CData Software Power BI Connector for Mocean from PowerBI.com to provide real-time Mocean data across the organization.
-
How to Create Power BI Visual Reports with Real-Time Beeminder Data
Use CData Power BI Connectors to visualize Beeminder data in Power BI.
-
Connect to Tally Data from PowerBuilder via JDBC
This article demonstrates how to access Tally data from PowerBuilder using the Tally JDBC Driver.
-
Build AI Agents with Cosmos DB 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 Cosmos DB data through CData Connect AI.
-
Import and Visualize Reckon Accounts Hosted Data in Power View
Create data visualizations based on Reckon Accounts Hosted data in Excel.
-
Automated Continuous Oracle Eloqua Replication to SQLite
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to SQLite.
-
Connect to Egnyte Data in HULFT Integrate
Connect to Egnyte as a JDBC data source in HULFT Integrate
-
Use the CData Software ODBC Driver for Sage Intacct in MicroStrategy Web
Connect to Sage Intacct data in MicroStrategy Web using the CData Software ODBC Driver for Sage Intacct.
-
Connect CapsuleCRM Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CapsuleCRM data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Use the CData ODBC Driver for Optimizely in Microsoft Power Query
You can use the CData Optimizely ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Optimizely data into Microsoft Power Query.
-
Use the CData Software JDBC Driver for Apify in MicroStrategy Desktop
Connect to Apify data in MicroStrategy Desktop using the CData Software JDBC Driver for Apify.
-
Access Live FormSite Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FormSite data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Reckon Accounts Hosted Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Reckon Accounts Hosted data to a JSON file on disk.
-
Build xBase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for xBase Data and create custom apps in Bubble.
-
Getting Started with the CData Excel Add-In for Facebook
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Facebook.
-
Automated Continuous Vault CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Vault CRM replication to Vertica.
-
Consume HubDB OData Feeds in PowerBuilder
This article demonstrates how to consume HubDB data as OData feeds from PowerBuilder using the API Server.
-
Analyze Cassandra Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Cassandra data with the CData JDBC Driver for Cassandra.
-
Integrating GitHub Copilot with Paylocity 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.
-
Model Zoho Projects Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho Projects, enabling the direct import of real-time Zoho Projects data.
-
Create Data Visualizations in Cognos BI with Reply.io Data
Access Reply.io data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build Neo4J-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Neo4J data.
-
Import Real-Time eBay Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use eBay Analytics data in ColdFusion.
-
Consume Cosmos DB OData Feeds in PowerBuilder
This article demonstrates how to consume Cosmos DB data as OData feeds from PowerBuilder using the API Server.
-
Load Front Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Front data to a database.
-
Integrate AdRoll with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate AdRoll with External Services.
-
How to Connect Flowise AI Agents to Live Cvent 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 Cvent data without replication.
-
How to connect and process Mocean data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mocean data.
-
Automated Continuous Beeminder Replication to MongoDB
Use CData Sync for automated, continuous, customizable Beeminder replication to MongoDB.
-
Build MVC Applications with Connectivity to Google Directory Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Directory from an ASP.NET MVC application.
-
Build Printify-Connected Apps in Choreo
Use CData Connect AI to connect to Printify Data from Choreo and build custom apps using live Printify data.
-
Connect to Mailgun from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Mailgun data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Data Flows from SAP BusinessObjects BI to SQL Server using SSIS
Easily back up SAP BusinessObjects BI data to SQL Server using the SSIS components for SAP BusinessObjects BI.
-
Use the CData Software ODBC Driver for Google Directory in MicroStrategy Desktop
Connect to Google Directory data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Directory.
-
Connect to SFTP Data in RapidMiner
Integrate SFTP data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Live Typeform Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Typeform data into the statistical analysis tools available in SAS JMP. This article shows how to use Typeform data in the Graph Builder and Query Builder.
-
Connect Autopilot to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Autopilot with IBM WebSphere for seamless data integration and connectivity.
-
How to connect SharePoint with Dynamics CRM Data through external lists
Provide Dynamics CRM data to SharePoint users as an external list.
-
Connect to Tickspot from a Connection Pool in WebLogic
Use the CData JDBC Driver for Tickspot to connect to Tickspot data from Web applications running on WebLogic.
-
Access Live Oracle Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle data from your Google Sheets.
-
How to Connect to Live Reckon Accounts Hosted Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Reckon Accounts Hosted data through natural language.
-
How to connect to SharePoint Data from Spring Boot
Connect to SharePoint in a Spring Boot Application using the CData JDBC Driver for SharePoint
-
Object-Relational Mapping (ORM) with Keap 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 Keap data into a Java-based ORM framework, Hibernate.
-
Enable the CData JDBC Driver for QuickBooks in KNIME
Access QuickBooks data and other data sources in KNIME using the JDBC Driver. You can follow the procedure detailed below to enable any CData JDBC driver in KNIME.
-
How to work with Accelo Data in Apache Spark using SQL
Access and process Accelo Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to ServiceDesk Plus Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live ServiceDesk Plus data from Filemaker Pro on Mac.
-
How to Visualize Smartsheet Data in Python with pandas
Use pandas and other modules to analyze and visualize live Smartsheet data in Python.
-
Automated Continuous Shortcut Replication to SingleStore
Use CData Sync for automated, continuous, customizable Shortcut replication to SingleStore.
-
Import Real-Time SAS Data Sets Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAS Data Sets data in ColdFusion.
-
Query Live Adobe Commerce 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 Adobe Commerce data directly from the development environment.
-
Integrating Oracle Financials Cloud Data in Talend Cloud Data Management Platform
Connect Oracle Financials Cloud Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle Financials Cloud.
-
Automated Continuous Notion Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Notion replication to delimited files (CSV/TSV).
-
Visualize Live Gmail Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Gmail data into custom reports in Power BI.
-
How to Query Live Exa Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Exa data data in natural language using Python.
-
How to connect Amazon QuickSight to Google Contacts Data
Create a connection to Google Contacts data in CData Connect AI and insert Google Contacts data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to connect and process Workable data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Workable data.
-
Build Perplexity-Connected Apps in Choreo
Use CData Connect AI to connect to Perplexity Data from Choreo and build custom apps using live Perplexity data.
-
Integrating Gumloop with Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Avro data within automated workflows.
-
Visualize Zoho Projects 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 Zoho Projects data into TIBCO Spotfire.
-
Publish Shortcut-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Shortcut data.
-
Integrating Antigravity CLI with Cosmos DB data via CData CLI
Connect Cosmos DB data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Office 365 Data in TIBCO Spotfire through ADO.NET
Integrate Office 365 data into dashboards in TIBCO Spotfire.
-
Use the CData ODBC Driver for GitLab in Microsoft Power Query
You can use the CData GitLab ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GitLab data into Microsoft Power Query.
-
Create a Data Access Object for REST Data using JDBI
A brief overview of creating a SQL Object API for REST data in JDBI.
-
DataBind Controls to Workday Data in Delphi
DataBind to Workday data in Delphi with standard data access components and controls.
-
Deploy the ADO.NET Provider for Timely on an SSRS Report Server
Connect to Timely data 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.
-
Access Live Cloudflare 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 Cloudflare data through MCP integration.
-
Connect to OneNote Data in Jaspersoft Studio
Execute SQL to remote OneNote data in Jaspersoft Studio.
-
Build Salesforce Pardot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Pardot data and build web apps with connectivity to live Salesforce Pardot data.
-
Query Live API Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live API data through a conversational interface.
-
A Comparison of Database Drivers for SQL Server
A performance comparison of the CData JDBC Driver for SQL Server and the native JDBC Driver for SQL Server (updated May 2020)
-
Prepare, Blend, and Analyze Dynamics NAV Data in Alteryx Designer (ODBC)
Build workflows to access live Dynamics NAV data for self-service data analytics.
-
Operational Reporting on Authorize.Net Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Authorize.Net data.
-
Access Live NetSuite Data in AWS Lambda
Connect to live NetSuite data in AWS Lambda using the CData JDBC Driver.
-
Connect to CouchDB Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live CouchDB data.
-
Create Coda-Connected Business Apps in AppSheet
Connect to Coda Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Coda data.
-
Integrate with YouTube Analytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live YouTube Analytics data in SnapLogic.
-
Create Suadeo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Suadeo from PowerBI.com to create Power BI Dataflows with real-time data.