CData Software - Knowledge Base
Recent Articles
-
Bridge Miro Connectivity with Apache NiFi
Access and process Miro in Apache NiFi using the CData JDBC Driver.
-
Integrating Cursor CLI with Google Sheets 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.
-
Query Redshift Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Amazon Redshift from Node.js.
-
Seamlessly Bring API Data into Retool Using CData Connect AI
Integrate API data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Live SQL Analysis Services Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SQL Analysis Services into custom reports in Power BI.
-
Visualize LionDesk 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 LionDesk into TIBCO Spotfire.
-
DataBind Templated Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Templated to a chart.
-
How to update Exact Online from Excel
This article explains how to transfer data from Excel to Exact Online using the Excel Add-In for Exact Online.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle Financials Cloud
Provide connectivity to Oracle Financials Cloud through an SAP BusinessObjects universe.
-
Integrate Pushbullet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Pushbullet from Informatica Cloud.
-
Neo4J Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Neo4J through CData Connect AI using different applications and tools.
-
Use the CData Software ODBC Driver for Dropbox in MicroStrategy Web
Connect to Dropbox in MicroStrategy Web using the CData Software ODBC Driver for Dropbox.
-
Enable the Salesloft JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Salesloft.
-
Analyze Oracle Service Cloud Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Oracle Service Cloud and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to load FHIR data into Elasticsearch via Logstash
Introducing a simple method to load FHIR data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Jira Assets within intelligent workflows.
-
Getting Started with the CData JDBC Driver for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Inventory.
-
Add Dropbox Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Dropbox with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Webflow to Power BI dashboards. Simply drag and drop Webflow into data visuals on the Power BI canvas.
-
DataBind Charts to Elasticsearch Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Elasticsearch 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.
-
Connect to WordPress Data in Ruby
Connect to WordPress in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Getting Started with the CData JDBC Driver for Qualaroo
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Qualaroo.
-
Query Wistia Data in ColdFusion
Write standard ColdFusion data access code to connect to Wistia.
-
ETL Adobe Analytics in Oracle Data Integrator
This article shows how to transfer Adobe Analytics into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Chargebee in MicroStrategy
Connect to Chargebee in MicroStrategy Developer using the CData Software ODBC Driver for Chargebee.
-
Connect to Browserless Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Browserless and the SQL Gateway to access Browserless from Google Apps Script.
-
Use Biml to Build SSIS Tasks to Replicate SendGrid Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SendGrid to SQL Server.
-
Connect to ActiveCampaign Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ActiveCampaign in the Denodo Virtual DataPort Administrator.
-
How to Create Power BI Visual Reports with Real-Time Aha! Data
Use CData Power BI Connectors to visualize Aha! in Power BI.
-
Connect to Scrapfly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Scrapfly from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Object-Relational Mapping (ORM) with Act-On Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Act-On into a Java-based ORM framework, Hibernate.
-
Create Dynamic EmailOctopus Grids Using the Infragistics XamDataGrid
Learn how you can connect EmailOctopus to Infragistics XamDataGrid to build dynamic grids.
-
Build Automated Workflows with Live Apollo Data in Workato
Use CData Connect AI to connect to live Apollo and build automated workflows in Workato.
-
Migrating data from SFTP to Snowflake using CData SSIS Components.
Easily push SFTP to Snowflake using the CData SSIS Tasks for SFTP and Snowflake.
-
Create SSAS Tabular Models from SQL Analysis Services Data
How to build a SQL Server Analysis Service Tabular Model from SQL Analysis Services using CData drivers.
-
Use Databricks Agent Bricks to Talk to Your Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Dynamics 365 Business Central for you.
-
DataBind Controls to JSON Services in C++Builder
DataBind to JSON in C++Builder with standard components and controls.
-
Automated Continuous Testmonitor Replication to Snowflake
Use CData Sync for automated, continuous, customizable Testmonitor replication to Snowflake.
-
How to Connect to Live Azure Table 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 Azure Table Storage for you.
-
Dynamics NAV Reporting in OBIEE with the Dynamics NAV JDBC Driver
Deploy the Dynamics NAV JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate LibreChat with Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Azure Data Lake Storage from within the chat interface.
-
How to connect to Jumpseller Data with Squirrel SQL client
Connect to Jumpseller and execute queries in the Squirrel SQL Client.
-
Build FTP-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for FTP to explore live FTP Data in Gemini Code Assist to assist with building FTP-powered applications.
-
Build MVC Applications with Connectivity to Browserless Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Browserless from an ASP.NET MVC application.
-
How to Query Live Coinbase Data in Claude Desktop
Connect to and query live Coinbase Data in Claude Desktop using CData MCP Server.
-
Connect to Presto Data in RazorSQL
Connect to Presto from wizards and query Presto from the GUI in the RazorSQL database management tool.
-
Build Semantic Layer Views for MailChimp Data in APOS Live Data Gateway
Use the CData Connector for MailChimp in APOS Live Data Gateway to build Semantic Layer Views for MailChimp.
-
Access Live NASA Data in AWS Lambda
Connect to live NASA in AWS Lambda using the CData JDBC Driver.
-
Use the CData ODBC Driver for ServiceNow in Microsoft Power Query
You can use the CData ServiceNow ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceNow into Microsoft Power Query.
-
Enable the Vercel JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Vercel.
-
Connect to Zoho Inventory Data in Jaspersoft Studio
Execute SQL to remote Zoho Inventory in Jaspersoft Studio.
-
Connecting Pipedream with YouTube Analytics 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 YouTube Analytics data in real time.
-
Connect to Oracle SCM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle SCM.
-
Process & Analyze PabblySubscriptions Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live PabblySubscriptions Data.
-
Use the CData Software JDBC Driver for Cosmos DB in MicroStrategy Web
Connect to Azure Cosmos DB in MicroStrategy Web using the CData Software JDBC Driver for Cosmos DB.
-
Getting Started with the CData Power BI Connector for Parquet
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Parquet.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zendesk
Provide connectivity to Zendesk through an SAP BusinessObjects universe.
-
Integrate with Power BI XMLA Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Power BI XMLA in SnapLogic.
-
Consume Discord OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Discord feeds that reflect any changes in SAP Lumira.
-
Replicate Multiple Vertica Accounts
Replicate multiple Vertica accounts to one or many databases.
-
How to Connect the Power BI Service to Outlook: Complete Guide
Connect to the CData Software Power BI Connector for Outlook from PowerBI.com to provide real-time Outlook across the organization.
-
Integrate Live Tickspot Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tickspot to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Email Data from PowerBuilder via ADO.NET
This article demonstrates how to access Email from Appeon PowerBuilder using the CData ADO.NET Provider for Email.
-
How to connect to FreeAgent Data from IntelliJ
Integrate connectivity to FreeAgent with wizards in IntelliJ.
-
How to Query Live Klipfolio Data in Claude Desktop
Connect to and query live Klipfolio Data in Claude Desktop using CData MCP Server.
-
Integrate Simplesat Data in the Pentaho Report Designer
Publish reports based on Simplesat in the Pentaho BI tool.
-
Connect to Oracle SCM Data in DBeaver
Use the CData ODBC Driver to connect to Oracle SCM in DBeaver.
-
Connect to Spotify Data in JRuby
Create a simple JRuby app with access to live Spotify.
-
Automated Continuous Figshare Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Figshare replication to Azure SQL Database.
-
Connect and Query Live Freshservice Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Freshservice into Databricks
-
Use the CData Software JDBC Driver for Aweber in MicroStrategy
Connect to Aweber in MicroStrategy Developer using the CData Software JDBC Driver for Aweber.
-
Prepare, Blend, and Analyze Outlook Data in Alteryx Designer (ODBC)
Build workflows to access live Outlook for self-service data analytics.
-
LINQ to Toggl 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 Toggl Data Provider.
-
Moving Data from RSS to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live RSS data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Live SAP HANA Data in SAS Viya
Use CData Connect AI to connect to SAP HANA from SAS Viya and deploy self-service analytics using live SAP HANA.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Quickbase within intelligent workflows.
-
Use Biml to Build SSIS Tasks to Replicate Freshsales Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshsales to SQL Server.
-
How to Easily Query Couchbase Data in OpenOffice Base
Connect to Couchbase data in OpenOffice Base using the CData ODBC Driver for Couchbase and generate reports with live data insights.
-
Automated Continuous Elorus Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Elorus replication to IBM DB2.
-
Build Charts with Cloudant Data in Clear Analytics
Create dynamic charts and perform analytics based on IBM Cloudant in Clear Analytics.
-
How to create Aircall federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Aircall in MySQL .
-
Publish Cvent-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cvent.
-
Automated Continuous Exa Replication to SQLite
Use CData Sync for automated, continuous, customizable Exa replication to SQLite.
-
Connect to Square Data in DBeaver
Use the CData ODBC Driver to connect to Square in DBeaver.
-
Automate Tasks in Power Automate Using the CData API Server
Automate EnterpriseDB actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Getting Started with the CData SSIS Components for Campaigner
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Campaigner.
-
How to Connect to Live CouchDB Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Apache CouchDB without replication.
-
Query JotForm Data as a MySQL Database in Node.js
Execute MySQL queries against JotForm from Node.js.
-
Migrating data from Mocean to Databricks using CData SSIS Components.
Easily push Mocean to Databricks using the CData SSIS Tasks for Mocean and Databricks.
-
Use the CData API Server to Access Zoho Creator Data in Microsoft PowerPivot
Use the CData API Server to connect to live Zoho Creator in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Google Tasks in MicroStrategy Web
Connect to Google Tasks in MicroStrategy Web using the CData Software ODBC Driver for Google Tasks.
-
DataBind Controls to TigerGraph Data in Delphi
DataBind to TigerGraph in Delphi with standard data access components and controls.
-
Automated Continuous Google Spanner Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Spanner replication to Apache Cassandra.
-
Explore Geographical Relationships in Parquet Data with Power Map
Create data visualizations with Apache Parquet in Power Map.
-
Natively Connect to Printify Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Printify. Leverage the native support for ODBC in PHP.
-
How to Connect Flowise AI Agents to Live Smartsheet 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 Smartsheet without replication.
-
Establish a Live Connection with OData Services using Tableau Bridge
The CData ODBC Driver for OData enables you to integrate live OData into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Live Supabase Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Supabase from the Cline extension in Visual Studio Code.
-
How to connect SharePoint with VWO Data through external lists
Provide VWO to SharePoint users as an external list.
-
Replicate Keap Data from PowerShell
Write a quick PowerShell script to query Keap. Use connectivity to the live data to replicate Keap to SQL Server.