CData Software - Knowledge Base
Recent Articles
-
Integrating Boomi Agentstudio with Adobe Commerce via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Adobe Commerce, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Natively Connect to Google Analytics in PHP
The CData ODBC driver for Google Analytics enables you to create PHP applications with connectivity to Google Analytics. Leverage the native support for ODBC in PHP.
-
Automated Continuous SAP Hybris C4C Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Kafka.
-
Connect to Bullhorn CRM in CloverDX (formerly CloverETL)
Transfer Bullhorn CRM using the visual workflow in the CloverDX data integration tool.
-
Connect to Greenhouse in Jaspersoft Studio
Execute SQL to remote Greenhouse in Jaspersoft Studio.
-
Object-Relational Mapping (ORM) with Twitter 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 Twitter into a Java-based ORM framework, Hibernate.
-
How to Query Live QuickBooks Time in Perplexity MacOS Desktop
Connect to and query live QuickBooks Time in Perplexity Desktop using CData Code Assist MCP.
-
Visualize Live Microsoft Planner in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Planner into custom reports in Power BI.
-
Query, Visualize, and Share live Google Search Results in Redash
Use CData Connect AI to connect to live Google Search in Redash for querying, visualizing, and sharing.
-
Add NetSuite to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for NetSuite with the Informatica Enterprise Data Catalog to classify and organize data.
-
Deploy the ADO.NET Provider for Adobe Commerce on an SSRS Report Server
Connect to Adobe Commerce 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 LangChain with Adobe Commerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Commerce within automated workflows.
-
Integrate Live CockroachDB 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.
-
Replicate Google Sheets from PowerShell
Write a quick PowerShell script to query Google Sheets. Use connectivity to the live data to replicate Google Sheets to SQL Server.
-
Analyze Azure Data Catalog with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Azure Data Catalog from Power Pivot. You will use the Table Import Wizard to load Azure Data Catalog. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Live Smartsheet in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Smartsheet.
-
Build Power BI XMLA-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Power BI XMLA and create custom apps in Mendix.
-
Add SharePoint to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SharePoint with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Live Jira Service Management in Claude Desktop
Connect to and query live Jira Service Management in Claude Desktop using CData Code Assist MCP.
-
Access Redis from MySQL in Amazon QuickSight
Connect to Redis and build visualizations of Redis using a MySQL Connection in Amazon QuickSight.
-
Build Agents in Relevance AI with Access to Live Reckon via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Reckon within intelligent agent workflows.
-
Use Claude to Talk to Your OneNote via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Microsoft OneNote for you.
-
Bridge BigCommerce Connectivity with Apache NiFi
Access and process BigCommerce in Apache NiFi using the CData JDBC Driver.
-
Connect to Dropbox in HULFT Integrate
Connect to Dropbox as a JDBC data source in HULFT Integrate
-
PowerShell Scripting to Replicate NetSuite to MySQL
Write a simple PowerShell script to replicate NetSuite CRM & ERP to a MySQL database.
-
Connect to QuickBooks in RapidMiner
Integrate QuickBooks Desktop with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Build an ETL App for SAP Netweaver Gateway in Python with CData
Create ETL applications and real-time data pipelines for SAP Netweaver Gateway in Python with petl.
-
Add Adobe Experience Manager to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Adobe Experience Manager with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to create Zendesk federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zendesk in MySQL .
-
Use the CData Software ODBC Driver for Bing Ads in SAS for Real-Time Reporting and Analytics
Connect to real-time Bing Ads in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Bing Ads.
-
LINQ to SendGrid
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 SendGrid Data Provider.
-
How to Connect to Live Azure Table 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 Azure Table Storage for you.
-
Connect to Marketo in Aqua Data Studio
Access Marketo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create a Data Access Object for Google Campaign Manager 360 using JDBI
A brief overview of creating a SQL Object API for Google Campaign Manager 360 in JDBI.
-
Build Voice Agents in ElevenLabs with access to Live Snapchat Ads
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Snapchat Ads.
-
Connect to LinkedIn in HULFT Integrate
Connect to LinkedIn as a JDBC data source in HULFT Integrate
-
Connect to eBay Analytics from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for eBay Analytics to connect to eBay Analytics and execute queries in PowerBuilder.
-
How to Work with AlloyDB in ETL Validator JDBC
Connect to AlloyDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Query Google Ads from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Ads and perform CRUD operations on Google Ads from Node.js.
-
Create a Data Access Object for HDFS using JDBI
A brief overview of creating a SQL Object API for Apache HDFS in JDBI.
-
How to Seamlessly Import Google Data Catalog Data into IBM SPSS Modeler
Integrate Google Data Catalog data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect Jira Assets to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Jira Assets using the CData Python MCP Server.
-
Write a Simple Go Application to work with Salesforce Data Cloud on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Salesforce Data Cloud.
-
Use the CData Software ODBC Driver for PostgreSQL in MicroStrategy Desktop
Connect to PostgreSQL in MicroStrategy Desktop using the CData Software ODBC Driver for PostgreSQL.
-
Create SSAS Tabular Models from SAS Data Sets
How to build a SQL Server Analysis Service Tabular Model from SAS Data Sets using CData drivers.
-
Replicate MarkLogic to Multiple Databases
Replicate MarkLogic to disparate databases with a point-and-click configuration.
-
Create Reports from YouTube Analytics in Looker Studio
Use CData Connect AI to gain access to live YouTube Analytics and create custom reports in Looker Studio.
-
Build Automated Oracle Service Cloud-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Service Cloud and build automated workflows in Zapier.
-
Publish Reports with SendGrid in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendGrid.
-
Connecting Agentforce with Redshift 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 Amazon Redshift for you.
-
How to load Workday data into Elasticsearch via Logstash
Introducing a simple method to load Workday data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Twilio from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Twilio for you.
-
Automate Wave Financial Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Wave Financial and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Easily Query MySQL in OpenOffice Base
-