CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with Oracle Financials Cloud 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.
-
Connect to Todoist Data in NetBeans
Connect to Todoist data in NetBeans with the data source configuration wizard.
-
Bridge Superchat Connectivity with Apache NiFi
Access and process Superchat data in Apache NiFi using the CData JDBC Driver.
-
Connect to Google Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access Google Analytics data from PowerBuilder using the Google Analytics JDBC Driver.
-
Process & Analyze Instagram Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Instagram Data.
-
How to Connect to & Open Zoho CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to Connect to & Open Hive Data in Microsoft Excel
This article uses the CData ODBC driver for Hive to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Rootly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Rootly data from HeidiSQL.
-
Build Apps with Live Pinterest Data Using the Low-Code Development Platform of Mendix
Connect Pinterest data with Mendix to build apps using the CData JDBC Driver for Pinterest.
-
Gmail Reporting in OBIEE with the Gmail JDBC Driver
Deploy the Gmail JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Coda Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Coda replication to IBM DB2.
-
Integrate Live Pinecone Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Pinecone data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Query Oracle Sales Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle Sales data from Node.js.
-
How to connect and process Highrise data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Highrise data.
-
Query Live Authorize.Net Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Authorize.Net data directly from the development environment.
-
Mistral AI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mistral AI facts in real time.
-
Connect to Neo4J from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Neo4J data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Miro Data in NetBeans
Connect to Miro data in NetBeans with the data source configuration wizard.
-
Access Live Microsoft Dataverse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dataverse data into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dataverse data in the Graph Builder and Query Builder.
-
Integrate LibreChat with Live Avro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Avro data from within the chat interface.
-
Automated Continuous SuiteCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SuiteCRM replication to AlloyDB.
-
Integrate Real-Time Access to Redshift in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Redshift data in real time.
-
Access Live SAP Ariba Source Data in Excel 365 Online (Excel for the web)
Connect to SAP Ariba Source data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Model Dynamics 365 Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365, enabling the direct import of real-time Dynamics 365 data.
-
Replicate Multiple Outreach.io Accounts via the CData Sync CLI
Replicate multiple Outreach.io accounts to one or many databases.
-
Integrate Live TaxJar Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live TaxJar data to Blue Prism using the CData ODBC Driver for TaxJar to create automated workflows for repetitive business tasks.
-
Access Live Authorize.Net Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Authorize.Net data from your Google Sheets.
-
Use the CData ODBC Driver for Xero in Microsoft Power Query
You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero data into Microsoft Power Query.
-
Build Dashboards with HBase Data in DBxtra
Create dynamic dashboards and perform analytics based on HBase data in DBxtra.
-
How to import ServiceDesk Plus Data into Apache Solr
Use the CData Software JDBC Driver for ServiceDesk Plus in Data Import Handler and create an automated import of ServiceDesk Plus data to Apache Solr Enterprise Search platform.
-
Integrate LibreChat with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Reckon Accounts Hosted data from within the chat interface.
-
Create SSAS Tabular Models from AlloyDB Data
How to build a SQL Server Analysis Service Tabular Model from AlloyDB data using CData drivers.
-
Access Deel Data from MySQL in Amazon QuickSight
Connect to Deel and build visualizations of Deel data using a MySQL Connection in Amazon QuickSight.
-
Integrate Google's Antigravity Agent with Live Campaigner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Campaigner data using the Model Context Protocol.
-
Connect to iContact Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live iContact data.
-
Connect to Epicor Kinetic Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Epicor Kinetic as an External Source in Dremio.
-
Getting Started with the CData Tableau Connector for Rebilly
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Google Tasks Data in DBArtisan
Use wizards in DBArtisan to configure Google Tasks data as a data source.
-
Deploy the ADO.NET Provider for Microsoft Ads on an SSRS Report Server
Connect to Microsoft Ads data 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.
-
Integrating Cursor with Teamgate 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 Billsby Data Replication to Teradata
Use CData Sync to Customize and automate Billsby data replication to Teradata.
-
Integrate Cursor with Live Facebook Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Facebook Ads data from within the editor.
-
How to connect to Aircall Data from IntelliJ
Integrate connectivity to Aircall data with wizards in IntelliJ.
-
Replicate Multiple Contentful Accounts via the CData Sync CLI
Replicate multiple Contentful accounts to one or many databases.
-
How to connect to Asana Data with Squirrel SQL client
Connect to Asana data and execute queries in the Squirrel SQL Client.
-
How to work with Rootly Data in Apache Spark using SQL
Access and process Rootly Data in Apache Spark using the CData Software JDBC Driver.
-
Natively Connect to JSON Services in PHP
The CData ODBC driver for JSON enables you to create PHP applications with connectivity to JSON services. Leverage the native support for ODBC in PHP.
-
Explore Geographical Relationships in Sage 300 Data with Power Map
Create data visualizations with Sage 300 data in Power Map.
-
Integrate with Live XML Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to XML from the MuleSoft Anypoint Platform to integrate live XML data into custom reports and dashboards.
-
Use Databricks Agent Bricks to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your LinkedIn Ads data for you.
-
Integrate Clockify Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Clockify data from Informatica Cloud.
-
Access Neo4J Data from MySQL in PHP
Connect to Neo4J through the standard MySQL libraries in PHP.
-
Choosing the Best Method to Connect FreshBooks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use FreshBooks data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to and Visualize Live Printify Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Printify data.
-
Connect to Superchat Data in NetBeans
Connect to Superchat data in NetBeans with the data source configuration wizard.
-
Create Presto-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Presto Data from OutSystems and build custom enterprise apps using live Presto data.
-
Use the CData ODBC Driver for Sage 300 from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage 300 to connect to Sage 300 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage 300 data in Excel.
-
Process & Analyze Office 365 Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Office 365 Data.
-
Natively Connect to Everhour Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Everhour data. Leverage the native support for ODBC in PHP.
-
How to connect to Pipedrive Data in DBVisualizer
Integrate Pipedrive data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Cline with Live Box Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Box data from within your IDE.
-
Use the CData Software ODBC Driver for TaxJar in MicroStrategy Web
Connect to TaxJar data in MicroStrategy Web using the CData Software ODBC Driver for TaxJar.
-
Analyze Apollo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Apollo data in Microsoft R Open.
-
Connect to MailChimp in SpagoBI
Create reports featuring live MailChimp data in SpagoBI Studio. Host MailChimp reports on SpagoBI Server.
-
How to connect to Anaplan Data in DBVisualizer
Integrate Anaplan data with visual data analysis tools and data connection wizards in DBVisualizer
-
Write a Simple Go Application to work with Teamgate Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teamgate data.
-
Build Pinterest-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Pinterest Data from Zoho Analytics and import live Pinterest data.
-
Query, Visualize, and Share live Hive Data in Redash
Use CData Connect AI to connect to live Hive data in Redash for querying, visualizing, and sharing.
-
How to Connect to Live Anaplan 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 Anaplan data through natural language.
-
Analyze Parquet Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Parquet data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build a Singer.io Tap for FHIR With the CData Python Connector
Learn how to easily build a Singer.io Tap for live FHIR data using the CData Python Connector.
-
Integrate Okta with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Okta with External Services.
-
Create Sybase IQ-Connected Applications in Appsmith
Connect to Sybase IQ Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Sybase IQ data.
-
Build Dashboards with Pinterest Data in DBxtra
Create dynamic dashboards and perform analytics based on Pinterest data in DBxtra.
-
How to Connect to Live Microsoft Exchange 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 Microsoft Exchange data for you.
-
Connect to Kintone Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Kintone to connect to Kintone data and execute queries in PowerBuilder.
-
Integrate Devin with Live Dynamics CRM 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 Dynamics CRM data.
-
Access Live SAP SuccessFactors Data in AWS Lambda
Connect to live SAP SuccessFactors data in AWS Lambda using the CData JDBC Driver.
-
Visualize Live Google Tasks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Tasks data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate AfterShip Integration Tasks from PowerShell
Are you in search of a quick and easy way to access AfterShip data from PowerShell? This article demonstrates how to utilize the AfterShip Cmdlets for tasks like connecting to AfterShip data, automating operations, downloading data, and more.
-
Integrate OpenCode with Live Shippo Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Shippo data from within your AI coding agent.
-
Query, Visualize, and Share live Reckon Data in Redash
Use CData Connect AI to connect to live Reckon data in Redash for querying, visualizing, and sharing.
-
Build Agents in Relevance AI with Access to Live ActiveCampaign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ActiveCampaign data within intelligent agent workflows.
-
How to Query Live Dynamics 365 Business Central Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Dynamics 365 Business Central data data in natural language using Python.
-
Integrate Redshift Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Redshift data and integrate live Redshift data into your Power Automate tasks.
-
Import and Visualize SendGrid Data in Power View
Create data visualizations based on SendGrid data in Excel.
-
Integrate Theia IDE with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Azure Analysis Services data from within the development environment.
-
DataBind Charts to Snapchat Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Snapchat Ads data 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.
-
Prepare, Blend, and Analyze Freshservice Data in Alteryx Designer (ODBC)
Build workflows to access live Freshservice data for self-service data analytics.
-
Connecting Pipedream with Toggl 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 Toggl data in real time.
-
Automated Continuous Intercom Replication to SQLite
Use CData Sync for automated, continuous, customizable Intercom replication to SQLite.
-
Integrating Kiro with Bright Data 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.
-
How to Connect DBeaver to eBay via a JDBC Driver
Manage eBay data with visual tools in DBeaver like the query browser.
-
Query Perigon Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Perigon data from Node.js.
-
Connecting Mastra with Pipedrive 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 Pipedrive data, no replication required.
-
Connect to Neo4J Data in JRuby
Create a simple JRuby app with access to live Neo4J data.
-
Connect to Act CRM Data in DBArtisan
Use wizards in DBArtisan to configure Act CRM data as a data source.
-
Build Neo4J-Connected Apps in Choreo
Use CData Connect AI to connect to Neo4J Data from Choreo and build custom apps using live Neo4J data.
-
Extract, Transform, and Load Exa Data in Informatica PowerCenter
Create a simple Workflow for Exa data in Informatica PowerCenter.
-
Create Reports from Sendwithus Data in Looker Studio
Use CData Connect AI to gain access to live Sendwithus data and create custom reports in Looker Studio.