CData Software - Knowledge Base
Recent Articles
-
Interact with Live DB2 Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live DB2 data.
-
Automated Continuous Teamgate Replication to Vertica
Use CData Sync for automated, continuous, customizable Teamgate replication to Vertica.
-
Connect to Real-Time Zendesk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zendesk and Dataflow to import and use Zendesk data in Power Apps.
-
Integrate LibreChat with Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cloudflare data from within the chat interface.
-
Connecting Mastra with Google Search Results via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Search results, no replication required.
-
Write a Simple Go Application to work with Nethunt Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Nethunt data.
-
Stream GitLab Data into Apache Kafka Topics
Access and stream GitLab data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live GraphQL 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 GraphQL data from within the IDE.
-
Query IBM Informix Data in DataGrip
Create a Data Source for IBM Informix in DataGrip and use SQL to query live IBM Informix data.
-
Import and Visualize MarkLogic Data in Power View
Create data visualizations based on MarkLogic data in Excel.
-
Configure the CData JDBC Driver for Google Forms in a Connection Pool in Tomcat
Connect to Google Forms data from a connection pool in Tomcat.
-
Use Agno to Talk to Your Wistia 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 Wistia data for you.
-
Connecting Pipedream with WordPress 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 WordPress data in real time.
-
Automated ServiceDesk Plus Data Replication to Teradata
Use CData Sync to Customize and automate ServiceDesk Plus data replication to Teradata.
-
Access Live LDAP Objects in AWS Lambda
Connect to live LDAP objects in AWS Lambda using the CData JDBC Driver.
-
Create SSAS Tabular Models from Adobe Commerce Data
How to build a SQL Server Analysis Service Tabular Model from Adobe Commerce data using CData drivers.
-
Build Teradata Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Teradata data and build visualizations in Tableau Cloud.
-
Use Dash to Build to Web Apps on Reply.io Data
Create Python applications that use pandas and Dash to build Reply.io-connected web apps.
-
Automated Continuous Testmonitor Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Testmonitor replication to Apache Kafka.
-
Automated Continuous Copper Replication to Databricks
Use CData Sync for automated, continuous, customizable Copper replication to Databricks.
-
Moving Data from Outlook to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Outlook data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Query, Visualize, and Share live Quickbase Data in Redash
Use CData Connect AI to connect to live Quickbase data in Redash for querying, visualizing, and sharing.
-
How to Access Live eBay Data in Power Automate Desktop via ODBC
The CData ODBC Driver for eBay enables you to integrate eBay data into workflows built using Microsoft Power Automate Desktop.
-
Import and Visualize Basecamp Data in Power View
Create data visualizations based on Basecamp data in Excel.
-
Getting Started with the CData SSIS Components for Azure Table
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Azure Table.
-
Automated Continuous Supabase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Supabase replication to Amazon S3.
-
Build an OLAP Cube in SSAS from CloudConvert Data
Establish a connection to CloudConvert data data from SQL Server Analysis Services, and use the CloudConvert Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Snapchat Ads-Connected Business Apps in AppSheet
Connect to Snapchat Ads Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Snapchat Ads data.
-
Build MVC Applications with Connectivity to Sybase IQ Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Sybase IQ from an ASP.NET MVC application.
-
Integrate Salesforce Data 360 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Salesforce Data 360 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Salesforce Data 360 data.
-
Use the CData Software ODBC Driver for Microsoft OneDrive in MicroStrategy
Connect to Microsoft OneDrive data in MicroStrategy Developer using the CData Software ODBC Driver for Microsoft OneDrive.
-
How to publish and share Azure Data Lake Storage Data dashboards with Tableau Server
The CData ODBC driver for Azure Data Lake Storage enables you integrate Azure Data Lake Storage data into Tableau dashboards.
-
Build Slack-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Slack data and build Slack-connected web apps with Axios.
-
Use the CData ODBC Driver for Cohere from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Cohere to connect to Cohere data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Cohere data in Excel.
-
Publish Crystal Reports on FreeAgent Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date FreeAgent data.
-
How to Query Live QuickBooks Online Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live QuickBooks Online data data in natural language using Python.
-
Replicate Databricks Data from PowerShell
Write a quick PowerShell script to query Databricks data. Use connectivity to the live data to replicate Databricks data to SQL Server.
-
Extract, Transform, and Load Amazon S3 Data in Informatica PowerCenter
Create a simple Workflow for Amazon S3 data in Informatica PowerCenter.
-
Connect to Real-Time Azure Data Catalog Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Azure Data Catalog and Dataflow to import and use Azure Data Catalog data in Power Apps.
-
How to work with Mailjet Data in Apache Spark using SQL
Access and process Mailjet Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Live Aweber Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Aweber data without replication.
-
Integrating Claude Code with Neo4J Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Neo4J data within assisted coding and automated development workflows.
-
Build Agents in Relevance AI with Access to Live Zoom Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zoom data within intelligent agent workflows.
-
ETL SAP BusinessObjects BI in Oracle Data Integrator
This article shows how to transfer SAP BusinessObjects BI data into a data warehouse using Oracle Data Integrator.
-
Visualize EnterpriseDB Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load EnterpriseDB data into TIBCO Spotfire.
-
Consume YouTube Analytics OData Feeds in SAP Lumira
Use the API Server to create data visualizations on YouTube Analytics feeds that reflect any changes in SAP Lumira.
-
How to create an RPA flow for Jumpseller Data in UiPath Studio
Use the Jumpseller ODBC Driver to create workflows that access real-time Jumpseller data without any coding.
-
Access Live SAS Data Sets Data in Excel 365 Online (Excel for the web)
Connect to SAS Data Sets data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Visualize Live SparkPost Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SparkPost data into custom reports in Power BI.
-
Manage Adobe Analytics Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Adobe Analytics.
-
Connect to SAP HANA Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SAP HANA and the SQL Gateway to access SAP HANA data from Google Apps Script.
-
Getting Started with the CData Python Connector for Amplitude
Learn to install and license the CData Python Connector and configure a connection to live Amplitude data.
-
Connect to Nethunt Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Nethunt.
-
Use the CData Software ODBC Driver for TigerGraph in SAS for Real-Time Reporting and Analytics
Connect to real-time TigerGraph data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for TigerGraph.
-
Bridge Stripe Connectivity with Apache NiFi
Access and process Stripe data in Apache NiFi using the CData JDBC Driver.
-
Create Airtable-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Airtable Data from OutSystems and build custom enterprise apps using live Airtable data.
-
Access Live GitLab Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GitLab data into the statistical analysis tools available in SAS JMP. This article shows how to use GitLab data in the Graph Builder and Query Builder.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft Teams
Create Microsoft Teams data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query LeadDesk Data in ColdFusion
Write standard ColdFusion data access code to connect to LeadDesk data.
-
Access Live Cohere Data in Coginiti Pro
Connect to and query live Cohere data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Sage 200 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Sage 200 data and build visualizations in Tableau.
-
Connect to Reply.io Data in DBArtisan
Use wizards in DBArtisan to configure Reply.io data as a data source.
-
Prepare, Blend, and Analyze Mailgun Data in Alteryx Designer (ODBC)
Build workflows to access live Mailgun data for self-service data analytics.
-
Model Discord Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Discord, enabling the direct import of real-time Discord data.
-
Use Agno to Talk to Your ZohoMarketingHub 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 ZohoMarketingHub data for you.
-
Connect to SendGrid Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SendGrid Data and connect to SendGrid data in Akorbi Digital RunMyProcess.
-
How to load Pinecone data into Elasticsearch via Logstash
Introducing a simple method to load Pinecone data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software ODBC Driver for Google Contacts in MicroStrategy Web
Connect to Google Contacts data in MicroStrategy Web using the CData Software ODBC Driver for Google Contacts.
-
Connect to and Query Superchat Data in QlikView over ODBC
Create data visualizations with Superchat data in QlikView.
-
How to Connect the Power BI Service to Reckon: Complete Guide
Connect to the CData Software Power BI Connector for Reckon from PowerBI.com to provide real-time Reckon data across the organization.
-
Integrate Live Simplesat Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Simplesat data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Access Live Act-On 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 Act-On data through MCP integration.
-
DataBind Charts to Zoho Projects Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho Projects data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Build Automated Notion-Connected Workflows in Zapier
Use CData Connect AI to connect to live Notion data and build automated workflows in Zapier.
-
How to Visualize MailerLite Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live MailerLite data in Python.
-
Design BIRT Reports on CSV Data
Provide current CSV data to your embedded analytics.
-
Building Dynamic Web Pages with Oracle Service Cloud Data Using AngularJS
Create single-page applications with live connectivity to Oracle Service Cloud using the CData API Server.
-
Use Claude to Talk to Your Highrise 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 Highrise data for you.
-
Connect to xBase Data from PowerBuilder via JDBC
This article demonstrates how to access xBase data from PowerBuilder using the xBase JDBC Driver.
-
How to Access Snowflake Data Using Entity Framework
This article shows how to access Snowflake data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Feed Epicor Kinetic Data into FineReport
How to set Epicor Kinetic data as a JDBC data source in FineReport.
-
Access Accelo Data from MySQL in PHP
Connect to Accelo through the standard MySQL libraries in PHP.
-
Build Sugar CRM Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Sugar CRM data and build visualizations in Tableau Cloud.
-
Integrating Kiro with Humanity 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.
-
Automated Continuous Kintone Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Kintone replication to AlloyDB.
-
Configure the CData JDBC Driver for Google Drive in a Connection Pool in Tomcat
Connect to Google Drive data from a connection pool in Tomcat.
-
Integrate OpenCode with Live Monday.com Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Monday.com data from within your AI coding agent.
-
Visualize Live WooCommerce Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live WooCommerce data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live ZohoInvoice Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your ZohoInvoice data through natural language.
-
Use the CData Software ODBC Driver for HDFS in MicroStrategy Desktop
Connect to HDFS data in MicroStrategy Desktop using the CData Software ODBC Driver for HDFS.
-
Design BIRT Reports on Sybase IQ Data
Provide current Sybase IQ data to your embedded analytics.
-
Feed SpaceX Data into FineReport
How to set SpaceX data as a JDBC data source in FineReport.
-
Replicate SpaceX Data to Multiple Databases
Replicate SpaceX data to disparate databases with a point-and-click configuration.
-
Model Quickbase Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Quickbase, enabling the direct import of real-time Quickbase data.
-
Link Hubstaff with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Hubstaff data in Filemaker Pro for Mac or Windows.
-
Connecting Moonlit Workflow with Highrise 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 Highrise data in real time.
-
How to Build an ETL App for NASA Data in Python with CData
Create ETL applications and real-time data pipelines for NASA data in Python with petl.
-
Bind Live Dynamics 365 Business Central Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics 365 Business Central data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to connect PolyBase to Factorial
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Factorial data.
-
Analyze Salesforce Marketing Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Marketing from Power Pivot. You will use the Table Import Wizard to load Salesforce Marketing data. You can visually build the import query or use any SQL supported by the driver.