CData Software - Knowledge Base
Recent Articles
-
Replicate Teamgate Data from PowerShell
Write a quick PowerShell script to query Teamgate. Use connectivity to the live data to replicate Teamgate to SQL Server.
-
Build a Simple VCL Application for Egnyte Data
How to build a simple VCL Application to view Egnyte in RAD Studio using the CData ODBC Driver for Egnyte.
-
Create Dashboards and Visualize Live Avro Data in Geckoboard
Use CData Connect AI to connect to live Apache Avro and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query SAP Business One Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP Business One and perform CRUD operations on SAP Business One from Node.js.
-
Excel Spreadsheet Automation on Deel Data with the QUERY Formula
Pull data from Deel, automate spreadsheets, and more with the QUERY formula.
-
Connect to Microsoft Exchange Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Microsoft Exchange as an External Source in Dremio.
-
Build Amazon Marketplace-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Amazon Marketplace Data and create custom apps in Bubble.
-
Getting Started with the CData JDBC Driver for Snapchat Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Snapchat Ads.
-
Integrate Impala Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Impala from Informatica Cloud.
-
Create Apps from Instagram Data in Qlik Sense Cloud
Use CData Connect AI to connect to Instagram Data and build apps from live Instagram in Qlik Sense Cloud.
-
Create Reports with OnePageCrm Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OnePageCrm.
-
Getting Started with the CData ADO.NET Provider for ElevenLabs
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Build Semantic Layer Views for MariaDB Data in APOS Live Data Gateway
Use the CData Connector for MariaDB in APOS Live Data Gateway to build Semantic Layer Views for MariaDB.
-
Use Biml to Build SSIS Tasks to Replicate AdRoll Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate AdRoll to SQL Server.
-
How to Connect to Live OData Services from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your OData for you.
-
Build YouTube Analytics Visualizations in Tableau Cloud
Use CData Connect AI to connect to live YouTube Analytics and build visualizations in Tableau Cloud.
-
Import Real-Time SAP Business One Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SAP Business One in ColdFusion.
-
Integrate Codat Data in Pentaho Data Integration
Build ETL pipelines based on Codat in the Pentaho Data Integration tool.
-
Create Dynamic Drip Grids Using the Infragistics XamDataGrid
Learn how you can connect Drip to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect DBeaver to Guru via a JDBC Driver
Manage Guru with visual tools in DBeaver like the query browser.
-
Build Freshdesk-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Freshdesk and build web apps with connectivity to live Freshdesk.
-
Building Dynamic Web Pages with HBase Data Using AngularJS
Create single-page applications with live connectivity to HBase using the CData API Server.
-
Create a Data Access Object for HCL Domino Data using JDBI
A brief overview of creating a SQL Object API for HCL Domino in JDBI.
-
Connect to Zoho Projects Data from Crystal Reports
Use CData Connect AI to connect to and report on live Zoho Projects from Crystal Reports.
-
Build Apps with Live Freshteam Data Using the Low-Code Development Platform of Mendix
Connect Freshteam with Mendix to build apps using the CData API Driver for JDBC.
-
Create Power BI Reports on Real-Time Salesforce Marketing Data
Use the CData ODBC Driver for Salesforce Marketing to visualize Salesforce Marketing Cloud in Power BI Desktop.
-
Connect to Deel Data in RazorSQL
Connect to Deel from wizards and query Deel from the GUI in the RazorSQL database management tool.
-
Add YouTube Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for YouTube Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create Datasets from Adobe Commerce in Domo Workbench and Build Visualizations of Adobe Commerce Data in Domo
Use the CData Software ODBC Driver for Adobe Commerce to create datasets from Adobe Commerce in Domo Workbench and then build visualizations in the Domo service.
-
Prepare, Blend, and Analyze SAP Ariba Procurement Data in Alteryx Designer (Connect AI)
Build workflows to access live SAP Ariba Procurement for self-service data analytics.
-
Integrate Theia IDE with Live ServiceNow Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use Azure AI Foundry to Talk to Your Microsoft Teams 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 Microsoft Teams for you.
-
Build Visualizations of Landbot Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Landbot in Birst.
-
Connect to Zendesk Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zendesk in the Denodo Virtual DataPort Administrator.
-
Deploy the ADO.NET Provider for Google Contacts on an SSRS Report Server
Connect to Google Contacts 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.
-
How to Connect to Microsoft Exchange Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Exchange. Leverage the pyodbc module for ODBC in Python.
-
Query Qualaroo Data as a MySQL Database in Node.js
Execute MySQL queries against Qualaroo from Node.js.
-
Build Pipelines with Live Basecamp Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Basecamp from Google Cloud Data Fusion, enabling the integration of live Basecamp into the building and management of effective data pipelines.
-
Analyze Live Google Spanner Data in SAS Viya
Use CData Connect AI to connect to Google Spanner from SAS Viya and deploy self-service analytics using live Google Spanner.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Oracle Service Cloud actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Automated Continuous Odoo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Odoo replication to Google BigQuery.
-
Replicate eBay Data from PowerShell
Write a quick PowerShell script to query eBay. Use connectivity to the live data to replicate eBay to SQL Server.
-
Consume Confluence OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Confluence feeds that reflect any changes in SAP Lumira.
-
Provide OData Services of ZohoDesk Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for ZohoDesk by developing a WCF Service Application.
-
Integrate CSV Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to CSV/TSV Files and integrate live CSV/TSV Files into your Power Automate tasks.
-
Import and Visualize Hive Data in Power View
Create data visualizations based on Apache Hive in Excel.
-
Build Dashboards with Azure Synapse Data in DBxtra
Create dynamic dashboards and perform analytics based on Azure Synapse in DBxtra.
-
Build Data Flows from ActiveCampaign to SQL Server using SSIS
Easily back up ActiveCampaign to SQL Server using the SSIS components for ActiveCampaign.
-
Create Informatica Mappings From/To a JDBC Data Source for Notion
Create Notion data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Open WebUI with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Outreach.io from within the chat interface.
-
Build Charts with LaunchDarkly Data in Clear Analytics
Create dynamic charts and perform analytics based on LaunchDarkly in Clear Analytics.
-
Build Agents in Relevance AI with Access to Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on MongoDB within intelligent agent workflows.
-
Bidirectional Access to Testmonitor Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Testmonitor in Filemaker Pro for Mac or Windows.
-
Connect to XML Data in RazorSQL
Connect to XML from wizards and query XML Files from the GUI in the RazorSQL database management tool.
-
How to Work with Act CRM Data in AWS Glue Jobs Using JDBC
Connect to Act CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Simplesat Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Simplesat in Microsoft R Open.
-
Integrate Eventbrite with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Eventbrite with External Services.
-
Query HubDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against HubDB from Node.js.
-
How to Easily Query ZohoDesk Data in OpenOffice Base
Connect to ZohoDesk data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to Connect to Live Google Drive Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Google Drive for you.
-
Use Azure AI Foundry to Talk to Your Office 365 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 Microsoft Office 365 for you.
-
Natively Connect to SAP SuccessFactors Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAP SuccessFactors. Leverage the native support for ODBC in PHP.
-
How to use SQLAlchemy ORM to access Amplitude Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Amplitude.
-
Query Azure Analysis Services Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Azure Analysis Services entities in PHP by modeling them as objects.
-
Create Apps from Google Calendar Data in Qlik Sense Cloud
Use CData Connect AI to connect to Google Calendar Data and build apps from live Google Calendar in Qlik Sense Cloud.
-
DataBind Controls to Greenhouse Data in C++Builder
DataBind to Greenhouse in C++Builder with standard components and controls.
-
Build Trello-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Trello Data and create custom apps in Mendix.
-
Use the CData Software ODBC Driver for ADP in SAS for Real-Time Reporting and Analytics
Connect to real-time ADP in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ADP.
-
Replicate Wistia Data from PowerShell
Write a quick PowerShell script to query Wistia. Use connectivity to the live data to replicate Wistia to SQL Server.
-
Connect to Gong Data in RapidMiner
Integrate Gong with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Visualize SAP Netweaver Gateway 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 SAP Netweaver Gateway in Python.
-
Query, Visualize, and Share live Sybase IQ Data in Redash
Use CData Connect AI to connect to live Sybase IQ in Redash for querying, visualizing, and sharing.
-
Create Amazon DynamoDB-Connected Applications in Appsmith
Connect to Amazon DynamoDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Amazon DynamoDB.
-
Use Databricks Agent Bricks to Talk to Your Klaviyo Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Klaviyo for you.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoom within intelligent workflows.
-
Analyze Confluence Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Atlassian Confluence and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Natively Connect to Short.io Data in PHP
The CData ODBC driver for Short.io enables you to create PHP applications with connectivity to Short.io. Leverage the native support for ODBC in PHP.
-
Getting Started with the CData JDBC Driver for ShipEngine
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for ShipEngine.
-
How to connect to Mistral AI Data from IntelliJ
Integrate connectivity to Mistral AI with wizards in IntelliJ.
-
Build Apps with Live Reckon Data Using the Low-Code Development Platform of Mendix
Connect Reckon with Mendix to build apps using the CData JDBC Driver for Reckon.
-
Connect to Kafka Data from a Connection Pool in Jetty
The Kafka JDBC Driver supports connection pooling: This article shows how to connect faster to Apache Kafka from Web apps in Jetty.
-
Automated Continuous Smartsheet Replication to MongoDB
Use CData Sync for automated, continuous, customizable Smartsheet replication to MongoDB.
-
Integrate with Vault CRM Data in JReport Designer
Create charts and reports based on Veeva Vault & Vault CRM in JReport Designer.
-
Automated Continuous SAP Ariba Source Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to AlloyDB.
-
DataBind Charts to BigCommerce Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to BigCommerce 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.
-
How to Import Data from Quickbase into Google Sheets
Import Quickbase into a Google spreadsheet that is automatically refreshed.
-
Connecting Pipedream with Google Ads 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 Google Ads data in real time.
-
Connect to ZohoPeople Data in CloverDX (formerly CloverETL)
Transfer ZohoPeople using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Ontraport Replication to Oracle
Use CData Sync for automated, continuous, customizable Ontraport replication to Oracle.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in SAS for Real-Time Reporting and Analytics
Connect to real-time SAP SuccessFactors in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SAP SuccessFactors.
-
Use Biml to Build SSIS Tasks to Replicate Zoho Recruit Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Zoho Recruit to SQL Server.
-
Use Claude to Talk to Your SQL Analysis Services 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 Analysis Services for you.
-
How to work with Reckon Accounts Hosted Data in Apache Spark using SQL
Access and process Reckon Accounts Hosted Data in Apache Spark using the CData Software JDBC Driver.
-
Query, Visualize, and Share live Sage 200 Data in Redash
Use CData Connect AI to connect to live Sage 200 in Redash for querying, visualizing, and sharing.
-
Automate Avalara AvaTax Data Replication to Couchbase
Use CData Sync to Customize and automate Avalara AvaTax replication to Couchbase.
-
Integrate with Foursquare Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Foursquare to a JSON file on disk.
-
Zoho CRM: "Invalid_Client" Error After Successful OAuth Authorization
In this entry, you will find the resolution to the most common cause of the "Invalid_Client" error, despite seeing a successful OAuth authorization in the browser.
-
Query Avalara AvaTax Data in DataGrip
Create a Data Source for Avalara AvaTax in DataGrip and use SQL to query live Avalara AvaTax.
-
Build Tanda-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Tanda and build web apps with connectivity to live Tanda.
-
Automated Continuous Dotmailer Replication to Vertica
Use CData Sync for automated, continuous, customizable Dotmailer replication to Vertica.