CData Software - Knowledge Base
Recent Articles
-
Analyze Jira Assets Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Jira Assets and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Smartsheet-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Smartsheet to explore live Smartsheet Data in Cursor to assist with building Smartsheet-powered applications.
-
Connect to Redshift Data from a Connection Pool in JBoss
Integrate Amazon Redshift into Java servlets: Use the Management Console in JBoss to install the Redshift JDBC Driver.
-
Explore Geographical Relationships in Parallel Data with Power Map
Create data visualizations with Parallel in Power Map.
-
Replicate Multiple Amazon Marketplace Accounts via the CData Sync CLI
Replicate multiple Amazon Marketplace accounts to one or many databases.
-
Build Moosend-Powered Applications in Cursor with CData MCP Server
Use the CData API Driver for MCP Server to explore live Moosend Data in Cursor to assist with building Moosend-powered applications.
-
How to Query Live Vault CRM Data in Claude Desktop
Connect to and query live Vault CRM Data in Claude Desktop using CData MCP Server.
-
Query Microsoft Entra ID Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Entra ID entities in PHP by modeling them as objects.
-
Integrating Kiro CLI with Bullhorn 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.
-
How to Query Live Azure Data Catalog Data in Perplexity MacOS Desktop
Connect to and query live Azure Data Catalog Data in Perplexity Desktop using CData MCP Server.
-
How to connect to Yelp Data from Spring Boot
Connect to Yelp in a Spring Boot Application using the CData API Driver for JDBC
-
Object-Relational Mapping (ORM) with Oracle Eloqua Reporting 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 Oracle Eloqua Reporting into a Java-based ORM framework, Hibernate.
-
Visualize ZohoExpense Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ZohoExpense.
-
How to work with Superchat Data in Apache Spark using SQL
Access and process Superchat Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to Facebook: Complete Guide
Connect to the CData Software Power BI Connector for Facebook from PowerBI.com to provide real-time Facebook across the organization.
-
Connect to Basecamp Data in Aqua Data Studio
Access Basecamp from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Dashboards with SAP Ariba Procurement Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Ariba Procurement in Dundas BI.
-
Replicate Mailjet Data from PowerShell
Write a quick PowerShell script to query Mailjet. Use connectivity to the live data to replicate Mailjet to SQL Server.
-
How to integrate Amazon DynamoDB with Apache Airflow
Access and process Amazon DynamoDB in Apache Airflow using the CData JDBC Driver.
-
Access Live MongoDB Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live MongoDB from your Excel spreadsheets.
-
Automated Continuous Google Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Ads replication to SQLite.
-
How to Access Live Epicor Kinetic Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Epicor Kinetic enables you to integrate Epicor Kinetic into workflows built using Microsoft Power Automate Desktop.
-
Bridge Keap Connectivity with Apache NiFi
Access and process Keap in Apache NiFi using the CData JDBC Driver.
-
Natively Connect to Insightly Data in PHP
The CData ODBC driver for Insightly enables you to create PHP applications with connectivity to Insightly. Leverage the native support for ODBC in PHP.
-
Query AdRoll Data as a MySQL Database in Node.js
Execute MySQL queries against AdRoll from Node.js.
-
Connecting Pipedream with Shopify Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Shopify data in real time.
-
DataBind FTP Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for FTP with the DevExpress Windows Forms and Web controls to provide FTP Servers to a chart.
-
Access PostgreSQL Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PostgreSQL from your Oracle system.
-
Query Azure Table Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Azure Table Storage from Node.js.
-
Connect to Live Google Search Results in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Search in CData Connect AI and connect to your Google Search from PostgreSQL.
-
Validate Facebook Ads Data with QuerySurge
Access and validate Facebook Ads in QuerySurge using the CData JDBC Driver.
-
Connect to Dynamics 365 Data in NetBeans
Connect to Microsoft Dynamics 365 in NetBeans with the data source configuration wizard.
-
Create Google Forms Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Forms data access from reports, embedded analytics, and more.
-
Easily Integrate Microsoft Dataverse Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Dataverse (CDS) in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Agentforce with Salesforce CRM Analytics 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 Salesforce CRM Analytics for you.
-
Migrating data from Cloudflare to Databricks using CData SSIS Components.
Easily push Cloudflare to Databricks using the CData SSIS Tasks for Cloudflare and Databricks.
-
Connect to Authorize.Net from a Connection Pool in WebLogic
Use the CData JDBC Driver for Authorize.Net to connect to Authorize.Net from Web applications running on WebLogic.
-
Add Freshsales Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Freshsales with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating LangGraph with Freshdesk Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Freshdesk within automated workflows.
-
Viewing Datadog Data in RAD Studio Data Explorer
How to view Datadog in RAD Studio Data Explorer using the CData ODBC Driver for Datadog.
-
Back Up Oracle Eloqua Reporting to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle Eloqua Reporting. In this article, we will employ an SSIS workflow to populate a database with Oracle Eloqua Reporting data.
-
Analyze QuickBooks Time Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of QuickBooks Time and visualize QuickBooks Time in SAP Analytics Cloud.
-
Operational Reporting on HubSpot Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HubSpot.
-
Integrate Cline with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live API from within your IDE.
-
Connect to ChargeOver from a Connection Pool in WebLogic
Use the CData JDBC Driver for ChargeOver to connect to ChargeOver from Web applications running on WebLogic.
-
Automate ZohoDesk Data Replication to SAP HANA
Use CData Sync to customize and automate ZohoDesk replication to SAP HANA.
-
Automated Continuous Oracle Eloqua Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Oracle Eloqua replication to Azure SQL Database.
-
Build Salesforce Data 360-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Salesforce Data Cloud to explore live Salesforce Data 360 Data in Cursor to assist with building Salesforce Data 360-powered applications.
-
Use Microsoft Copilot Studio to talk to your Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Bullhorn CRM for you.
-
Integrating Claude Code CLI with ZohoInvoice 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.
-
Integrate Live CockroachDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to CockroachDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live CockroachDB.
-
Getting Started with the CData Tableau Connector for Anaplan
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Anaplan.
-
Automate Microsoft OneLake Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft OneLake replication to SAP HANA.
-
Use the CData Software ODBC Driver for MarkLogic in SAS for Real-Time Reporting and Analytics
Connect to real-time MarkLogic in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for MarkLogic.
-
Automated Continuous Pinterest Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Pinterest replication to Apache Cassandra.
-
Migrating data from Aircall to Snowflake using CData SSIS Components.
Easily push Aircall to Snowflake using the CData SSIS Tasks for Aircall and Snowflake.
-
Integrate Live Yelp Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Yelp to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating GitHub Copilot CLI with Perigon 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.
-
Easily Integrate SAP Hybris C4C Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP Hybris C4C in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Office 365 Data from a Connection Pool in JBoss
Integrate Microsoft Office 365 into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.
-
Connecting GenSpark with Authorize.Net Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Authorize.Net without any replication or custom integration required.
-
Using the CData Software ODBC Driver for OnePageCrm in PyCharm
Connect to OnePageCrm as an ODBC data source in PyCharm using the CData Software ODBC Driver for OnePageCrm.
-
Use the CData Software ODBC Driver for CloudConvert in MicroStrategy Web
Connect to CloudConvert in MicroStrategy Web using the CData Software ODBC Driver for CloudConvert.
-
Connect to JotForm Data as an External Source in Dremio
Use the CData JDBC Driver to connect to JotForm as an External Source in Dremio.
-
Reply.io Reporting in OBIEE with the Reply.io JDBC Driver
Deploy the Reply.io JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Building Dynamic Web Pages with Sybase Data Using AngularJS
Create single-page applications with live connectivity to Sybase using the CData API Server.
-
How to publish and share Facebook Ads Data dashboards with Tableau Server
The CData ODBC driver for Facebook Ads enables you integrate Facebook Ads into Tableau dashboards.
-
Build MVC Applications with Connectivity to Instantly Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Instantly from an ASP.NET MVC application.
-
Integrate Live Act CRM Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use Databricks Agent Bricks to Talk to Your HBase Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Apache HBase for you.
-
Automated Continuous Avalara AvaTax Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to Azure SQL Database.
-
Build Coinbase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData API Driver for MCP Server to explore live Coinbase Data in Gemini Code Assist to assist with building Coinbase-powered applications.
-
Connect to and Query iContact Data in QlikView over ODBC
Create data visualizations with iContact in QlikView.
-
Automate PagerDuty Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live PagerDuty and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous ZohoPeople Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Vertica.
-
Create Google Analytics Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Analytics from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous FHIR Replication to Databricks
Use CData Sync for automated, continuous, customizable FHIR replication to Databricks.
-
Bridge Oracle HCM Cloud Connectivity with Apache NiFi
Access and process Oracle HCM Cloud in Apache NiFi using the CData JDBC Driver.
-
Connect to Adobe Experience Manager Data from a Connection Pool in JBoss
Integrate Adobe Experience Manager into Java servlets: Use the Management Console in JBoss to install the Adobe Experience Manager JDBC Driver.
-
Create Dynamic Couchbase Grids Using the Infragistics XamDataGrid
Learn how you can connect Couchbase to Infragistics XamDataGrid to build dynamic grids.
-
Publish Jira-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Atlassian Jira.
-
How to Build an ETL App for Twitter Ads Data in Python with CData
Create ETL applications and real-time data pipelines for Twitter Ads in Python with petl.
-
Create Reports from Avro Data in Looker Studio
Use CData Connect AI to gain access to live Apache Avro and create custom reports in Looker Studio.
-
Integrating LangChain with OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on OData within automated workflows.
-
How to Connect DBeaver to Recurly via a JDBC Driver
Manage Recurly with visual tools in DBeaver like the query browser.
-
Build Tally-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Tally to explore live Tally Data in GitHub Copilot to assist with building Tally-powered applications.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Workable to Power BI dashboards. Simply drag and drop Workable into data visuals on the Power BI canvas.
-
Build Pipelines with Live SAS Data Sets Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SAS Data Sets from Google Cloud Data Fusion, enabling the integration of live SAS Data Sets into the building and management of effective data pipelines.
-
How to create SAP HANA XS Advanced federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP HANA XS Advanced in MySQL .
-
Build FHIR-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live FHIR and build FHIR-connected web apps with Axios.
-
Access Live GraphQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live GraphQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Dynamic Autopilot Grids Using the Infragistics XamDataGrid
Learn how you can connect Autopilot to Infragistics XamDataGrid to build dynamic grids.
-
Analyze ServiceNow Data in Cognos Analytics
Use CData Connect AI to connect to ServiceNow Data from Cognos Analytics and analyze live ServiceNow.
-
Create Datasets from Presto in Domo Workbench and Build Visualizations of Presto Data in Domo
Use the CData Software ODBC Driver for Presto to create datasets from Presto in Domo Workbench and then build visualizations in the Domo service.
-
Excel Spreadsheet Automation on YouTube Analytics Data with the QUERY Formula
Pull data from YouTube Analytics, automate spreadsheets, and more with the QUERY formula.
-
Integrating Kiro CLI with Sage 300 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.
-
Visualize Google Ad Manager Data in Sisense
Create an ElastiCube in Sisense app with access to Google Ad Manager.
-
Connect to Omnisend Data from a Connection Pool in JBoss
Integrate Omnisend into Java servlets: Use the Management Console in JBoss to install the Omnisend JDBC Driver.
-
How to Connect to & Open Jira Data in Microsoft Excel
This article uses the CData ODBC driver for Jira to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Hive Data in Jaspersoft Studio
Execute SQL to remote Apache Hive in Jaspersoft Studio.