CData Software - Knowledge Base
Recent Articles
-
Viewing Oracle HCM Cloud Data in RAD Studio Data Explorer
How to view Oracle HCM Cloud in RAD Studio Data Explorer using the CData ODBC Driver for Oracle HCM Cloud.
-
Use the CData ODBC Driver for Couchbase from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Couchbase to connect to Couchbase from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Couchbase in Excel.
-
Connect to Live MariaDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MariaDB in CData Connect AI and connect to your MariaDB from PostgreSQL.
-
How to Create Power BI Visual Reports with Real-Time Cvent Data
Use CData Power BI Connectors to visualize Cvent in Power BI.
-
Create Datasets from FreshBooks in Domo Workbench and Build Visualizations of FreshBooks Data in Domo
Use the CData Software ODBC Driver for FreshBooks to create datasets from FreshBooks in Domo Workbench and then build visualizations in the Domo service.
-
Create a Data Access Object for Google Drive Data using JDBI
A brief overview of creating a SQL Object API for Google Drive in JDBI.
-
Access Live API Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live API from your Google Sheets.
-
Connect to Discourse in SpagoBI
Create reports featuring live Discourse in SpagoBI Studio. Host Discourse reports on SpagoBI Server.
-
Integrating Antigravity CLI with SAP Fieldglass via CData CLI
Connect SAP Fieldglass to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Vertica-Connected Business Apps in AppSheet
Connect to Vertica Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Vertica.
-
Access Live Placid Data in AWS Lambda
Connect to live Placid in AWS Lambda using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Tasks
Create an ODBC connection to Google Tasks in Informatica and browse and transfer Google Tasks.
-
Connecting Mastra with Facebook Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Facebook Ads, no replication required.
-
Connect and Visualize Live SAP Fieldglass Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Fieldglass into the Databricks platform and create visualization dashboards with real-time SAP Fieldglass.
-
Connect to and Visualize Live LDAP Objects in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LDAP.
-
How to Build an ETL App for eBay Data in Python with CData
Create ETL applications and real-time data pipelines for eBay in Python with petl.
-
Connect to Gumroad from Asprova with CData Software ODBC Driver for Gumroad
This article shows how to connect faster to Gumroad data from Asprova.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live FTP Servers using the Model Context Protocol.
-
How to Connect the Power BI Service to CSV: Complete Guide
Connect to the CData Software Power BI Connector for CSV from PowerBI.com to provide real-time CSV/TSV Files across the organization.
-
Build SendGrid-Connected Apps in Choreo
Use CData Connect AI to connect to SendGrid Data from Choreo and build custom apps using live SendGrid.
-
Create Reports with Wrike Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Wrike.
-
Build Dashboards with Attio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Attio in Dundas BI.
-
Automated Continuous Google Calendar Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Calendar replication to Azure SQL Database.
-
How to Query Live SAP Netweaver Gateway Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Netweaver Gateway data in natural language using Python.
-
Import and Visualize Retently Data in Power View
Create data visualizations based on Retently in Excel.
-
Getting Started with the CData SSIS Components for Freshteam
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Freshteam.
-
Integrating Kiro CLI with Google Contacts 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.
-
Build MVC Applications with Connectivity to Google Sheets Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Sheets from an ASP.NET MVC application.
-
How to Access Live Monday.com Data in Visual Studio Code via Cline
Run CData MCP Server for Monday.com on Windows Subsytem for Linux (WSL) and connect to live Monday.com from the Cline extension in Visual Studio Code.
-
Automate MariaDB Data Replication to Azure Synapse
Use CData Sync to customize and automate MariaDB replication to Azure Synapse.
-
Connect to Omnisend from Asprova with CData Software ODBC Driver for Omnisend
This article shows how to connect faster to Omnisend data from Asprova.
-
How to Connect to Live eBay Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your eBay through natural language.
-
Build Amazon Marketplace-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Amazon Marketplace Data from Zoho Analytics and import live Amazon Marketplace.
-
How to Query Live Mistral AI Data in Claude Desktop
Connect to and query live Mistral AI Data in Claude Desktop using CData MCP Server.
-
Use Manus AI to Talk to Your IBM Informix 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 IBM Informix.
-
Consume PDFMonkey OData Feeds in SAP Lumira
Use the API Server to create data visualizations on PDFMonkey feeds that reflect any changes in SAP Lumira.
-
Build AI/ML Models with Live Cassandra Data using Dataiku
Connect Cassandra Data with Dataiku using the CData JDBC Driver for Apache Cassandra.
-
Validate Google Tasks Data with QuerySurge
Access and validate Google Tasks in QuerySurge using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Raisers Edge NXT in MicroStrategy
Connect to Raisers Edge NXT in MicroStrategy Developer using the CData Software ODBC Driver for Raisers Edge NXT.
-
How to connect and process Perigon from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Perigon.
-
Connect to Real-Time HubDB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for HubDB and Dataflow to import and use HubDB in Power Apps.
-
Use the CData Software ODBC Driver for Cohere in SAS for Real-Time Reporting and Analytics
Connect to real-time Cohere in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Cohere.
-
Automated Continuous Avaza Replication to MongoDB
Use CData Sync for automated, continuous, customizable Avaza replication to MongoDB.
-
Build Apps with Live EmailOctopus Data Using the Low-Code Development Platform of Mendix
Connect EmailOctopus with Mendix to build apps using the CData API Driver for JDBC.
-
Build AI/ML Models with Live Webflow Data using Dataiku
Connect Webflow Data with Dataiku using the CData API Driver for JDBC.
-
LINQ to Cassandra 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 Cassandra Data Provider.
-
Connect Facebook to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Facebook with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Moosend Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Moosend from Power Pivot. You will use the Table Import Wizard to load Moosend. You can visually build the import query or use any SQL supported by the driver.
-
Automate Microsoft Dataverse Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Dataverse (CDS) replication to Couchbase.
-
How to connect SharePoint with SAP Netweaver Gateway Data through external lists
Provide SAP Netweaver Gateway to SharePoint users as an external list.
-
Build MVC Applications with Connectivity to ChartMogul Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ChartMogul from an ASP.NET MVC application.
-
Getting Started with the CData ODBC Driver for eBay
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for eBay.
-
LINQ to Webflow 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 Webflow Data Provider.
-
Feed Paylocity Data into FineReport
How to set Paylocity as a JDBC data source in FineReport.
-
Configure the CData JDBC Driver for Google Directory in a Connection Pool in Tomcat
Connect to Google Directory from a connection pool in Tomcat.
-
How to connect to Reckon Accounts Hosted Data from IntelliJ
Integrate connectivity to Reckon Accounts Hosted with wizards in IntelliJ.
-
Integrating Antigravity CLI with OpenWeatherMap via CData CLI
Connect OpenWeatherMap to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate WordPress Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live WordPress and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Query Live Mode Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Mode data in natural language using Python.
-
How to update JSON from Excel
This article explains how to transfer data from Excel to JSON using the Excel Add-In for JSON.
-
Load Salesforce CRM Analytics Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Salesforce CRM Analytics to a database.
-
Connect to and Visualize Live Pushbullet Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Pushbullet.
-
Extract, Transform, and Load Auth0 Data in Informatica PowerCenter
Create a simple Workflow for Auth0 in Informatica PowerCenter.
-
Access Recurly 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 Recurly.
-
Access Live Pipeline CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Pipeline CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Pipeline CRM in the Graph Builder and Query Builder.
-
How to connect to REST Data from Spring Boot
Connect to REST in a Spring Boot Application using the CData JDBC Driver for REST
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager for you.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Web
Connect to Harvest in MicroStrategy Web using the CData Software ODBC Driver for Harvest.
-
Easily Integrate Keap Data in Lazarus Pascal IDE
Learn how to easily integrate live Keap in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Oracle Eloqua Data in Coginiti Pro
Connect to and query live Oracle Eloqua from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous ZohoExpense Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Google BigQuery.
-
Deploy the ADO.NET Provider for Pipeliner CRM on an SSRS Report Server
Connect to Pipeliner CRM 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.
-
Visualize Live PostgreSQL Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live PostgreSQL.
-
Create Power BI Reports on Real-Time CouchDB Data
Use the CData ODBC Driver for CouchDB to visualize Apache CouchDB in Power BI Desktop.
-
Write a Simple Go Application to work with Jumpseller Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jumpseller.
-
Create Data Visualizations Based On Square Data in Mode
Use CData Connect AI to connect to Square Data from Mode and build visualizations using live
-
Getting Started with the CData SSIS Components for Monday.com
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Monday.com.
-
Rapidly Develop Oracle Financials Cloud-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 Oracle Financials Cloud.
-
How to Query Live Pipeline CRM Data in Claude Desktop
Connect to and query live Pipeline CRM Data in Claude Desktop using CData MCP Server.
-
Integrating LangChain with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sugar CRM within automated workflows.
-
Connect to Sendwithus Data from a Connection Pool in Jetty
The Sendwithus JDBC Driver supports connection pooling: This article shows how to connect faster to Sendwithus from Web apps in Jetty.
-
Prepare, Blend, and Analyze Vimeo Data in Alteryx Designer (ODBC)
Build workflows to access live Vimeo for self-service data analytics.
-
Build Automated Authorize.Net-Connected Workflows in Zapier
Use CData Connect AI to connect to live Authorize.Net and build automated workflows in Zapier.
-
Connect to and Query ZendeskSell Data in QlikView over ODBC
Create data visualizations with ZendeskSell in QlikView.
-
Use the CData Software JDBC Driver for Figshare in MicroStrategy Web
Connect to Figshare in MicroStrategy Web using the CData Software JDBC Driver for Figshare.
-
Connect to QuickBooks Data in Aqua Data Studio
Access QuickBooks Desktop from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Oracle Service Cloud Data in Jaspersoft Studio
Execute SQL to remote Oracle Service Cloud in Jaspersoft Studio.
-
Create Data Visualizations in Cognos BI with Databricks Data
Access Databricks as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Access Replication to Oracle
Use CData Sync for automated, continuous, customizable Access replication to Oracle.
-
Use the CData Software JDBC Driver for Google Calendar in MicroStrategy Desktop
Connect to Google Calendar in MicroStrategy Desktop using the CData Software JDBC Driver for Google Calendar.
-
Integrate Azure Table with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Azure Table with External Services.
-
How to Create Power BI Visual Reports with Real-Time FreshBooks Data
Use CData Power BI Connectors to visualize FreshBooks in Power BI.
-
Connect to ZohoMarketingHub Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoMarketingHub to connect to ZohoMarketingHub and execute queries in PowerBuilder.
-
Connect to Gorgias Data in CloverDX (formerly CloverETL)
Transfer Gorgias using the visual workflow in the CloverDX data integration tool.
-
Integrating Oracle Data in Talend Cloud Data Management Platform
Connect Oracle Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Oracle.
-
Migrating data from BambooHR to Databricks using CData SSIS Components.
Easily push BambooHR to Databricks using the CData SSIS Tasks for BambooHR and Databricks.
-
Access Live ActiveCampaign Data in TIBCO Data Virtualization
Use the ActiveCampaign Tibco DV Adapter to create a ActiveCampaign data source in TIBCO Data Virtualization Studio and gain access to live ActiveCampaign from your TDV Server.
-
Query Rootly Data in DataGrip
Create a Data Source for Rootly in DataGrip and use SQL to query live Rootly.
-
A PostgreSQL Interface for RabbitMQ Data using the CData ODBC Driver
Use the SQL Gateway and RabbitMQ ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Couchbase Data in HULFT Integrate
Connect to Couchbase as a JDBC data source in HULFT Integrate