CData Software - Knowledge Base
Recent Articles
-
Deploy the ADO.NET Provider for Webflow on an SSRS Report Server
Connect to Webflow 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.
-
Connect to Apollo Data in Jaspersoft Studio
Execute SQL to remote Apollo in Jaspersoft Studio.
-
How to connect and process Teamgate from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teamgate.
-
How to Work with Couchbase Data in ETL Validator JDBC
Connect to Couchbase from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate Real-Time Access to Google Search in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Search in real time.
-
How to Import Data from Zoom into Google Sheets
Import Zoom into a Google spreadsheet that is automatically refreshed.
-
How to Query Live Highrise Data in Perplexity MacOS Desktop
Connect to and query live Highrise Data in Perplexity Desktop using CData MCP Server.
-
Access NetSuite 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 NetSuite CRM & ERP.
-
Connect to Neo4J Data in NetBeans
Connect to Neo4J in NetBeans with the data source configuration wizard.
-
Building Dynamic Web Pages with Workable Data Using AngularJS
Create single-page applications with live connectivity to Workable using the CData API Server.
-
Query ZeroBounce Data as a MySQL Database in Node.js
Execute MySQL queries against ZeroBounce from Node.js.
-
Automate Vault CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Couchbase.
-
Build Agents in Relevance AI with Access to Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Informix within intelligent agent workflows.
-
Bind Live Planio Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Planio data
-
Build Azure Synapse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Synapse Data from Zoho Analytics and import live Azure Synapse.
-
Analyze Asana Data in Looker
Use CData Connect AI to connect to Asana Data from Looker and build custom apps using live Asana.
-
Connect to Microsoft OneDrive Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft OneDrive in DBeaver.
-
How to Connect DBeaver to DB2 via a JDBC Driver
Manage IBM DB2 with visual tools in DBeaver like the query browser.
-
Integrating Cursor CLI with SAP Concur 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.
-
Automate Kafka Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Kafka replication to SAP HANA.
-
Integrate Real-Time Access to Neo4J in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Neo4J in real time.
-
Migrating data from Clio to Databricks using CData SSIS Components.
Easily push Clio to Databricks using the CData SSIS Tasks for Clio and Databricks.
-
Use the CData API Server to Access Flowlu Data in Microsoft PowerPivot
Use the CData API Server to connect to live Flowlu in the Power Pivot business intelligence tool.
-
How to Create Power BI Visual Reports with Real-Time SAP Fieldglass Data
Use CData Power BI Connectors to visualize SAP Fieldglass in Power BI.
-
Access Live LDAP Objects in Coginiti Pro
Connect to and query live LDAP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Enable the Flowlu JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Flowlu.
-
Import MailerSend Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MailerSend. In this article, you will use the OData format to import MailerSend into Microsoft Power Query.
-
Automate Google Sheets Data Replication to Couchbase
Use CData Sync to Customize and automate Google Sheets replication to Couchbase.
-
How to connect PolyBase to CockroachDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CockroachDB.
-
Natively Connect to Harvest Data in PHP
The CData ODBC driver for Harvest enables you to create PHP applications with connectivity to Harvest. Leverage the native support for ODBC in PHP.
-
Analyze WordPress Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze WordPress in Microsoft R Open.
-
Integrate with BenchmarkEmail Data in JReport Designer
Create charts and reports based on BenchmarkEmail in JReport Designer.
-
Integrate Highrise Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Highrise CRM and integrate live Highrise CRM into your Power Automate tasks.
-
Create Dynamic BambooHR Grids Using the Infragistics XamDataGrid
Learn how you can connect BambooHR to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Short.io Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Short.io and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Cursor CLI with CloudConvert 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.
-
Extend Google Sheets with Tanda Data
Make calls to Tanda from Google Apps Script via the API Server.
-
How to Work with Elorus Data in AWS Glue Jobs Using JDBC
Connect to Elorus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Hubstaff Data in DBArtisan
Use wizards in DBArtisan to configure Hubstaff as a data source.
-
Using the CData Software ODBC Driver for Act-On in PyCharm
Connect to Act-On as an ODBC data source in PyCharm using the CData Software ODBC Driver for Act-On.
-
Integrate with Flowlu Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Flowlu to a JSON file on disk.
-
Create MongoDB-Connected Applications in Appsmith
Connect to MongoDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MongoDB.
-
Visualize Accelo Data in TIBCO Spotfire through OData
Integrate Accelo into dashboards in TIBCO Spotfire.
-
Connecting Mastra with DB2 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 IBM DB2, no replication required.
-
Connect to Tavily Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tavily using standard SQL.
-
Enable the Typeform JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Typeform.
-
How to Access Reckon Accounts Hosted Data Using Entity Framework
This article shows how to access Reckon Accounts Hosted using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with Live GitHub Data in Power Query
Use CData Connect AI to connect to GitHub and work with live GitHub in Microsoft Power Query.
-
How to connect to Datadog Data from Spring Boot
Connect to Datadog in a Spring Boot Application using the CData API Driver for JDBC
-
Build Dashboards with SAP Business Warehouse Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business Warehouse in DBxtra.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Email using the Model Context Protocol.
-
Integrate Real-Time Access to BenchmarkEmail in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to BenchmarkEmail in real time.
-
Build Copper-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Copper Data in Claude Code to assist with building Copper-powered applications.
-
Connect to Paddle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paddle to connect to Paddle and execute queries in PowerBuilder.
-
Integrate with Aircall Data in JReport Designer
Create charts and reports based on Aircall in JReport Designer.
-
Automated Continuous HBase Replication to MySQL
Use CData Sync for automated, continuous, customizable HBase replication to MySQL.
-
Getting Started with the CData ADO.NET Provider for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Access Live SAP BusinessObjects BI Data in Visual Studio Code via Cline
Run CData MCP Server for SAP BusinessObjects BI on Windows Subsytem for Linux (WSL) and connect to live SAP BusinessObjects BI from the Cline extension in Visual Studio Code.
-
Connect WooCommerce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live WooCommerce using the CData Python MCP Server.
-
Connect to Google Forms from Asprova with CData Software ODBC Driver for Google Forms
This article shows how to connect faster to Google Forms data from Asprova.
-
Automated Continuous Spark Replication to Vertica
Use CData Sync for automated, continuous, customizable Spark replication to Vertica.
-
Connect to Adobe Target Data from a Connection Pool in Jetty
The Adobe Target JDBC Driver supports connection pooling: This article shows how to connect faster to Adobe Target from Web apps in Jetty.
-
Automated Continuous Impala Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Impala replication to AlloyDB.
-
Work with Google Search Results in FoxPro
Load Google Search into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Google Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Analytics.
-
Connect to and Query Databricks Data in QlikView over ODBC
Create data visualizations with Databricks in QlikView.
-
Integrating Claude Code with Google Drive Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Drive within assisted coding and automated development workflows.
-
Create Reports with Everhour Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Everhour.
-
How to Seamlessly Import Certinia Data into IBM SPSS Modeler
Integrate Certinia data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Simple VCL Application for Perplexity Data
How to build a simple VCL Application to view Perplexity in RAD Studio using the CData ODBC Driver for Perplexity.
-
Prepare, Blend, and Analyze Microsoft Entra ID Data in Alteryx Designer (Connect AI)
Build workflows to access live Microsoft Entra ID for self-service data analytics.
-
How to Access Live Campaigner Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Campaigner from the Cline extension in Visual Studio Code.
-
Prepare, Blend, and Analyze CircleCI Data in Alteryx Designer (ODBC)
Build workflows to access live CircleCI for self-service data analytics.
-
Access Live Oracle Sales Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Sales from your Excel spreadsheets.
-
Configure the CData JDBC Driver for ZarMoney in a Connection Pool in Tomcat
Connect to ZarMoney from a connection pool in Tomcat.
-
Automate SharePoint Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft SharePoint from PowerShell? This article demonstrates how to utilize the SharePoint Cmdlets for tasks like connecting to Microsoft SharePoint, automating operations, downloading data, and more.
-
Moving Data from PayPal to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live PayPal data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build AI Agents with Vertica 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 Vertica through CData Connect AI.
-
Automate Google Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Ads from PowerShell? This article demonstrates how to utilize the Google Ads Cmdlets for tasks like connecting to Google Ads, automating operations, downloading data, and more.
-
Integrating Antigravity CLI with Instagram via CData CLI
Connect Instagram to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect Raisers Edge NXT to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Raisers Edge NXT with IBM WebSphere for seamless data integration and connectivity.
-
Bind Live Perigon Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Perigon data
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Microsoft Ads
Provide connectivity to Microsoft Ads through an SAP BusinessObjects universe.
-
Import SAP Ariba Source Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access SAP Ariba Source. In this article, you will use the OData format to import SAP Ariba Source into Microsoft Power Query.
-
Use Agno to Talk to Your ADP 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 ADP for you.
-
Create Datasets from Azure Table in Domo Workbench and Build Visualizations of Azure Table Data in Domo
Use the CData Software ODBC Driver for Azure Table to create datasets from Azure Table Storage in Domo Workbench and then build visualizations in the Domo service.
-
Access Live SageHR Data in AWS Lambda
Connect to live SageHR in AWS Lambda using the CData JDBC Driver.
-
How to Connect the Power BI Service to Teradata: Complete Guide
Connect to the CData Software Power BI Connector for Teradata from PowerBI.com to provide real-time Teradata across the organization.
-
How to Import Data from Nethunt into Google Sheets
Import Nethunt into a Google spreadsheet that is automatically refreshed.
-
How to publish and share Gorgias Data dashboards with Tableau Server
The CData ODBC driver for Gorgias enables you integrate Gorgias into Tableau dashboards.
-
Connect to ConvertKit Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ConvertKit as an External Source in Dremio.
-
Automated Continuous Mailgun Replication to SQLite
Use CData Sync for automated, continuous, customizable Mailgun replication to SQLite.
-
DataBind Stack Exchange Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Stack Exchange to a chart.
-
Integrate Excel Online Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Excel Online from Informatica Cloud.
-
Add AlloyDB Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for AlloyDB with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish Twilio-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Twilio.
-
Process & Analyze ZohoInvoice Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live ZohoInvoice Data.
-
Use Agno to Talk to Your SharePoint 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 Microsoft SharePoint for you.
-
Build Kintone-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Kintone to explore live Kintone Data in Claude Code to assist with building Kintone-powered applications.
-
Access ZarMoney Data from MySQL in Amazon QuickSight
Connect to ZarMoney and build visualizations of ZarMoney using a MySQL Connection in Amazon QuickSight.