CData Software - Knowledge Base
Recent Articles
-
How to create Nethunt federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Nethunt in MySQL .
-
Build RSS-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for RSS to explore live RSS Feeds in GitHub Copilot to assist with building RSS-powered applications.
-
Automated Continuous Exact Online Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Exact Online replication to Azure SQL Database.
-
View Reports on Real-Time Exa Data in Power BI Report Server
Use the CData ODBC Driver for Exa to visualize Exa in Power BI Desktop and then publish them to Power BI Report Server.
-
LINQ to Adobe Experience Manager 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 Adobe Experience Manager Data Provider.
-
Use the CData ODBC Driver for Email in Microsoft Power Query
You can use the CData Email ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Email into Microsoft Power Query.
-
Manage Zoom Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoom.
-
Replicate RSS Feeds to Multiple Databases
Replicate RSS Feeds to disparate databases with a point-and-click configuration.
-
How to Connect the Power BI Service to Redshift: Complete Guide
Connect to the CData Software Power BI Connector for Redshift from PowerBI.com to provide real-time Amazon Redshift across the organization.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Xero Accounting to Power BI dashboards. Simply drag and drop Xero Accounting into data visuals on the Power BI canvas.
-
Analyze EnterpriseDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of EnterpriseDB and visualize live EnterpriseDB in Infragistics Reveal.
-
DataBind SuiteCRM Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SuiteCRM with the DevExpress Windows Forms and Web controls to provide SuiteCRM to a chart.
-
Integrate Email Data in Pentaho Data Integration
Build ETL pipelines based on Email in the Pentaho Data Integration tool.
-
Connect to DocuSign Data from Crystal Reports
Use CData Connect AI to connect to and report on live DocuSign from Crystal Reports.
-
Access Live Dotmailer Data in AWS Lambda
Connect to live Dotmailer in AWS Lambda using the CData JDBC Driver.
-
Build Charts with Xero Data in Clear Analytics
Create dynamic charts and perform analytics based on Xero Accounting in Clear Analytics.
-
Replicate Multiple SAP Accounts
Replicate multiple SAP accounts to one or many databases.
-
Connect to BigCommerce Data in DBArtisan
Use wizards in DBArtisan to configure BigCommerce as a data source.
-
Connect to SAP Ariba Procurement Data in ACL Analytics
Connect to SAP Ariba Procurement via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP Ariba Procurement.
-
Integrating Dataiku with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live eBay.
-
How to Connect to Live AlloyDB 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 Google AlloyDB for you.
-
How to Query Live OneNote Data in Perplexity MacOS Desktop
Connect to and query live OneNote Data in Perplexity Desktop using CData MCP Server.
-
Automate Quaderno Data Replication to Couchbase
Use CData Sync to Customize and automate Quaderno replication to Couchbase.
-
Connecting Moonlit Workflow with SAP Hybris C4C Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your SAP Hybris C4C in real time.
-
Create Informatica Mappings From/To a JDBC Data Source for BigQuery
Create BigQuery data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Build an ETL App for Greenplum Data in Python with CData Connect AI
Build ETL pipelines that read and write live Pivotal GreenPlum in Python with petl and the CData Connect AI Python SDK.
-
Use the CData ODBC Driver for Retently from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Retently to connect to Retently from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Retently in Excel.
-
Connect to PingOne Data in JRuby
Create a simple JRuby app with access to live PingOne.
-
Use CData Connect AI to Access Outreach.io Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Outreach.io in the Power Pivot business intelligence tool.
-
Import Real-Time Parquet Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Apache Parquet in ColdFusion.
-
Automated SendPulse Data Replication to Teradata
Use CData Sync to Customize and automate SendPulse replication to Teradata.
-
Integrating LlamaIndex with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on eBay in real time.
-
Connect to Hubstaff Data in Jaspersoft Studio
Execute SQL to remote Hubstaff in Jaspersoft Studio.
-
Build Adobe Commerce-Connected Apps in Choreo
Use CData Connect AI to connect to Adobe Commerce Data from Choreo and build custom apps using live Adobe Commerce.
-
Integrate with HubSpot Data in JReport Designer
Create charts and reports based on HubSpot in JReport Designer.
-
Create SSAS Tabular Models from Oracle Service Cloud Data
How to build a SQL Server Analysis Service Tabular Model from Oracle Service Cloud using CData drivers.
-
How to Connect DBeaver to SAP SuccessFactors via a JDBC Driver
Manage SAP SuccessFactors with visual tools in DBeaver like the query browser.
-
How to Connect ShipStation 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 ShipStation data in real time using natural language.
-
Access Live Chargebee Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Chargebee in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Using the CData Software ODBC Driver for Gumroad in PyCharm
Connect to Gumroad as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gumroad.
-
How to connect Amazon QuickSight to Redshift Data
Create a connection to Amazon Redshift in CData Connect AI and insert Amazon Redshift into Amazon QuickSight SPICE to build interactive dashboards.
-
Query DB2 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against IBM DB2 from Node.js.
-
Integrating Claude Code CLI with SuiteCRM 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.
-
Visualize Live Oracle Eloqua Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Oracle Eloqua into custom reports in Power BI.
-
Build Agents in Relevance AI with Access to Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on EnterpriseDB within intelligent agent workflows.
-
Integrating Cursor CLI with Helpscout 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.
-
Automate Retently Data Replication to Couchbase
Use CData Sync to Customize and automate Retently replication to Couchbase.
-
Connect to Paddle Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Paddle.
-
Publish Google Drive-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Google Drive.
-
Automate Oracle Service Cloud Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle Service Cloud and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Access Figshare Data Using Entity Framework
This article shows how to access Figshare using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Visualize Live Jira Assets Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Jira Assets.
-
How to Access Live Oracle Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle on Windows Subsytem for Linux (WSL) and connect to live Oracle Database from the Cline extension in Visual Studio Code.
-
How to work with Contentful Data in Apache Spark using SQL
Access and process Contentful Data in Apache Spark using the CData Software JDBC Driver.
-
Analyze TaxJar Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze TaxJar in Microsoft R Open.
-
Getting Started with the CData Tableau Connector for ShipStation
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for ShipStation.
-
Import Cassandra Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Cassandra Data and provide access to live Apache Cassandra for custom reports in the Power BI Service.
-
Build Dashboards with Printify Data in DBxtra
Create dynamic dashboards and perform analytics based on Printify in DBxtra.
-
Integrate Real-Time Access to MarkLogic in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to MarkLogic in real time.
-
How to Connect Impala 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 Impala data in real time using natural language.
-
Integrate Exact Online with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Exact Online with External Services.
-
How to Access Greenplum Data Using Entity Framework
This article shows how to access Pivotal GreenPlum using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to BigQuery Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google BigQuery using standard SQL.
-
Use Dash to Build to Web Apps on Sage 300 Data
Create Python applications that use pandas and Dash to build Sage 300-connected web apps.
-
How to Access Kintone Data Using Entity Framework
This article shows how to access Kintone using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
A PostgreSQL Interface for Codat Data (MySQL Remoting via JDBC)
Use the Remoting features of the Codat JDBC Driver to create a PostgreSQL entry-point for data access.
-
Publish SFTP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SFTP.
-
Connect to and Visualize Live XML Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live XML Files.
-
Automated Continuous Azure Data Lake Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to Google BigQuery.
-
Integrating LangChain with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Exchange within automated workflows.
-
Integrate Google Ads Data in the Pentaho Report Designer
Publish reports based on Google Ads in the Pentaho BI tool.
-
Automated Continuous Dynamics 365 Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to SQLite.
-
Automated Continuous QuickBooks Online Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Azure SQL Database.
-
How to Access Live Amazon Marketplace Data in Visual Studio Code via Cline
Run CData MCP Server for Amazon Marketplace on Windows Subsytem for Linux (WSL) and connect to live Amazon Marketplace from the Cline extension in Visual Studio Code.
-
Publish Crystal Reports on SpaceX Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SpaceX.
-
Create Datasets from Salesforce Marketing in Domo Workbench and Build Visualizations of Salesforce Marketing Data in Domo
Use the CData Software ODBC Driver for Salesforce Marketing to create datasets from Salesforce Marketing Cloud in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Snapchat Ads Data with Squirrel SQL client
Connect to Snapchat Ads and execute queries in the Squirrel SQL Client.
-
JobNimbus Reporting in OBIEE with the JobNimbus JDBC Driver
Deploy the JobNimbus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Feed Cvent Data into FineReport
How to set Cvent as a JDBC data source in FineReport.
-
How to Visualize LDAP Data in Python with pandas
Use pandas and other modules to analyze and visualize live LDAP in Python.
-
Connecting Pipedream with Sugar CRM 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 Sugar CRM data in real time.
-
Create Dynamic Notion Grids Using the Infragistics XamDataGrid
Learn how you can connect Notion to Infragistics XamDataGrid to build dynamic grids.
-
Import API Data Using Azure Data Factory
Use CData Connect AI to connect to API Data from Azure Data Factory and import live API.
-
How to connect to Freshteam Data from Spring Boot
Connect to Freshteam in a Spring Boot Application using the CData API Driver for JDBC
-
Visualize Onfleet 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 Onfleet into TIBCO Spotfire.
-
Build MVC Applications with Connectivity to Pinterest Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Pinterest from an ASP.NET MVC application.
-
Automated Continuous Elorus Replication to Oracle
Use CData Sync for automated, continuous, customizable Elorus replication to Oracle.
-
Connect to Elorus Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Access Live Salesforce Marketing Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Salesforce Marketing Cloud from your Excel spreadsheets.
-
Query SharePoint Excel Services Data through ODBC in Node.js
Use node-odbc to execute SQL queries against SharePoint Excel Services from Node.js.
-
Connect to Sugar CRM Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sugar CRM from Crystal Reports.
-
Automated Continuous Zendesk Replication to MySQL
Use CData Sync for automated, continuous, customizable Zendesk replication to MySQL.
-
How to import Outlook Data into Apache Solr
Use the CData Software JDBC Driver for Outlook in Data Import Handler and create an automated import of Outlook to Apache Solr Enterprise Search platform.
-
Integrate with Paddle Data in JReport Designer
Create charts and reports based on Paddle in JReport Designer.
-
Access LaunchDarkly Data from MySQL in Amazon QuickSight
Connect to LaunchDarkly and build visualizations of LaunchDarkly using a MySQL Connection in Amazon QuickSight.
-
Create Asana-Connected Applications in Appsmith
Connect to Asana Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Asana.
-
Build MVC Applications with Connectivity to PivotalTracker Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PivotalTracker from an ASP.NET MVC application.
-
View Reports on Real-Time Onfleet Data in Power BI Report Server
Use the CData ODBC Driver for Onfleet to visualize Onfleet in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to SingleStore from Asprova with CData Software ODBC Driver for SingleStore
This article shows how to connect faster to SingleStore data from Asprova.
-
Excel Spreadsheet Automation on ConstantContact Data with the QUERY Formula
Pull data from ConstantContact, automate spreadsheets, and more with the QUERY formula.