CData Software - Knowledge Base
Recent Articles
-
Integrate Cursor with Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Cloudflare data from within the editor.
-
Integrate Oracle SCM Data in Pentaho Data Integration
Build ETL pipelines based on Oracle SCM data in the Pentaho Data Integration tool.
-
Connect to Attio Data in HULFT Integrate
Connect to Attio as a JDBC data source in HULFT Integrate
-
Getting Started with the CData ODBC Driver for Apollo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Apollo.
-
Create Power BI Reports on Real-Time CockroachDB Data
Use the CData ODBC Driver for CockroachDB to visualize CockroachDB data in Power BI Desktop.
-
Migrating data from Greenplum to Google BigQuery using CData SSIS Components.
Easily push Greenplum data to Google BigQuery using the CData SSIS Tasks for Greenplum and Google BigQuery.
-
How to connect to Tally Data from Spring Boot
Connect to Tally in a Spring Boot Application using the CData JDBC Driver for Tally
-
Establish a Live Connection with Twilio Data using Tableau Bridge
The CData ODBC Driver for Twilio enables you to integrate live Twilio data into Tableau Cloud dashboards using the Tableau Bridge.
-
Publish Crystal Reports on Phoenix Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Phoenix data.
-
Connect Zoho CRM to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho CRM data using the CData Python MCP Server.
-
How to Work with SAP ByDesign Data in ETL Validator JDBC
Connect to SAP ByDesign from ETL Validator jobs using the CData Software JDBC Driver.
-
Import Real-Time Autopilot Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Autopilot data in ColdFusion.
-
How to Connect to Live Samanage 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 Samanage data through natural language.
-
Connecting GenSpark with Redshift Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Redshift data without any replication or custom integration required.
-
Explore Geographical Relationships in CapsuleCRM Data with Power Map
Create data visualizations with CapsuleCRM data in Power Map.
-
Automated Continuous Qualaroo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Qualaroo replication to SingleStore.
-
Visualize Parquet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Parquet data.
-
Integrating Boomi Agentstudio with Oracle HCM Cloud Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Oracle HCM Cloud data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to connect to Sybase Data in DBVisualizer
Integrate Sybase data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access ZohoMarketingHub Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for ZohoMarketingHub data.
-
How to update Square from Excel
This article explains how to transfer data from Excel to Square using the Excel Add-In for Square.
-
Build AI Agents with Sendwithus Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sendwithus data through CData Connect AI.
-
Build Exa Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Exa data and build visualizations in Tableau Cloud.
-
Analyze Azure Data Catalog Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Data Catalog data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with CockroachDB Data in JReport Designer
Create charts and reports based on CockroachDB data in JReport Designer.
-
Access Live Zuora Data in Excel 365 Online (Excel for the web)
Connect to Zuora data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
CData Code Assist MCP: Deprecation Notice and Migration Guide
CData is deprecating Code Assist MCP. Migrate to Connect AI or CData CLI based on your use case.
-
Build Pipelines with Live Oracle Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Oracle from Google Cloud Data Fusion, enabling the integration of live Oracle data into the building and management of effective data pipelines.
-
How to Connect to Live Bullhorn CRM 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 Bullhorn CRM data for you.
-
Build Charts with Hive Data in Clear Analytics
Create dynamic charts and perform analytics based on Hive data in Clear Analytics.
-
How to connect to Spark Data with Squirrel SQL client
Connect to Spark data and execute queries in the Squirrel SQL Client.
-
How to Query Live ClickTime Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ClickTime data data in natural language using Python.
-
How to Connect to Live Google Drive 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 Google Drive data for you.
-
Prepare, Blend, and Analyze Gorgias Data in Alteryx Designer (ODBC)
Build workflows to access live Gorgias data for self-service data analytics.
-
Establish a Live Connection with Google Tasks Data using Tableau Bridge
The CData ODBC Driver for Google Tasks enables you to integrate live Google Tasks data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Live Templated Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Templated data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Exa-Connected Nintex Workflows
Use CData Connect AI to connect to Exa Data from Nintex Workflow Cloud and build custom workflows using live Exa data.
-
How to Connect MarkLogic Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live MarkLogic data in real time using natural language.
-
How to Connect to Live Jira 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 Jira data through natural language.
-
How to connect PolyBase to Facebook Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Facebook Ads data.
-
Build Azure Table-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Azure Table data and build Azure Table-connected web apps with Axios.
-
Analyze Live Reckon Data in SAS Viya
Use CData Connect AI to connect to Reckon data from SAS Viya and deploy self-service analytics using live Reckon data.
-
Automate Microsoft Ads Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Microsoft Ads data from PowerShell? This article demonstrates how to utilize the Microsoft Ads Cmdlets for tasks like connecting to Microsoft Ads data, automating operations, downloading data, and more.
-
Integrating Antigravity CLI with Google Tasks data via CData CLI
Connect Google Tasks data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Claude Code CLI with ShipStation 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.
-
Getting Started with the CData Tableau Connector for Sage 200
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sage 200.
-
Integrate Cline with Live Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Synapse data from within your IDE.
-
Replicate Microsoft Exchange Data in Heroku for Use in Salesforce Connect
Replicate Microsoft Exchange data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Publish Sentry-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Sentry data.
-
How to Access Live Salesloft Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesloft enables you to integrate Salesloft data into workflows built using Microsoft Power Automate Desktop.
-
Getting Started with the CData Python Connector for Demio
Learn to install and license the CData Python Connector and configure a connection to live Demio data.
-
Integrate Reply.io Data in the Pentaho Report Designer
Publish reports based on Reply.io data in the Pentaho BI tool.
-
Visualize Airtable Data in TIBCO Spotfire through ADO.NET
Integrate Airtable data into dashboards in TIBCO Spotfire.
-
Create Informatica Mappings From/To an ODBC Data Source for Coinbase
Create an ODBC connection to Coinbase in Informatica and browse and transfer Coinbase data.
-
Automated Continuous SAP ByDesign Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Snowflake.
-
Connect PagerDuty Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PagerDuty data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Freshteam 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 Freshteam data without replication.
-
How to integrate Metabase with Discord Data
Use CData Connect AI to connect to live Discord data and create an interactive dashboard in Metabase from Discord data.
-
Connect to Sybase Data in NetBeans
Connect to Sybase data in NetBeans with the data source configuration wizard.
-
Integrate Dify with Live Azure Data Lake Storage 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 Azure Data Lake Storage data.
-
How to Connect to Live Samanage 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 Samanage data for you.
-
Create a Data Access Object for EmailOctopus Data using JDBI
A brief overview of creating a SQL Object API for EmailOctopus data in JDBI.
-
Validate JotForm Data with QuerySurge
Access and validate JotForm data in QuerySurge using the CData JDBC Driver.
-
Create Dynamic SAP ByDesign Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP ByDesign to Infragistics XamDataGrid to build dynamic grids.
-
Easily Integrate Miro Data in Lazarus Pascal IDE
Learn how to easily integrate live Miro data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData Excel Add-In for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Adobe Analytics.
-
Access PhantomBuster Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PhantomBuster data from your Oracle system.
-
Build Agents in Relevance AI with Access to Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SQL Analysis Services data within intelligent agent workflows.
-
DataBind PolarTeamPro Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PolarTeamPro data to a chart.
-
Connect to Brex Data in CloverDX (formerly CloverETL)
Transfer Brex data using the visual workflow in the CloverDX data integration tool.
-
Explore Geographical Relationships in Google Ad Manager Data with Power Map
Create data visualizations with Google Ad Manager data in Power Map.
-
How to connect and process Tally data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Tally data.
-
Create Dashboards and Visualize Live Snowflake Data in Geckoboard
Use CData Connect AI to connect to live Snowflake data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Cassandra Data using the CData ODBC Driver
Use the SQL Gateway and Cassandra ODBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ShipStation
Provide connectivity to ShipStation data through an SAP BusinessObjects universe.
-
Access Live Authorize.Net 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 Authorize.Net data through MCP integration.
-
How to integrate PagerDuty with Apache Airflow
Access and process PagerDuty data in Apache Airflow using the CData JDBC Driver.
-
Connect to and Visualize Live Excel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Excel data.
-
Integrate OpenCode with Live AgileCRM Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live AgileCRM data from within your AI coding agent.
-
Building Dynamic Web Pages with Outreach.io Data Using AngularJS
Create single-page applications with live connectivity to Outreach.io using the CData API Server.
-
Integrating LangGraph with Reckon Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Reckon data within automated workflows.
-
Build Charts with Factorial Data in Clear Analytics
Create dynamic charts and perform analytics based on Factorial data in Clear Analytics.
-
Replicate Cohere Data from PowerShell
Write a quick PowerShell script to query Cohere data. Use connectivity to the live data to replicate Cohere data to SQL Server.
-
Automated Continuous ClickTime Replication to Snowflake
Use CData Sync for automated, continuous, customizable ClickTime replication to Snowflake.
-
Automated Continuous Spark Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Spark data replication to OneLake in Microsoft Fabric.
-
Automated Continuous Outlook Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Outlook replication to Google Cloud SQL.
-
Getting Started with the CData Power BI Connector for Kintone
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Kintone.
-
Create Datasets from SAS xpt in Domo Workbench and Build Visualizations of SAS xpt Data in Domo
Use the CData Software ODBC Driver for SAS xpt to create datasets from SAS xpt data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to GitLab Data with Squirrel SQL client
Connect to GitLab data and execute queries in the Squirrel SQL Client.
-
How to Query Live Tally Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Tally data data in natural language using Python.
-
Integrate Live Sugar CRM Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sugar CRM data and integrate live Sugar CRM data into apps built in Microsoft Power Apps.
-
Choosing the Best Method to Connect SAS Data Sets to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SAS Data Sets data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Open WebUI with Live Sendwithus Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Sendwithus data from within the chat interface.
-
Visualize Live Workable Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Workable data.
-
Consume Marketo OData Feeds in PowerBuilder
This article demonstrates how to consume Marketo data as OData feeds from PowerBuilder using the API Server.
-
How to integrate Zendesk with Apache Airflow
Access and process Zendesk data in Apache Airflow using the CData JDBC Driver.
-
How to Easily Query Snowflake Data in OpenOffice Base
Connect to Snowflake data in OpenOffice Base using the CData ODBC Driver for Snowflake and generate reports with live data insights.
-
Access Live Freshdesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Freshdesk data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Operational Reporting on QuickBooks Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote QuickBooks data.
-
Process & Analyze Todoist Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Todoist Data.