CData Software - Knowledge Base
Recent Articles
-
Connect to Excel Data in CloverDX (formerly CloverETL)
Transfer Excel data using the visual workflow in the CloverDX data integration tool.
-
Feed Avalara AvaTax Data into FineReport
How to set Avalara AvaTax data as a JDBC data source in FineReport.
-
Connecting Mastra with Acumatica Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Acumatica data, no replication required.
-
Visualize BenchmarkEmail Data in Sisense
Create an ElastiCube in Sisense app with access to BenchmarkEmail data.
-
Build Copper-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Copper data and build web apps with connectivity to live Copper data.
-
How to load Teamwork data into Elasticsearch via Logstash
Introducing a simple method to load Teamwork data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to use SQLAlchemy ORM to access Shopify Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shopify data.
-
Excel Spreadsheet Automation on NASA Data with the QUERY Formula
Pull data from NASA, automate spreadsheets, and more with the QUERY formula.
-
Create SSAS Tabular Models from Monday.com Data
How to build a SQL Server Analysis Service Tabular Model from Monday.com data using CData drivers.
-
Back Up Monday.com data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Monday.com. In this article, we will employ an SSIS workflow to populate a database with Monday.com data data.
-
Automated Continuous Factorial Replication to Oracle
Use CData Sync for automated, continuous, customizable Factorial replication to Oracle.
-
Load Dynamics NAV Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Dynamics NAV data to a database.
-
How to Seamlessly Import Oracle HCM Cloud Data into IBM SPSS Modeler
Integrate Oracle HCM Cloud data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with BenchmarkEmail Data in SnapLogic
Use CData Connect AI to connect to and integrate with live BenchmarkEmail data in SnapLogic.
-
Migrating data from SAP Ariba Source to Snowflake using CData SSIS Components.
Easily push SAP Ariba Source data to Snowflake using the CData SSIS Tasks for SAP Ariba Source and Snowflake.
-
Integrate Dify with Live PostgreSQL Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live PostgreSQL data.
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy Web
Connect to HubSpot data in MicroStrategy Web using the CData Software ODBC Driver for HubSpot.
-
Automated Continuous Bitly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Bitly replication to Azure SQL Database.
-
Analyze CouchDB Data in Looker
Use CData Connect AI to connect to CouchDB Data from Looker and build custom apps using live CouchDB data.
-
Integrating GitHub Copilot with MySQL 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.
-
Automated Continuous DB2 for i Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable DB2 for i replication to Google Cloud SQL.
-
Import Oracle Financials Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle Financials Cloud Data from Azure Data Factory and import live Oracle Financials Cloud data.
-
How to import Customer.io Data into Apache Solr
Use the CData Software JDBC Driver for Customer.io in Data Import Handler and create an automated import of Customer.io data to Apache Solr Enterprise Search platform.
-
Automated Continuous Chargebee Replication to SQL Server
Use CData Sync for automated, continuous, customizable Chargebee replication to SQL Server.
-
Connecting GenSpark with Klaviyo Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Klaviyo data without any replication or custom integration required.
-
Use the CData ODBC Driver for Clockify in Microsoft Power Query
You can use the CData Clockify ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Clockify data into Microsoft Power Query.
-
Connect and Query Live AgileCRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live AgileCRM data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Monday.com Data in JRuby
Create a simple JRuby app with access to live Monday.com data.
-
Integrating Claude Code CLI with BigQuery 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.
-
Access OneNote Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OneNote data from HeidiSQL.
-
Interact with Live Zuora Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Zuora data.
-
Connect to PingOne Data from PowerBuilder via ADO.NET
This article demonstrates how to access PingOne data from Appeon PowerBuilder using the CData ADO.NET Provider for PingOne.
-
SuiteCRM Reporting in OBIEE with the SuiteCRM JDBC Driver
Deploy the SuiteCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Easily Integrate Xero Data in Lazarus Pascal IDE
Learn how to easily integrate live Xero data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create an RPA flow for ServiceDesk Plus Data in UiPath Studio
Use the ServiceDesk Plus ODBC Driver to create workflows that access real-time ServiceDesk Plus data without any coding.
-
Enable the Zoho Recruit JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Zoho Recruit data.
-
Connect to and Query LinkedIn Ads Data in QlikView over ODBC
Create data visualizations with LinkedIn Ads data in QlikView.
-
Create Datasets from Shippo in Domo Workbench and Build Visualizations of Shippo Data in Domo
Use the CData Software ODBC Driver for Shippo to create datasets from Shippo data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Microsoft OneDrive Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft OneDrive data from your AWS Glue jobs.
-
Automated Continuous TaxJar Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable TaxJar replication to Apache Kafka.
-
Build an OLAP Cube in SSAS from AgileCRM Data
Establish a connection to AgileCRM data data from SQL Server Analysis Services, and use the AgileCRM Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build xBase-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to xBase data and build web apps with connectivity to live xBase data.
-
Access Live HubSpot 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 HubSpot data through MCP integration.
-
Model MailChimp Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MailChimp, enabling the direct import of real-time MailChimp data.
-
Build Amplitude-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amplitude data.
-
Automated Continuous Google Directory Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Google Directory data replication to OneLake in Microsoft Fabric.
-
Replicate Multiple Optimizely Accounts via the CData Sync CLI
Replicate multiple Optimizely accounts to one or many databases.
-
Publish BigQuery-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live BigQuery data.
-
Integrate with Azure DevOps Data in JReport Designer
Create charts and reports based on Azure DevOps data in JReport Designer.
-
Integrate Devin with Live Greenplum Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Greenplum data.
-
Connect to Spotify 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 Spotify and work with Spotify data in your FileMaker application.
-
How to Create Power BI Visual Reports with Real-Time Customer.io Data
Use CData Power BI Connectors to visualize Customer.io data in Power BI.
-
Design BIRT Reports on Wrike Data
Provide current Wrike data to your embedded analytics.
-
Create SAP Netweaver Gateway-Connected Dashboards in Grafana
Connect to SAP Netweaver Gateway Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Netweaver Gateway data.
-
Seamlessly Bring Yelp Data into Retool Using CData Connect AI
Integrate Yelp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Wistia Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Wistia data.
-
Getting Started with the CData Tableau Connector for ChargeOver
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize Cvent Data in TIBCO Spotfire through OData
Integrate Cvent data into dashboards in TIBCO Spotfire.
-
Create a Data Access Object for eBay Analytics Data using JDBI
A brief overview of creating a SQL Object API for eBay Analytics data in JDBI.
-
Connecting Agentforce with Zoom 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 Zoom data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for MailChimp
Create an ODBC connection to MailChimp in Informatica and browse and transfer MailChimp data.
-
Connect to Oracle Financials Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Financials Cloud data in Jaspersoft Studio.
-
Moving Data from Helpscout to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Helpscout data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Deel Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Deel replication to Amazon S3.
-
Integrate with HubDB Data in JReport Designer
Create charts and reports based on HubDB data in JReport Designer.
-
Use the CData Software JDBC Driver for Act-On in MicroStrategy Desktop
Connect to Act-On data in MicroStrategy Desktop using the CData Software JDBC Driver for Act-On.
-
Query Epicor Kinetic Data as a SQL Server Database in Node.js
Execute SQL Server queries against Epicor Kinetic data from Node.js.
-
Build Bullhorn CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Bullhorn CRM Data and create custom apps in Mendix.
-
Automated Continuous CampaignMonitor Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Google BigQuery.
-
Automated Continuous RSS Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable RSS replication to Azure SQL Database.
-
Process & Analyze Landbot Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Landbot Data.
-
Integrate SQL Server Data in the Pentaho Report Designer
Publish reports based on SQL Server data in the Pentaho BI tool.
-
How to Connect the Power BI Service to Typeform: Complete Guide
Connect to the CData Software Power BI Connector for Typeform from PowerBI.com to provide real-time Typeform data across the organization.
-
Integrate OpenCode with Live Marketo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Marketo data from within your AI coding agent.
-
Create Reports with SAP Ariba Procurement Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Ariba Procurement data.
-
Automated Continuous Cassandra Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Cassandra replication to Apache Kafka.
-
Use the CData Software ODBC Driver for ShipEngine in SAS for Real-Time Reporting and Analytics
Connect to real-time ShipEngine data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ShipEngine.
-
Connect to SageHR Data in NetBeans
Connect to SageHR data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for Cvent in MicroStrategy
Connect to Cvent data in MicroStrategy Developer using the CData Software ODBC Driver for Cvent.
-
Use Biml to Build SSIS Tasks to Replicate Snowflake Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Snowflake data to SQL Server.
-
Connect to SAP Concur Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Concur data using standard SQL.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy
Connect to SAP Netweaver Gateway data in MicroStrategy Developer using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
SAP Ariba Source Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Ariba Source facts in real time.
-
Integrate Webex Data in Pentaho Data Integration
Build ETL pipelines based on Webex data in the Pentaho Data Integration tool.
-
Connecting Agentforce with Couchbase 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 Couchbase data for you.
-
Connect to SAP Hybris C4C Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Hybris C4C as an External Source in Dremio.
-
Use Dash to Build to Web Apps on Mixpanel Data
Create Python applications that use pandas and Dash to build Mixpanel-connected web apps.
-
Use Biml to Build SSIS Tasks to Replicate EnterpriseDB Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate EnterpriseDB data to SQL Server.
-
Integrate Campaigner Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Campaigner data and integrate live Campaigner data into your Power Automate tasks.
-
ETL PayPal in Oracle Data Integrator
This article shows how to transfer PayPal data into a data warehouse using Oracle Data Integrator.
-
Connect to Dropbox Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Dropbox data from Filemaker Pro on Mac.
-
Rapidly Develop Toggl-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 Toggl.
-
Analyze Ontraport Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Ontraport data in Microsoft R Open.
-
Integrate Goose with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP BusinessObjects BI data from within the local AI agent.
-
Build a Simple VCL Application for Azure Analysis Services Data
How to build a simple VCL Application to view Azure Analysis Services data in RAD Studio using the CData ODBC Driver for Azure Analysis Services.
-
How to Connect to Live CouchDB 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 CouchDB data for you.
-
Integrate SingleStore with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SingleStore with External Services.
-
Integrate Google Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Ads with External Services.
-
Access Live Freshdesk Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Freshdesk data into the statistical analysis tools available in SAS JMP. This article shows how to use Freshdesk data in the Graph Builder and Query Builder.
-
Connect to Spotify Data in NetBeans
Connect to Spotify data in NetBeans with the data source configuration wizard.