CData Software - Knowledge Base
Recent Articles
-
Connect to SQL Analysis Services Data from HeidiSQL
Use CData Connect AI to connect to and query live SQL Analysis Services from HeidiSQL.
-
Query SharePoint Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft SharePoint from Node.js.
-
Automate Typeform Data Replication to Azure Synapse
Use CData Sync to customize and automate Typeform replication to Azure Synapse.
-
Use the CData API Server to Access Avro Data in Microsoft PowerPivot
Use the CData API Server to connect to live Apache Avro in the Power Pivot business intelligence tool.
-
DataBind Controls to HCL Domino Data in Delphi
DataBind to HCL Domino in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics CRM
Create Dynamics CRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to SAP Fieldglass Data from AWS Glue
Use CData Connect AI to gain access to live SAP Fieldglass from your AWS Glue jobs.
-
How to Connect to Live SAP ByDesign Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live SAP Business ByDesign securely in real time.
-
Analyze Live Salesforce Data in SAS Viya
Use CData Connect AI to connect to Salesforce & Force.com from SAS Viya and deploy self-service analytics using live Salesforce & Force.com.
-
Connect JotForm Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your JotForm using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData ODBC Driver for Greenhouse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Greenhouse.
-
Natively Connect to Zoho Projects Data in PHP
The CData ODBC driver for Zoho Projects enables you to create PHP applications with connectivity to Zoho Projects. Leverage the native support for ODBC in PHP.
-
Connect to Excel Data in Jaspersoft Studio
Execute SQL to remote Microsoft Excel in Jaspersoft Studio.
-
Analyze Amazon DynamoDB Data in Looker
Use CData Connect AI to connect to Amazon DynamoDB Data from Looker and build custom apps using live Amazon DynamoDB.
-
Automated Continuous Jodoo Replication to Oracle
Use CData Sync for automated, continuous, customizable Jodoo replication to Oracle.
-
How to Connect the Power BI Service to Excel: Complete Guide
Connect to the CData Software Power BI Connector for Excel from PowerBI.com to provide real-time Microsoft Excel across the organization.
-
Integrate Cursor with Live Basecamp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Basecamp from within the editor.
-
Build a PostgreSQL Interface for Adobe Commerce Data using the CData JDBC Driver
Use the Remoting features of the Adobe Commerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating OpenCode Terminal with Placid 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 Query Live Ontraport Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Ontraport data in natural language using Python.
-
Create Dynamic Aircall Grids Using the Infragistics XamDataGrid
Learn how you can connect Aircall to Infragistics XamDataGrid to build dynamic grids.
-
Replicate Multiple Box Accounts
Replicate multiple Box accounts to one or many databases.
-
Connect to Bullhorn CRM Data from PowerBuilder via ADO.NET
This article demonstrates how to access Bullhorn CRM from Appeon PowerBuilder using the CData ADO.NET Provider for Bullhorn CRM.
-
Access Live Sybase Data in AWS Lambda
Connect to live Sybase in AWS Lambda using the CData JDBC Driver.
-
Build a PostgreSQL Interface for JSON Services using the CData JDBC Driver
Use the Remoting features of the JSON JDBC Driver to create a PostgreSQL entry-point for data access.
-
Replicate Hive Data to Multiple Databases via the CData Sync CLI
Replicate Apache Hive to disparate databases with a single configuration.
-
Integrating Antigravity CLI with Omnisend via CData CLI
Connect Omnisend to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Zoom Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoom replication to Azure SQL Database.
-
Automated Continuous Supabase Replication to Oracle
Use CData Sync for automated, continuous, customizable Supabase replication to Oracle.
-
Build LDAP-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for LDAP to explore live LDAP Objects in GitHub Copilot to assist with building LDAP-powered applications.
-
Connect to WooCommerce from a Connection Pool in WebLogic
Use the CData JDBC Driver for WooCommerce to connect to WooCommerce from Web applications running on WebLogic.
-
Use Dash to Build to Web Apps on Amazon DynamoDB Data
Create Python applications that use pandas and Dash to build Amazon DynamoDB-connected web apps.
-
Integrating Claude Code CLI with iContact 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 Recurly Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Recurly from Node.js.
-
How to Connect to Live Sugar CRM Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Sugar CRM for you.
-
How to connect Amazon QuickSight to Zoom Data
Create a connection to Zoom in CData Connect AI and insert Zoom into Amazon QuickSight SPICE to build interactive dashboards.
-
Publish Reports with Rootly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Rootly.
-
How to Access Live SAP HANA Data in Visual Studio Code via Cline
Run CData MCP Server for SAP HANA on Windows Subsytem for Linux (WSL) and connect to live SAP HANA from the Cline extension in Visual Studio Code.
-
Automated Continuous Copper Replication to SQLite
Use CData Sync for automated, continuous, customizable Copper replication to SQLite.
-
Integrating Gumloop with SAS xpt Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAS XPORT within automated workflows.
-
DataBind Phoenix Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Phoenix with the DevExpress Windows Forms and Web controls to provide Apache Phoenix to a chart.
-
Connect Salesforce Marketing to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce Marketing Cloud using the CData Python MCP Server.
-
Connect to AlloyDB Data in RazorSQL
Connect to AlloyDB from wizards and query Google AlloyDB from the GUI in the RazorSQL database management tool.
-
Integrating Dataiku with PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live PostgreSQL.
-
NetSuite SuiteAnalytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to NetSuite SuiteAnalytics through CData Connect AI using different applications and tools.
-
Visualize SendPulse Data in Tableau
The CData ODBC driver for SendPulse enables you integrate SendPulse into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for Intercom
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Intercom.
-
Back Up Browserless to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Browserless data.
-
Consume Okta OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Okta feeds that reflect any changes in SAP Lumira.
-
How to update Zoho Projects from Excel
This article explains how to transfer data from Excel to Zoho Projects using the Excel Add-In for Zoho Projects.
-
Use JayDeBeApi to access Excel Online Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Excel Online.
-
How to Connect to Live Highrise Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Highrise CRM for you.
-
Automated Continuous LionDesk Replication to SQLite
Use CData Sync for automated, continuous, customizable LionDesk replication to SQLite.
-
Publish Reports with Recurly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Recurly.
-
A Feature Comparison of Drivers for NoSQL
An article comparing the available features and functionality of CData Software Drivers for MongoDB.
-
Getting Started with the CData SSIS Components for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Microsoft Dataverse.
-
Connect to Sybase IQ Data from Crystal Reports
Use CData Connect AI to connect to and report on live Sybase IQ from Crystal Reports.
-
Create Power BI Reports on Real-Time Apify Data
Use the CData ODBC Driver for Apify to visualize Apify in Power BI Desktop.
-
LINQ to Wave Financial 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 Wave Financial Data Provider.
-
Integrate Cursor with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Pipedrive from within the editor.
-
Build Active Directory-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Active Directory to explore live Active Directory Data in Gemini Code Assist to assist with building Active Directory-powered applications.
-
Query, Visualize, and Share live Apollo Data in Redash
Use CData Connect AI to connect to live Apollo in Redash for querying, visualizing, and sharing.
-
How to update XML from Excel
This article explains how to transfer data from Excel to XML using the Excel Add-In for XML.
-
Connect to Pushbullet in SpagoBI
Create reports featuring live Pushbullet in SpagoBI Studio. Host Pushbullet reports on SpagoBI Server.
-
Visualize Live Google Cloud Storage Data in the Power BI Service
Use CData Connect AI to connect to live Google Cloud Storage and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize MessageBird Data in TIBCO Spotfire through ADO.NET
Integrate MessageBird into dashboards in TIBCO Spotfire.
-
Build an OLAP Cube in SSAS from Hacker News Data
Establish a connection to Hacker News data from SQL Server Analysis Services, and use the Hacker News Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use JayDeBeApi to access Dynamics 365 Business Central Data in Python
Use standard Python scripting and the development environment of your choice to access live Dynamics 365 Business Central.
-
How to Query Live Oracle Sales Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Oracle Sales data in natural language using Python.
-
Build Agents in Relevance AI with Access to Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Microsoft OneDrive within intelligent agent workflows.
-
Work with Live Snapchat Ads Data in Power Query
Use CData Connect AI to connect to Snapchat Ads and work with live Snapchat Ads in Microsoft Power Query.
-
Build Dynamics CRM-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Dynamics CRM to explore live Dynamics CRM Data in Gemini Code Assist to assist with building Dynamics CRM-powered applications.
-
Use Grok to Talk to Your Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Asana for you.
-
Connect to Amplitude Data in RapidMiner
Integrate Amplitude with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Data Visualizations in Cognos BI with Redshift Data
Access Amazon Redshift as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Prepare, Blend, and Analyze Raisers Edge NXT Data in Alteryx Designer (ODBC)
Build workflows to access live Raisers Edge NXT for self-service data analytics.
-
DataBind Charts to Google Forms Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Forms 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.
-
Automated Continuous SendGrid Replication to Vertica
Use CData Sync for automated, continuous, customizable SendGrid replication to Vertica.
-
Connect to CockroachDB in SpagoBI
Create reports featuring live CockroachDB in SpagoBI Studio. Host CockroachDB reports on SpagoBI Server.
-
Integrating Claude Code with DocuSign Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on DocuSign within assisted coding and automated development workflows.
-
Connect to LinkedIn Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live LinkedIn from Filemaker Pro on Mac.
-
Connect to Pingdom Data in CloverDX (formerly CloverETL)
Transfer Pingdom using the visual workflow in the CloverDX data integration tool.
-
Access Live Sage Intacct 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 Sage Intacct through MCP integration.
-
How to publish and share Webex Data dashboards with Tableau Server
The CData ODBC driver for Webex enables you integrate Webex into Tableau dashboards.
-
Know Your LLMs: Google Gemini
Learn how Google Gemini models support enterprise AI workloads, including multimodality, function calling, security, and integration with CData Connect AI via MCP.
-
DataBind Controls to CouchDB Data in Delphi
DataBind to Apache CouchDB in Delphi with standard data access components and controls.
-
Extract, Transform, and Load Invoiced Data in Informatica PowerCenter
Create a simple Workflow for Invoiced in Informatica PowerCenter.
-
Connect to ZohoSubscriptions Data in JRuby
Create a simple JRuby app with access to live ZohoSubscriptions.
-
Build CSV-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live CSV/TSV Files.
-
Manage Monday.com Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Monday.com.
-
Automate GitHub Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live GitHub and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Dash to Build to Web Apps on ServiceNow Data
Create Python applications that use pandas and Dash to build ServiceNow-connected web apps.
-
Getting Started with the CData Power BI Connector for SAP HANA XS Advanced
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SAP HANA XS Advanced.
-
Connecting Pipedream with Databricks 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 Databricks data in real time.
-
Connect to Paylocity Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Paylocity and the SQL Gateway to access Paylocity from Google Apps Script.
-
Access PolarTeamPro Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PolarTeamPro from HeidiSQL.
-
Replicate Insightly Data to Multiple Databases
Replicate Insightly to disparate databases with a point-and-click configuration.
-
Build Automated Workflows with Live WooCommerce Data in Workato
Use CData Connect AI to connect to live WooCommerce and build automated workflows in Workato.
-
How to connect SharePoint with Zoho CRM Data through external lists
Provide Zoho CRM to SharePoint users as an external list.
-
How to Build an ETL App for ServiceDesk Plus Data in Python with CData
Create ETL applications and real-time data pipelines for ServiceDesk Plus in Python with petl.