CData Software - Knowledge Base
Recent Articles
-
Analyze Pipeliner CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Pipeliner CRM from Power Pivot. You will use the Table Import Wizard to load Pipeliner CRM data. You can visually build the import query or use any SQL supported by the driver.
-
Publish Rebilly-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Rebilly data.
-
Integrating LangChain with PayPal Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PayPal data within automated workflows.
-
Connect to Paymo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paymo and the SQL Gateway to access Paymo data from Google Apps Script.
-
Access Demio Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Demio data from HeidiSQL.
-
How to Work with HubDB Data in ETL Validator JDBC
Connect to HubDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating Intercom Data in Talend Cloud Data Management Platform
Connect Intercom Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Dropbox-Connected Business Apps in AppSheet
Connect to Dropbox Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Dropbox data.
-
Query Live AlloyDB Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live AlloyDB data through a conversational interface.
-
Create Yelp-Connected Dashboards in Grafana
Connect to Yelp Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Yelp data.
-
Connect to Real-Time Qualaroo Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Qualaroo data in Power Apps.
-
Connecting Agentforce with Wistia Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Wistia data for you.
-
How to Connect to Live SAP SuccessFactors LMS Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP SuccessFactors LMS data securely in real time.
-
Analyze Wistia Data in Looker
Use CData Connect AI to connect to Wistia Data from Looker and build custom apps using live Wistia data.
-
Interact with Live Salesforce Pardot Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Salesforce Pardot data.
-
Query ZohoDesk Data in ColdFusion
Write standard ColdFusion data access code to connect to ZohoDesk data.
-
Visualize Dynamics CRM 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 Dynamics CRM data into TIBCO Spotfire.
-
Access Live Datadog Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Datadog data into the statistical analysis tools available in SAS JMP. This article shows how to use Datadog data in the Graph Builder and Query Builder.
-
Access SurveyMonkey Data from MySQL in Amazon QuickSight
Connect to SurveyMonkey and build visualizations of SurveyMonkey data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous MongoDB Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable MongoDB replication to Google Cloud SQL.
-
Connect to MongoDB Data as an External Source in Dremio
Use the CData JDBC Driver to connect to MongoDB as an External Source in Dremio.
-
Query Splunk Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Splunk data from Node.js.
-
Integrate Live eBay Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to eBay data and integrate live eBay data into apps built in Microsoft Power Apps.
-
View Reports on Real-Time Access Data in Power BI Report Server
Use the CData ODBC Driver for Access to visualize Access data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Figshare Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Figshare data in Airbyte.
-
Create Bannerbear-Connected Nintex Workflows
Use CData Connect AI to connect to Bannerbear Data from Nintex Workflow Cloud and build custom workflows using live Bannerbear data.
-
How to Visualize QuickBooks 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 QuickBooks data in Python.
-
Search External RSS Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of RSS feeds to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create RSS Feeds objects that you can access from apps and the dashboard.
-
Import Real-Time CockroachDB Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CockroachDB data in ColdFusion.
-
Access Rootly Data from MySQL in PHP
Connect to Rootly through the standard MySQL libraries in PHP.
-
Build Dashboards with CircleCI Data in DBxtra
Create dynamic dashboards and perform analytics based on CircleCI data in DBxtra.
-
Integrating Dataiku with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Gmail data.
-
Automated Continuous Elorus Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Elorus replication to Apache Cassandra.
-
How to connect SharePoint with MySQL Data through external lists
Provide MySQL data to SharePoint users as an external list.
-
Connect to ZohoDesk Data in DBeaver
Use the CData ODBC Driver to connect to ZohoDesk data in DBeaver.
-
How to connect to Placid Data in DBVisualizer
Integrate Placid data with visual data analysis tools and data connection wizards in DBVisualizer
-
Deploy the ADO.NET Provider for Paymo on an SSRS Report Server
Connect to Paymo data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData Software ODBC Driver for Slack in MicroStrategy Web
Connect to Slack data in MicroStrategy Web using the CData Software ODBC Driver for Slack.
-
Build Tally-Connected Apps in Choreo
Use CData Connect AI to connect to Tally Data from Choreo and build custom apps using live Tally data.
-
Automate HelloSign Data Replication to SAP HANA
Use CData Sync to customize and automate HelloSign data replication to SAP HANA.
-
Integrate Devin with Live Odoo Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Odoo data.
-
Access Samanage Data from MySQL in Amazon QuickSight
Connect to Samanage and build visualizations of Samanage data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Aha! Replication to MySQL
Use CData Sync for automated, continuous, customizable Aha! replication to MySQL.
-
Create OneNote-Connected Applications in Appsmith
Connect to OneNote Data via CData Connect AI in Appsmith and create custom business applications with real-time access to OneNote data.
-
Automate OneNote Data Replication to SAP HANA
Use CData Sync to customize and automate OneNote data replication to SAP HANA.
-
Analyze Exact Online Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Exact Online data in Microsoft R Open.
-
Use Microsoft Copilot Studio to talk to your Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Slack data for you.
-
SendGrid Reporting in OBIEE with the SendGrid JDBC Driver
Deploy the SendGrid JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Getting Started with the CData Connect AI Python SDK for Salesforce Data 360
Install the CData Connect AI Python SDK to read live Salesforce Data 360 data with standard DB-API 2.0 Python code.
-
Automate SparkPost Data Replication to Azure Synapse
Use CData Sync to customize and automate SparkPost data replication to Azure Synapse.
-
Connect to Avalara AvaTax Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Avalara AvaTax and the Script function in FileMaker Pro to connect to Avalara AvaTax and work with Avalara AvaTax data in your FileMaker application.
-
Operational Reporting on Parquet Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Parquet data.
-
Automated Continuous Salesforce CRM Analytics Replication to Vertica
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Vertica.
-
Feed Sage Intacct Data into FineReport
How to set Sage Intacct data as a JDBC data source in FineReport.
-
Visualize Webflow Data in TIBCO Spotfire through ADO.NET
Integrate Webflow data into dashboards in TIBCO Spotfire.
-
Use Claude to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud data for you.
-
Search External Procore Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Procore data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Procore Data objects that you can access from apps and the dashboard.
-
Build Dashboards with Exa Data in DBxtra
Create dynamic dashboards and perform analytics based on Exa data in DBxtra.
-
Query Testmonitor Data in DataGrip
Create a Data Source for Testmonitor in DataGrip and use SQL to query live Testmonitor data.
-
Integrate Live ChargeOver Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ChargeOver data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
A PostgreSQL Interface for Accelo Data using the CData ODBC Driver
Use the SQL Gateway and Accelo ODBC Driver to create a PostgreSQL entry-point for data access.
-
Extract, Transform, and Load Blackbaud FE NXT Data in Informatica PowerCenter
Create a simple Workflow for Blackbaud FE NXT data in Informatica PowerCenter.
-
Connecting Mastra with ClickUp Data 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 ClickUp data, no replication required.
-
Build a Singer.io Tap for Smartsheet With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Smartsheet data using the CData Python Connector.
-
Build Dashboards with Shopify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Shopify data in Dundas BI.
-
How to Visualize ShipStation Data in Python with pandas
Use pandas and other modules to analyze and visualize live ShipStation data in Python.
-
Automated Continuous Jira Assets Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Jira Assets replication to PostgreSQL.
-
Connect to Cosmos DB Data in HULFT Integrate
Connect to Cosmos DB as a JDBC data source in HULFT Integrate
-
Getting Started with the CData Connect AI Python SDK for Typeform
Install the CData Connect AI Python SDK to read live Typeform data with standard DB-API 2.0 Python code.
-
How to Connect to Live Greenhouse 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 Greenhouse data for you.
-
Connect and Query Live Okta Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Okta data into Databricks and enable direct, live querying and analysis without replication.
-
Enable the Missive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Missive data.
-
Access Live Zoho Inventory Data in Excel 365 Online (Excel for the web)
Connect to Zoho Inventory data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Data Visualizations in Cognos BI with Freshteam Data
Access Freshteam data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
A PostgreSQL Interface for XML Data (MySQL Remoting via JDBC)
Use the Remoting features of the XML JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect SendGrid 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 SendGrid data in real time using natural language.
-
Automated Continuous SendGrid Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SendGrid replication to delimited files (CSV/TSV).
-
How to Visualize SAP ByDesign Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP ByDesign data in Python.
-
Query Simplesat Data in DataGrip
Create a Data Source for Simplesat in DataGrip and use SQL to query live Simplesat data.
-
Analyze Ontraport Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Ontraport from Power Pivot. You will use the Table Import Wizard to load Ontraport data. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Cursor with Azure Synapse 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.
-
Build Data Flows from Excel to SQL Server using SSIS
Easily back up Excel data to SQL Server using the SSIS components for Excel.
-
Connect to Jira Assets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Jira Assets data in Airbyte.
-
Access Live Reckon Data in AWS Lambda
Connect to live Reckon data in AWS Lambda using the CData JDBC Driver.
-
Connect to XML Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with XML Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Bind Live Lakebase Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Lakebase data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Visualize Email Data in Python with pandas
Use pandas and other modules to analyze and visualize live Email data in Python.
-
Build MVC Applications with Connectivity to Stripe Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Stripe from an ASP.NET MVC application.
-
Automate SAP Concur Data Replication to Azure Synapse
Use CData Sync to customize and automate SAP Concur data replication to Azure Synapse.
-
Use the CData Software ODBC Driver for Campaigner in MicroStrategy Web
Connect to Campaigner data in MicroStrategy Web using the CData Software ODBC Driver for Campaigner.
-
How to Build an ETL App for Oracle Service Cloud Data in Python with CData Connect AI
Build ETL pipelines that read and write live Oracle Service Cloud data in Python with petl and the CData Connect AI Python SDK.
-
How to Seamlessly Import Zendesk Data into IBM SPSS Modeler
Integrate Zendesk data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Amazon Marketplace Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Amazon Marketplace data to Blue Prism using the CData ODBC Driver for Amazon Marketplace to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Power BI XMLA in MicroStrategy Desktop
Connect to Power BI XMLA data in MicroStrategy Desktop using the CData Software ODBC Driver for Power BI XMLA.
-
Integrating GitHub Copilot with Facebook Ads 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 SAP ByDesign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP ByDesign data using standard SQL.
-
Integrating Kiro with Perplexity 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.
-
Model, Search, and Visualize Live Teradata Data in ThoughtSpot
Use CData Connect AI to connect to live Teradata data for modeling, searching, and visualizing.
-
Consume Cvent OData Feeds in PowerBuilder
This article demonstrates how to consume Cvent data as OData feeds from PowerBuilder using the API Server.
-
Build Apps with Live Azure Analysis Services Data Using the Low-Code Development Platform of Mendix
Connect Azure Analysis Services data with Mendix to build apps using the CData JDBC Driver for Azure Analysis Services.