CData Software - Knowledge Base
Recent Articles
-
How to Create Power BI Visual Reports with Real-Time OpenWeatherMap Data
Use CData Power BI Connectors to visualize OpenWeatherMap data in Power BI.
-
Configure the CData JDBC Driver for Notion in a Connection Pool in Tomcat
Connect to Notion data from a connection pool in Tomcat.
-
Visualize Vercel Data in Sisense
Create an ElastiCube in Sisense app with access to Vercel data.
-
Prepare, Blend, and Analyze Quaderno Data in Alteryx Designer (ODBC)
Build workflows to access live Quaderno data for self-service data analytics.
-
Integrate Live Acumatica Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Acumatica data and integrate live Acumatica data into apps built in Microsoft Power Apps.
-
How to create an RPA flow for Cloudant Data in UiPath Studio
Use the Cloudant ODBC Driver to create workflows that access real-time Cloudant data without any coding.
-
Build an OLAP Cube in SSAS from Guru Data
Establish a connection to Guru data data from SQL Server Analysis Services, and use the Guru Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Stripe-Connected Business Apps in AppSheet
Connect to Stripe Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Stripe data.
-
Publish SendGrid-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live SendGrid data.
-
Query Amazon Marketplace Data as a MySQL Database in Node.js
Execute MySQL queries against Amazon Marketplace data from Node.js.
-
How to Visualize Gmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live Gmail data in Python.
-
Use Dash to Build to Web Apps on Rebilly Data
Create Python applications that use pandas and Dash to build Rebilly-connected web apps.
-
Integrate Live Teradata Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Teradata data and integrate live Teradata data into apps built in Microsoft Power Apps.
-
How to Connect to Live Shippo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Shippo data securely in real time.
-
Import Real-Time Reckon Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Reckon data in ColdFusion.
-
Build a Simple VCL Application for Short.io Data
How to build a simple VCL Application to view Short.io data in RAD Studio using the CData ODBC Driver for Short.io.
-
Build an OLAP Cube in SSAS from SAP HANA XS Advanced Data
Establish a connection to SAP HANA XS Advanced data data from SQL Server Analysis Services, and use the SAP HANA XS Advanced Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Connect Flowise AI Agents to Live Azure Data Catalog 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 Azure Data Catalog data without replication.
-
Publish HCL Domino-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live HCL Domino data.
-
Create Power BI Reports on Real-Time Reply.io Data
Use the CData ODBC Driver for Reply.io to visualize Reply.io data in Power BI Desktop.
-
Automated Avaza Data Replication to Teradata
Use CData Sync to Customize and automate Avaza data replication to Teradata.
-
Use Microsoft Copilot Studio to talk to your Figshare 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 Figshare data for you.
-
Connect to ADP Data from Crystal Reports
Use CData Connect AI to connect to and report on live ADP data from Crystal Reports.
-
Build GitHub-Connected Apps in Choreo
Use CData Connect AI to connect to GitHub Data from Choreo and build custom apps using live GitHub data.
-
Create SSAS Tabular Models from Notion Data
How to build a SQL Server Analysis Service Tabular Model from Notion data using CData drivers.
-
Integrate Live SpaceX Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SpaceX data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrating OpenCode with SAS Data Sets 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 connect PolyBase to Clockify
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Clockify data.
-
Use Microsoft Copilot Studio to talk to your HBase 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 HBase data for you.
-
Build SendGrid-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SendGrid Data and create custom apps in Mendix.
-
Integrate Cline with Live Microsoft Dataverse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Dataverse data from within your IDE.
-
Connect to TaxJar Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live TaxJar data.
-
Rapidly Develop Autopilot-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 Autopilot.
-
Use Dash to Build to Web Apps on Box Data
Create Python applications that use pandas and Dash to build Box-connected web apps.
-
Analyze Microsoft Teams Data in Looker
Use CData Connect AI to connect to Microsoft Teams Data from Looker and build custom apps using live Microsoft Teams data.
-
DataBind Controls to SpaceX Data in Delphi
DataBind to SpaceX data in Delphi with standard data access components and controls.
-
Connect to Salesforce Pardot Data from Crystal Reports
Use CData Connect AI to connect to and report on live Salesforce Pardot data from Crystal Reports.
-
Getting Started with the CData SSIS Components for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Ariba Procurement.
-
Automated Continuous Aweber Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Aweber replication to Azure SQL Database.
-
Manage Oracle Service Cloud Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Oracle Service Cloud.
-
Operational Reporting on Amazon DynamoDB Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Amazon DynamoDB data.
-
How to Connect to Live SAP Concur 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 SAP Concur data without replication.
-
Access Live BigQuery Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live BigQuery data from your Excel spreadsheets.
-
Publish Crystal Reports on Beeminder Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Beeminder data.
-
Connect to Pinecone Data in RapidMiner
Integrate Pinecone data with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Claude to Talk to Your Marketing Data
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your marketing data for you.
-
Connect to and Visualize Live Nuclia Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Nuclia data.
-
Integrate Xero Data in Pentaho Data Integration
Build ETL pipelines based on Xero data in the Pentaho Data Integration tool.
-
How to Connect to Live CockroachDB 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 CockroachDB data without replication.
-
Integrating Cursor with SAP HANA XS Advanced 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 Connect to Live HBase 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 HBase data for you.
-
Create SSAS Tabular Models from Oracle Sales Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Sales data using CData drivers.
-
Analyze Zoho Books Data in Cognos Analytics
Use CData Connect AI to connect to Zoho Books Data from Cognos Analytics and analyze live Zoho Books data.
-
Import RSS Feeds into the Power BI Service for Visualizations
Use CData Connect AI to connect to RSS Feeds and provide access to live RSS feeds for custom reports in the Power BI Service.
-
Connect to Zoho CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho CRM data using standard SQL.
-
Connect to Cloudflare Data in RapidMiner
Integrate Cloudflare data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Devin with Live Redis 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 Redis data.
-
How to Connect to Live Shippo 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 Shippo data for you.
-
How to import Egnyte Data into Apache Solr
Use the CData Software JDBC Driver for Egnyte in Data Import Handler and create an automated import of Egnyte data to Apache Solr Enterprise Search platform.
-
How to connect SharePoint with Zendesk Data through external lists
Provide Zendesk data to SharePoint users as an external list.
-
Rapidly Develop Accelo-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 Accelo.
-
How to integrate MarkLogic with Apache Airflow
Access and process MarkLogic data in Apache Airflow using the CData JDBC Driver.
-
How to connect SharePoint with Microsoft Teams Data through external lists
Provide Microsoft Teams data to SharePoint users as an external list.
-
Connect to Amazon DynamoDB Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Amazon DynamoDB data.
-
Create Dynamic YouTube Analytics Grids Using the Infragistics XamDataGrid
Learn how you can connect YouTube Analytics to Infragistics XamDataGrid to build dynamic grids.
-
Build Automated Workflows with Live SAP SuccessFactors LMS Data in Workato
Use CData Connect AI to connect to live SAP SuccessFactors LMS data and build automated workflows in Workato.
-
Visualize DocuSign Data in TIBCO Spotfire through ADO.NET
Integrate DocuSign data into dashboards in TIBCO Spotfire.
-
Write a Simple Go Application to work with ClickTime Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ClickTime data.
-
Integrate with Oracle Financials Cloud Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle Financials Cloud data in SnapLogic.
-
Connect to TaxJar Data in CloverDX (formerly CloverETL)
Transfer TaxJar data using the visual workflow in the CloverDX data integration tool.
-
Connecting GenSpark with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP Hybris C4C data without any replication or custom integration required.
-
Build Sage 300-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Sage 300 data.
-
Import Basecamp Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Basecamp Data and provide access to live Basecamp data for custom reports in the Power BI Service.
-
LINQ to Klaviyo 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 Klaviyo Data Provider.
-
Design BIRT Reports on SQL Server Data
Provide current SQL Server data to your embedded analytics.
-
Connect to Billsby Data from a Connection Pool in Jetty
The Billsby JDBC Driver supports connection pooling: This article shows how to connect faster to Billsby data from Web apps in Jetty.
-
Design BIRT Reports on HubDB Data
Provide current HubDB data to your embedded analytics.
-
Seamlessly Bring Facebook Ads Data into Retool Using CData Connect AI
Integrate Facebook Ads data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Use Manus AI to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Stripe data.
-
Access Spotify Data from MySQL in Amazon QuickSight
Connect to Spotify and build visualizations of Spotify data using a MySQL Connection in Amazon QuickSight.
-
Connect to Dynamics 365 Data in JRuby
Create a simple JRuby app with access to live Dynamics 365 data.
-
Excel Spreadsheet Automation on XML Data with the QUERY Formula
Pull data from XML, automate spreadsheets, and more with the QUERY formula.
-
Integrating Claude Code with Oracle Financials Cloud Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Oracle Financials Cloud data within assisted coding and automated development workflows.
-
Visualize SAP Business Warehouse Data in TIBCO Spotfire through OData
Integrate SAP Business Warehouse data into dashboards in TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Oracle Sales in MicroStrategy
Connect to Oracle Sales data in MicroStrategy Developer using the CData Software JDBC Driver for Oracle Sales.
-
Use the CData Software ODBC Driver for OneNote in MicroStrategy Web
Connect to OneNote data in MicroStrategy Web using the CData Software ODBC Driver for OneNote.
-
Build Automated Workflows with Live ZohoSubscriptions Data in Workato
Use CData Connect AI to connect to live ZohoSubscriptions data and build automated workflows in Workato.
-
How to connect to Vercel Data with Squirrel SQL client
Connect to Vercel data and execute queries in the Squirrel SQL Client.
-
Connect to ConvertAPI Data from PowerBuilder via JDBC
This article demonstrates how to access ConvertAPI data from PowerBuilder using the ConvertAPI JDBC Driver.
-
Use Microsoft Copilot Studio to talk to your Jira Assets 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 Jira Assets data for you.
-
Build Charts with Rebilly Data in Clear Analytics
Create dynamic charts and perform analytics based on Rebilly data in Clear Analytics.
-
How to Seamlessly Import Productboard Data into IBM SPSS Modeler
Integrate Productboard data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Exa-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Exa data and build Exa-connected web apps with Axios.
-
Perform Batch Operations with Stripe Data in Apache NiFi
Connect to Stripe data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Create Apps from Sendwithus Data in Qlik Sense Cloud
Use CData Connect AI to connect to Sendwithus Data and build apps from live Sendwithus data in Qlik Sense Cloud.
-
Access Live Exa Data in AWS Lambda
Connect to live Exa data in AWS Lambda using the CData JDBC Driver.
-
Query Raisers Edge NXT Data in ColdFusion
Write standard ColdFusion data access code to connect to Raisers Edge NXT data.
-
Object-Relational Mapping (ORM) with MailerLite Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MailerLite data into a Java-based ORM framework, Hibernate.
-
Query Zoho Creator Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Zoho Creator data from Node.js.
-
Automated Continuous Amazon DynamoDB Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Google BigQuery.