CData Software - Knowledge Base
Recent Articles
-
MarkLogic Reporting in OBIEE with the MarkLogic JDBC Driver
Deploy the MarkLogic JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Access Live PagerDuty Data in Coginiti Pro
Connect to and query live PagerDuty data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connecting Pipedream with Perplexity 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 Perplexity data in real time.
-
Use Dash to Build Web Apps on Gmail Data via CData Connect AI
Build interactive Dash web apps on live Gmail data using pandas and the CData Connect AI Python SDK.
-
Import and Visualize Everhour Data in Power View
Create data visualizations based on Everhour data in Excel.
-
Create ZohoSubscriptions-Connected Business Apps in AppSheet
Connect to ZohoSubscriptions Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to ZohoSubscriptions data.
-
DataBind Controls to HelloSign Data in Delphi
DataBind to HelloSign data in Delphi with standard data access components and controls.
-
Use Dash to Build Web Apps on MarkLogic Data via CData Connect AI
Build interactive Dash web apps on live MarkLogic data using pandas and the CData Connect AI Python SDK.
-
Query SAP Business Warehouse Data in DataGrip
Create a Data Source for SAP Business Warehouse in DataGrip and use SQL to query live SAP Business Warehouse data.
-
Integrate Shortcut Data in Pentaho Data Integration
Build ETL pipelines based on Shortcut data in the Pentaho Data Integration tool.
-
How to work with Cvent Data in Apache Spark using SQL
Access and process Cvent Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Tally Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Tally data from Informatica Cloud.
-
Connect Zuora Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Zuora data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight data through an SAP BusinessObjects universe.
-
Build Keap-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Keap data.
-
Automate Google Translate Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Translate data from PowerShell? This article demonstrates how to utilize the Google Translate Cmdlets for tasks like connecting to Google Translate data, automating operations, downloading data, and more.
-
How to Connect to Live SAP Ariba Procurement 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 SAP Ariba Procurement data for you.
-
Automated Continuous Cloudflare Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cloudflare replication to Snowflake.
-
How to create an RPA flow for Salesforce Data 360 Data in UiPath Studio
Use the Salesforce Data 360 ODBC Driver to create workflows that access real-time Salesforce Data 360 data without any coding.
-
Query EnterpriseDB Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume EnterpriseDB entities in PHP by modeling them as objects.
-
Replicate MYOB AccountRight Data to Multiple Databases
Replicate MYOB AccountRight data to disparate databases with a point-and-click configuration.
-
How to Connect to Live Twilio 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 Twilio data through natural language.
-
Integrating Gumloop with Sage 300 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sage 300 data within automated workflows.
-
Create Monday.com Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Monday.com from PowerBI.com to create Power BI Dataflows with real-time data.
-
Rapidly Develop Contentful-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Contentful.
-
How to Connect DBeaver to ElevenLabs via a JDBC Driver
Manage ElevenLabs data with visual tools in DBeaver like the query browser.
-
How to Work with ChartMogul Data in ETL Validator JDBC
Connect to ChartMogul from ETL Validator jobs using the CData Software JDBC Driver.
-
Automate ZohoExpense Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoExpense data replication to Azure Data Lake.
-
How to Connect DBeaver to Microsoft Ads via a JDBC Driver
Manage Microsoft Ads data with visual tools in DBeaver like the query browser.
-
Replicate Mixpanel Data from PowerShell
Write a quick PowerShell script to query Mixpanel data. Use connectivity to the live data to replicate Mixpanel data to SQL Server.
-
Integrate OneNote Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to OneNote data and integrate live OneNote data into your Power Automate tasks.
-
Build Dashboards with Tickspot Data in DBxtra
Create dynamic dashboards and perform analytics based on Tickspot data in DBxtra.
-
Integrating Dataiku with Google Campaign Manager 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Campaign Manager 360 data.
-
Perform Batch Operations with Microsoft Teams Data in Apache NiFi
Connect to Microsoft Teams data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Airtable Data in Alteryx Designer (Connect AI)
Build workflows to access live Airtable data for self-service data analytics.
-
How to connect to GraphQL Data in DBVisualizer
Integrate GraphQL data with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Customer.io Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Customer.io data from PowerShell? This article demonstrates how to utilize the Customer.io Cmdlets for tasks like connecting to Customer.io data, automating operations, downloading data, and more.
-
How to use SQLAlchemy ORM to access Zoho Inventory Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Inventory data.
-
Connect to Anaplan Data in Google Apps Script via Connect AI
Use CData Connect AI to access Anaplan data in Google Apps Script.
-
Prepare, Blend, and Analyze Redis Data in Alteryx Designer (ODBC)
Build workflows to access live Redis data for self-service data analytics.
-
Create Adobe Experience Manager-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Experience Manager Data from Nintex Workflow Cloud and build custom workflows using live Adobe Experience Manager data.
-
Access Live Oracle Sales Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Oracle Sales data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Integrate Trae with Live SingleStore Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live SingleStore data from within the AI-powered IDE.
-
Analyze Gorgias Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Gorgias data with the CData JDBC Driver for Gorgias.
-
Connect to Live FTP Data in MicroStrategy through CData Connect AI
Create a live connection to FTP Data in CData Connect AI and connect to your FTP data from MicroStrategy.
-
Connect to Coda Data in JRuby
Create a simple JRuby app with access to live Coda data.
-
Getting Started with the CData ODBC Driver for SAP HANA
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP HANA.
-
Link QuickBooks Time with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate QuickBooks Time data in Filemaker Pro for Mac or Windows.
-
Integrating Claude Code CLI with Facebook 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 Mailgun to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mailgun data using the CData Python MCP Server.
-
Access Live Kafka Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Kafka data from your Excel spreadsheets.
-
Integrate Cline with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Authorize.Net data from within your IDE.
-
Integrate Live HubDB 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 HubDB data from within the IDE.
-
Integrating Antigravity CLI with NASA data via CData CLI
Connect NASA data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Confluence Data into Apache Kafka Topics
Access and stream Confluence data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Optimizely Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Optimizely replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time SQL Analysis Services Data
Use the CData ODBC Driver for SQL Analysis Services to visualize SQL Analysis Services data in Power BI Desktop.
-
How to Connect the Power BI Service to Zendesk: Complete Guide
Connect to the CData Software Power BI Connector for Zendesk from PowerBI.com to provide real-time Zendesk data across the organization.
-
Connect to DocuSign Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time DocuSign data using standard SQL.
-
DataBind Charts to LinkedIn Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LinkedIn Ads 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.
-
Enable the Databricks JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Databricks data.
-
Publish Crystal Reports on Google Cloud Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Cloud Storage data.
-
DataBind PostgreSQL Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for PostgreSQL with the DevExpress Windows Forms and Web controls to provide PostgreSQL data to a chart.
-
Build Apps with Live Parallel Data Using the Low-Code Development Platform of Mendix
Connect Parallel data with Mendix to build apps using the CData API Driver for JDBC.
-
Access SAP Hybris C4C 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 SAP Hybris C4C data.
-
How to Query Paymo Data in MySQL Workbench
Execute MySQL queries against live Paymo data from MySQL Workbench.
-
Access HBase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live HBase data from HeidiSQL.
-
Build a Singer.io Tap for Telegram With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Telegram data using the CData Python Connector.
-
Consume Microsoft Exchange OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Exchange feeds that reflect any changes in SAP Lumira.
-
Getting Started with the CData Connect AI Python SDK for Google Ads
Install the CData Connect AI Python SDK to read live Google Ads data with standard DB-API 2.0 Python code.
-
Visualize CSV 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 CSV data into TIBCO Spotfire.
-
Integrate Printful Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Printful data from Informatica Cloud.
-
Access Zoho Projects Data from MySQL in PHP
Connect to Zoho Projects through the standard MySQL libraries in PHP.
-
Build AI Agents with ShipEngine 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 ShipEngine data through CData Connect AI.
-
Use the CData Software ODBC Driver for Testmonitor in SAS for Real-Time Reporting and Analytics
Connect to real-time Testmonitor data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Testmonitor.
-
Automated Continuous Amazon Marketplace Replication to Oracle
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Oracle.
-
How to Work with Coda Data in AWS Glue Jobs Using JDBC
Connect to Coda from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Keap Data from PowerBuilder via JDBC
This article demonstrates how to access Keap data from PowerBuilder using the Keap JDBC Driver.
-
How to integrate Metabase with Kintone Data
Use CData Connect AI to connect to live Kintone data and create an interactive dashboard in Metabase from Kintone data.
-
How to Connect to Live BigQuery 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 BigQuery data through natural language.
-
How to Connect Flowise AI Agents to Live Oracle Financials Cloud 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 Oracle Financials Cloud data without replication.
-
Connect and Query Live Microsoft Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Microsoft Ads data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software JDBC Driver for iContact in MicroStrategy Web
Connect to iContact data in MicroStrategy Web using the CData Software JDBC Driver for iContact.
-
Use JayDeBeApi to access OnePageCrm Data in Python
Use standard Python scripting and the development environment of your choice to access live OnePageCrm data.
-
Integrate Trae with Live MySQL Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live MySQL data from within the AI-powered IDE.
-
Build Authorize.Net-Connected Apps in Choreo
Use CData Connect AI to connect to Authorize.Net Data from Choreo and build custom apps using live Authorize.Net data.
-
Access Live ZohoSubscriptions Data in Excel 365 Online (Excel for the web)
Connect to ZohoSubscriptions data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Connect Gmail 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 Gmail data in real time using natural language.
-
Import and Visualize SAP Fieldglass Data in Power View
Create data visualizations based on SAP Fieldglass data in Excel.
-
How to Query QuickBooks Time Data in MySQL Workbench
Execute MySQL queries against live QuickBooks Time data from MySQL Workbench.
-
Analyze Mailgun Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Mailgun data in Microsoft R Open.
-
Getting Started with the CData Connect AI Python SDK for Azure Analysis Services
Install the CData Connect AI Python SDK to read live Azure Analysis Services data with standard DB-API 2.0 Python code.
-
Visualize Amplitude Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amplitude data.
-
Getting Started with the CData SSIS Components for Adobe Commerce
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Adobe Commerce.
-
Integrate Cursor with Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Kafka data from within the editor.
-
Publish Databricks-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Databricks data.
-
Connect to SAP Netweaver Gateway Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Netweaver Gateway and the Script function in FileMaker Pro to connect to SAP Netweaver Gateway and work with SAP Netweaver Gateway data in your FileMaker application.
-
Build SurveyMonkey Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SurveyMonkey data and build visualizations in Tableau Cloud.
-
Analyze Mailgun Data in Cognos Analytics
Use CData Connect AI to connect to Mailgun Data from Cognos Analytics and analyze live Mailgun data.
-
Access Live Dynamics 365 Business Central Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Dynamics 365 Business Central data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.