CData Software - Knowledge Base
Recent Articles
-
Integrate Theia IDE with Live Airtable Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrating Codex CLI with MailChimp 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 Informatica Mappings From/To a JDBC Data Source for Slack
Create Slack data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Bridge ChartMogul Connectivity with Apache NiFi
Access and process ChartMogul in Apache NiFi using the CData JDBC Driver.
-
Integrating OpenCode Terminal with RabbitMQ 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.
-
Connecting Moonlit Workflow with SAP BusinessObjects BI 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 SAP BusinessObjects BI in real time.
-
Connect to Workday Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Workday Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Visualize Live Neo4J Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Neo4J.
-
Natively Connect to Microsoft Teams Data in PHP
The CData ODBC driver for Microsoft Teams enables you to create PHP applications with connectivity to Microsoft Teams. Leverage the native support for ODBC in PHP.
-
Consume Elasticsearch OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Elasticsearch feeds that reflect any changes in SAP Lumira.
-
Build Sybase IQ-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase IQ Data and create custom apps in Mendix.
-
How to connect to Shippo Data from IntelliJ
Integrate connectivity to Shippo with wizards in IntelliJ.
-
Automated Continuous CapsuleCRM Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable CapsuleCRM replication to Apache Cassandra.
-
Use CData Connect AI to Access Quickbase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Quickbase in the Power Pivot business intelligence tool.
-
Connect to Blackbaud FE NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Notion Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Notion using standard SQL.
-
Build a Simple VCL Application for FreeAgent Data
How to build a simple VCL Application to view FreeAgent in RAD Studio using the CData ODBC Driver for FreeAgent.
-
Create Informatica Mappings From/To a JDBC Data Source for ServiceDesk Plus
Create ServiceDesk Plus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
ETL SAP ByDesign in Oracle Data Integrator
This article shows how to transfer SAP Business ByDesign into a data warehouse using Oracle Data Integrator.
-
Access Live Adobe Commerce Data in TIBCO Data Virtualization
Use the Adobe Commerce Tibco DV Adapter to create a Adobe Commerce data source in TIBCO Data Virtualization Studio and gain access to live Adobe Commerce from your TDV Server.
-
Write a Simple Go Application to work with Jira Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Atlassian Jira.
-
Query Google Drive Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Drive and perform CRUD operations on Google Drive from Node.js.
-
Use the CData ODBC Driver for ActiveCampaign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ActiveCampaign to connect to ActiveCampaign from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ActiveCampaign in Excel.
-
Connect to Gong from Asprova with CData Software ODBC Driver for Gong
This article shows how to connect faster to Gong data from Asprova.
-
Automated Continuous Presto Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Presto replication to delimited files (CSV/TSV).
-
Publish Reports with Guru Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Guru.
-
How to use SQLAlchemy ORM to access Shortcut Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shortcut.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Elorus
Provide connectivity to Elorus through an SAP BusinessObjects universe.
-
Build CockroachDB-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to CockroachDB and build web apps with connectivity to live CockroachDB.
-
Access Live Brex Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Brex in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Power BI Reports on Real-Time HubDB Data
Use the CData ODBC Driver for HubDB to visualize HubDB in Power BI Desktop.
-
Prepare, Blend, and Analyze Google Spanner Data in Alteryx Designer (Connect AI)
Build workflows to access live Google Spanner for self-service data analytics.
-
Use Azure AI Foundry to Talk to Your OData Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your OData for you.
-
How to Connect the Power BI Service to Shippo: Complete Guide
Connect to the CData Software Power BI Connector for Shippo from PowerBI.com to provide real-time Shippo across the organization.
-
Connect to Egnyte Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Egnyte using standard SQL.
-
Connect to ServiceNow Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ServiceNow in the Denodo Virtual DataPort Administrator.
-
Connect to Zuora Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zuora.
-
How to use SQLAlchemy ORM to access Oracle Sales Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Oracle Sales.
-
Connect to Apollo Data from PowerBuilder via JDBC
This article demonstrates how to access Apollo from PowerBuilder using the Apollo JDBC Driver.
-
Access Live Azure DevOps Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure DevOps from your Excel spreadsheets.
-
How to Access Live Unbounce Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Unbounce from the Cline extension in Visual Studio Code.
-
Replicate Jumpseller Data to Multiple Databases via the CData Sync CLI
Replicate Jumpseller to disparate databases with a single configuration.
-
Import SAP BusinessObjects BI Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SAP BusinessObjects BI Data and provide access to live SAP BusinessObjects BI for custom reports in the Power BI Service.
-
Connect to ConvertKit Data in DBeaver
Use the CData ODBC Driver to connect to ConvertKit in DBeaver.
-
How to Connect to Delighted Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Delighted. Leverage the pyodbc module for ODBC in Python.
-
Leverage the Full Potential of Workday data with CData Sync
This article compares the CData Sync Workday Connector with Workday connectors from other ETL/ELT platforms.
-
Build Apps with Live Pingdom Data Using the Low-Code Development Platform of Mendix
Connect Pingdom with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to Teamwork Data in JRuby
Create a simple JRuby app with access to live Teamwork.
-
Getting Started with the CData JDBC Driver for Contentful
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Contentful.
-
Connect to QuickBooks Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Desktop in the Denodo Virtual DataPort Administrator.
-
Moving Data from Codat to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Codat data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Dynamic Jira Assets Grids Using the Infragistics XamDataGrid
Learn how you can connect Jira Assets to Infragistics XamDataGrid to build dynamic grids.
-
Access ChartMogul Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live ChartMogul from HeidiSQL.
-
Use Manus AI to Talk to Your Email 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 Email.
-
Integrating Antigravity CLI with Sendwithus via CData CLI
Connect Sendwithus to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData Power BI Connector for Impala
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Impala.
-
Import SingleStore Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SingleStore Data and provide access to live SingleStore for custom reports in the Power BI Service.
-
How to Access Live Confluence Data in Visual Studio Code via Cline
Run CData MCP Server for Confluence on Windows Subsytem for Linux (WSL) and connect to live Atlassian Confluence from the Cline extension in Visual Studio Code.
-
Query Jodoo Data in ColdFusion
Write standard ColdFusion data access code to connect to Jodoo.
-
Build MVC Applications with Connectivity to SageHR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SageHR from an ASP.NET MVC application.
-
Analyze Monday.com Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Monday.com and visualize live Monday.com in Infragistics Reveal.
-
How to Work with Adobe Analytics Data in ETL Validator JDBC
Connect to Adobe Analytics from ETL Validator jobs using the CData Software JDBC Driver.
-
Connecting GenSpark with Sage Cloud Accounting Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Sage Business Cloud Accounting without any replication or custom integration required.
-
Build Cassandra-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Apache Cassandra to explore live Cassandra Data in Gemini Code Assist to assist with building Cassandra-powered applications.
-
Build Dashboards with Shopify Data in DBxtra
Create dynamic dashboards and perform analytics based on Shopify in DBxtra.
-
Migrating data from Front to Snowflake using CData SSIS Components.
Easily push Front to Snowflake using the CData SSIS Tasks for Front and Snowflake.
-
Migrating data from Xero to Databricks using CData SSIS Components.
Easily push Xero Accounting to Databricks using the CData SSIS Tasks for Xero and Databricks.
-
How to use SQLAlchemy ORM to access Azure Data Lake Storage Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Lake Storage.
-
Automated Continuous Bitbucket Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bitbucket replication to Apache Cassandra.
-
Build Apps with Live MarkLogic in Adalo using CData Connect AI
Use CData Connect AI to integrate live MarkLogic into the Adalo platform and build custom mobile and web applications with real-time MarkLogic.
-
Integrating GitHub Copilot CLI with PagerDuty 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 Everhour Data Replication to Azure Synapse
Use CData Sync to customize and automate Everhour replication to Azure Synapse.
-
Building Dynamic Web Pages with Strava Data Using AngularJS
Create single-page applications with live connectivity to Strava using the CData API Server.
-
Automated Continuous Printify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Printify replication to SQL Server.
-
ZohoExpense Reporting in OBIEE with the ZohoExpense JDBC Driver
Deploy the ZohoExpense JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Query Live Amazon Marketplace Data in Perplexity MacOS Desktop
Connect to and query live Amazon Marketplace Data in Perplexity Desktop using CData MCP Server.
-
Access Live Grafana Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Grafana data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect PolyBase to DocuSign
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live DocuSign.
-
DataBind Controls to Azure Table Data in C++Builder
DataBind to Azure Table Storage in C++Builder with standard components and controls.
-
How to create an RPA flow for Float Data in UiPath Studio
Use the Float ODBC Driver to create workflows that access real-time Float without any coding.
-
Access Live Harvest Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Harvest data source in TIBCO Data Virtualization Studio and gain access to live Harvest from your TDV Server.
-
Load Perplexity Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Perplexity to a database.
-
Create a Data Access Object for Tavily Data using JDBI
A brief overview of creating a SQL Object API for Tavily in JDBI.
-
Object-Relational Mapping (ORM) with Odoo 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 Odoo ERP into a Java-based ORM framework, Hibernate.
-
Extract, Transform, and Load RabbitMQ Data in Informatica PowerCenter
Create a simple Workflow for RabbitMQ in Informatica PowerCenter.
-
Getting Started with the CData ADO.NET Provider for CockroachDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for CockroachDB.
-
Access Live Suadeo Data in Coginiti Pro
Connect to and query live Suadeo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use Dash to Build to Web Apps on Zendesk Data
Create Python applications that use pandas and Dash to build Zendesk-connected web apps.
-
Automated Hive Data Replication to Teradata
Use CData Sync to Customize and automate Apache Hive replication to Teradata.
-
Access Live Mode Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Mode data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Connect the Power BI Service to Drift: Complete Guide
Connect to the CData Software Power BI Connector for Drift from PowerBI.com to provide real-time Drift across the organization.
-
Connect to Avaza Data in Aqua Data Studio
Access Avaza from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live SAP Concur Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SAP Concur through MCP integration.
-
Building Dynamic Web Pages with Couchbase Data Using AngularJS
Create single-page applications with live connectivity to Couchbase using the CData API Server.
-
Use Manus AI to Talk to Your Microsoft Planner 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 Microsoft Planner.
-
Automated Continuous Jumpseller Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Jumpseller replication to AlloyDB.
-
Visualize LinkedIn Ads Data in TIBCO Spotfire through OData
Integrate LinkedIn Ads into dashboards in TIBCO Spotfire.
-
Stream Jira Data into Apache Kafka Topics
Access and stream Atlassian Jira in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData Software JDBC Driver for Copper in MicroStrategy Web
Connect to Copper in MicroStrategy Web using the CData Software JDBC Driver for Copper.
-
How to Connect to IBM Informix Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to IBM Informix. Leverage the pyodbc module for ODBC in Python.