CData Software - Knowledge Base
Recent Articles
-
Viewing Hive Data in RAD Studio Data Explorer
How to view Apache Hive in RAD Studio Data Explorer using the CData ODBC Driver for Hive.
-
DataBind Charts to LeadDesk Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to LeadDesk 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 iContact Data in Ruby
Connect to iContact in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
DataBind OnePageCrm Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide OnePageCrm to a chart.
-
Bridge Harvest Connectivity with Apache NiFi
Access and process Harvest in Apache NiFi using the CData JDBC Driver.
-
Create Datasets from LinkedIn in Domo Workbench and Build Visualizations of LinkedIn Data in Domo
Use the CData Software ODBC Driver for LinkedIn to create datasets from LinkedIn in Domo Workbench and then build visualizations in the Domo service.
-
How to Work with Grafana Data in AWS Glue Jobs Using JDBC
Connect to Grafana from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Import Real-Time Spark Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Apache Spark SQL in ColdFusion.
-
Query SAP Business Warehouse Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Business Warehouse and perform CRUD operations on SAP Business Warehouse from Node.js.
-
Edit and Search External SAS Data Sets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAS Data Sets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAS Data Sets Data objects that you can access from apps and the dashboard.
-
Build Apps with Live SAS Data Sets Data Using the Low-Code Development Platform of Mendix
Connect SAS Data Sets with Mendix to build apps using the CData JDBC Driver for SAS Data Sets.
-
Use the CData Software ODBC Driver for Wrike in MicroStrategy Desktop
Connect to Wrike in MicroStrategy Desktop using the CData Software ODBC Driver for Wrike.
-
Getting Started with the CData Power BI Connector for ServiceNow
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for ServiceNow.
-
Connect to Live MYOB AccountRight Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MYOB AccountRight in CData Connect AI and connect to your MYOB AccountRight from PostgreSQL.
-
Access Facebook Ads Data from MySQL in Amazon QuickSight
Connect to Facebook Ads and build visualizations of Facebook Ads using a MySQL Connection in Amazon QuickSight.
-
How to Query Sentry Data in MySQL Workbench
Execute MySQL queries against live Sentry from MySQL Workbench.
-
Connect to Greenplum Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pivotal GreenPlum using standard SQL.
-
Connect and Query Live Highrise Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Highrise CRM into Databricks
-
Connect to Sage Intacct Data from PowerBuilder via ADO.NET
This article demonstrates how to access Sage Intacct from Appeon PowerBuilder using the CData ADO.NET Provider for Sage Intacct.
-
Process & Analyze Dynamics 365 Business Central Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dynamics 365 Business Central Data.
-
How to connect to Dynamics 365 Data from Spring Boot
Connect to Dynamics 365 in a Spring Boot Application using the CData JDBC Driver for Dynamics 365
-
Create Pinterest Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pinterest data access from reports, embedded analytics, and more.
-
Getting Started with the CData Excel Add-In for ChartMogul
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ChartMogul.
-
Automated Continuous AdRoll Replication to Vertica
Use CData Sync for automated, continuous, customizable AdRoll replication to Vertica.
-
Operational Reporting on SAP HANA Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA.
-
Integrate Live MarkLogic Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Seamlessly Import HBase Data into IBM SPSS Modeler
Integrate HBase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Write a Simple Go Application to work with Zuora Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Zuora.
-
Deploy the ADO.NET Provider for Everhour on an SSRS Report Server
Connect to Everhour 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.
-
Query ClickUp Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ClickUp from Node.js.
-
Connect to Excel from a Connection Pool in WebLogic
Use the CData JDBC Driver for Excel to connect to Microsoft Excel from Web applications running on WebLogic.
-
Integrating Kiro CLI with Supabase 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.
-
Publish Box-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Box.
-
How to connect to Cassandra Data in DBVisualizer
Integrate Apache Cassandra with visual data analysis tools and data connection wizards in DBVisualizer
-
Edit and Search Splunk External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Splunk to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Splunk objects that you can access from apps and the dashboard.
-
Import Real-Time Elasticsearch Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Elasticsearch in ColdFusion.
-
Analyze DocuSign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze DocuSign with the CData JDBC Driver for DocuSign.
-
Automated Continuous Clari Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Clari replication to Amazon S3.
-
Integrating Claude Code CLI with Excel Online 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.
-
Automated Continuous Confluence Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Confluence replication to Google BigQuery.
-
Connect to Dropbox Data from AWS Glue
Use CData Connect AI to gain access to live Dropbox from your AWS Glue jobs.
-
Access Mocean Data from MySQL in Amazon QuickSight
Connect to Mocean and build visualizations of Mocean using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Lakebase Replication to SQLite
Use CData Sync for automated, continuous, customizable Lakebase replication to SQLite.
-
How to Access Live Shortcut Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Shortcut enables you to integrate Shortcut into workflows built using Microsoft Power Automate Desktop.
-
Connect to Scrapfly Data in DBeaver
Use the CData ODBC Driver to connect to Scrapfly in DBeaver.
-
Build a Singer.io Tap for MySQL With the CData Python Connector
Learn how to easily build a Singer.io Tap for live MySQL data using
-
How to Connect the Power BI Service to Google Translate: Complete Guide
Connect to the CData Software Power BI Connector for Google Translate from PowerBI.com to provide real-time Google Translate across the organization.
-
Build Charts with Intercom Data in Clear Analytics
Create dynamic charts and perform analytics based on Intercom in Clear Analytics.
-
Connect to Dynamics NAV Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Dynamics NAV from Appeon PowerBuilder using the CData ADO.NET Provider for Dynamics NAV.
-
Connect to SpaceX Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SpaceX to connect to SpaceX and execute queries in PowerBuilder.
-
Create Apps from Oracle Eloqua Data in Qlik Sense Cloud
Use CData Connect AI to connect to Oracle Eloqua Data and build apps from live Oracle Eloqua in Qlik Sense Cloud.
-
Visualize Impala Data in Tableau
The CData ODBC driver for Impala enables you integrate Apache Impala into Tableau dashboards.
-
Connecting Agentforce with Zoho Projects 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 Zoho Projects for you.
-
Connect to Exa Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Exa as an External Source in Dremio.
-
Query Oracle Eloqua Data in ColdFusion
Write standard ColdFusion data access code to connect to Oracle Eloqua.
-
Viewing SAP Fieldglass Data in RAD Studio Data Explorer
How to view SAP Fieldglass in RAD Studio Data Explorer using the CData ODBC Driver for SAP Fieldglass.
-
Integrating Gumloop with Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Active Directory within automated workflows.
-
Configure the CData JDBC Driver for Quickbase in a Connection Pool in Tomcat
Connect to Quickbase from a connection pool in Tomcat.
-
How to Query Live Hubstaff Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Hubstaff data in natural language using Python.
-
Access Coda Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Coda from HeidiSQL.
-
Mailjet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mailjet facts in real time.
-
Use the CData Software ODBC Driver for LaunchDarkly in MicroStrategy Web
Connect to LaunchDarkly in MicroStrategy Web using the CData Software ODBC Driver for LaunchDarkly.
-
Deploy the ADO.NET Provider for Databricks on an SSRS Report Server
Connect to Databricks 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.
-
Build a Simple VCL Application for eBay Data
How to build a simple VCL Application to view eBay in RAD Studio using the CData ODBC Driver for eBay.
-
How to Use a Microsoft Access Database to Update Zoho Inventory Data in Real Time
Update Zoho Inventory data by creating a linked table in Microsoft Access with the CData Zoho Inventory ODBC Driver.
-
Connect to SharePoint Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SharePoint as an External Source in Dremio.
-
How to load GitLab data into Elasticsearch via Logstash
Introducing a simple method to load GitLab data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live Salesforce 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 Salesforce & Force.com through natural language.
-
Connect to Miro Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Miro using standard SQL.
-
Integrate Cursor with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Amazon Marketplace from within the editor.
-
Visualize SAP Ariba Procurement Data in Sisense
Create an ElastiCube in Sisense app with access to SAP Ariba Procurement.
-
Create Power BI Reports on Real-Time Discourse Data
Use the CData ODBC Driver for Discourse to visualize Discourse in Power BI Desktop.
-
Connect to SuiteCRM Data in RazorSQL
Connect to SuiteCRM from wizards and query SuiteCRM from the GUI in the RazorSQL database management tool.
-
Explore Geographical Relationships in Zoho Projects Data with Power Map
Create data visualizations with Zoho Projects in Power Map.
-
How to integrate Dynamics 365 Business Central with Apache Airflow
Access and process Dynamics 365 Business Central in Apache Airflow using the CData JDBC Driver.
-
How to Query Live Sage Cloud Accounting Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sage Business Cloud Accounting data in natural language using Python.
-
Automated Continuous Rebilly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Rebilly replication to IBM DB2.
-
How to Work with Productboard Data in ETL Validator JDBC
Connect to Productboard from ETL Validator jobs using the CData Software JDBC Driver.
-
Design BIRT Reports on Mouseflow Data
Provide current Mouseflow to your embedded analytics.
-
Stream CSV Data into Apache Kafka Topics
Access and stream CSV/TSV Files in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Informatica Mappings From/To a JDBC Data Source for ADP
Create ADP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Query Templated Data in QlikView over ODBC
Create data visualizations with Templated in QlikView.
-
Manage Zoho Recruit Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Zoho Recruit.
-
Access Live Zoho Inventory Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Inventory from your Excel spreadsheets.
-
Connect to AlloyDB Data from HeidiSQL
Use CData Connect AI to connect to and query live Google AlloyDB from HeidiSQL.
-
Moving Data from Reckon Accounts Hosted to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reckon Accounts Hosted data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze ChargeOver Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ChargeOver in Microsoft R Open.
-
How to work with HelloSign Data in Apache Spark using SQL
Access and process HelloSign Data in Apache Spark using the CData Software JDBC Driver.
-
Use Claude to Talk to Your Amazon S3 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 Amazon S3 for you.
-
A PostgreSQL Interface for Everhour Data (MySQL Remoting via JDBC)
Use the Remoting features of the Everhour JDBC Driver to create a PostgreSQL entry-point for data access.
-
Easily Integrate Hive Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache Hive in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import Real-Time Google Translate Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Translate in ColdFusion.
-
How to Access ServiceDesk Plus Data Using Entity Framework
This article shows how to access ServiceDesk Plus using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live Microsoft Dataverse 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 Microsoft Dataverse (CDS) through MCP integration.
-
Working with MarkLogic Data in LINQPad
Execute LINQ queries to MarkLogic in LINQPad.
-
Integrate with ZohoMarketingHub Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoMarketingHub to a JSON file on disk.
-
How to Connect to OpenWeatherMap Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to OpenWeatherMap. Leverage the pyodbc module for ODBC in Python.
-
Automate Teradata Data Replication to SAP HANA
Use CData Sync to customize and automate Teradata replication to SAP HANA.
-
Connect CSV to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live CSV/TSV Files using the CData Python MCP Server.
-
How to import IBM Cloud Object Storage Data into Apache Solr
Use the CData Software JDBC Driver for IBM Cloud Object Storage in Data Import Handler and create an automated import of IBM Cloud Object Storage to Apache Solr Enterprise Search platform.