CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData Connect AI Python SDK for MarkLogic
Install the CData Connect AI Python SDK to read and write live MarkLogic data with standard DB-API 2.0 Python code.
-
Connect to FormSite Data from PowerBuilder via ADO.NET
This article demonstrates how to access FormSite data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Access Live Salesforce Marketing Data in AWS Lambda
Connect to live Salesforce Marketing data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Campaigner Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Campaigner replication to Google BigQuery.
-
Strava Reporting in OBIEE with the Strava JDBC Driver
Deploy the Strava JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build MessageBird-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to MessageBird data and build web apps with connectivity to live MessageBird data.
-
Automated Continuous ZendeskSell Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZendeskSell replication to PostgreSQL.
-
Validate Snapchat Ads Data with QuerySurge
Access and validate Snapchat Ads data in QuerySurge using the CData JDBC Driver.
-
Use the CData ODBC Driver for SAP Concur in Microsoft Power Query
You can use the CData SAP Concur ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SAP Concur data into Microsoft Power Query.
-
Access Google Analytics Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Analytics data from HeidiSQL.
-
How to connect PolyBase to Google Calendar
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Calendar data.
-
Integrating OpenCode with SAS xpt 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.
-
Bridge Google Sheets Connectivity with Apache NiFi
Access and process Google Sheets data in Apache NiFi using the CData JDBC Driver.
-
Query Greenhouse Data in ColdFusion
Write standard ColdFusion data access code to connect to Greenhouse data.
-
Build Charts with MariaDB Data in Clear Analytics
Create dynamic charts and perform analytics based on MariaDB data in Clear Analytics.
-
Visualize Live SAS xpt Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SAS xpt data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Google Contacts-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Google Contacts Data and create custom apps in Mendix.
-
Connect to Quaderno Data in HULFT Integrate
Connect to Quaderno as a JDBC data source in HULFT Integrate
-
Integrating GitHub Copilot with Sage Cloud Accounting 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.
-
Back Up Bitly data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Bitly data data.
-
How to Query Live Cosmos DB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Cosmos DB data data in natural language using Python.
-
How to connect to Parallel Data in DBVisualizer
Integrate Parallel data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Seamlessly Import Parquet Data into IBM SPSS Modeler
Integrate Parquet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Apps with Live Microsoft Exchange Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Exchange data with Mendix to build apps using the CData JDBC Driver for Microsoft Exchange.
-
How to Connect to Live Marketo Data 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 Marketo data for you.
-
How to integrate Metabase with MailerLite Data
Use CData Connect AI to connect to live MailerLite data and create an interactive dashboard in Metabase from MailerLite data.
-
How to use SQLAlchemy ORM to access Nethunt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Nethunt data.
-
Visualize Live Azure DevOps Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Azure DevOps data into custom reports in Power BI.
-
Import Real-Time PDFMonkey Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PDFMonkey data in ColdFusion.
-
Connect DocuSign to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect DocuSign with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Power BI XMLA Data in Pentaho Data Integration
Build ETL pipelines based on Power BI XMLA data in the Pentaho Data Integration tool.
-
Create LDAP-Connected Business Apps in AppSheet
Connect to LDAP Objects via CData Connect AI in Google AppSheet and create custom business applications with real-time access to LDAP objects.
-
Integrate Trae with Live Sybase IQ Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Sybase IQ data from within the AI-powered IDE.
-
Create Data Visualizations Based On Notion Data in Mode
Use CData Connect AI to connect to Notion Data from Mode and build visualizations using live Notion data.
-
Integrate Open WebUI with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Figshare data from within the chat interface.
-
Integrate Live YouTube Analytics Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to YouTube Analytics from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live YouTube Analytics data.
-
Replicate Moosend Data from PowerShell
Write a quick PowerShell script to query Moosend data. Use connectivity to the live data to replicate Moosend data to SQL Server.
-
Automated Continuous Avaza Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Avaza data replication to OneLake in Microsoft Fabric.
-
Visualize Live Microsoft Teams Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Teams data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build NetSuite-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 NetSuite data without replication.
-
Build Visualizations of Mouseflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Mouseflow data in Birst.
-
Build Agents in Relevance AI with Access to Live CapsuleCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CapsuleCRM data within intelligent agent workflows.
-
Build Semantic Layer Views for Postmark Data in APOS Live Data Gateway
Use the CData Connector for Postmark in APOS Live Data Gateway to build Semantic Layer Views for Postmark data.
-
How to import Guru Data into Apache Solr
Use the CData Software JDBC Driver for Guru in Data Import Handler and create an automated import of Guru data to Apache Solr Enterprise Search platform.
-
How to connect to YouTube Analytics Data with Squirrel SQL client
Connect to YouTube Analytics data and execute queries in the Squirrel SQL Client.
-
Integrate with Factorial Data in JReport Designer
Create charts and reports based on Factorial data in JReport Designer.
-
Create Dynamic Procore Grids Using the Infragistics XamDataGrid
Learn how you can connect Procore to Infragistics XamDataGrid to build dynamic grids.
-
Analyze Bullhorn CRM Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bullhorn CRM data and visualize Bullhorn CRM data in SAP Analytics Cloud.
-
How to Access Azure Table Data Using Entity Framework
This article shows how to access Azure Table data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to publish and share Reckon Data dashboards with Tableau Server
The CData ODBC driver for Reckon enables you integrate Reckon data into Tableau dashboards.
-
Build Agents in Relevance AI with Access to Live Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Salesforce Data 360 data within intelligent agent workflows.
-
A PostgreSQL Interface for Zoho Creator Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zoho Creator JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Factorial in SAS for Real-Time Reporting and Analytics
Connect to real-time Factorial data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Factorial.
-
How to connect to Avro Data with Squirrel SQL client
Connect to Avro data and execute queries in the Squirrel SQL Client.
-
Getting Started with the CData Excel Add-In for BenchmarkEmail
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BenchmarkEmail.
-
Access Live SAS Data Sets Data in TIBCO Data Virtualization
Use the SAS Data Sets Tibco DV Adapter to create a SAS Data Sets data data source in TIBCO Data Virtualization Studio and gain access to live SAS Data Sets data from your TDV Server.
-
ETL Webex in Oracle Data Integrator
This article shows how to transfer Webex data into a data warehouse using Oracle Data Integrator.
-
How to import Shopify Data into Apache Solr
Use the CData Software JDBC Driver for Shopify in Data Import Handler and create an automated import of Shopify data to Apache Solr Enterprise Search platform.
-
Create Azure DevOps-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure DevOps Data from Klipfolio and build custom visualizations using live Azure DevOps data.
-
Query SAS Data Sets Data in DataGrip
Create a Data Source for SAS Data Sets in DataGrip and use SQL to query live SAS Data Sets data.
-
How to Connect to Live Act-On Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Act-On data for you.
-
How to create Trello federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Trello data in MySQL .
-
Write a Simple Go Application to work with HubDB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HubDB data.
-
Build Automated Jira-Connected Workflows in Zapier
Use CData Connect AI to connect to live Jira data and build automated workflows in Zapier.
-
Integrating Codex with Samanage 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.
-
Connect to Azure Data Catalog Data in HULFT Integrate
Connect to Azure Data Catalog as a JDBC data source in HULFT Integrate
-
Connect to Google Analytics Data in DBeaver
Use the CData ODBC Driver to connect to Google Analytics data in DBeaver.
-
Build Semantic Layer Views for Quickbase Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Quickbase data.
-
How to Seamlessly Import Google Cloud Storage Data into IBM SPSS Modeler
Integrate Google Cloud Storage data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Snapchat Ads Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Google BigQuery.
-
Connect and Query Live Microsoft Dataverse Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Dataverse data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to IBM Cloud Object Storage Data with Squirrel SQL client
Connect to IBM Cloud Object Storage data and execute queries in the Squirrel SQL Client.
-
Create Datasets from Cassandra in Domo Workbench and Build Visualizations of Cassandra Data in Domo
Use the CData Software ODBC Driver for Cassandra to create datasets from Cassandra data in Domo Workbench and then build visualizations in the Domo service.
-
How to Connect Flowise AI Agents to Live Cloudant Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Cloudant data without replication.
-
Migrating data from FTP to Databricks using CData SSIS Components.
Easily push FTP data to Databricks using the CData SSIS Tasks for FTP and Databricks.
-
Automated Cosmos DB Data Replication to Teradata
Use CData Sync to Customize and automate Cosmos DB data replication to Teradata.
-
Use Manus AI to Talk to Your Klaviyo 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 Klaviyo data.
-
A PostgreSQL Interface for LightSpeedRetail Data (MySQL Remoting via JDBC)
Use the Remoting features of the LightSpeedRetail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Manage Cassandra Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Cassandra.
-
Connect to Testmonitor from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Testmonitor data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Stream Aha! Data into Apache Kafka Topics
Access and stream Aha! data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to publish and share Microsoft OneDrive Data dashboards with Tableau Server
The CData ODBC driver for Microsoft OneDrive enables you integrate Microsoft OneDrive data into Tableau dashboards.
-
Publish Helpscout-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Helpscout data.
-
Connect to and Query AfterShip Data in QlikView over ODBC
Create data visualizations with AfterShip data in QlikView.
-
How to connect and process Supabase data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Supabase data.
-
Use Agno to Talk to Your SAP HANA 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 SAP HANA data for you.
-
How to import Quickbase Data into Apache Solr
Use the CData Software JDBC Driver for Quickbase in Data Import Handler and create an automated import of Quickbase data to Apache Solr Enterprise Search platform.
-
Access MailerSend Data from MySQL in PHP
Connect to MailerSend through the standard MySQL libraries in PHP.
-
Write a Simple Go Application to work with Hubstaff Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Hubstaff data.
-
A PostgreSQL Interface for Shortcut Data (MySQL Remoting via JDBC)
Use the Remoting features of the Shortcut JDBC Driver to create a PostgreSQL entry-point for data access.
-
Consume Cvent OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Cvent feeds that reflect any changes in SAP Lumira.
-
Edit and Search External MySQL Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MySQL data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MySQL Data objects that you can access from apps and the dashboard.
-
Integrate Presto Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Presto data from Informatica Cloud.
-
Replicate ChargeOver Data from PowerShell
Write a quick PowerShell script to query ChargeOver data. Use connectivity to the live data to replicate ChargeOver data to SQL Server.
-
Connect to SAP Business Warehouse Data from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Business Warehouse data from Crystal Reports.
-
Connect to Supabase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Supabase as an External Source in Dremio.
-
Use Manus AI to Talk to Your SageHR 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 SageHR data.
-
Integrate with Elasticsearch Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Elasticsearch data to a JSON file on disk.
-
Use ChatGPT to Talk to Your SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SendGrid data for you.
-
Integrating Kiro with Egnyte 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.