CData Software - Knowledge Base
Recent Articles
-
Access Live SharePoint 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 Microsoft SharePoint through MCP integration.
-
Analyze Excel Online Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Excel Online with the CData JDBC Driver for Excel Online.
-
Getting Started with the CData Tableau Connector for Scrapfly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Visualize CampaignMonitor Data in Tableau
The CData ODBC driver for CampaignMonitor enables you integrate CampaignMonitor into Tableau dashboards.
-
How to Work with Clio Data in AWS Glue Jobs Using JDBC
Connect to Clio from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Query Live Optimizely Data in Perplexity MacOS Desktop
Connect to and query live Optimizely Data in Perplexity Desktop using CData MCP Server.
-
Microsoft Ads Reporting in OBIEE with the Microsoft Ads JDBC Driver
Deploy the Microsoft Ads JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData ODBC Driver for Copper in Microsoft Power Query
You can use the CData Copper ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Copper into Microsoft Power Query.
-
Connect to and Visualize Live Jira Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Atlassian Jira.
-
Create Power BI Reports on Real-Time Cvent Data
Use the CData ODBC Driver for Cvent to visualize Cvent in Power BI Desktop.
-
Excel Spreadsheet Automation on iContact Data with the QUERY Formula
Pull data from iContact, automate spreadsheets, and more with the QUERY formula.
-
Working with Square Data in LINQPad
Execute LINQ queries to Square in LINQPad.
-
Getting Started with the CData Python Connector for Mode
Learn to install and license the CData Python Connector
-
Analyze MongoDB Data in Cognos Analytics
Use CData Connect AI to connect to MongoDB Data from Cognos Analytics and analyze live MongoDB.
-
Integrating LlamaIndex with Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Google Search in real time.
-
Getting Started with the CData ADO.NET Provider for MongoDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for MongoDB.
-
Feed Helpscout Data into FineReport
How to set Helpscout as a JDBC data source in FineReport.
-
Connect to Insightly Data in RapidMiner
Integrate Insightly with standard components and data source configuration wizards in RapidMiner Studio.
-
Use the CData API Server to Access Google Ads Data in Microsoft PowerPivot
Use the CData API Server to connect to live Google Ads in the Power Pivot business intelligence tool.
-
Automated Continuous FormSite Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FormSite replication to OneLake in Microsoft Fabric.
-
How to create Mailgun federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Mailgun in MySQL .
-
Integrate Printify Data in Pentaho Data Integration
Build ETL pipelines based on Printify in the Pentaho Data Integration tool.
-
Visualize CapsuleCRM Data in TIBCO Spotfire through ADO.NET
Integrate CapsuleCRM into dashboards in TIBCO Spotfire.
-
Use JayDeBeApi to access Spotify Data in Python
Use standard Python scripting and the development environment of your choice to access live Spotify.
-
How to connect Amazon QuickSight to Raisers Edge NXT Data
Create a connection to Raisers Edge NXT in CData Connect AI and insert Raisers Edge NXT into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to and Query Moosend Data in QlikView over ODBC
Create data visualizations with Moosend in QlikView.
-
DataBind Charts to Bitly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Bitly 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.
-
How to Easily Query MessageBird Data in OpenOffice Base
Connect to MessageBird data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to Gmail Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Gmail and the SQL Gateway to access Gmail from Google Apps Script.
-
Query ZohoSubscriptions Data in DataGrip
Create a Data Source for ZohoSubscriptions in DataGrip and use SQL to query live ZohoSubscriptions.
-
Integrating Cursor CLI with Aircall 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.
-
Access Email Data from MySQL in PHP
Connect to Email through the standard MySQL libraries in PHP.
-
Connecting Agentforce with FHIR 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 FHIR for you.
-
Natively Connect to Neo4J Data in PHP
The CData ODBC driver for Neo4J enables you to create PHP applications with connectivity to Neo4J. Leverage the native support for ODBC in PHP.
-
Automate Strava Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Strava from PowerShell? This article demonstrates how to utilize the Strava Cmdlets for tasks like connecting to Strava, automating operations, downloading data, and more.
-
How to Access Live Azure Table Data in Visual Studio Code via Cline
Run CData MCP Server for Azure on Windows Subsytem for Linux (WSL) and connect to live Azure Table Storage from the Cline extension in Visual Studio Code.
-
Excel Spreadsheet Automation on SurveyMonkey Data with the QUERY Formula
Pull data from SurveyMonkey, automate spreadsheets, and more with the QUERY formula.
-
Build Agents in Relevance AI with Access to Live Google Search Results via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Search within intelligent agent workflows.
-
How to Visualize Neo4J Data in Python with pandas
Use pandas and other modules to analyze and visualize live Neo4J in Python.
-
Visualize Twilio Data in Sisense
Create an ElastiCube in Sisense app with access to Twilio.
-
Connect to Cloudant Data in Google Apps Script via Connect AI
Use CData Connect AI to access IBM Cloudant in Google Apps Script.
-
Connecting Pipedream with Oracle Service Cloud 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 Oracle Service Cloud data in real time.
-
Integrate Vercel with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Vercel with External Services.
-
Choosing the Best Method to Connect Azure Data Lake Storage to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Data Lake Storage from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Viewing PolarTeamPro Data in RAD Studio Data Explorer
How to view PolarTeamPro in RAD Studio Data Explorer using the CData ODBC Driver for PolarTeamPro.
-
How to integrate Templated with Apache Airflow
Access and process Templated in Apache Airflow using the CData JDBC Driver.
-
Stream Copper Data into Apache Kafka Topics
Access and stream Copper in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Build Semantic Layer Views for Miro Data in APOS Live Data Gateway
Use the CData Connector for Miro in APOS Live Data Gateway to build Semantic Layer Views for Miro.
-
Create Reports with CampaignMonitor Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date CampaignMonitor.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Mocean to Power BI dashboards. Simply drag and drop Mocean into data visuals on the Power BI canvas.
-
How to connect PolyBase to ConstantContact
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ConstantContact.
-
How to Connect to SAP Business One Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Business One. Leverage the pyodbc module for ODBC in Python.
-
Build Cloudant-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for IBM Cloudant to explore live Cloudant Data in Cursor to assist with building Cloudant-powered applications.
-
Create SSAS Tabular Models from Oracle Financials Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Financials Cloud using CData drivers.
-
Creating HubSpot-Connected Applications in Unqork
You can use CData Connect AI to feed HubSpot to Unqork and build custom business apps.
-
Write a Simple Go Application to work with Oracle HCM Cloud Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle HCM Cloud.
-
Consume SAP Business Warehouse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Business Warehouse feeds that reflect any changes in SAP Lumira.
-
Create Zoho Books-Connected Dashboards in Grafana
Connect to Zoho Books Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Books.
-
Connect to and Visualize Live MessageBird Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MessageBird.
-
How to Query Live BigCommerce Data in Perplexity MacOS Desktop
Connect to and query live BigCommerce Data in Perplexity Desktop using CData MCP Server.
-
Connect to Exact Online Data in NetBeans
Connect to Exact Online in NetBeans with the data source configuration wizard.
-
Integrate Real-Time Access to Amazon Athena in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Athena in real time.
-
Create Couchbase-Connected Nintex Workflows
Use CData Connect AI to connect to Couchbase Data from Nintex Workflow Cloud and build custom workflows using live Couchbase.
-
Build Dashboards with MYOB AccountRight Data in Dundas BI
Create dynamic dashboards and perform analytics based on MYOB AccountRight in Dundas BI.
-
Connect to Pipeline CRM Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build AI/ML Models with Live TigerGraph Data using Dataiku
Connect TigerGraph Data with Dataiku using the CData JDBC Driver for TigerGraph.
-
Visualize Live MySQL Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MySQL using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Open WebUI with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zuora from within the chat interface.
-
Work with AlloyDB Data in FoxPro
Load Google AlloyDB into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Elasticsearch Data to Multiple Databases via the CData Sync CLI
Replicate Elasticsearch to disparate databases with a single configuration.
-
Getting Started with the CData ODBC Driver for Postmark
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Postmark.
-
Build Dashboards with Azure DevOps Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure DevOps in DBxtra.
-
Create Datasets from Trello in Domo Workbench and Build Visualizations of Trello Data in Domo
Use the CData Software ODBC Driver for Trello to create datasets from Trello in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Demio Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Demio data source in TIBCO Data Virtualization Studio and gain access to live Demio from your TDV Server.
-
Integrating LangChain with Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Entra ID within automated workflows.
-
How to Connect the Power BI Service to ClickUp: Complete Guide
Connect to the CData Software Power BI Connector for ClickUp from PowerBI.com to provide real-time ClickUp across the organization.
-
Work with Salesforce Data in FoxPro
Load Salesforce & Force.com into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated Continuous ConvertKit Replication to SQLite
Use CData Sync for automated, continuous, customizable ConvertKit replication to SQLite.
-
Access Apollo Data from MySQL in PHP
Connect to Apollo through the standard MySQL libraries in PHP.
-
Publish ChartMogul-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ChartMogul.
-
Work with Live Exact Online Data in Power Query
Use CData Connect AI to connect to Exact Online and work with live Exact Online in Microsoft Power Query.
-
Use Dash to Build to Web Apps on Zoho Recruit Data
Create Python applications that use pandas and Dash to build Zoho Recruit-connected web apps.
-
Integrating Kiro CLI with HDFS 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.
-
How to Query Chargebee Data in MySQL Workbench
Execute MySQL queries against live Chargebee from MySQL Workbench.
-
LINQ to Amazon DynamoDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Amazon DynamoDB Data Provider.
-
Load XML Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load XML Files to a database.
-
Build Visualizations of ConstantContact Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ConstantContact in Birst.
-
Build Pipelines with Live Elasticsearch Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Elasticsearch from Google Cloud Data Fusion, enabling the integration of live Elasticsearch into the building and management of effective data pipelines.
-
Connect PayPal Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your PayPal using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Brex-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData API Driver for MCP Server to explore live Brex Data in GitHub Copilot to assist with building Brex-powered applications.
-
Work with PivotalTracker Data in FoxPro
Load PivotalTracker into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extract, Transform, and Load Tavily Data in Informatica PowerCenter
Create a simple Workflow for Tavily in Informatica PowerCenter.
-
Bridge Salesforce Marketing Connectivity with Apache NiFi
Access and process Salesforce Marketing Cloud in Apache NiFi using the CData JDBC Driver.
-
How to connect to MYOB AccountRight Data in DBVisualizer
Integrate MYOB AccountRight with visual data analysis tools and data connection wizards in DBVisualizer
-
Analyze AlloyDB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Google AlloyDB and visualize Google AlloyDB in SAP Analytics Cloud.
-
Use JayDeBeApi to access SpaceX Data in Python
Use standard Python scripting and the development environment of your choice to access live SpaceX.
-
Connect to Wistia Data in Jaspersoft Studio
Execute SQL to remote Wistia in Jaspersoft Studio.
-
Design BIRT Reports on ZohoSubscriptions Data
Provide current ZohoSubscriptions to your embedded analytics.
-
Build Charts with DB2 Data in Clear Analytics
Create dynamic charts and perform analytics based on IBM DB2 in Clear Analytics.
-
How to connect SharePoint with ScrapingBee Data through external lists
Provide ScrapingBee to SharePoint users as an external list.