CData Software - Knowledge Base
Recent Articles
-
Connect to Dynamics 365 Business Central Data in JRuby
Create a simple JRuby app with access to live Dynamics 365 Business Central data.
-
Natively Connect to Excel Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Excel data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Google Contacts Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Google Contacts replication to Apache Cassandra.
-
Automated Continuous Stripe Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Stripe replication to AlloyDB.
-
Connect to Mailgun Data in NetBeans
Connect to Mailgun data in NetBeans with the data source configuration wizard.
-
Connect to Salesforce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Salesforce data.
-
Integrate Trae with Live Adobe Experience Manager Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Adobe Experience Manager data from within the AI-powered IDE.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon Marketplace
Create Amazon Marketplace data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Google Search-Connected Nintex Workflows
Use CData Connect AI to connect to Google Search Results from Nintex Workflow Cloud and build custom workflows using live Google Search results.
-
Build QuickBooks Online-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live QuickBooks Online data without replication.
-
Integrating Claude Code CLI with Box 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 Microsoft Planner Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Microsoft Planner data in Airbyte.
-
Connect to Vault CRM Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Vault CRM data from Filemaker Pro on Mac.
-
Access Live Xero Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Xero data from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HBase
Provide connectivity to HBase data through an SAP BusinessObjects universe.
-
Connect to ShipStation Data from HeidiSQL
Use CData Connect AI to connect to and query live ShipStation data from HeidiSQL.
-
Access Live Azure Analysis Services Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Analysis Services data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to Create Power BI Visual Reports with Real-Time Pinterest Data
Use CData Power BI Connectors to visualize Pinterest data in Power BI.
-
Build a PostgreSQL Interface for Deel Data using the CData JDBC Driver
Use the Remoting features of the Deel JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind SAP ByDesign Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for SAP ByDesign with the DevExpress Windows Forms and Web controls to provide SAP ByDesign data to a chart.
-
Load Excel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Excel data to a database.
-
Integrate with Close Data in JReport Designer
Create charts and reports based on Close data in JReport Designer.
-
Easily Integrate Deel Data in Lazarus Pascal IDE
Learn how to easily integrate live Deel data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Getting Started with the CData ADO.NET Provider for SageHR
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Create Sage Cloud Accounting Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage Cloud Accounting data access from reports, embedded analytics, and more.
-
Access PDFMonkey Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access PDFMonkey data from your Oracle system.
-
Visualize Live Reply.io Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reply.io data.
-
How to integrate Metabase with Cvent Data
Use CData Connect AI to connect to live Cvent data and create an interactive dashboard in Metabase from Cvent data.
-
Automate Wave Financial Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Wave Financial data from PowerShell? This article demonstrates how to utilize the Wave Financial Cmdlets for tasks like connecting to Wave Financial data, automating operations, downloading data, and more.
-
Zoho Projects Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Projects facts in real time.
-
Automated Continuous ZohoMarketingHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to Google BigQuery.
-
How to Create Power BI Visual Reports with Real-Time Klaviyo Data
Use CData Power BI Connectors to visualize Klaviyo data in Power BI.
-
Replicate Raisers Edge NXT Data to Multiple Databases via the CData Sync CLI
Replicate Raisers Edge NXT data to disparate databases with a single configuration.
-
Integrate Open WebUI with Live iContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live iContact data from within the chat interface.
-
Analyze HBase Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of HBase data and visualize HBase data in SAP Analytics Cloud.
-
How to Connect to & Open Coda Data in Microsoft Excel
This article uses the CData ODBC driver for Coda to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Gumloop with CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on CockroachDB data within automated workflows.
-
Link eBay Analytics with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate eBay Analytics data in Filemaker Pro for Mac or Windows.
-
Create Figshare Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Figshare from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create a Data Access Object for ClickUp Data using JDBI
A brief overview of creating a SQL Object API for ClickUp data in JDBI.
-
Use the CData Software ODBC Driver for ElevenLabs in MicroStrategy Web
Connect to ElevenLabs data in MicroStrategy Web using the CData Software ODBC Driver for ElevenLabs.
-
Integrate Live EnterpriseDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to EnterpriseDB data and integrate live EnterpriseDB data into apps built in Microsoft Power Apps.
-
Consume Hive OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Hive feeds that reflect any changes in SAP Lumira.
-
Integrate Live Salesforce Data 360 Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Salesforce Data 360 from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Salesforce Data 360 data.
-
Connect to and Query Aircall Data in QlikView over ODBC
Create data visualizations with Aircall data in QlikView.
-
Create Reports from Microsoft Teams Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Teams data and create custom reports in Looker Studio.
-
Integrate with live Amazon Marketplace Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon Marketplace data in Jitterbit.
-
Create HCL Domino-Connected Dashboards in Grafana
Connect to HCL Domino Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HCL Domino data.
-
Provide OData Services of Quaderno Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Quaderno data by developing a WCF Service Application.
-
Visualize Live Zoho Books Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Books data.
-
How to Connect to Live WordPress 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 WordPress data for you.
-
Analyze Kintone Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Kintone data in Microsoft R Open.
-
Getting Started with the CData JDBC Driver for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zoho Projects.
-
Use Claude to Talk to Your SQL Server 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 SQL Server data for you.
-
CData SSIS Packages for Azure Data Factory
CData and Microsoft have partnered to make it easy to use CData SSIS Components within Azure Data Factory (ADF)
-
Create Dashboards and Visualize Live Bright Data Data in Geckoboard
Use CData Connect AI to connect to live Bright Data data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate OpenCode with Live Cloudant Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Cloudant data from within your AI coding agent.
-
How to integrate Sugar CRM with Apache Airflow
Access and process Sugar CRM data in Apache Airflow using the CData JDBC Driver.
-
Add Amazon S3 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon S3 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Moving Data from ChartMogul to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live ChartMogul data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to NetSuite Data in Jaspersoft Studio
Execute SQL to remote NetSuite data in Jaspersoft Studio.
-
How to connect to Coda Data from IntelliJ
Integrate connectivity to Coda data with wizards in IntelliJ.
-
Connect Todoist to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Todoist with IBM WebSphere for seamless data integration and connectivity.
-
Integrate Goose with Live ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ZohoExpense data from within the local AI agent.
-
Publish Reports with ServiceNow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceNow data.
-
Integrate Live ADP Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live ADP data from within the IDE.
-
Use JayDeBeApi to access Accelo Data in Python
Use standard Python scripting and the development environment of your choice to access live Accelo data.
-
Bind Live Marketo Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Marketo data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Analyze Live Office 365 Data in SAS Viya
Use CData Connect AI to connect to Office 365 data from SAS Viya and deploy self-service analytics using live Office 365 data.
-
Visualize Tickspot 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 Tickspot data into TIBCO Spotfire.
-
Integrating Boomi Agentstudio with Wistia Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Wistia data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Access Close Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Close data from HeidiSQL.
-
Automated Continuous SAP HANA XS Advanced Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to PostgreSQL.
-
Oracle Service Cloud Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Service Cloud facts in real time.
-
Connect to Keap Data in DBArtisan
Use wizards in DBArtisan to configure Keap data as a data source.
-
Connect and Visualize Live ServiceNow Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ServiceNow data into the Databricks platform and create visualization dashboards with real-time ServiceNow data.
-
How to Visualize Epicor Kinetic Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Epicor Kinetic data in Python.
-
Connecting Moonlit Workflow with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Google Directory data in real time.
-
Sage Cloud Accounting Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sage Cloud Accounting data through CData Connect AI using different applications and tools.
-
Edit and Search External ActiveCampaign Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of ActiveCampaign data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create ActiveCampaign Data objects that you can access from apps and the dashboard.
-
Connect to Vault CRM Data from a Connection Pool in Jetty
The Vault CRM JDBC Driver supports connection pooling: This article shows how to connect faster to Vault CRM data from Web apps in Jetty.
-
How to Work with Guru Data in AWS Glue Jobs Using JDBC
Connect to Guru from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Slack-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Slack data.
-
Integrate with SAP HANA XS Advanced Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP HANA XS Advanced data in SnapLogic.
-
Build a Singer.io Tap for Zoho Projects With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Zoho Projects data using the CData Python Connector.
-
Connect to Dotmailer Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Dotmailer and the SQL Gateway to access Dotmailer data from Google Apps Script.
-
How to publish and share Office 365 Data dashboards with Tableau Server
The CData ODBC driver for Office 365 enables you integrate Office 365 data into Tableau dashboards.
-
Model, Search, and Visualize Live Zoho Books Data in ThoughtSpot
Use CData Connect AI to connect to live Zoho Books data for modeling, searching, and visualizing.
-
Build Semantic Layer Views for Dynamics NAV Data in APOS Live Data Gateway
Use the CData Connector for Dynamics NAV in APOS Live Data Gateway to build Semantic Layer Views for Dynamics NAV data.
-
Connect to Salesforce Data 360 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce Data 360 Data and connect to Salesforce Data 360 data in Akorbi Digital RunMyProcess.
-
How to Connect to Live Odoo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Odoo data securely in real time.
-
Publish Crystal Reports on SAP Fieldglass Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Fieldglass data.
-
Create Microsoft Exchange-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft Exchange Data from Nintex Workflow Cloud and build custom workflows using live Microsoft Exchange data.
-
Load Sage Cloud Accounting Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Sage Cloud Accounting data to a database.
-
Connect to Dropbox Data in ACL Analytics
Connect to Dropbox data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Dropbox data.
-
Connect OneNote to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live OneNote data using the CData Python MCP Server.
-
Establish a Live Connection with Mocean Data using Tableau Bridge
The CData ODBC Driver for Mocean enables you to integrate live Mocean data into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Power BI Connector for Samanage
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connecting Pipedream with Omnisend 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 Omnisend data in real time.
-
Create Dashboards and Visualize Live Zoho CRM Data in Geckoboard
Use CData Connect AI to connect to live Zoho CRM data and create dashboards for real-time monitoring and visualization in Geckoboard.