CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Chargebee on an SSRS Report Server
Connect to Chargebee 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.
-
ETL LightSpeedRetail in Oracle Data Integrator
This article shows how to transfer LightSpeedRetail data into a data warehouse using Oracle Data Integrator.
-
Validate CapsuleCRM Data with QuerySurge
Access and validate CapsuleCRM data in QuerySurge using the CData JDBC Driver.
-
Automated Continuous eBay Analytics Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable eBay Analytics replication to Apache Cassandra.
-
Automated Continuous Grafana Replication to Databricks
Use CData Sync for automated, continuous, customizable Grafana replication to Databricks.
-
Rapidly Develop ClickTime-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 ClickTime.
-
Integrating Antigravity CLI with Certinia data via CData CLI
Connect Certinia data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Kiro with Smartsheet 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.
-
Feed SQL Server Data into FineReport
How to set SQL Server data as a JDBC data source in FineReport.
-
Build Charts with OData Services in Clear Analytics
Create dynamic charts and perform analytics based on OData services in Clear Analytics.
-
Create Sybase IQ-Connected Business Apps in AppSheet
Connect to Sybase IQ Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sybase IQ data.
-
Visualize Oracle Eloqua 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 Oracle Eloqua data into TIBCO Spotfire.
-
Connect to Shopify Data in CloverDX (formerly CloverETL)
Transfer Shopify data using the visual workflow in the CloverDX data integration tool.
-
Access Mocean Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Mocean data from your Oracle system.
-
How to Use a Microsoft Access Database to Update WooCommerce Data in Real Time
Update WooCommerce data by creating a linked table in Microsoft Access with the CData WooCommerce ODBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate SAP Business Warehouse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Business Warehouse data to SQL Server.
-
Getting Started with the CData ADO.NET Provider for RSS
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for RSS.
-
Visualize Printify Data in Tableau
The CData ODBC driver for Printify enables you integrate Printify data into Tableau dashboards.
-
ETL Sybase in Oracle Data Integrator
This article shows how to transfer Sybase data into a data warehouse using Oracle Data Integrator.
-
Automate MySQL Data Replication to SAP HANA
Use CData Sync to customize and automate MySQL data replication to SAP HANA.
-
Connect to Real-Time Vimeo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Vimeo data in Power Apps.
-
Create Power BI Reports on Real-Time JobNimbus Data
Use the CData ODBC Driver for JobNimbus to visualize JobNimbus data in Power BI Desktop.
-
Create Google Drive-Connected Nintex Workflows
Use CData Connect AI to connect to Google Drive Data from Nintex Workflow Cloud and build custom workflows using live Google Drive data.
-
Replicate Bullhorn CRM Data from PowerShell
Write a quick PowerShell script to query Bullhorn CRM data. Use connectivity to the live data to replicate Bullhorn CRM data to SQL Server.
-
Connect to Typeform Data in HULFT Integrate
Connect to Typeform as a JDBC data source in HULFT Integrate
-
How to load Slack data into Elasticsearch via Logstash
Introducing a simple method to load Slack data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Basecamp Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Basecamp data securely in real time.
-
Replicate Hacker News Data from PowerShell
Write a quick PowerShell script to query Hacker News data. Use connectivity to the live data to replicate Hacker News data to SQL Server.
-
Integrating Claude Code CLI with ADP 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.
-
Build MVC Applications with Connectivity to Egnyte Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Egnyte from an ASP.NET MVC application.
-
Connect REST to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live REST data using the CData Python MCP Server.
-
Connect to Spark Data from Crystal Reports
Use CData Connect AI to connect to and report on live Spark data from Crystal Reports.
-
Object-Relational Mapping (ORM) with PabblySubscriptions 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 PabblySubscriptions data into a Java-based ORM framework, Hibernate.
-
How to work with Azure Data Lake Storage Data in Apache Spark using SQL
Access and process Azure Data Lake Storage Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Power BI Connector for Azure Table
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Table.
-
Integrate Dynamics 365 Data in Pentaho Data Integration
Build ETL pipelines based on Dynamics 365 data in the Pentaho Data Integration tool.
-
Automate Klipfolio Data Replication to Azure Data Lake
Use CData Sync to customize and automate Klipfolio data replication to Azure Data Lake.
-
Connect to Bullhorn CRM 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 Bullhorn CRM data.
-
Salesforce Pardot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Salesforce Pardot facts in real time.
-
Automated Continuous Sybase IQ Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Azure SQL Database.
-
How to Build an ETL App for Templated Data in Python with CData
Create ETL applications and real-time data pipelines for Templated data in Python with petl.
-
Integrating LangGraph with SharePoint Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SharePoint data within automated workflows.
-
Use the CData ODBC Driver for Stack Exchange from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Stack Exchange to connect to Stack Exchange data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Stack Exchange data in Excel.
-
Use Claude to Talk to Your Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Airtable data for you.
-
Automated Continuous Typeform Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Typeform replication to Amazon Redshift.
-
Analyze RSS Feeds in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of RSS feeds and visualize RSS feeds in SAP Analytics Cloud.
-
Excel Spreadsheet Automation on Lakebase Data with the QUERY Formula
Pull data from Lakebase, automate spreadsheets, and more with the QUERY formula.
-
How to use SQLAlchemy ORM to access Qualaroo Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Qualaroo data.
-
Build AI/ML Models with Live JobNimbus Data using Dataiku
Connect JobNimbus Data with Dataiku using the CData API Driver for JDBC.
-
Visualize Live Dynamics CRM Data in the Power BI Service
Use CData Connect AI to connect to live Dynamics CRM data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to ZohoMarketingHub Data in PHP
The CData ODBC driver for ZohoMarketingHub enables you to create PHP applications with connectivity to ZohoMarketingHub data. Leverage the native support for ODBC in PHP.
-
Integrate Planio Data in Pentaho Data Integration
Build ETL pipelines based on Planio data in the Pentaho Data Integration tool.
-
Automated Continuous OpenWeatherMap Replication to Snowflake
Use CData Sync for automated, continuous, customizable OpenWeatherMap replication to Snowflake.
-
Visualize Live Basecamp Data in the Power BI Service
Use CData Connect AI to connect to live Basecamp data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Dataiku with Zoho Inventory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Inventory data.
-
Use the CData Software ODBC Driver for Hubstaff in MicroStrategy
Connect to Hubstaff data in MicroStrategy Developer using the CData Software ODBC Driver for Hubstaff.
-
Automate Postmark Data Replication to Azure Data Lake
Use CData Sync to customize and automate Postmark data replication to Azure Data Lake.
-
Create Microsoft Dataverse-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Dataverse Data from Klipfolio and build custom visualizations using live Microsoft Dataverse data.
-
Replicate Multiple Omnisend Accounts via the CData Sync CLI
Replicate multiple Omnisend accounts to one or many databases.
-
Connect to CapsuleCRM Data as an External Source in Dremio
Use the CData JDBC Driver to connect to CapsuleCRM as an External Source in Dremio.
-
Getting Started with the CData SSIS Components for Couchbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Couchbase.
-
Access Live Trello Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Trello data from your Excel spreadsheets.
-
How to Seamlessly Import Strava Data into IBM SPSS Modeler
Integrate Strava data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Perform Batch Operations with Dynamics 365 Data in Apache NiFi
Connect to Dynamics 365 data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use Claude to Talk to Your HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your HCL Domino data for you.
-
Access Live Accelo Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Accelo data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Work with Pipeliner CRM Data in ETL Validator JDBC
Connect to Pipeliner CRM from ETL Validator jobs using the CData Software JDBC Driver.
-
Model, Search, and Visualize Live Mode Data in ThoughtSpot
Use CData Connect AI to connect to live Mode data for modeling, searching, and visualizing.
-
Use the CData Software ODBC Driver for Auth0 in MicroStrategy Desktop
Connect to Auth0 data in MicroStrategy Desktop using the CData Software ODBC Driver for Auth0.
-
Build Data Flows from Workday to SQL Server using SSIS
Easily back up Workday data to SQL Server using the SSIS components for Workday.
-
Automated Continuous Paddle Replication to MySQL
Use CData Sync for automated, continuous, customizable Paddle replication to MySQL.
-
Build Dynamics 365-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Dynamics 365 data.
-
Build SAP Netweaver Gateway-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP Netweaver Gateway data and build SAP Netweaver Gateway-connected web apps with Axios.
-
Query GraphQL Data through ODBC in Node.js
Use node-odbc to execute SQL queries against GraphQL data from Node.js.
-
Create Sugar CRM-Connected Business Apps in AppSheet
Connect to Sugar CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sugar CRM data.
-
Work with Live eBay Data in Power Query
Use CData Connect AI to connect to eBay data and work with live eBay data in Microsoft Power Query.
-
Build HBase-Connected Apps in Choreo
Use CData Connect AI to connect to HBase Data from Choreo and build custom apps using live HBase data.
-
Getting Started with the CData ODBC Driver for Vault CRM
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Vault CRM.
-
Connect to Zoho CRM Data in HULFT Integrate
Connect to Zoho CRM as a JDBC data source in HULFT Integrate
-
Import Real-Time HDFS Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HDFS data in ColdFusion.
-
Write a Simple Go Application to work with GetResponse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to GetResponse data.
-
Use Dash to Build Web Apps on Exa Data via CData Connect AI
Build interactive Dash web apps on live Exa data using pandas and the CData Connect AI Python SDK.
-
Process & Analyze SAP Business One Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Business One Data.
-
Model Salesloft Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Salesloft, enabling the direct import of real-time Salesloft data.
-
Access Live GitLab 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 GitLab data through MCP integration.
-
Use Microsoft Copilot Studio to talk to your Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Cloudflare data for you.
-
Rapidly Develop Reckon-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 Reckon.
-
Enable the Redis JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Redis data.
-
Getting Started with the CData Connect AI Python SDK for Bitbucket
Install the CData Connect AI Python SDK to read and write live Bitbucket data with standard DB-API 2.0 Python code.
-
Automated Continuous Reply.io Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Reply.io replication to Apache Kafka.
-
Connect to Adobe Commerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Adobe Commerce data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Avalara AvaTax Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to MongoDB.
-
Automated Continuous Raisers Edge NXT Replication to Databricks
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Databricks.
-
Build Box-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Box data without replication.
-
Integrate Live Highrise Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Highrise data from within the IDE.
-
Create SAP Hybris C4C-Connected Dashboards in Grafana
Connect to SAP Hybris C4C Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Hybris C4C data.
-
Build Agents in Relevance AI with Access to Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Cosmos DB data within intelligent agent workflows.
-
Publish AdRoll-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AdRoll data.
-
Create PostgreSQL Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PostgreSQL data access from reports, embedded analytics, and more.
-
Getting Started with the CData ADO.NET Provider for Mailgun
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.