CData Software - Knowledge Base
Recent Articles
-
Connect to SAP Business Warehouse Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Business Warehouse data.
-
Connect to ZohoDesk in SpagoBI
Create reports featuring live ZohoDesk data in SpagoBI Studio. Host ZohoDesk reports on SpagoBI Server.
-
Automate Moosend Data Replication to Couchbase
Use CData Sync to Customize and automate Moosend data replication to Couchbase.
-
Connect to OpenWeatherMap Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to OpenWeatherMap and work with OpenWeatherMap data in your FileMaker applications.
-
Automated Rebilly Data Replication to Teradata
Use CData Sync to Customize and automate Rebilly data replication to Teradata.
-
View Reports on Real-Time Zoho Projects Data in Power BI Report Server
Use the CData ODBC Driver for Zoho Projects to visualize Zoho Projects data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Confluence in MicroStrategy Web
Connect to Confluence data in MicroStrategy Web using the CData Software ODBC Driver for Confluence.
-
Access Live Dynamics 365 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dynamics 365 data into the statistical analysis tools available in SAS JMP. This article shows how to use Dynamics 365 data in the Graph Builder and Query Builder.
-
Connect to and Query SAS xpt Data in QlikView over ODBC
Create data visualizations with SAS xpt data in QlikView.
-
Integrate Dify with Live Oracle SCM 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 Oracle SCM data.
-
Integrate Open WebUI with Live Xero Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Xero data from within the chat interface.
-
Use Dash to Build to Web Apps on Oracle Sales Data
Create Python applications that use pandas and Dash to build Oracle Sales-connected web apps.
-
Connect to Facebook Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Facebook as an External Source in Dremio.
-
Integrate RSS Feeds into Power Automate Desktop using CData Connect
CData Connect for RSS Feeds enables you to integrate RSS feeds into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To an ODBC Data Source for Cassandra
Create an ODBC connection to Cassandra in Informatica and browse and transfer Cassandra data.
-
Getting Started with the CData JDBC Driver for Bitbucket
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bitbucket.
-
Integrate with Live Samanage Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Samanage from the MuleSoft Anypoint Platform to integrate live Samanage data into custom reports and dashboards.
-
Build a PostgreSQL Interface for SingleStore Data using the CData JDBC Driver
Use the Remoting features of the SingleStore JDBC Driver to create a PostgreSQL entry-point for data access.
-
Explore Geographical Relationships in Browserless Data with Power Map
Create data visualizations with Browserless data in Power Map.
-
Integrate with Asana Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Asana data in SnapLogic.
-
Connect to OpenWeatherMap Data in RapidMiner
Integrate OpenWeatherMap data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live Egnyte 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 Egnyte data without replication.
-
Automated Presto Data Replication to Teradata
Use CData Sync to Customize and automate Presto data replication to Teradata.
-
Connect to Real-Time BenchmarkEmail Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use BenchmarkEmail data in Power Apps.
-
Interact with Live Authorize.Net Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Authorize.Net data.
-
Connect to Wave Financial Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wave Financial data in the Denodo Virtual DataPort Administrator.
-
Visualize Zoho Projects Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Projects data.
-
Connect CircleCI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CircleCI with IBM WebSphere for seamless data integration and connectivity.
-
Explore Geographical Relationships in HubSpot Data with Power Map
Create data visualizations with HubSpot data in Power Map.
-
Connect Hive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hive with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Zendesk 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 Zendesk data through MCP integration.
-
Automated Continuous Monday.com Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Monday.com replication to Google Cloud SQL.
-
Replicate Multiple Neo4J Accounts
Replicate multiple Neo4J accounts to one or many databases.
-
Design BIRT Reports on ADP Data
Provide current ADP data to your embedded analytics.
-
Connect to SuiteCRM from Asprova with CData Software ODBC Driver for SuiteCRM
This article shows how to connect faster to SuiteCRM data from Asprova.
-
Automated Continuous Sentry Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sentry replication to SingleStore.
-
Visualize HelloSign 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 HelloSign data into TIBCO Spotfire.
-
Process & Analyze Missive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Missive Data.
-
How to Connect to Live Cvent Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Cvent data for you.
-
Visualize Live GitHub Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live GitHub data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Instantly Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Instantly data using standard SQL.
-
Rapidly Develop Office 365-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 Office 365.
-
ETL Mailgun in Oracle Data Integrator
This article shows how to transfer Mailgun data into a data warehouse using Oracle Data Integrator.
-
Analyze SQL Server Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze SQL Server data with the CData JDBC Driver for SQL Server.
-
Create Data Visualizations Based On PostgreSQL Data in Mode
Use CData Connect AI to connect to PostgreSQL Data from Mode and build visualizations using live PostgreSQL data.
-
Use Databricks Agent Bricks to Talk to Your AlloyDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your AlloyDB data for you.
-
Getting Started with the CData Excel Add-In for Raisers Edge NXT
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Raisers Edge NXT.
-
Automated Continuous NASA Replication to Snowflake
Use CData Sync for automated, continuous, customizable NASA replication to Snowflake.
-
Model SAP SuccessFactors LMS Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP SuccessFactors LMS, enabling the direct import of real-time SAP SuccessFactors LMS data.
-
Connect to Blackbaud FE NXT Data in DBeaver
Use the CData ODBC Driver to connect to Blackbaud FE NXT data in DBeaver.
-
Query Couchbase Data in ColdFusion
Write standard ColdFusion data access code to connect to Couchbase data.
-
Connect to REST from Asprova with CData Software ODBC Driver for REST
This article shows how to connect faster to REST data from Asprova.
-
How to Connect to Live PostgreSQL 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 PostgreSQL data without replication.
-
Visualize Oracle Sales Data in Sisense
Create an ElastiCube in Sisense app with access to Oracle Sales data.
-
How to create Reckon Accounts Hosted federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Reckon Accounts Hosted data in MySQL .
-
Use Databricks Agent Bricks to Talk to Your Cvent Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Cvent data for you.
-
Integrate Dify with Live Google Directory 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 Google Directory data.
-
Integrating GitHub Copilot with Webex 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 integrate LinkedIn Ads with Apache Airflow
Access and process LinkedIn Ads data in Apache Airflow using the CData JDBC Driver.
-
Access LightSpeedRetail Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LightSpeedRetail data from HeidiSQL.
-
Consume REST OData Feeds in SAP Lumira
Use the API Server to create data visualizations on REST feeds that reflect any changes in SAP Lumira.
-
Load CockroachDB Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load CockroachDB data to a database.
-
Integrate Apify with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Apify with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apify data.
-
Build Charts with Paylocity Data in Clear Analytics
Create dynamic charts and perform analytics based on Paylocity data in Clear Analytics.
-
Connecting Pipedream with LinkedIn Ads 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 LinkedIn Ads data in real time.
-
Perform Batch Operations with Zoho Projects Data in Apache NiFi
Connect to Zoho Projects data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use Manus AI to Talk to Your SAP Business One 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 SAP Business One data.
-
Analyze Wrike Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Wrike data in Microsoft R Open.
-
Visualize SAP HANA Data in Tableau
The CData ODBC driver for SAP HANA enables you integrate SAP HANA data into Tableau dashboards.
-
Replicate Templated Data to Multiple Databases
Replicate Templated data to disparate databases with a point-and-click configuration.
-
Query Postmark Data in ColdFusion
Write standard ColdFusion data access code to connect to Postmark data.
-
Analyze Odoo Data in Looker
Use CData Connect AI to connect to Odoo Data from Looker and build custom apps using live Odoo data.
-
Connect to Sugar CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sugar CRM and the Script function in FileMaker Pro to connect to Sugar CRM and work with Sugar CRM data in your FileMaker application.
-
Use Microsoft Copilot Studio to talk to your Splunk 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 Splunk data for you.
-
Getting Started with the CData Python Connector for Humanity
Learn to install and license the CData Python Connector and configure a connection to live Humanity data.
-
Deploy the ADO.NET Provider for Nethunt on an SSRS Report Server
Connect to Nethunt 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.
-
Integrating LangChain with WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on WooCommerce data within automated workflows.
-
Getting Started with the CData Tableau Connector for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Amazon S3.
-
Create Oracle Financials Cloud-Connected Applications in Appsmith
Connect to Oracle Financials Cloud Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Oracle Financials Cloud data.
-
Access Live Okta Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Okta data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Connect to Qualaroo in SpagoBI
Create reports featuring live Qualaroo data in SpagoBI Studio. Host Qualaroo reports on SpagoBI Server.
-
Provide OData Services of SAS xpt Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAS xpt data by developing a WCF Service Application.
-
Connect to Epicor Kinetic Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Epicor Kinetic data.
-
Getting Started with the CData Excel Add-In for Printify
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Printify.
-
Build AI/ML Models with Live CSV Data using Dataiku
Connect CSV Data with Dataiku using the CData JDBC Driver for CSV.
-
Build Voice Agents in ElevenLabs with access to Live SparkPost Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SparkPost data.
-
Connect to Freshservice Data from PowerBuilder via ADO.NET
This article demonstrates how to access Freshservice data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate ClickUp Data in the Pentaho Report Designer
Publish reports based on ClickUp data in the Pentaho BI tool.
-
LINQ to Act CRM 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 Act CRM Data Provider.
-
A PostgreSQL Interface for Salesforce CRM Analytics Data (MySQL Remoting via JDBC)
Use the Remoting features of the Salesforce CRM Analytics JDBC Driver to create a PostgreSQL entry-point for data access.
-
Working with Airtable Data in LINQPad
Execute LINQ queries to Airtable data in LINQPad.
-
Integrating Presto Data in Talend Cloud Data Management Platform
Connect Presto Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Presto.
-
Bridge Google Translate Connectivity with Apache NiFi
Access and process Google Translate data in Apache NiFi using the CData JDBC Driver.
-
Publish Reports with Insightly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Insightly data.
-
Migrating data from ServiceDesk Plus to Databricks using CData SSIS Components.
Easily push ServiceDesk Plus data to Databricks using the CData SSIS Tasks for ServiceDesk Plus and Databricks.
-
Create Exact Online-Connected Dashboards in Grafana
Connect to Exact Online Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Exact Online data.
-
How to Query Tally Data in MySQL Workbench
Execute MySQL queries against live Tally data from MySQL Workbench.
-
Using the CData Software ODBC Driver for Twilio in PyCharm
Connect to Twilio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twilio.
-
Getting Started with the CData Python Connector for Amazon S3
Learn to install and license the CData Python Connector and configure a connection to live Amazon S3 data.
-
Integrate Mode Data in Pentaho Data Integration
Build ETL pipelines based on Mode data in the Pentaho Data Integration tool.