CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Basecamp in MicroStrategy Desktop
Connect to Basecamp in MicroStrategy Desktop using the CData Software ODBC Driver for Basecamp.
-
Integrate Sage Cloud Accounting with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage Cloud Accounting with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage Business Cloud Accounting.
-
How to publish and share Clockify Data dashboards with Tableau Server
The CData ODBC driver for Clockify enables you integrate Clockify into Tableau dashboards.
-
Access MariaDB Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live MariaDB from HeidiSQL.
-
Import and Visualize QuickBooks Time Data in Power View
Create data visualizations based on QuickBooks Time in Excel.
-
Query Clio Data as a MySQL Database in Node.js
Execute MySQL queries against Clio from Node.js.
-
How to load Intercom data into Elasticsearch via Logstash
Introducing a simple method to load Intercom data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData ODBC Driver for Azure Table from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Table to connect to Azure Table Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Table Storage in Excel.
-
Query Amplitude Data as a MySQL Database in Node.js
Execute MySQL queries against Amplitude from Node.js.
-
Automated Continuous EnterpriseDB Replication to Oracle
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Oracle.
-
Create BigQuery-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BigQuery Data from Klipfolio and build custom visualizations using live Google BigQuery.
-
Build an OLAP Cube in SSAS from Aweber Data
Establish a connection to Aweber data from SQL Server Analysis Services, and use the Aweber Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to JSON Services in NetBeans
Connect to JSON in NetBeans with the data source configuration wizard.
-
Connect to Klaviyo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Klaviyo.
-
Integrating Dataiku with Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Elasticsearch.
-
Migrating data from Adobe Commerce to Google BigQuery using CData SSIS Components.
Easily push Adobe Commerce to Google BigQuery using the CData SSIS Tasks for Adobe Commerce and Google BigQuery.
-
Bridge OData Connectivity with Apache NiFi
Access and process OData in Apache NiFi using the CData JDBC Driver.
-
Build Visualizations of FHIR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of FHIR in Birst.
-
Use the CData Software ODBC Driver for GitHub in MicroStrategy Desktop
Connect to GitHub in MicroStrategy Desktop using the CData Software ODBC Driver for GitHub.
-
Build SAP Business One-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP Business One Data and create custom apps in Bubble.
-
Connect to Oracle HCM Cloud from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle HCM Cloud to connect to Oracle HCM Cloud from Web applications running on WebLogic.
-
LINQ to SendInBlue Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the SendInBlue Data Provider.
-
Connect to and Visualize Live PDFMonkey Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live PDFMonkey.
-
Visualize Reckon Accounts Hosted 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 Reckon Accounts Hosted into TIBCO Spotfire.
-
Connect to Grafana Data in Aqua Data Studio
Access Grafana from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Visualizations of Aha! Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Aha! in Birst.
-
How to Query Live Outlook Data in Claude Desktop
Connect to and query live Outlook Data in Claude Desktop using CData MCP Server.
-
Use the CData Software ODBC Driver for FHIR in MicroStrategy
Connect to FHIR in MicroStrategy Developer using the CData Software ODBC Driver for FHIR.
-
How to Access MessageBird Data Using Entity Framework
This article shows how to access MessageBird using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Deploy the ADO.NET Provider for Zoho Projects on an SSRS Report Server
Connect to Zoho Projects 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.
-
Integrating LangGraph with Workday Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Workday within automated workflows.
-
Visualize SharePoint 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 Microsoft SharePoint into TIBCO Spotfire.
-
Integrate with Supabase Data in JReport Designer
Create charts and reports based on Supabase in JReport Designer.
-
Integrate Real-Time Access to Exact Online in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Exact Online in real time.
-
Use the CData Software ODBC Driver for Invoiced in MicroStrategy
Connect to Invoiced in MicroStrategy Developer using the CData Software ODBC Driver for Invoiced.
-
Integrating Claude Code CLI with Cloudflare 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.
-
Analyze ZohoMarketingHub Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of ZohoMarketingHub and visualize live ZohoMarketingHub in Infragistics Reveal.
-
Build Automated Workflows with Live Sugar CRM Data in Workato
Use CData Connect AI to connect to live Sugar CRM and build automated workflows in Workato.
-
How to Access Live Gumroad Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Gumroad enables you to integrate Gumroad into workflows built using Microsoft Power Automate Desktop.
-
Visualize Live eBay Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live eBay into custom reports in Power BI.
-
Create Dynamic Splunk Grids Using the Infragistics XamDataGrid
Learn how you can connect Splunk to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Superchat Data in DBeaver
Use the CData ODBC Driver to connect to Superchat in DBeaver.
-
Build Cassandra-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Apache Cassandra to explore live Cassandra Data in Claude Code to assist with building Cassandra-powered applications.
-
Bidirectional Access to Google Spanner Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Spanner in Filemaker Pro for Mac or Windows.
-
Integrate Testmonitor with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Testmonitor with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Testmonitor.
-
Query SAP Fieldglass Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Fieldglass from Node.js.
-
Integrate Real-Time Access to Twilio in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Twilio in real time.
-
How to Connect to Live MarkLogic 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 MarkLogic for you.
-
Build Semantic Layer Views for Salesloft Data in APOS Live Data Gateway
Use the CData Connector for Salesloft in APOS Live Data Gateway to build Semantic Layer Views for Salesloft.
-
Connect to and Query Klaviyo Data in QlikView over ODBC
Create data visualizations with Klaviyo in QlikView.
-
Analyze Bright Data Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Bright Data from Power Pivot. You will use the Table Import Wizard to load Bright Data. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Salesforce Marketing Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to PostgreSQL.
-
Operational Reporting on Google Campaign Manager 360 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Google Campaign Manager 360.
-
Publish Access-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Microsoft Access.
-
How to connect to Shortcut Data with Squirrel SQL client
Connect to Shortcut and execute queries in the Squirrel SQL Client.
-
Integrating Testmonitor Data in Talend Cloud Data Management Platform
Connect Testmonitor Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Getting Started with the CData Excel Add-In for SendGrid
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SendGrid.
-
Use Claude to Talk to Your JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your JSON for you.
-
Bind Live Salesforce Pardot Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Salesforce Pardot data
-
Load Xero Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Xero Accounting to a database.
-
Load Oracle Eloqua Reporting Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle Eloqua Reporting to a database.
-
Create Jira Assets-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Jira Assets Data from OutSystems and build custom enterprise apps using live Jira Assets.
-
Build a Singer.io Tap for Airtable With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Airtable data using
-
How to Connect to Live Airtable Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Airtable for you.
-
Connect to AgileCRM Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to AgileCRM and work with AgileCRM in your FileMaker applications.
-
Integrate with Codat Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Codat to a JSON file on disk.
-
Replicate SAP HANA Data in Heroku for Use in Salesforce Connect
Replicate SAP HANA to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Epicor Kinetic
Provide connectivity to Epicor Kinetic through an SAP BusinessObjects universe.
-
How to Connect to Clockify Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Clockify. Leverage the pyodbc module for ODBC in Python.
-
Working with Bitly Data in LINQPad
Execute LINQ queries to Bitly in LINQPad.
-
Choosing the Best Method to Connect Reply.io to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Reply.io from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to integrate Clari with Apache Airflow
Access and process Clari in Apache Airflow using the CData JDBC Driver.
-
Connect to VWO Data in DBArtisan
Use wizards in DBArtisan to configure VWO as a data source.
-
Connect ChargeOver to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ChargeOver using the CData Python MCP Server.
-
Query Calendly Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Calendly and perform CRUD operations on Calendly from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Spanner within intelligent workflows.
-
Visualize Omnisend 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 Omnisend into TIBCO Spotfire.
-
Connect to Optimizely Data in Jaspersoft Studio
Execute SQL to remote Optimizely in Jaspersoft Studio.
-
A PostgreSQL Interface for Demio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Demio JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect to ClickUp Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to ClickUp. Leverage the pyodbc module for ODBC in Python.
-
Connect to Ontraport Data from a Connection Pool in JBoss
Integrate Ontraport into Java servlets: Use the Management Console in JBoss to install the Ontraport JDBC Driver.
-
Analyze CouchDB Data in Cognos Analytics
Use CData Connect AI to connect to CouchDB Data from Cognos Analytics and analyze live Apache CouchDB.
-
How to Build an ETL App for EnterpriseDB Data in Python with CData
Create ETL applications and real-time data pipelines for EnterpriseDB in Python with petl.
-
Replicate Teamgate Data to Multiple Databases via the CData Sync CLI
Replicate Teamgate to disparate databases with a single configuration.
-
How to Query Live SageHR Data in Claude Desktop
Connect to and query live SageHR Data in Claude Desktop using CData MCP Server.
-
Replicate Multiple REST Accounts
Replicate multiple REST accounts to one or many databases.
-
How to Build an ETL App for Power BI XMLA Data in Python with CData
Create ETL applications and real-time data pipelines for Power BI XMLA in Python with petl.
-
Access Live LinkedIn Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate LinkedIn Ads into the statistical analysis tools available in SAS JMP. This article shows how to use LinkedIn Ads in the Graph Builder and Query Builder.
-
Access Live SAP HANA Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP HANA from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Sugar CRM Data in Pentaho Data Integration
Build ETL pipelines based on Sugar CRM in the Pentaho Data Integration tool.
-
Connect to Samanage Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Samanage and work with Samanage in your FileMaker applications.
-
Build Agents in Relevance AI with Access to Live Google Ad Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Ad Manager within intelligent agent workflows.
-
How to Visualize Workday Data in Python with pandas
Use pandas and other modules to analyze and visualize live Workday in Python.
-
Connect to Teradata Data in Claris FileMaker Pro
Use the CData ODBC Driver for Teradata in FileMaker Pro to connect to Teradata and work with Teradata in your FileMaker applications.
-
Use Claude to Talk to Your Neo4J 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 Neo4J for you.
-
Visualize Live Amazon Marketplace Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Amazon Marketplace into custom reports in Power BI.
-
Create Power BI Reports on Real-Time Factorial Data
Use the CData ODBC Driver for Factorial to visualize Factorial in Power BI Desktop.
-
Extract, Transform, and Load JotForm Data in Informatica PowerCenter
Create a simple Workflow for JotForm in Informatica PowerCenter.
-
Query ClickUp Data in DataGrip
Create a Data Source for ClickUp in DataGrip and use SQL to query live ClickUp.
-
How to integrate Dynamics CRM with Apache Airflow
Access and process Microsoft Dynamics CRM in Apache Airflow using the CData JDBC Driver.