CData Software - Knowledge Base
Recent Articles
-
Query Live Perplexity Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Perplexity data directly from the development environment.
-
Use CData Connect AI to Access AfterShip Data in Microsoft Power Pivot
Use CData Connect AI to connect to live AfterShip data in the Power Pivot business intelligence tool.
-
Enable the Productboard JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Productboard data.
-
Interact with Live Testmonitor Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Testmonitor data.
-
Bind Live Monday.com Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Monday.com data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Live SageHR Data in Coginiti Pro
Connect to and query live SageHR data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Import Real-Time Clockify Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Clockify data in ColdFusion.
-
How to connect SharePoint with Databricks Data through external lists
Provide Databricks data to SharePoint users as an external list.
-
Getting Started with the CData ODBC Driver for SendPulse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SendPulse.
-
Access Sage Intacct Data from MySQL in PHP
Connect to Sage Intacct through the standard MySQL libraries in PHP.
-
How to connect PolyBase to Smartsheet
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Smartsheet data.
-
How to Connect Mode 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 Mode data in real time using natural language.
-
Create CloudConvert Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time CloudConvert data access from reports, embedded analytics, and more.
-
Getting Started with the CData Connect AI Python SDK for MariaDB
Install the CData Connect AI Python SDK to read and write live MariaDB data with standard DB-API 2.0 Python code.
-
Use the CData ODBC Driver for Salesforce Data 360 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Salesforce Data 360 to connect to Salesforce Data 360 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Salesforce Data 360 data in Excel.
-
Connecting Agentforce with Jira Assets 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 Jira Assets data for you.
-
Create Quickbase Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Quickbase from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Dashboards and Visualize Live Act-On Data in Geckoboard
Use CData Connect AI to connect to live Act-On data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Spotify Data in DBeaver
Use the CData ODBC Driver to connect to Spotify data in DBeaver.
-
Create Apps from IBM Cloud Object Storage Data in Qlik Sense Cloud
Use CData Connect AI to connect to IBM Cloud Object Storage Data and build apps from live IBM Cloud Object Storage data in Qlik Sense Cloud.
-
How to Connect to Live Guru 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 Guru data for you.
-
How to Seamlessly Import Front Data into IBM SPSS Modeler
Integrate Front data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to CloudConvert Data from PowerBuilder via JDBC
This article demonstrates how to access CloudConvert data from PowerBuilder using the CloudConvert JDBC Driver.
-
Explore Geographical Relationships in Oracle Eloqua Reporting Data with Power Map
Create data visualizations with Oracle Eloqua Reporting data in Power Map.
-
Analyze Gong Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Gong from Power Pivot. You will use the Table Import Wizard to load Gong data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect DBeaver to Google Contacts via a JDBC Driver
Manage Google Contacts data with visual tools in DBeaver like the query browser.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for IBM Informix
Provide connectivity to IBM Informix data through an SAP BusinessObjects universe.
-
Edit and Search External IBM Informix Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Informix data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create IBM Informix Data objects that you can access from apps and the dashboard.
-
Integrate Devin with Live Sybase 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 Sybase data.
-
Create Datasets from LaunchDarkly in Domo Workbench and Build Visualizations of LaunchDarkly Data in Domo
Use the CData Software ODBC Driver for LaunchDarkly to create datasets from LaunchDarkly data in Domo Workbench and then build visualizations in the Domo service.
-
Create Salesforce Pardot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Pardot data access from reports, embedded analytics, and more.
-
Integrating Antigravity CLI with Klaviyo data via CData CLI
Connect Klaviyo data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating LangChain with Guru Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Guru data within automated workflows.
-
How to integrate Metabase with Microsoft Dataverse Data
Use CData Connect AI to connect to live Microsoft Dataverse data and create an interactive dashboard in Metabase from Microsoft Dataverse data.
-
Integrate Wrike Data in Pentaho Data Integration
Build ETL pipelines based on Wrike data in the Pentaho Data Integration tool.
-
View Reports on Real-Time Outreach.io Data in Power BI Report Server
Use the CData ODBC Driver for Outreach.io to visualize Outreach.io data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Bright Data Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Bright Data data from your Excel spreadsheets.
-
Integrate Dify with Live Stripe 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 Stripe data.
-
Create Datasets from Dynamics CRM in Domo Workbench and Build Visualizations of Dynamics CRM Data in Domo
Use the CData Software ODBC Driver for Dynamics CRM to create datasets from Dynamics CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Real-Time Microsoft Ads Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Ads and Dataflow to import and use Microsoft Ads data in Power Apps.
-
Connect to Microsoft OneDrive Data in CloverDX (formerly CloverETL)
Transfer Microsoft OneDrive data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous RSS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable RSS replication to AlloyDB.
-
Connect to Keap Data in RazorSQL
Connect to Keap from wizards and query Keap data from the GUI in the RazorSQL database management tool.
-
Migrating data from SharePoint Excel Services to Google BigQuery using CData SSIS Components.
Easily push SharePoint Excel Services data to Google BigQuery using the CData SSIS Tasks for SharePoint Excel Services and Google BigQuery.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live CampaignMonitor data.
-
DataBind Charts to Elorus Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elorus 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.
-
Automated Continuous RSS Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable RSS replication to delimited files (CSV/TSV).
-
Create Azure Data Catalog Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure Data Catalog data access from reports, embedded analytics, and more.
-
Integrate Mode Data into Power Automate Desktop using CData Connect
CData Connect for Mode Data enables you to integrate Mode data into workflows built using Microsoft Power Automate Desktop.
-
Easily Integrate Apollo Data in Lazarus Pascal IDE
Learn how to easily integrate live Apollo data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate Azure DevOps Data into Power Automate Desktop using CData Connect
CData Connect for Azure DevOps Data enables you to integrate Azure DevOps data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous OData Services Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable OData services replication to OneLake in Microsoft Fabric.
-
Create FTP-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to FTP Data from OutSystems and build custom enterprise apps using live FTP data.
-
How to load LeadDesk data into Elasticsearch via Logstash
Introducing a simple method to load LeadDesk data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Odoo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Odoo data and visualize Odoo data in SAP Analytics Cloud.
-
Automated Continuous Hive Replication to SQL Server
Use CData Sync for automated, continuous, customizable Hive replication to SQL Server.
-
Connect Pinterest to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Pinterest data using the CData Python MCP Server.
-
Connect to and Visualize Live Elasticsearch Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Elasticsearch data.
-
Query Google Search Results through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Search results from Node.js.
-
Connect to Airtable Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Airtable data in the Denodo Virtual DataPort Administrator.
-
Analyze Authorize.Net Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Authorize.Net data and visualize live Authorize.Net data in Infragistics Reveal.
-
Connect to Zoho Recruit Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Recruit to connect to Zoho Recruit data and execute queries in PowerBuilder.
-
Build MVC Applications with Connectivity to Elasticsearch Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Elasticsearch from an ASP.NET MVC application.
-
Analyze Zuora Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Zuora data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Analyze JSON Services in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze JSON services in Microsoft R Open.
-
How to Work with Google Ads Data in ETL Validator JDBC
Connect to Google Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Spotify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Spotify replication to MongoDB.
-
Create Apps from Impala Data in Qlik Sense Cloud
Use CData Connect AI to connect to Impala Data and build apps from live Impala data in Qlik Sense Cloud.
-
Validate Insightly Data with QuerySurge
Access and validate Insightly data in QuerySurge using the CData JDBC Driver.
-
How to Access Parquet Data Using Entity Framework
This article shows how to access Parquet data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Presto Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Presto data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Apps with Live SAS xpt Data Using the Low-Code Development Platform of Mendix
Connect SAS xpt data with Mendix to build apps using the CData JDBC Driver for SAS xpt.
-
Connect to Bannerbear Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Bannerbear and work with Bannerbear data in your FileMaker application.
-
Connect to Adobe Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Analytics and the Script function in FileMaker Pro to connect to Adobe Analytics and work with Adobe Analytics data in your FileMaker application.
-
Visualize Clio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Clio data.
-
Explore Geographical Relationships in YouTube Analytics Data with Power Map
Create data visualizations with YouTube Analytics data in Power Map.
-
How to connect to Autopilot Data with Squirrel SQL client
Connect to Autopilot data and execute queries in the Squirrel SQL Client.
-
How to integrate Stripe with Apache Airflow
Access and process Stripe data in Apache Airflow using the CData JDBC Driver.
-
Integrating Boomi Agentstudio with Presto Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Presto data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to ClickTime Data in Ruby
Connect to ClickTime data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Front Data in Sisense
Create an ElastiCube in Sisense app with access to Front data.
-
Use Dash to Build Web Apps on Sybase Data via CData Connect AI
Build interactive Dash web apps on live Sybase data using pandas and the CData Connect AI Python SDK.
-
Visualize Adobe Analytics 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 Adobe Analytics data into TIBCO Spotfire.
-
How to Connect the Power BI Service to Egnyte: Complete Guide
Connect to the CData Software Power BI Connector for Egnyte from PowerBI.com to provide real-time Egnyte data across the organization.
-
Work with Live Oracle HCM Cloud Data in Power Query
Use CData Connect AI to connect to Oracle HCM Cloud data and work with live Oracle HCM Cloud data in Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Couchbase
Provide connectivity to Couchbase data through an SAP BusinessObjects universe.
-
Create Microsoft Entra ID-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Entra ID Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Entra ID data.
-
Getting Started with the CData SSIS Components for Redshift
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Redshift.
-
Import SAP HANA Data Using Azure Data Factory
Use CData Connect AI to connect to SAP HANA Data from Azure Data Factory and import live SAP HANA data.
-
Connect to Raisers Edge NXT Data in RazorSQL
Connect to Raisers Edge NXT from wizards and query Raisers Edge NXT data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Authorize.Net Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Google Cloud SQL.
-
Import AlloyDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to AlloyDB Data and provide access to live AlloyDB data for custom reports in the Power BI Service.
-
Integrate LibreChat with Live Perplexity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Perplexity data from within the chat interface.
-
Perform Batch Operations with Cassandra Data in Apache NiFi
Connect to Cassandra data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
How to connect Amazon QuickSight to AlloyDB Data
Create a connection to AlloyDB data in CData Connect AI and insert AlloyDB data into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Build an ETL App for Wave Financial Data in Python with CData
Create ETL applications and real-time data pipelines for Wave Financial data in Python with petl.
-
Automated Continuous Redis Replication to SingleStore
Use CData Sync for automated, continuous, customizable Redis replication to SingleStore.
-
Connect to Airtable Data from PowerBuilder via JDBC
This article demonstrates how to access Airtable data from PowerBuilder using the Airtable JDBC Driver.
-
Build Charts with TigerGraph Data in Clear Analytics
Create dynamic charts and perform analytics based on TigerGraph data in Clear Analytics.
-
How to Easily Query SAP HANA Data in OpenOffice Base
Connect to SAP HANA data in OpenOffice Base using the CData ODBC Driver for SAP HANA and generate reports with live data insights.