CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Ariba Procurement Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Ariba Procurement from your Google Sheets.
-
Automated Continuous Impala Replication to MySQL
Use CData Sync for automated, continuous, customizable Impala replication to MySQL.
-
Integrate with Live ShipStation Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ShipStation from the MuleSoft Anypoint Platform to integrate live ShipStation into custom reports and dashboards.
-
Publish Bullhorn CRM-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Bullhorn CRM.
-
Access Live SAP Netweaver Gateway Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SAP Netweaver Gateway from your Excel spreadsheets.
-
How to Query Live Splunk Data in Perplexity MacOS Desktop
Connect to and query live Splunk Data in Perplexity Desktop using CData MCP Server.
-
Operational Reporting on LaunchDarkly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote LaunchDarkly.
-
Automated Continuous Azure DevOps Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure DevOps replication to Oracle.
-
Visualize Live Square Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Square using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to ElevenLabs 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 ElevenLabs Data Provider.
-
Create Reports with SAS Data Sets Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAS Data Sets.
-
Connect to Float Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Float and the SQL Gateway to access Float from Google Apps Script.
-
Replicate Multiple Drip Accounts via the CData Sync CLI
Replicate multiple Drip accounts to one or many databases.
-
How to Query Live IBM Cloud Object Storage Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live IBM Cloud Object Storage data in natural language using Python.
-
DataBind Kafka Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Apache Kafka with the DevExpress Windows Forms and Web controls to provide Apache Kafka to a chart.
-
How to connect to Planio Data in DBVisualizer
Integrate Planio with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Odoo Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Odoo Data and connect to Odoo ERP in Akorbi Digital RunMyProcess.
-
Integrate Discord with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Discord with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Discord.
-
Publish Reports with Teradata Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teradata.
-
Integrating Claude Code with OneNote Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Microsoft OneNote within assisted coding and automated development workflows.
-
Connect to Hive Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Hive and the SQL Gateway to access Apache Hive from Google Apps Script.
-
Create a Data Access Object for Customer.io Data using JDBI
A brief overview of creating a SQL Object API for Customer.io in JDBI.
-
Import and Visualize Bitbucket Data in Power View
Create data visualizations based on Bitbucket in Excel.
-
ETL OneNote in Oracle Data Integrator
This article shows how to transfer Microsoft OneNote into a data warehouse using Oracle Data Integrator.
-
Access Insightly Data from MySQL in Amazon QuickSight
Connect to Insightly and build visualizations of Insightly using a MySQL Connection in Amazon QuickSight.
-
Configure the CData JDBC Driver for Webex in a Connection Pool in Tomcat
Connect to Webex from a connection pool in Tomcat.
-
DataBind Controls to ZohoSubscriptions Data in Delphi
DataBind to ZohoSubscriptions in Delphi with standard data access components and controls.
-
Analyze Webflow Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Webflow and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Jira Assets Data in Aqua Data Studio
Access Jira Assets from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Excel Data in HULFT Integrate
Connect to Excel as a JDBC data source in HULFT Integrate
-
Prepare, Blend, and Analyze AgileCRM Data in Alteryx Designer (ODBC)
Build workflows to access live AgileCRM for self-service data analytics.
-
How to Connect to Live Zoho Inventory 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 Zoho Inventory for you.
-
Extract, Transform, and Load Attio Data in Informatica PowerCenter
Create a simple Workflow for Attio in Informatica PowerCenter.
-
Query Bright Data Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Bright Data from Node.js.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Blackbaud FE NXT within intelligent workflows.
-
How to connect SharePoint with Google Contacts Data through external lists
Provide Google Contacts to SharePoint users as an external list.
-
Excel Spreadsheet Automation on Redis Data with the QUERY Formula
Pull data from Redis, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Tableau Connector for ConstantContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for SendGrid in SAS for Real-Time Reporting and Analytics
Connect to real-time SendGrid in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SendGrid.
-
Access Live HCL Domino Data in Excel 365 Online (Excel for the web)
Connect to HCL Domino from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Feed LDAP Objects into FineReport
How to set LDAP as a JDBC data source in FineReport.
-
How to Access Browserless Data Using Entity Framework
This article shows how to access Browserless using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Microsoft Planner-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Microsoft Planner to explore live Microsoft Planner Data in Cursor to assist with building Microsoft Planner-powered applications.
-
Connect to Printify Data in DBeaver
Use the CData ODBC Driver to connect to Printify in DBeaver.
-
Configure the CData JDBC Driver for MySQL in a Connection Pool in Tomcat
Connect to MySQL from a connection pool in Tomcat.
-
Integrate Live Neo4J Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Neo4J to Blue Prism using the CData ODBC Driver for Neo4J to create automated workflows for repetitive business tasks.
-
Access Live AfterShip Data in AWS Lambda
Connect to live AfterShip in AWS Lambda using the CData JDBC Driver.
-
Access Live Shopify Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Shopify from your Excel spreadsheets.
-
Working with Supabase Data in LINQPad
Execute LINQ queries to Supabase in LINQPad.
-
Build Agents in Relevance AI with Access to Live YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on YouTube Analytics within intelligent agent workflows.
-
Use the CData API Server to Access Trello Data in Microsoft PowerPivot
Use the CData API Server to connect to live Trello in the Power Pivot business intelligence tool.
-
How to Work with Aweber Data in AWS Glue Jobs Using JDBC
Connect to Aweber from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Working with Microsoft OneDrive Data in LINQPad
Execute LINQ queries to Microsoft OneDrive in LINQPad.
-
Enable the Jira Assets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Jira Assets.
-
Consume SharePoint OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SharePoint feeds that reflect any changes in SAP Lumira.
-
Manage Access Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Access.
-
Connect to Freshservice Data in Ruby
Connect to Freshservice in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Amplitude
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amplitude.
-
Replicate Multiple Email Accounts
Replicate multiple Email accounts to one or many databases.
-
Connect to Dynamics 365 Data in JRuby
Create a simple JRuby app with access to live Microsoft Dynamics 365.
-
How to Connect to Live Sugar CRM 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 Sugar CRM for you.
-
Connect to Live Certinia Data in MicroStrategy through CData Connect AI
Create a live connection to Certinia Data in CData Connect AI and connect to your Certinia from MicroStrategy.
-
Connect to Nethunt Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Nethunt.
-
Add SAP Concur Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for SAP Concur with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Power BI Reports on Real-Time Google Tasks Data
Use the CData ODBC Driver for Google Tasks to visualize Google Tasks in Power BI Desktop.
-
Automated Continuous Excel Replication to MySQL
Use CData Sync for automated, continuous, customizable Excel replication to MySQL.
-
Connect to Azure Table Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Azure Table as an External Source in Dremio.
-
Access Pinecone Data from MySQL in Amazon QuickSight
Connect to Pinecone and build visualizations of Pinecone using a MySQL Connection in Amazon QuickSight.
-
Connecting Agentforce with Oracle Financials Cloud 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 Oracle Financials Cloud for you.
-
Automated Continuous ZarMoney Replication to SQLite
Use CData Sync for automated, continuous, customizable ZarMoney replication to SQLite.
-
Integrate Cursor with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Greenhouse from within the editor.
-
Automate Datadog Data Replication to SAP HANA
Use CData Sync to customize and automate Datadog replication to SAP HANA.
-
Publish Crystal Reports on Nethunt Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Nethunt.
-
Automated Continuous Elorus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Elorus replication to AlloyDB.
-
Replicate Multiple Certinia Accounts via the CData Sync CLI
Replicate multiple Certinia accounts to one or many databases.
-
Work with ConvertKit Data in FoxPro
Load ConvertKit into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to ChartMogul Data from PowerBuilder via JDBC
This article demonstrates how to access ChartMogul from PowerBuilder using the ChartMogul JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Microsoft OneDrive
Create Microsoft OneDrive data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Add Amazon Athena Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon Athena with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Cline with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live JSON from within your IDE.
-
Connect HCL Domino to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live HCL Domino using the CData Python MCP Server.
-
Lakebase Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Lakebase facts in real time.
-
A PostgreSQL Interface for Workday Data (MySQL Remoting via JDBC)
Use the Remoting features of the Workday JDBC Driver to create a PostgreSQL entry-point for data access.
-
Add Dynamics NAV Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dynamics NAV with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Claude to Talk to Your Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Freshdesk for you.
-
Create Dashboards and Visualize Live Zoho Creator Data in Geckoboard
Use CData Connect AI to connect to live Zoho Creator and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Paddle
Provide connectivity to Paddle through an SAP BusinessObjects universe.
-
Edit and Search External Epicor Kinetic Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Epicor Kinetic to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Epicor Kinetic Data objects that you can access from apps and the dashboard.
-
Build Redshift-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Amazon Redshift to explore live Redshift Data in Gemini Code Assist to assist with building Redshift-powered applications.
-
How to Connect eBay 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 eBay data in real time using natural language.
-
Connect to HCL Domino from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from HCL Domino, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connecting Mastra with SAP SuccessFactors LMS 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 SAP SuccessFactors LMS, no replication required.
-
Integrate Live Databricks Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Databricks and integrate live Databricks into apps built in Microsoft Power Apps.
-
Integrate HCL Domino Data in Pentaho Data Integration
Build ETL pipelines based on HCL Domino in the Pentaho Data Integration tool.
-
Analyze BenchmarkEmail Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of BenchmarkEmail and visualize live BenchmarkEmail in Infragistics Reveal.
-
Analyze Salesloft Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesloft from Power Pivot. You will use the Table Import Wizard to load Salesloft. You can visually build the import query or use any SQL supported by the driver.
-
Access Bitbucket 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 Bitbucket.
-
Automated Continuous Zoho Inventory Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to Google BigQuery.
-
Integrate with Harvest Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Harvest to a JSON file on disk.
-
DataBind Charts to Yelp Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Yelp 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.