CData Software - Knowledge Base
Recent Articles
-
Connect to Monday.com Data in RazorSQL
Connect to Monday.com from wizards and query Monday.com from the GUI in the RazorSQL database management tool.
-
Integrate Google Sheets Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Sheets and integrate live Google Sheets into your Power Automate tasks.
-
How to connect Amazon QuickSight to Impala Data
Create a connection to Apache Impala in CData Connect AI and insert Apache Impala into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Active Directory Data from AWS Glue
Use CData Connect AI to gain access to live Active Directory from your AWS Glue jobs.
-
How to Easily Query Google Analytics Data in OpenOffice Base
Connect to Google Analytics data in OpenOffice Base using the CData ODBC Driver for Google Analytics and generate reports with live data insights.
-
Seamlessly Bring eBay Data into Retool Using CData Connect AI
Integrate eBay data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access ServiceDesk Plus Data from MySQL in PHP
Connect to ServiceDesk Plus through the standard MySQL libraries in PHP.
-
Getting Started with the CData Excel Add-In for Mode
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Mode.
-
How to Query Live ClickUp Data in Claude Desktop
Connect to and query live ClickUp Data in Claude Desktop using CData MCP Server.
-
How to Query Live Supabase Data in Perplexity MacOS Desktop
Connect to and query live Supabase Data in Perplexity Desktop using CData MCP Server.
-
Integrating Antigravity CLI with Oracle Eloqua Reporting via CData CLI
Connect Oracle Eloqua Reporting to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code CLI with Google Campaign Manager 360 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 Apify-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Apify.
-
Publish SuiteCRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SuiteCRM.
-
Stream Avaza Data into Apache Kafka Topics
Access and stream Avaza in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create MailerSend Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MailerSend data access from reports, embedded analytics, and more.
-
Access Email Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Email from your Oracle system.
-
Connect to Zoom from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Zoom, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Cursor CLI with Wistia 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.
-
Configure the CData JDBC Driver for Google Spanner in a Connection Pool in Tomcat
Connect to Google Spanner from a connection pool in Tomcat.
-
Integrating Cursor CLI with Jodoo 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 SendInBlue Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SendInBlue replication to Amazon Redshift.
-
Connect SurveyMonkey Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SurveyMonkey using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live ServiceNow Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ServiceNow from your Google Sheets.
-
Natively Connect to Access Data in PHP
The CData ODBC driver for Access enables you to create PHP applications with connectivity to Microsoft Access. Leverage the native support for ODBC in PHP.
-
Extract, Transform, and Load Cloudflare Data in Informatica PowerCenter
Create a simple Workflow for Cloudflare in Informatica PowerCenter.
-
Create Oracle SCM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle SCM from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Connect to & Open Productboard Data in Microsoft Excel
This article uses the CData ODBC driver for Productboard to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge Azure Table Connectivity with Apache NiFi
Access and process Azure Table Storage in Apache NiFi using the CData JDBC Driver.
-
How to Connect to Live ShipStation 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 ShipStation for you.
-
Use the CData Software JDBC Driver for HubSpot in MicroStrategy Desktop
Connect to HubSpot in MicroStrategy Desktop using the CData Software JDBC Driver for HubSpot.
-
How to Connect to & Open Shopify Data in Microsoft Excel
This article uses the CData ODBC driver for Shopify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to connect to Salesloft Data from Spring Boot
Connect to Salesloft in a Spring Boot Application using the CData JDBC Driver for Salesloft
-
Automated Continuous Google Ad Manager Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to SQLite.
-
Analyze SAP SuccessFactors Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SAP SuccessFactors and visualize live SAP SuccessFactors in Infragistics Reveal.
-
How to import LionDesk Data into Apache Solr
Use the CData Software JDBC Driver for LionDesk in Data Import Handler and create an automated import of LionDesk to Apache Solr Enterprise Search platform.
-
Replicate Multiple Authorize.Net Accounts
Replicate multiple Authorize.Net accounts to one or many databases.
-
Create Apps from Certinia Data in Qlik Sense Cloud
Use CData Connect AI to connect to Certinia Data and build apps from live Certinia in Qlik Sense Cloud.
-
How to Connect the Power BI Service to Highrise: Complete Guide
Connect to the CData Software Power BI Connector for Highrise from PowerBI.com to provide real-time Highrise CRM across the organization.
-
Integrate Cursor with Live Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Atlassian Confluence from within the editor.
-
Use the CData Software ODBC Driver for QuickBooks Time in MicroStrategy Web
Connect to QuickBooks Time in MicroStrategy Web using the CData Software ODBC Driver for QuickBooks Time.
-
Integrating Claude Code with Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft Dynamics 365 within assisted coding and automated development workflows.
-
Integrating Codex CLI with AdRoll 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.
-
View Reports on Real-Time Anaplan Data in Power BI Report Server
Use the CData ODBC Driver for Anaplan to visualize Anaplan in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate ScrapingBee Data in the Pentaho Report Designer
Publish reports based on ScrapingBee in the Pentaho BI tool.
-
How to connect to Bitly Data in DBVisualizer
Integrate Bitly with visual data analysis tools and data connection wizards in DBVisualizer
-
How to use SQLAlchemy ORM to access LDAP Objects in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of LDAP.
-
Extend Google Sheets with Shortcut Data
Make calls to Shortcut from Google Apps Script via the API Server.
-
Getting Started with the CData Python Connector for Reply.io
Learn to install and license the CData Python Connector
-
Process & Analyze MariaDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live MariaDB Data.
-
Use Dash to Build to Web Apps on Blackbaud FE NXT Data
Create Python applications that use pandas and Dash to build Blackbaud FE NXT-connected web apps.
-
Use the CData Software ODBC Driver for Sentry in MicroStrategy Desktop
Connect to Sentry in MicroStrategy Desktop using the CData Software ODBC Driver for Sentry.
-
Connect to Vercel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Vercel using standard SQL.
-
Integrate with Kafka Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apache Kafka to a JSON file on disk.
-
Using the CData Software ODBC Driver for Epicor Kinetic in PyCharm
Connect to Epicor Kinetic as an ODBC data source in PyCharm using the CData Software ODBC Driver for Epicor Kinetic.
-
Automated Continuous WooCommerce Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable WooCommerce replication to Google BigQuery.
-
Integrating SpaceX Data in Talend Cloud Data Management Platform
Connect SpaceX Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Bridge SQL Server Connectivity with Apache NiFi
Access and process Microsoft SQL Server in Apache NiFi using the CData JDBC Driver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Redis actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Operational Reporting on Gong Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Gong.
-
Build a Simple VCL Application for SAP BusinessObjects BI Data
How to build a simple VCL Application to view SAP BusinessObjects BI in RAD Studio using the CData ODBC Driver for SAP BusinessObjects BI.
-
Choosing the Best Method to Connect Acumatica to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Acumatica ERP from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Access Live Pipeline CRM Data in Coginiti Pro
Connect to and query live Pipeline CRM from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create Datasets from VWO in Domo Workbench and Build Visualizations of VWO Data in Domo
Use the CData Software ODBC Driver for VWO to create datasets from VWO in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Live Amplitude Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amplitude to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Operational Reporting on Autopilot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Autopilot.
-
Visualize Retently 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 Retently into TIBCO Spotfire.
-
Build a Singer.io Tap for PostgreSQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PostgreSQL data using
-
How to load HCL Domino data into Elasticsearch via Logstash
Introducing a simple method to load HCL Domino data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Write a Simple Go Application to work with NetSuite Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NetSuite CRM & ERP.
-
Establish a Live Connection with Zuora Data using Tableau Bridge
The CData ODBC Driver for Zuora enables you to integrate live Zuora into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Controls to FreshBooks Data in C++Builder
DataBind to FreshBooks in C++Builder with standard components and controls.
-
How to work with Azure Synapse Data in Apache Spark using SQL
Access and process Azure Synapse Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP Hybris C4C Data in DBArtisan
Use wizards in DBArtisan to configure SAP Hybris C4C as a data source.
-
Excel Spreadsheet Automation on Tally Data with the QUERY Formula
Pull data from Tally, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Oracle Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Oracle replication to Amazon Redshift.
-
Prepare, Blend, and Analyze HelloSign Data in Alteryx Designer (ODBC)
Build workflows to access live HelloSign for self-service data analytics.
-
Connect to YouTube Analytics from a Connection Pool in WebLogic
Use the CData JDBC Driver for YouTube Analytics to connect to YouTube Analytics from Web applications running on WebLogic.
-
Connect to ZarMoney Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ZarMoney.
-
Build Semantic Layer Views for CouchDB Data in APOS Live Data Gateway
Use the CData Connector for CouchDB in APOS Live Data Gateway to build Semantic Layer Views for Apache CouchDB.
-
Migrating data from SpaceX to Google BigQuery using CData SSIS Components.
Easily push SpaceX to Google BigQuery using the CData SSIS Tasks for SpaceX and Google BigQuery.
-
Create Informatica Mappings From/To an ODBC Data Source for Outreach.io
Create an ODBC connection to Outreach.io in Informatica and browse and transfer Outreach.io.
-
Deploy the ADO.NET Provider for SAP Hybris C4C on an SSRS Report Server
Connect to SAP Hybris C4C 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.
-
Publish Reports with Grafana Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Grafana.
-
Replicate Multiple Salesforce Marketing Accounts
Replicate multiple Salesforce Marketing accounts to one or many databases.
-
Access Yelp Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Yelp from HeidiSQL.
-
How to Seamlessly Import SAP HANA Data into IBM SPSS Modeler
Integrate SAP HANA data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Singer.io Tap for Kintone With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Kintone data using
-
Use JayDeBeApi to access HubDB Data in Python
Use standard Python scripting and the development environment of your choice to access live HubDB.
-
Visualize Live CampaignMonitor Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live CampaignMonitor.
-
Visualize SAP Business One Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Business One.
-
Edit and Search Workable External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Workable to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Workable objects that you can access from apps and the dashboard.
-
How to Query Live Templated Data in Perplexity MacOS Desktop
Connect to and query live Templated Data in Perplexity Desktop using CData MCP Server.
-
Query CircleCI Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume CircleCI entities in PHP by modeling them as objects.
-
Integrate Theia IDE with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Jira Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Atlassian Jira in the Denodo Virtual DataPort Administrator.
-
Connecting Agentforce with Snapchat Ads 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 Snapchat Ads for you.
-
Integrate Real-Time Access to Sage Cloud Accounting in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage Business Cloud Accounting in real time.
-
Connect to Workday Data in NetBeans
Connect to Workday in NetBeans with the data source configuration wizard.
-
Add Google Directory Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Directory with the Informatica Enterprise Data Catalog to classify and organize data.