CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code with Oracle Sales Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Sales data within assisted coding and automated development workflows.
-
Integrating Kiro with Reckon 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.
-
Create a Data Access Object for Campaigner Data using JDBI
A brief overview of creating a SQL Object API for Campaigner data in JDBI.
-
Integrate Google's Vertex AI Agent with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Couchbase data within intelligent workflows.
-
Use Dash to Build Web Apps on Moosend Data via CData Connect AI
Build interactive Dash web apps on live Moosend data using pandas and the CData Connect AI Python SDK.
-
Integrate Real-Time Access to Couchbase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Couchbase data in real time.
-
Connect to SAP Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to SAP.
-
Create SSAS Tabular Models from Amazon Marketplace Data
How to build a SQL Server Analysis Service Tabular Model from Amazon Marketplace data using CData drivers.
-
Integrate xBase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate xBase with External Services.
-
Build Dashboards with Freshsales Data in Dundas BI
Create dynamic dashboards and perform analytics based on Freshsales data in Dundas BI.
-
Connect to Vimeo Data from a Connection Pool in JBoss
Integrate Vimeo data into Java servlets: Use the Management Console in JBoss to install the Vimeo JDBC Driver.
-
Design BIRT Reports on Microsoft Planner Data
Provide current Microsoft Planner data to your embedded analytics.
-
Publish Sugar CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sugar CRM data.
-
Build Cassandra-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Cassandra data without replication.
-
How to load Gumroad data into Elasticsearch via Logstash
Introducing a simple method to load Gumroad data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create ShipStation-Connected Dashboards in Grafana
Connect to ShipStation Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ShipStation data.
-
Connect to Egnyte Data from AWS Glue
Use CData Connect AI to gain access to live Egnyte data from your AWS Glue jobs.
-
Automated Continuous Mocean Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mocean replication to Azure SQL Database.
-
Build Semantic Layer Views for FreshBooks Data in APOS Live Data Gateway
Use the CData Connector for FreshBooks in APOS Live Data Gateway to build Semantic Layer Views for FreshBooks data.
-
Automated Continuous Cosmos DB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Cosmos DB replication to IBM DB2.
-
Prepare, Blend, and Analyze Shopify Data in Alteryx Designer (Connect AI)
Build workflows to access live Shopify data for self-service data analytics.
-
Use Databricks Agent Bricks to Talk to Your QuickBooks Online Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your QuickBooks Online data for you.
-
Connect to TaxJar Data from Crystal Reports
Use CData Connect AI to connect to and report on live TaxJar data from Crystal Reports.
-
How to Connect to Live Redshift Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Redshift data for you.
-
Replicate Mailgun Data in Heroku for Use in Salesforce Connect
Replicate Mailgun data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Confluence Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Confluence data from your Excel spreadsheets.
-
Connect Instagram Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Instagram data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Python Connector for Opsgenie
Learn to install and license the CData Python Connector and configure a connection to live Opsgenie data.
-
Connect to and Query MYOB AccountRight Data in QlikView over ODBC
Create data visualizations with MYOB AccountRight data in QlikView.
-
How to create an RPA flow for Insightly Data in UiPath Studio
Use the Insightly ODBC Driver to create workflows that access real-time Insightly data without any coding.
-
Build a Singer.io Tap for Mocean With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Mocean data using the CData Python Connector.
-
How to Connect to Live Freshdesk 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 Freshdesk data for you.
-
Integrate with Freshdesk Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Freshdesk data to a JSON file on disk.
-
Automated Continuous Customer.io Replication to SingleStore
Use CData Sync for automated, continuous, customizable Customer.io replication to SingleStore.
-
Use Manus AI to Talk to Your Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Slack data.
-
Replicate Salesforce Marketing Data to Multiple Databases via the CData Sync CLI
Replicate Salesforce Marketing data to disparate databases with a single configuration.
-
Back Up Square data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Square. In this article, we will employ an SSIS workflow to populate a database with Square data data.
-
How to connect Amazon QuickSight to SAP Ariba Procurement Data
Create a connection to SAP Ariba Procurement data in CData Connect AI and insert SAP Ariba Procurement data into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Claude Code CLI with Zoho Creator 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.
-
Establish a Live Connection with Freshservice Data using Tableau Bridge
The CData ODBC Driver for Freshservice enables you to integrate live Freshservice data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate BenchmarkEmail Data into Power Automate Desktop using CData Connect
CData Connect for BenchmarkEmail Data enables you to integrate BenchmarkEmail data into workflows built using Microsoft Power Automate Desktop.
-
How to connect to VWO Data from Spring Boot
Connect to VWO in a Spring Boot Application using the CData API Driver for JDBC
-
Use Databricks Agent Bricks to Talk to Your Active Directory Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Active Directory data for you.
-
Integrate Wistia Data in the Pentaho Report Designer
Publish reports based on Wistia data in the Pentaho BI tool.
-
Integrate Exact Online with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Exact Online with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Exact Online data.
-
Add Okta Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Okta with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Productboard Data Using Entity Framework
This article shows how to access Productboard data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to AdRoll Data from IntelliJ
Integrate connectivity to AdRoll data with wizards in IntelliJ.
-
Connect to Pinterest Data in CloverDX (formerly CloverETL)
Transfer Pinterest data using the visual workflow in the CloverDX data integration tool.
-
Query MarkLogic Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume MarkLogic entities in PHP by modeling them as objects.
-
Use the CData ODBC Driver for RabbitMQ from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for RabbitMQ to connect to RabbitMQ data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring RabbitMQ data in Excel.
-
Publish JSON-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live JSON services.
-
Create a Data Access Object for Klipfolio Data using JDBI
A brief overview of creating a SQL Object API for Klipfolio data in JDBI.
-
Model, Search, and Visualize Live Gong Data in ThoughtSpot
Use CData Connect AI to connect to live Gong data for modeling, searching, and visualizing.
-
Integrate Dify with Live Freshservice Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Freshservice data.
-
How to Query Live Figshare Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Figshare data data in natural language using Python.
-
Connect to Keap Data in Aqua Data Studio
Access Keap data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Claude to Talk to Your BigCommerce 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 BigCommerce data for you.
-
Automated Continuous CapsuleCRM Replication to Vertica
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Vertica.
-
View Reports on Real-Time Google Spanner Data in Power BI Report Server
Use the CData ODBC Driver for Google Spanner to visualize Google Spanner data in Power BI Desktop and then publish them to Power BI Report Server.
-
Build Sage 300-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Sage 300 data and build Sage 300-connected web apps with Axios.
-
Connect to Demio Data from a Connection Pool in Jetty
The Demio JDBC Driver supports connection pooling: This article shows how to connect faster to Demio data from Web apps in Jetty.
-
Extract, Transform, and Load Microsoft Planner Data in Informatica PowerCenter
Create a simple Workflow for Microsoft Planner data in Informatica PowerCenter.
-
Automated Continuous MailerLite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MailerLite replication to AlloyDB.
-
Integrate with Couchbase Data in JReport Designer
Create charts and reports based on Couchbase data in JReport Designer.
-
Getting Started with the CData Connect AI Python SDK for EnterpriseDB
Install the CData Connect AI Python SDK to read and write live EnterpriseDB data with standard DB-API 2.0 Python code.
-
Integrating LlamaIndex with Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshteam data in real time.
-
Migrating data from Freshteam to Databricks using CData SSIS Components.
Easily push Freshteam data to Databricks using the CData SSIS Tasks for Freshteam and Databricks.
-
Automate Google Forms Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Forms data replication to Azure Data Lake.
-
Use Claude to Talk to Your SAP Ariba Source 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 SAP Ariba Source data for you.
-
Access Live ZohoSubscriptions Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZohoSubscriptions data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live MongoDB Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live MongoDB data from within the IDE.
-
Mailgun Reporting in OBIEE with the Mailgun JDBC Driver
Deploy the Mailgun JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Bridge Paylocity Connectivity with Apache NiFi
Access and process Paylocity data in Apache NiFi using the CData JDBC Driver.
-
Visualize Jira Assets Data in Sisense
Create an ElastiCube in Sisense app with access to Jira Assets data.
-
Build Highrise-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Highrise data and build Highrise-connected web apps with Axios.
-
Create Datasets from Perplexity in Domo Workbench and Build Visualizations of Perplexity Data in Domo
Use the CData Software ODBC Driver for Perplexity to create datasets from Perplexity data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous Codat Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Codat replication to Google Cloud SQL.
-
Access Live Zoho Recruit Data in AWS Lambda
Connect to live Zoho Recruit data in AWS Lambda using the CData JDBC Driver.
-
Access Live Moosend Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Moosend data through MCP integration.
-
Connect to Highrise Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Highrise data in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for Office 365 in MicroStrategy Web
Connect to Office 365 data in MicroStrategy Web using the CData Software JDBC Driver for Office 365.
-
How to connect to Google Directory Data with Squirrel SQL client
Connect to Google Directory data and execute queries in the Squirrel SQL Client.
-
Viewing Active Directory Data in RAD Studio Data Explorer
How to view Active Directory data in RAD Studio Data Explorer using the CData ODBC Driver for Active Directory.
-
Connect to JotForm Data in CloverDX (formerly CloverETL)
Transfer JotForm data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Spotify Replication to Oracle
Use CData Sync for automated, continuous, customizable Spotify replication to Oracle.
-
Analyze Quickbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Quickbase data in Microsoft R Open.
-
Connect to Real-Time CampaignMonitor Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use CampaignMonitor data in Power Apps.
-
Build Apps with Live MYOB AccountRight data in Adalo using CData Connect AI
Use CData Connect AI to integrate live MYOB AccountRight data into the Adalo platform and build custom mobile and web applications with real-time MYOB AccountRight data.
-
Prepare, Blend, and Analyze Wistia Data in Alteryx Designer (ODBC)
Build workflows to access live Wistia data for self-service data analytics.
-
How to Connect to & Open Supabase Data in Microsoft Excel
This article uses the CData ODBC driver for Supabase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Vercel Replication to SQLite
Use CData Sync for automated, continuous, customizable Vercel replication to SQLite.
-
Query DB2 Data in ColdFusion
Write standard ColdFusion data access code to connect to DB2 data.
-
Integrate Live Testmonitor Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Testmonitor data and integrate live Testmonitor data into apps built in Microsoft Power Apps.
-
Build MVC Applications with Connectivity to Parallel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parallel from an ASP.NET MVC application.
-
How to import Gorgias Data into Apache Solr
Use the CData Software JDBC Driver for Gorgias in Data Import Handler and create an automated import of Gorgias data to Apache Solr Enterprise Search platform.
-
Connecting Moonlit Workflow with Cvent Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Cvent data in real time.
-
Process & Analyze TaxJar Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live TaxJar Data.
-
Visualize Live Vimeo Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Vimeo data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for OpenWeatherMap in SAS for Real-Time Reporting and Analytics
Connect to real-time OpenWeatherMap data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for OpenWeatherMap.