CData Software - Knowledge Base
Recent Articles
-
Connect to Retently Data in NetBeans
Connect to Retently data in NetBeans with the data source configuration wizard.
-
Back Up Neo4J data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Neo4J. In this article, we will employ an SSIS workflow to populate a database with Neo4J data data.
-
Connect to NASA Data from PowerBuilder via JDBC
This article demonstrates how to access NASA data from PowerBuilder using the NASA JDBC Driver.
-
How to Query Live Reckon Accounts Hosted Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Reckon Accounts Hosted data data in natural language using Python.
-
Connect to ZohoPeople Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ZohoPeople as an External Source in Dremio.
-
Connect and Visualize Live Anaplan Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Anaplan data into the Databricks platform and create visualization dashboards with real-time Anaplan data.
-
Integrating Claude Code with Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Zendesk data within assisted coding and automated development workflows.
-
Connect to Klaviyo Data in NetBeans
Connect to Klaviyo data in NetBeans with the data source configuration wizard.
-
Consume Xero OData Feeds in PowerBuilder
This article demonstrates how to consume Xero data as OData feeds from PowerBuilder using the API Server.
-
How to Connect to Live SingleStore Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SingleStore data for you.
-
Prepare, Blend, and Analyze Webflow Data in Alteryx Designer (ODBC)
Build workflows to access live Webflow data for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Neo4J
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Neo4J.
-
Connect to Gumroad Data in Ruby
Connect to Gumroad data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Natively Connect to Facebook Data in PHP
The CData ODBC driver for Facebook enables you to create PHP applications with connectivity to Facebook data. Leverage the native support for ODBC in PHP.
-
Build Visualizations of Clockify Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clockify data in Birst.
-
How to connect SharePoint with XML Data through external lists
Provide XML data to SharePoint users as an external list.
-
Connect to Zoho Books Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Books data from your AWS Glue jobs.
-
DataBind Controls to FormSite Data in C++Builder
DataBind to FormSite data in C++Builder with standard components and controls.
-
Prepare, Blend, and Analyze Todoist Data in Alteryx Designer (ODBC)
Build workflows to access live Todoist data for self-service data analytics.
-
Analyze Coda Data in Cognos Analytics
Use CData Connect AI to connect to Coda Data from Cognos Analytics and analyze live Coda data.
-
Feed Spotify Data into FineReport
How to set Spotify data as a JDBC data source in FineReport.
-
Build Data Flows from ChargeOver to SQL Server using SSIS
Easily back up ChargeOver data to SQL Server using the SSIS components for ChargeOver.
-
How to load SAP Netweaver Gateway data into Elasticsearch via Logstash
Introducing a simple method to load SAP Netweaver Gateway data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Seamlessly Import HubSpot Data into IBM SPSS Modeler
Integrate HubSpot data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use Claude to Talk to Your SAP Concur 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 SAP Concur data for you.
-
Access Azure Analysis Services Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Azure Analysis Services data from HeidiSQL.
-
Connect to ShipStation Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipStation as an External Source in Dremio.
-
Automated Continuous Humanity Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Humanity replication to Apache Kafka.
-
Build Apps with Live Toggl Data Using the Low-Code Development Platform of Mendix
Connect Toggl data with Mendix to build apps using the CData API Driver for JDBC.
-
Build Data Flows from Zoho Recruit to SQL Server using SSIS
Easily back up Zoho Recruit data to SQL Server using the SSIS components for Zoho Recruit.
-
Create Reports with Helpscout Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Helpscout data.
-
How to Easily Query Gumroad Data in OpenOffice Base
Connect to Gumroad data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access Live Dynamics CRM Data in AWS Lambda
Connect to live Dynamics CRM data in AWS Lambda using the CData JDBC Driver.
-
How to Connect to & Open Basecamp Data in Microsoft Excel
This article uses the CData ODBC driver for Basecamp to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Manage NASA Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for NASA.
-
Visualize Missive 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 Missive data into TIBCO Spotfire.
-
Explore Geographical Relationships in Marketo Data with Power Map
Create data visualizations with Marketo data in Power Map.
-
How to Work with Azure Table Data in ETL Validator JDBC
Connect to Azure Table from ETL Validator jobs using the CData Software JDBC Driver.
-
Import and Visualize HelloSign Data in Power View
Create data visualizations based on HelloSign data in Excel.
-
Create SSAS Tabular Models from Amplitude Data
How to build a SQL Server Analysis Service Tabular Model from Amplitude data using CData drivers.
-
Connect to Foursquare Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Foursquare data.
-
Connect to and Visualize Live MySQL Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MySQL data.
-
How to Query Live Access Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Access data data in natural language using Python.
-
Build Apps with Live Certinia data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Certinia data into the Adalo platform and build custom mobile and web applications with real-time Certinia data.
-
Integrate with Klaviyo Data in JReport Designer
Create charts and reports based on Klaviyo data in JReport Designer.
-
Integrate Cline with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live BenchmarkEmail data from within your IDE.
-
Connect to Factorial Data in RapidMiner
Integrate Factorial data with standard components and data source configuration wizards in RapidMiner Studio.
-
Access Webflow Data from MySQL in Amazon QuickSight
Connect to Webflow and build visualizations of Webflow data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous ActiveCampaign Replication to SQLite
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to SQLite.
-
Integrate Trae with Live Reckon Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Reckon data from within the AI-powered IDE.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data for you.
-
Integrate Open WebUI with Live OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live OneNote data from within the chat interface.
-
Build Apps with Live Retently Data Using the Low-Code Development Platform of Mendix
Connect Retently data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Placid Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Placid replication to Apache Cassandra.
-
Connect to Close Data in CloverDX (formerly CloverETL)
Transfer Close data using the visual workflow in the CloverDX data integration tool.
-
Enable the DocuSign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with DocuSign data.
-
Access Zoho Books 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 Zoho Books data.
-
How to connect Amazon QuickSight to Samanage Data
Create a connection to Samanage data in CData Connect AI and insert Samanage data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Oracle in SpagoBI
Create reports featuring live Oracle data in SpagoBI Studio. Host Oracle reports on SpagoBI Server.
-
Integrate Devin with Live Presto Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Presto data.
-
How to Visualize Google Search Results in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google Search results in Python.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Acumatica
Provide connectivity to Acumatica data through an SAP BusinessObjects universe.
-
Connect DocuSign to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live DocuSign data using the CData Python MCP Server.
-
Provide OData Services of Google Search Results from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Search results by developing a WCF Service Application.
-
How to import Datadog Data into Apache Solr
Use the CData Software JDBC Driver for Datadog in Data Import Handler and create an automated import of Datadog data to Apache Solr Enterprise Search platform.
-
Use Azure AI Foundry to Talk to Your CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your CSV data for you.
-
Access Live Oracle Financials Cloud Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle Financials Cloud data into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle Financials Cloud data in the Graph Builder and Query Builder.
-
Getting Started with the CData Connect AI Python SDK for Redshift
Install the CData Connect AI Python SDK to read and write live Redshift data with standard DB-API 2.0 Python code.
-
Use Agno to Talk to Your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Moosend data for you.
-
Create Informatica Mappings From/To an ODBC Data Source for Databricks
Create an ODBC connection to Databricks in Informatica and browse and transfer Databricks data.
-
Moving Data from OneNote to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live OneNote data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Create Power BI Visual Reports with Real-Time Oracle Service Cloud Data
Use CData Power BI Connectors to visualize Oracle Service Cloud data in Power BI.
-
Use the CData Software ODBC Driver for TigerGraph in MicroStrategy Desktop
Connect to TigerGraph data in MicroStrategy Desktop using the CData Software ODBC Driver for TigerGraph.
-
Automated Continuous Zendesk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zendesk replication to Amazon Redshift.
-
Getting Started with the CData Power BI Connector for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Sage Cloud Accounting.
-
Use the CData ODBC Driver for Google Drive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Drive to connect to Google Drive data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Drive data in Excel.
-
Viewing Microsoft Exchange Data in RAD Studio Data Explorer
How to view Microsoft Exchange data in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft Exchange.
-
Migrating data from Databricks to Google BigQuery using CData SSIS Components.
Easily push Databricks data to Google BigQuery using the CData SSIS Tasks for Databricks and Google BigQuery.
-
Connecting GenSpark with Azure Synapse Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure Synapse data without any replication or custom integration required.
-
Connect to and Query Dynamics 365 Data in QlikView over ODBC
Create data visualizations with Dynamics 365 data in QlikView.
-
Connect to ServiceNow Data in JRuby
Create a simple JRuby app with access to live ServiceNow data.
-
Build Dashboards with Deel Data in Dundas BI
Create dynamic dashboards and perform analytics based on Deel data in Dundas BI.
-
Prepare, Blend, and Analyze Pinterest Data in Alteryx Designer (Connect AI)
Build workflows to access live Pinterest data for self-service data analytics.
-
Access Live Sage 200 Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Sage 200 data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange data for you.
-
Use the CData Software ODBC Driver for WooCommerce in MicroStrategy
Connect to WooCommerce data in MicroStrategy Developer using the CData Software ODBC Driver for WooCommerce.
-
Publish Google Search-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Google Search results.
-
Replicate Wrike Data from PowerShell
Write a quick PowerShell script to query Wrike data. Use connectivity to the live data to replicate Wrike data to SQL Server.
-
Add Float Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Float with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Live Freshservice Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Freshservice from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Freshservice data.
-
Automated Continuous Excel Online Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Excel Online replication to Google Cloud SQL.
-
Getting Started with the CData Excel Add-In for Clari
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Clari.
-
Integrate with Live Adobe Commerce Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Adobe Commerce from the MuleSoft Anypoint Platform to integrate live Adobe Commerce data into custom reports and dashboards.
-
How to Visualize SAP BusinessObjects BI Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP BusinessObjects BI data in Python.
-
Getting Started with the CData JDBC Driver for Mode
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Mode.
-
Natively Connect to Flowlu Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Flowlu data. Leverage the native support for ODBC in PHP.
-
Design BIRT Reports on MailerLite Data
Provide current MailerLite data to your embedded analytics.
-
How to Seamlessly Import MessageBird Data into IBM SPSS Modeler
Integrate MessageBird data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Cline with Live Discord Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Discord data from within your IDE.
-
Connect to Elasticsearch Data in RapidMiner
Integrate Elasticsearch data with standard components and data source configuration wizards in RapidMiner Studio.