CData Software - Knowledge Base
Recent Articles
-
How to connect to Bullhorn CRM Data from Spring Boot
Connect to Bullhorn CRM in a Spring Boot Application using the CData JDBC Driver for Bullhorn CRM
-
Use the CData Software ODBC Driver for Paylocity in SAS for Real-Time Reporting and Analytics
Connect to real-time Paylocity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paylocity.
-
Integrating Claude Code CLI with Printify 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 Paymo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Paymo replication to SingleStore.
-
How to Connect to Live SQL Analysis Services Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SQL Analysis Services for you.
-
Build VWO-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to VWO and build web apps with connectivity to live VWO.
-
Automated Continuous SendGrid Replication to SingleStore
Use CData Sync for automated, continuous, customizable SendGrid replication to SingleStore.
-
Use Manus AI to Talk to Your NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics.
-
Automated Continuous Kafka Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Kafka replication to IBM DB2.
-
Automated Continuous QuickBooks Online Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Amazon Redshift.
-
Analyze CloudConvert Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CloudConvert in Microsoft R Open.
-
Natively Connect to PayPal Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PayPal. Leverage the native support for ODBC in PHP.
-
How to Create Power BI Visual Reports with Real-Time Miro Data
Use CData Power BI Connectors to visualize Miro in Power BI.
-
Automated Continuous Zuora Replication to Snowflake
Use CData Sync for automated, continuous, customizable Zuora replication to Snowflake.
-
TigerGraph Reporting in OBIEE with the TigerGraph JDBC Driver
Deploy the TigerGraph JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Retently Data to Multiple Databases
Replicate Retently to disparate databases with a point-and-click configuration.
-
Integrating LangGraph with SQL Server Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft SQL Server within automated workflows.
-
Build Visualizations of Missive Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Missive in Birst.
-
Build Dashboards with Salesloft Data in DBxtra
Create dynamic dashboards and perform analytics based on Salesloft in DBxtra.
-
Use the CData Software JDBC Driver for Reply.io in MicroStrategy Desktop
Connect to Reply.io in MicroStrategy Desktop using the CData Software JDBC Driver for Reply.io.
-
Integrate Live Clockify Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Clockify to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Build Automated Workflows with Live SAP BusinessObjects BI Data in Workato
Use CData Connect AI to connect to live SAP BusinessObjects BI and build automated workflows in Workato.
-
Access Live Sybase Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Sybase from your Excel spreadsheets.
-
Connect to Microsoft Teams Data in NetBeans
Connect to Microsoft Teams in NetBeans with the data source configuration wizard.
-
Connect to Google Contacts Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Contacts.
-
Connect to Bright Data Data in JRuby
Create a simple JRuby app with access to live Bright Data.
-
Use Grok to Talk to Your SAP SuccessFactors LMS 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 SAP SuccessFactors LMS for you.
-
Model Xero Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Xero, enabling the direct import of real-time Xero Accounting.
-
How to Connect to Coda Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Coda. Leverage the pyodbc module for ODBC in Python.
-
Create Data Visualizations in Cognos BI with Act-On Data
Access Act-On as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connecting Mastra with Asana 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 Asana, no replication required.
-
Choosing the Best Method to Connect Google Forms to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Forms from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automate Copper Data Replication to SAP HANA
Use CData Sync to customize and automate Copper replication to SAP HANA.
-
Automated Continuous ZohoSubscriptions Replication to MySQL
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to MySQL.
-
Connect to MongoDB Data in Google Apps Script via Connect AI
Use CData Connect AI to access MongoDB in Google Apps Script.
-
Use Agno to Talk to Your Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Neo4J for you.
-
DataBind Charts to SendPulse Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SendPulse from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Bidirectional Access to Intercom Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Intercom in Filemaker Pro for Mac or Windows.
-
Integrating Antigravity CLI with PagerDuty via CData CLI
Connect PagerDuty to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create SSAS Tabular Models from Authorize.Net Data
How to build a SQL Server Analysis Service Tabular Model from Authorize.Net using CData drivers.
-
Create FormSite Dataflows on PowerBI.com
Connect to the CData Power BI Connector for FormSite from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Notion Data in JRuby
Create a simple JRuby app with access to live Notion.
-
Analyze Zoho CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho CRM from Power Pivot. You will use the Table Import Wizard to load Zoho CRM. You can visually build the import query or use any SQL supported by the driver.
-
Build Data Flows from Smartsheet to SQL Server using SSIS
Easily back up Smartsheet to SQL Server using the SSIS components for Smartsheet.
-
Connect to Placid Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Create Power BI Visual Reports with Real-Time SAP Data
Use CData Power BI Connectors to visualize SAP ERP/NetWeaver in Power BI.
-
Build SAP Concur-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Concur Data and create custom apps in Bubble.
-
Build AI Agents with HubSpot 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 HubSpot through CData Connect AI.
-
Use the CData ODBC Driver for BenchmarkEmail from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for BenchmarkEmail to connect to BenchmarkEmail from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring BenchmarkEmail in Excel.
-
How to Import Data from Raisers Edge NXT into Google Sheets
Import Raisers Edge NXT into a Google spreadsheet that is automatically refreshed.
-
Connect to Sage 300 Data from a Connection Pool in JBoss
Integrate Sage 300 into Java servlets: Use the Management Console in JBoss to install the Sage 300 JDBC Driver.
-
How to create Parquet federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Parquet in MySQL .
-
Build an OLAP Cube in SSAS from Planio Data
Establish a connection to Planio data from SQL Server Analysis Services, and use the Planio Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Kintone actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Prepare, Blend, and Analyze SAP ByDesign Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Business ByDesign for self-service data analytics.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MySQL within intelligent workflows.
-
How to connect PolyBase to Sage 200
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Sage 200.
-
A PostgreSQL Interface for Egnyte Data (MySQL Remoting via JDBC)
Use the Remoting features of the Egnyte JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to import Office 365 Data into Apache Solr
Use the CData Software JDBC Driver for Office 365 in Data Import Handler and create an automated import of Microsoft Office 365 to Apache Solr Enterprise Search platform.
-
Connect to SendGrid Data in CloverDX (formerly CloverETL)
Transfer SendGrid using the visual workflow in the CloverDX data integration tool.
-
Use the CData ODBC Driver for SAP HANA XS Advanced from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for SAP HANA XS Advanced to connect to SAP HANA XS Advanced from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring SAP HANA XS Advanced in Excel.
-
Integrating OpenCode Terminal with Pipeliner CRM 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.
-
Use the CData Software ODBC Driver for Twilio in MicroStrategy
Connect to Twilio in MicroStrategy Developer using the CData Software ODBC Driver for Twilio.
-
Automated Continuous Pipeline CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to PostgreSQL.
-
Access Kintone 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 Kintone.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Google Drive to Power BI dashboards. Simply drag and drop Google Drive into data visuals on the Power BI canvas.
-
Integrate Live Paymo Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Paymo to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Synchronize Google and SharePoint Calendars in Talend
You can access SharePoint data in Talend using the CData JDBC Driver for SharePoint.
-
Access SAP ByDesign Data from MySQL in Amazon QuickSight
Connect to SAP ByDesign and build visualizations of SAP Business ByDesign using a MySQL Connection in Amazon QuickSight.
-
How to Query Live Oracle Service Cloud Data in Claude Desktop
Connect to and query live Oracle Service Cloud Data in Claude Desktop using CData MCP Server.
-
Moving Data from Instantly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Instantly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Visualize Access Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Access in Python.
-
Write a Simple Go Application to work with Brex Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Brex.
-
Integrate WooCommerce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate WooCommerce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to WooCommerce.
-
Automate CockroachDB Data Replication to SAP HANA
Use CData Sync to customize and automate CockroachDB replication to SAP HANA.
-
How to Connect to PabblySubscriptions Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to PabblySubscriptions. Leverage the pyodbc module for ODBC in Python.
-
Explore Geographical Relationships in Airtable Data with Power Map
Create data visualizations with Airtable in Power Map.
-
Choosing the Best Method to Connect Testmonitor to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Testmonitor from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrating Figshare Data in Talend Cloud Data Management Platform
Connect Figshare Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access OpenWeatherMap Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of OpenWeatherMap.
-
Access Live Smartsheet Data in Excel 365 Online (Excel for the web)
Connect to Smartsheet from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Live EnterpriseDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to EnterpriseDB in CData Connect AI and connect to your EnterpriseDB from PostgreSQL.
-
Analyze TaxJar Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for TaxJar from Power Pivot. You will use the Table Import Wizard to load TaxJar. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Clari Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Clari replication to Apache Cassandra.
-
Visualize Strava Data in Tableau
The CData ODBC driver for Strava enables you integrate Strava into Tableau dashboards.
-
Build Couchbase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Couchbase Data and create custom apps in Bubble.
-
Prepare, Blend, and Analyze Superchat Data in Alteryx Designer (ODBC)
Build workflows to access live Superchat for self-service data analytics.
-
Getting Started with the CData Excel Add-In for SFTP
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SFTP.
-
Connecting Mastra with Bullhorn CRM 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 Bullhorn CRM, no replication required.
-
Getting Started with the CData JDBC Driver for Spark
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Spark.
-
How to Query Live Databricks Data in Perplexity MacOS Desktop
Connect to and query live Databricks Data in Perplexity Desktop using CData MCP Server.
-
Create SSAS Tabular Models from SingleStore Data
How to build a SQL Server Analysis Service Tabular Model from SingleStore using CData drivers.
-
Analyze Suadeo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Suadeo with the CData JDBC Driver for Suadeo.
-
Validate CircleCI Data with QuerySurge
Access and validate CircleCI in QuerySurge using the CData JDBC Driver.
-
Query SharePoint Excel Services Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SharePoint Excel Services entities in PHP by modeling them as objects.
-
How to Access Live Telegram Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Telegram enables you to integrate Telegram into workflows built using Microsoft Power Automate Desktop.
-
Object-Relational Mapping (ORM) with ScrapingBee 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 ScrapingBee into a Java-based ORM framework, Hibernate.
-
Automate FreeAgent Data Replication to SAP HANA
Use CData Sync to customize and automate FreeAgent replication to SAP HANA.
-
Integrating Mistral AI Data in Talend Cloud Data Management Platform
Connect Mistral AI Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Semantic Layer Views for Grafana Data in APOS Live Data Gateway
Use the CData Connector for Grafana in APOS Live Data Gateway to build Semantic Layer Views for Grafana.