CData Software - Knowledge Base
Recent Articles
-
Connect to Live CouchDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to CouchDB in CData Connect AI and connect to your CouchDB data from PostgreSQL.
-
Connect to Recurly Data in DBeaver
Use the CData ODBC Driver to connect to Recurly data in DBeaver.
-
Integrating Dataiku with ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live ADP data.
-
Access Live Zendesk Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zendesk data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Query Landbot Data in MySQL Workbench
Execute MySQL queries against live Landbot data from MySQL Workbench.
-
How to Access Anaplan Data Using Entity Framework
This article shows how to access Anaplan data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access SAP Netweaver Gateway Data from MySQL in Amazon QuickSight
Connect to SAP Netweaver Gateway and build visualizations of SAP Netweaver Gateway data using a MySQL Connection in Amazon QuickSight.
-
Access PabblySubscriptions Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for PabblySubscriptions data.
-
How to use SQLAlchemy ORM to access SAP BusinessObjects BI Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP BusinessObjects BI data.
-
Trigger Quickbase IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Quickbase with standard wizards in Logic Apps.
-
Connect to Customer.io Data in RapidMiner
Integrate Customer.io data with standard components and data source configuration wizards in RapidMiner Studio.
-
LINQ to FreeAgent 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 FreeAgent Data Provider.
-
Access Live MariaDB Data in Coginiti Pro
Connect to and query live MariaDB data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live ZohoSubscriptions 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 ZohoSubscriptions data for you.
-
Access Live NetSuite 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 NetSuite data through MCP integration.
-
Publish Crystal Reports on Spark Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Spark data.
-
Edit and Search External SAP Hybris C4C Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP Hybris C4C data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP Hybris C4C Data objects that you can access from apps and the dashboard.
-
How to Work with SAP SuccessFactors LMS Data in AWS Glue Jobs Using JDBC
Connect to SAP SuccessFactors LMS from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Validate Beeminder Data with QuerySurge
Access and validate Beeminder data in QuerySurge using the CData JDBC Driver.
-
Moving Data from JSON to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live JSON data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Write a Simple Go Application to work with SAP HANA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA data.
-
A PostgreSQL Interface for Perplexity Data (MySQL Remoting via JDBC)
Use the Remoting features of the Perplexity JDBC Driver to create a PostgreSQL entry-point for data access.
-
Analyze Live MySQL Data in SAS Viya
Use CData Connect AI to connect to MySQL data from SAS Viya and deploy self-service analytics using live MySQL data.
-
Integrate Cursor with Live Oracle Service Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Oracle Service Cloud data from within the editor.
-
Excel Spreadsheet Automation on Xero Data with the QUERY Formula
Pull data from Xero, automate spreadsheets, and more with the QUERY formula.
-
Use CData Connect AI to Access GitLab Data in Microsoft Power Pivot
Use CData Connect AI to connect to live GitLab data in the Power Pivot business intelligence tool.
-
Integrating Close Data in Talend Cloud Data Management Platform
Connect Close Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Data Visualizations in Cognos BI with PayPal Data
Access PayPal data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Stripe Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Stripe data.
-
Connect to NASA Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for NASA data in the Denodo Virtual DataPort Administrator.
-
Automate Harvest Data Replication to Couchbase
Use CData Sync to Customize and automate Harvest data replication to Couchbase.
-
How to create xBase federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for xBase data in MySQL .
-
Automated Continuous Xero Replication to MongoDB
Use CData Sync for automated, continuous, customizable Xero replication to MongoDB.
-
Connect to ZarMoney Data in Aqua Data Studio
Access ZarMoney data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Slack Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Slack data and build visualizations in Tableau Cloud.
-
Connect to Sendwithus Data from a Connection Pool in JBoss
Integrate Sendwithus data into Java servlets: Use the Management Console in JBoss to install the Sendwithus JDBC Driver.
-
Build an OLAP Cube in SSAS from Onfleet Data
Establish a connection to Onfleet data data from SQL Server Analysis Services, and use the Onfleet Data Provider to build OLAP cubes for use in analytics and reporting.
-
A PostgreSQL Interface for Raisers Edge NXT Data (MySQL Remoting via JDBC)
Use the Remoting features of the Raisers Edge NXT JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ClickUp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ClickUp data using standard SQL.
-
Integrating Antigravity CLI with Google Directory data via CData CLI
Connect Google Directory data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to PolarTeamPro Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PolarTeamPro from an ASP.NET MVC application.
-
Create MariaDB-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to MariaDB Data from Klipfolio and build custom visualizations using live MariaDB data.
-
Model Facebook Ads Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Facebook Ads, enabling the direct import of real-time Facebook Ads data.
-
Publish RSS-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live RSS feeds.
-
Create Wistia-Connected Business Apps in AppSheet
Connect to Wistia Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Wistia data.
-
Connect to Oracle HCM Cloud Data in DBeaver
Use the CData ODBC Driver to connect to Oracle HCM Cloud data in DBeaver.
-
Import Real-Time Neo4J Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Neo4J data in ColdFusion.
-
Getting Started with the CData JDBC Driver for Guru
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Guru.
-
Automated Continuous Cohere Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cohere data replication to OneLake in Microsoft Fabric.
-
Build a Singer.io Tap for Rootly With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Rootly data using the CData Python Connector.
-
Analyze Cosmos DB Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Cosmos DB data and visualize Cosmos DB data in SAP Analytics Cloud.
-
Automate Vercel Data Replication to Azure Synapse
Use CData Sync to customize and automate Vercel data replication to Azure Synapse.
-
Connect to Azure Data Catalog Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Azure Data Catalog data using standard SQL.
-
Analyze Cloudflare Data in Looker
Use CData Connect AI to connect to Cloudflare Data from Looker and build custom apps using live Cloudflare data.
-
Jumpseller Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Jumpseller data through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for OData from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for OData to connect to OData services from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring OData services in Excel.
-
How to use SQLAlchemy ORM to access Tanda Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tanda data.
-
Build Visualizations of IBM Informix Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of IBM Informix data in Birst.
-
Replicate Multiple Retently Accounts
Replicate multiple Retently accounts to one or many databases.
-
Migrating data from Hubstaff to Google BigQuery using CData SSIS Components.
Easily push Hubstaff data to Google BigQuery using the CData SSIS Tasks for Hubstaff and Google BigQuery.
-
Connect to JotForm 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 JotForm and work with JotForm data in your FileMaker application.
-
Migrating data from ZeroBounce to Databricks using CData SSIS Components.
Easily push ZeroBounce data to Databricks using the CData SSIS Tasks for ZeroBounce and Databricks.
-
Rapidly Develop Greenplum-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 Greenplum.
-
Query Google Sheets Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Google Sheets entities in PHP by modeling them as objects.
-
Create SSAS Tabular Models from Smartsheet Data
How to build a SQL Server Analysis Service Tabular Model from Smartsheet data using CData drivers.
-
Connect to Zuora Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zuora data in the Denodo Virtual DataPort Administrator.
-
How to Connect Flowise AI Agents to Live SAS Data Sets 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 SAS Data Sets data without replication.
-
Automated Continuous Blackbaud FE NXT Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to AlloyDB.
-
Integrating LangChain with Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Freshservice data within automated workflows.
-
Getting Started with the CData Python Connector for SparkPost
Learn to install and license the CData Python Connector and configure a connection to live SparkPost data.
-
How to connect and process Strava data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Strava data.
-
Access Marketo Data from MySQL in PHP
Connect to Marketo through the standard MySQL libraries in PHP.
-
Integrate ShipStation Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live ShipStation data from Informatica Cloud.
-
Access SuiteCRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SuiteCRM data from HeidiSQL.
-
Microsoft Dataverse Reporting in OBIEE with the Microsoft Dataverse JDBC Driver
Deploy the Microsoft Dataverse JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous SageHR Replication to Vertica
Use CData Sync for automated, continuous, customizable SageHR replication to Vertica.
-
Build Visualizations of SAP SuccessFactors Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP SuccessFactors data in Birst.
-
How to create an RPA flow for Adobe Analytics Data in UiPath Studio
Use the Adobe Analytics ODBC Driver to create workflows that access real-time Adobe Analytics data without any coding.
-
How to Access Live Outlook Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Outlook enables you to integrate Outlook data into workflows built using Microsoft Power Automate Desktop.
-
Feed Phoenix Data into FineReport
How to set Phoenix data as a JDBC data source in FineReport.
-
How to Work with Optimizely Data in AWS Glue Jobs Using JDBC
Connect to Optimizely from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import eBay Analytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to eBay Analytics Data and provide access to live eBay Analytics data for custom reports in the Power BI Service.
-
Build an OLAP Cube in SSAS from Microsoft Exchange Data
Establish a connection to Microsoft Exchange data data from SQL Server Analysis Services, and use the Microsoft Exchange Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Dataiku with SAP Concur Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Concur data.
-
Use the CData SSIS Components to Insert New or Update Existing Cosmos DB Records from SQL Server
Easily push SQL Server data to Cosmos DB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Cosmos DB or update existing records with data from a SQL Server database.
-
Automated Continuous Moosend Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Moosend replication to Azure SQL Database.
-
Automate AlloyDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access AlloyDB data from PowerShell? This article demonstrates how to utilize the AlloyDB Cmdlets for tasks like connecting to AlloyDB data, automating operations, downloading data, and more.
-
Access OneNote Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access OneNote data from your Oracle system.
-
How to Connect the Power BI Service to Certinia: Complete Guide
Connect to the CData Software Power BI Connector for Certinia from PowerBI.com to provide real-time Certinia data across the organization.
-
Choosing the Best Method to Connect Beeminder to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Beeminder data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Live SAP HANA XS Advanced Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP HANA XS Advanced data and integrate live SAP HANA XS Advanced data into apps built in Microsoft Power Apps.
-
Create Dashboards and Visualize Live API Data in Geckoboard
Use CData Connect AI to connect to live API data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Connect Flowise AI Agents to Live Azure Synapse 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 Synapse data without replication.
-
Import Zuora Data Using Azure Data Factory
Use CData Connect AI to connect to Zuora Data from Azure Data Factory and import live Zuora data.
-
Build Visualizations of Excel Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Excel data in Birst.
-
Access Live Dynamics 365 Business Central Data in Excel 365 Online (Excel for the web)
Connect to Dynamics 365 Business Central data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Access Live JobNimbus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for JobNimbus enables you to integrate JobNimbus data into workflows built using Microsoft Power Automate Desktop.
-
Analyze Amazon S3 Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Amazon S3 data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect and Visualize Live Zoho Creator Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Zoho Creator data into the Databricks platform and create visualization dashboards with real-time Zoho Creator data.
-
Build Charts with Airtable Data in Clear Analytics
Create dynamic charts and perform analytics based on Airtable data in Clear Analytics.