CData Software - Knowledge Base
Recent Articles
-
Query Live SAS xpt 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 SAS xpt data directly from the development environment.
-
Use the CData Software JDBC Driver for Oracle in MicroStrategy Web
Connect to Oracle data in MicroStrategy Web using the CData Software JDBC Driver for Oracle.
-
Create Informatica Mappings From/To an ODBC Data Source for Sage 200
Create an ODBC connection to Sage 200 in Informatica and browse and transfer Sage 200 data.
-
Bind Live FTP Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live FTP data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrating Antigravity CLI with Email data via CData CLI
Connect Email data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to SAP Netweaver Gateway Data from Spring Boot
Connect to SAP Netweaver Gateway in a Spring Boot Application using the CData JDBC Driver for SAP Netweaver Gateway
-
Viewing Gong Data in RAD Studio Data Explorer
How to view Gong data in RAD Studio Data Explorer using the CData ODBC Driver for Gong.
-
Connect to Smartsheet Data in NetBeans
Connect to Smartsheet data in NetBeans with the data source configuration wizard.
-
Automated Continuous HCL Domino Replication to Oracle
Use CData Sync for automated, continuous, customizable HCL Domino replication to Oracle.
-
Integrate OpenCode with Live Office 365 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Office 365 data from within your AI coding agent.
-
Use Dash to Build to Web Apps on Oracle Financials Cloud Data
Create Python applications that use pandas and Dash to build Oracle Financials Cloud-connected web apps.
-
How to publish and share Shortcut Data dashboards with Tableau Server
The CData ODBC driver for Shortcut enables you integrate Shortcut data into Tableau dashboards.
-
Automated Continuous HCL Domino Replication to Vertica
Use CData Sync for automated, continuous, customizable HCL Domino replication to Vertica.
-
Build Semantic Layer Views for Reckon Accounts Hosted Data in APOS Live Data Gateway
Use the CData Connector for Reckon Accounts Hosted in APOS Live Data Gateway to build Semantic Layer Views for Reckon Accounts Hosted data.
-
Integrate Live Jira Assets 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 Jira Assets data from within the IDE.
-
Analyze Exact Online Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Exact Online from Power Pivot. You will use the Table Import Wizard to load Exact Online data. You can visually build the import query or use any SQL supported by the driver.
-
How to connect to Snapchat Ads Data from Spring Boot
Connect to Snapchat Ads in a Spring Boot Application using the CData JDBC Driver for Snapchat Ads
-
Extract, Transform, and Load DocuSign Data in Informatica PowerCenter
Create a simple Workflow for DocuSign data in Informatica PowerCenter.
-
Create Outreach.io Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Outreach.io from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create MarkLogic Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MarkLogic from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Copper Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Copper data from Node.js.
-
Load RSS Feeds to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load RSS feeds to a database.
-
Query ADP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ADP entities in PHP by modeling them as objects.
-
How to Connect DBeaver to Zoom via a JDBC Driver
Manage Zoom data with visual tools in DBeaver like the query browser.
-
ConvertKit Reporting in OBIEE with the ConvertKit JDBC Driver
Deploy the ConvertKit JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Import and Visualize Sage 200 Data in Power View
Create data visualizations based on Sage 200 data in Excel.
-
Connect to Hubstaff Data in RazorSQL
Connect to Hubstaff from wizards and query Hubstaff data from the GUI in the RazorSQL database management tool.
-
Integrating Boomi Agentstudio with PostgreSQL Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to PostgreSQL data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Validate Coda Data with QuerySurge
Access and validate Coda data in QuerySurge using the CData JDBC Driver.
-
Connecting Pipedream with MYOB AccountRight 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 MYOB AccountRight data in real time.
-
Use the CData ODBC Driver for Couchbase in Microsoft Power Query
You can use the CData Couchbase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Couchbase data into Microsoft Power Query.
-
Automated Continuous Gumroad Replication to SQLite
Use CData Sync for automated, continuous, customizable Gumroad replication to SQLite.
-
Working with Google Drive Data in LINQPad
Execute LINQ queries to Google Drive data in LINQPad.
-
Build SendGrid Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SendGrid data and build visualizations in Tableau Cloud.
-
Bridge FormSite Connectivity with Apache NiFi
Access and process FormSite data in Apache NiFi using the CData JDBC Driver.
-
Integrate Goose with Live Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Jira Assets data from within the local AI agent.
-
Connect to Cvent Data in ACL Analytics
Connect to Cvent data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Cvent data.
-
Import Real-Time ServiceDesk Plus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ServiceDesk Plus data in ColdFusion.
-
Working with QuickBooks Time Data in LINQPad
Execute LINQ queries to QuickBooks Time data in LINQPad.
-
Build Twitter Ads-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 Twitter Ads data without replication.
-
Create Quickbase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Quickbase Data from Klipfolio and build custom visualizations using live Quickbase data.
-
How to connect to MailerLite Data from Spring Boot
Connect to MailerLite in a Spring Boot Application using the CData API Driver for JDBC
-
Build Dashboards with Act CRM Data in DBxtra
Create dynamic dashboards and perform analytics based on Act CRM data in DBxtra.
-
How to publish and share SAP Fieldglass Data dashboards with Tableau Server
The CData ODBC driver for SAP Fieldglass enables you integrate SAP Fieldglass data into Tableau dashboards.
-
Import and Visualize Sage Intacct Data in Power View
Create data visualizations based on Sage Intacct data in Excel.
-
Visualize Google Tasks Data in Sisense
Create an ElastiCube in Sisense app with access to Google Tasks data.
-
Integrate OpenCode with Live Salesforce Pardot Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Salesforce Pardot data from within your AI coding agent.
-
Visualize Live JSON Services in the Power BI Service
Use CData Connect AI to connect to live JSON services and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Coda Data in DBxtra
Create dynamic dashboards and perform analytics based on Coda data in DBxtra.
-
Integrate with Live ZohoMarketingHub Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to ZohoMarketingHub from the MuleSoft Anypoint Platform to integrate live ZohoMarketingHub data into custom reports and dashboards.
-
How to Measure Claude Token Reduction with CData Connect AI
Reproduce the published CData Connect AI token-reduction benchmark on your own data, or use it as a starting point to measure your own AI workloads.
-
Connecting Mastra with Sugar CRM 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 Sugar CRM data, no replication required.
-
How to Connect the Power BI Service to Dynamics 365: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics 365 from PowerBI.com to provide real-time Dynamics 365 data across the organization.
-
Create Reports from Freshservice Data in Looker Studio
Use CData Connect AI to gain access to live Freshservice data and create custom reports in Looker Studio.
-
Integrating Kiro with Monday.com 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.
-
Create Datasets from LDAP in Domo Workbench and Build Visualizations of LDAP Objects in Domo
Use the CData Software ODBC Driver for LDAP to create datasets from LDAP objects in Domo Workbench and then build visualizations in the Domo service.
-
Build Charts with SurveyMonkey Data in Clear Analytics
Create dynamic charts and perform analytics based on SurveyMonkey data in Clear Analytics.
-
Connect to Oracle HCM Cloud Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle HCM Cloud data.
-
Automated Continuous Marketo Replication to MySQL
Use CData Sync for automated, continuous, customizable Marketo replication to MySQL.
-
Automated Continuous Jira Replication to Snowflake
Use CData Sync for automated, continuous, customizable Jira replication to Snowflake.
-
Integrating LlamaIndex with Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle HCM Cloud data in real time.
-
ETL Google Calendar in Oracle Data Integrator
This article shows how to transfer Google Calendar data into a data warehouse using Oracle Data Integrator.
-
DataBind Controls to Freshteam Data in Delphi
DataBind to Freshteam data in Delphi with standard data access components and controls.
-
Build Semantic Layer Views for Acumatica Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Acumatica data.
-
Integrate Mode with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Mode with External Services.
-
A PostgreSQL Interface for Blackbaud FE NXT Data using the CData ODBC Driver
Use the SQL Gateway and Blackbaud FE NXT ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access SAS xpt Data from MySQL in PHP
Connect to SAS xpt through the standard MySQL libraries in PHP.
-
Connect to Access Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Access and the Script function in FileMaker Pro to connect to Access and work with Access data in your FileMaker application.
-
DataBind Charts to Teradata Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Teradata 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.
-
Use Claude to Talk to Your Google Spanner 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 Google Spanner data for you.
-
Connect to Jodoo Data in RapidMiner
Integrate Jodoo data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to WooCommerce from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from WooCommerce data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to integrate Supabase with Apache Airflow
Access and process Supabase data in Apache Airflow using the CData JDBC Driver.
-
Migrating data from Microsoft Ads to Databricks using CData SSIS Components.
Easily push Microsoft Ads data to Databricks using the CData SSIS Tasks for Microsoft Ads and Databricks.
-
Build Paymo-Connected Apps in Choreo
Use CData Connect AI to connect to Paymo Data from Choreo and build custom apps using live Paymo data.
-
Build Snapchat Ads-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Snapchat Ads Data from Zoho Analytics and import live Snapchat Ads data.
-
Integrate SAP Concur with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Concur with External Services.
-
Use Claude to Talk to Your Mode 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 Mode data for you.
-
Integrating LangChain with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Oracle Eloqua data within automated workflows.
-
Use Dash to Build to Web Apps on Gmail Data
Create Python applications that use pandas and Dash to build Gmail-connected web apps.
-
Build a Singer.io Tap for Box With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Box data using the CData Python Connector.
-
Visualize Samanage 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 Samanage data into TIBCO Spotfire.
-
How to Connect the Power BI Service to PingOne: Complete Guide
Connect to the CData Software Power BI Connector for PingOne from PowerBI.com to provide real-time PingOne data across the organization.
-
How to Connect to Live Workday 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 Workday data for you.
-
Connect to eBay Analytics Data in RazorSQL
Connect to eBay Analytics from wizards and query eBay Analytics data from the GUI in the RazorSQL database management tool.
-
How to integrate AfterShip with Apache Airflow
Access and process AfterShip data in Apache Airflow using the CData JDBC Driver.
-
Connect to Oracle Financials Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Financials Cloud data as a data source.
-
Analyze SAP HANA Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP HANA data in Microsoft R Open.
-
Query Phoenix Data as a SQL Server Database in Node.js
Execute SQL Server queries against Phoenix data from Node.js.
-
ETL Avalara AvaTax in Oracle Data Integrator
This article shows how to transfer Avalara AvaTax data into a data warehouse using Oracle Data Integrator.
-
Integrate OpenCode with Live WooCommerce Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live WooCommerce data from within your AI coding agent.
-
How to connect PolyBase to CSV
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CSV data.
-
Connect to Testmonitor Data from PowerBuilder via ADO.NET
This article demonstrates how to access Testmonitor data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Use the CData Software JDBC Driver for Google Sheets in MicroStrategy
Connect to Google Sheets data in MicroStrategy Developer using the CData Software JDBC Driver for Google Sheets.
-
Explore Geographical Relationships in Microsoft Entra ID Data with Power Map
Create data visualizations with Microsoft Entra ID data in Power Map.
-
Integrate ConvertKit with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ConvertKit with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ConvertKit data.
-
Provide OData Services of Reckon Accounts Hosted Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Reckon Accounts Hosted data by developing a WCF Service Application.
-
Integrating Cursor with Active Directory 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 Google Ads Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Ads Data and connect to Google Ads data in Akorbi Digital RunMyProcess.
-
Build Suadeo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Suadeo data and build Suadeo-connected web apps with Axios.