CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time Sage 300 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage 300 and Dataflow to import and use Sage 300 in Power Apps.
-
Use Biml to Build SSIS Tasks to Replicate LDAP Objects to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate LDAP to SQL Server.
-
Connect to YouTube Analytics Data in HULFT Integrate
Connect to YouTube Analytics as a JDBC data source in HULFT Integrate
-
Integrating OpenCode Terminal with QuickBooks Online 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.
-
Deploy the ADO.NET Provider for Aircall on an SSRS Report Server
Connect to Aircall 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.
-
Deploy the ADO.NET Provider for Google Analytics on an SSRS Report Server
Connect to Google Analytics 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.
-
Query Pinecone Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pinecone from Node.js.
-
ETL Cosmos DB in Oracle Data Integrator
This article shows how to transfer Azure Cosmos DB into a data warehouse using Oracle Data Integrator.
-
Stream Keap Data into Apache Kafka Topics
Access and stream Keap in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Highrise-Connected Nintex Workflows
Use CData Connect AI to connect to Highrise Data from Nintex Workflow Cloud and build custom workflows using live Highrise CRM.
-
How to Handle PostgreSQL Infinity Values Using CData Sync
A basic guide to configuring CData Sync to handle infinity values from PostgreSQL during replication.
-
Use the CData Software JDBC Driver for Impala in MicroStrategy Web
Connect to Apache Impala in MicroStrategy Web using the CData Software JDBC Driver for Impala.
-
How to Connect to & Open Pipeliner CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Pipeliner CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Agents in Relevance AI with Access to Live Raisers Edge NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Raisers Edge NXT within intelligent agent workflows.
-
Integrate with Adobe Commerce Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Adobe Commerce in SnapLogic.
-
Integrate Live Office 365 Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Replicate Oracle SCM Data from PowerShell
Write a quick PowerShell script to query Oracle SCM. Use connectivity to the live data to replicate Oracle SCM to SQL Server.
-
How to Connect to Live Certinia 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 Certinia for you.
-
Connect and Query Live Splunk Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Splunk into Databricks
-
Create Data Visualizations in Cognos BI with Basecamp Data
Access Basecamp as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to and Visualize Live Mocean Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mocean.
-
Integrating LangChain with Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Amazon Redshift within automated workflows.
-
Query PolarTeamPro Data in ColdFusion
Write standard ColdFusion data access code to connect to PolarTeamPro.
-
Use the CData Software JDBC Driver for Splunk in MicroStrategy
Connect to Splunk in MicroStrategy Developer using the CData Software JDBC Driver for Splunk.
-
Automated Continuous ZohoExpense Replication to Snowflake
Use CData Sync for automated, continuous, customizable ZohoExpense replication to Snowflake.
-
Query Avalara AvaTax Data as a MySQL Database in Node.js
Execute MySQL queries against Avalara AvaTax from Node.js.
-
Access Live Google Directory Data in Excel 365 Online (Excel for the web)
Connect to Google Directory from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate PivotalTracker Data in Heroku for Use in Salesforce Connect
Replicate PivotalTracker to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Wave Financial Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Wave Financial data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Antigravity CLI with Adobe Experience Manager via CData CLI
Connect Adobe Experience Manager to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrating Codex CLI with Strava 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.
-
Access Google Campaign Manager 360 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Campaign Manager 360 from your Oracle system.
-
Integrating OpenCode Terminal with Google Drive 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 Blackbaud FE NXT from a Connection Pool in WebLogic
Use the CData JDBC Driver for Blackbaud FE NXT to connect to Blackbaud FE NXT from Web applications running on WebLogic.
-
Build Azure Table-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Azure Table to explore live Azure Table Data in GitHub Copilot to assist with building Azure Table-powered applications.
-
Connecting GenSpark with API Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to API without any replication or custom integration required.
-
Connect to Access Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft Access in the Denodo Virtual DataPort Administrator.
-
How to Build an ETL App for Zoho Creator Data in Python with CData Connect AI
Build ETL pipelines that read and write live Zoho Creator in Python with petl and the CData Connect AI Python SDK.
-
Validate Mixpanel Data with QuerySurge
Access and validate Mixpanel in QuerySurge using the CData JDBC Driver.
-
Integrate Live Splunk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Automate JotForm Data Replication to SAP HANA
Use CData Sync to customize and automate JotForm replication to SAP HANA.
-
Bidirectional Access to ZarMoney Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ZarMoney in Filemaker Pro for Mac or Windows.
-
Use CData Connect AI to Access Google Spanner Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Spanner in the Power Pivot business intelligence tool.
-
Integrate Real-Time Access to Zoho Inventory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Inventory in real time.
-
Bind Live Act-On Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Act-On data
-
Analyze MongoDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MongoDB and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Antigravity CLI with Telegram via CData CLI
Connect Telegram to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create Datasets from Zuora in Domo Workbench and Build Visualizations of Zuora Data in Domo
Use the CData Software ODBC Driver for Zuora to create datasets from Zuora in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Odoo Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Odoo ERP.
-
How to Easily Query SAP BusinessObjects BI Data in OpenOffice Base
Connect to SAP BusinessObjects BI data in OpenOffice Base using the CData ODBC Driver for SAP BusinessObjects BI and generate reports with live data insights.
-
Automated Continuous Facebook Replication to Databricks
Use CData Sync for automated, continuous, customizable Facebook replication to Databricks.
-
Use Azure AI Foundry to Talk to Your Vertica 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 Vertica for you.
-
Connect to ZohoMarketingHub in SpagoBI
Create reports featuring live ZohoMarketingHub in SpagoBI Studio. Host ZohoMarketingHub reports on SpagoBI Server.
-
Use Agno to Talk to Your Oracle Service Cloud 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 Oracle Service Cloud for you.
-
Automate Active Directory Data Replication to SAP HANA
Use CData Sync to customize and automate Active Directory replication to SAP HANA.
-
Connect to Tavily Data in JRuby
Create a simple JRuby app with access to live Tavily.
-
Access Live GraphQL Data in Excel 365 Online (Excel for the web)
Connect to GraphQL from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Live FTP Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live FTP data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Rapidly Develop YouTube Analytics-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by YouTube Analytics.
-
Build Semantic Layer Views for Microsoft Ads Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Ads in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Ads.
-
Analyze Typeform Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Typeform with the CData JDBC Driver for Typeform.
-
Integrating Codex CLI with Amazon Marketplace 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.
-
Integrate Azure Analysis Services Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Analysis Services and integrate live Azure Analysis Services into your Power Automate tasks.
-
Connect to Basecamp Data in DBeaver
Use the CData ODBC Driver to connect to Basecamp in DBeaver.
-
Connect to Teradata Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Teradata and the SQL Gateway to access Teradata from Google Apps Script.
-
Automated Continuous Twilio Replication to Snowflake
Use CData Sync for automated, continuous, customizable Twilio replication to Snowflake.
-
Use the CData Software JDBC Driver for Wrike in MicroStrategy
Connect to Wrike in MicroStrategy Developer using the CData Software JDBC Driver for Wrike.
-
Viewing Sage Cloud Accounting Data in RAD Studio Data Explorer
How to view Sage Business Cloud Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Sage Cloud Accounting.
-
Build Google Directory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Directory and build Google Directory-connected web apps with Axios.
-
How to connect PolyBase to Unbounce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Unbounce.
-
How to connect to Hugging Face Data with Squirrel SQL client
Connect to Hugging Face and execute queries in the Squirrel SQL Client.
-
Automate Smartsheet Data Replication to SAP HANA
Use CData Sync to customize and automate Smartsheet replication to SAP HANA.
-
Use JayDeBeApi to access Mocean Data in Python
Use standard Python scripting and the development environment of your choice to access live Mocean.
-
How to create an RPA flow for Bannerbear Data in UiPath Studio
Use the Bannerbear ODBC Driver to create workflows that access real-time Bannerbear without any coding.
-
How to connect and process Atlassian Jira from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Atlassian Jira.
-
How to import HBase Data into Apache Solr
Use the CData Software JDBC Driver for HBase in Data Import Handler and create an automated import of Apache HBase to Apache Solr Enterprise Search platform.
-
Use ChatGPT to Talk to Your LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your LinkedIn Ads for you.
-
Extract, Transform, and Load Zoho CRM Data in Informatica PowerCenter
Create a simple Workflow for Zoho CRM in Informatica PowerCenter.
-
Getting Started with the CData JDBC Driver for MarkLogic
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for MarkLogic.
-
Query NetSuite Data from Node.js
Use the OData endpoint of the CData API Server to connect to your NetSuite CRM & ERP and perform CRUD operations on NetSuite from Node.js.
-
Access Live Zendesk Data in Excel 365 Online (Excel for the web)
Connect to Zendesk from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Jira from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Atlassian Jira, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData ADO.NET Provider for Ontraport
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to and Query Unbounce Data in QlikView over ODBC
Create data visualizations with Unbounce in QlikView.
-
How to Query Live Paddle Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Paddle data in natural language using Python.
-
Analyze Demio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Demio from Power Pivot. You will use the Table Import Wizard to load Demio. You can visually build the import query or use any SQL supported by the driver.
-
Automated Continuous Office 365 Replication to MySQL
Use CData Sync for automated, continuous, customizable Office 365 replication to MySQL.
-
Bind Live Dynamics 365 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Dynamics 365 data
-
Replicate Multiple MessageBird Accounts via the CData Sync CLI
Replicate multiple MessageBird accounts to one or many databases.
-
How to connect to Float Data from Spring Boot
Connect to Float in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate with Live Azure Synapse Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Azure Synapse from the MuleSoft Anypoint Platform to integrate live Azure Synapse into custom reports and dashboards.
-
How to Visualize BenchmarkEmail Data in Python with pandas
Use pandas and other modules to analyze and visualize live BenchmarkEmail in Python.
-
Connect to Vault CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Veeva Vault & Vault CRM.
-
How to connect to Google Calendar Data from Spring Boot
Connect to Google Calendar in a Spring Boot Application using the CData JDBC Driver for Google Calendar
-
Access Live SAP Fieldglass Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Fieldglass data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Analyze Vault CRM Data in Looker
Use CData Connect AI to connect to Vault CRM Data from Looker and build custom apps using live Veeva Vault & Vault CRM.
-
How to connect SharePoint with Oracle Eloqua Data through external lists
Provide Oracle Eloqua to SharePoint users as an external list.
-
Replicate Multiple Exact Online Accounts via the CData Sync CLI
Replicate multiple Exact Online accounts to one or many databases.
-
Automated Continuous Azure DevOps Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure DevOps replication to SingleStore.
-
Integrate Open WebUI with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Snowflake from within the chat interface.