CData Software - Knowledge Base
Recent Articles
-
Visualize Live YouTube Analytics Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live YouTube Analytics data into custom reports in Power BI.
-
Connect to QuickBooks Online Data from a Connection Pool in JBoss
Integrate QuickBooks Online data into Java servlets: Use the Management Console in JBoss to install the QuickBooks Online JDBC Driver.
-
Access Live Microsoft Entra ID Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Microsoft Entra ID data through MCP integration.
-
Integrate Trae with Live Zendesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Zendesk data from within the AI-powered IDE.
-
Bridge Adobe Analytics Connectivity with Apache NiFi
Access and process Adobe Analytics data in Apache NiFi using the CData JDBC Driver.
-
Connect to Active Directory Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Active Directory data.
-
Getting Started with the CData ADO.NET Provider for Gumroad
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to connect to LightSpeedRetail Data with Squirrel SQL client
Connect to LightSpeedRetail data and execute queries in the Squirrel SQL Client.
-
Use Azure AI Foundry to Talk to Your Paylocity 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 Paylocity data for you.
-
Design BIRT Reports on SageHR Data
Provide current SageHR data to your embedded analytics.
-
Integrate Goose with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zoho Books data from within the local AI agent.
-
Build Charts with SAP Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP data in Clear Analytics.
-
Query Live HBase 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 HBase data directly from the development environment.
-
Integrate OpenCode with Live Cvent Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Cvent data from within your AI coding agent.
-
Consume eBay OData Feeds in PowerBuilder
This article demonstrates how to consume eBay data as OData feeds from PowerBuilder using the API Server.
-
Automated Continuous Intercom Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Intercom replication to Amazon S3.
-
Migrating data from HBase to Snowflake using CData SSIS Components.
Easily push HBase data to Snowflake using the CData SSIS Tasks for HBase and Snowflake.
-
Back Up Ontraport data 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 Ontraport data data.
-
DataBind Charts to ZendeskSell Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZendeskSell 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.
-
Visualize SAP SuccessFactors LMS Data in TIBCO Spotfire through ADO.NET
Integrate SAP SuccessFactors LMS data into dashboards in TIBCO Spotfire.
-
Access Live Discord Data in Coginiti Pro
Connect to and query live Discord data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create a Data Access Object for Smartsheet Data using JDBI
A brief overview of creating a SQL Object API for Smartsheet data in JDBI.
-
Access Live Azure Synapse Data in Coginiti Pro
Connect to and query live Azure Synapse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ElevenLabs
Provide connectivity to ElevenLabs data through an SAP BusinessObjects universe.
-
How to connect and process SAP Business One data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Business One data.
-
Connect to CouchDB Data from AWS Glue
Use CData Connect AI to gain access to live CouchDB data from your AWS Glue jobs.
-
Build Semantic Layer Views for Sentry Data in APOS Live Data Gateway
Use the CData Connector for Sentry in APOS Live Data Gateway to build Semantic Layer Views for Sentry data.
-
Import Shortcut Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Shortcut Data and provide access to live Shortcut data for custom reports in the Power BI Service.
-
How to Build an ETL App for Microsoft Planner Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Planner data in Python with petl.
-
Visualize BambooHR 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 BambooHR data into TIBCO Spotfire.
-
Integrate OpenCode with Live Microsoft Dataverse Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Microsoft Dataverse data from within your AI coding agent.
-
How to use SQLAlchemy ORM to access WooCommerce Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of WooCommerce data.
-
Visualize Live MailChimp Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live MailChimp data.
-
Automated Continuous Discord Replication to Snowflake
Use CData Sync for automated, continuous, customizable Discord replication to Snowflake.
-
Connect to ClickUp Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ClickUp Data and connect to ClickUp data in Akorbi Digital RunMyProcess.
-
How to Use a Microsoft Access Database to Update Amazon Athena Data in Real Time
Update Amazon Athena data by creating a linked table in Microsoft Access with the CData Amazon Athena ODBC Driver.
-
How to Connect DBeaver to Avro via a JDBC Driver
Manage Avro data with visual tools in DBeaver like the query browser.
-
Access Live Ontraport Data in Coginiti Pro
Connect to and query live Ontraport data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query ZohoInvoice Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ZohoInvoice data from Node.js.
-
Access Aweber Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aweber data from HeidiSQL.
-
Integrate with Mixpanel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mixpanel data to a JSON file on disk.
-
Connect to Instantly Data in Aqua Data Studio
Access Instantly data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Data Visualizations in Cognos BI with Reckon Data
Access Reckon data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Model Amazon DynamoDB Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Amazon DynamoDB, enabling the direct import of real-time Amazon DynamoDB data.
-
Connect Sybase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Sybase data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Query SpaceX Data in MySQL Workbench
Execute MySQL queries against live SpaceX data from MySQL Workbench.
-
Connect and Query Live Google Campaign Manager 360 Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Campaign Manager 360 data into Databricks and enable direct, live querying and analysis without replication.
-
Integrate with Planio Data in JReport Designer
Create charts and reports based on Planio data in JReport Designer.
-
Connect to OnePageCrm Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to OnePageCrm.
-
Use ChatGPT to Talk to Your Avalara AvaTax 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 Avalara AvaTax data for you.
-
Use the CData Software ODBC Driver for Adobe Target in MicroStrategy Web
Connect to Adobe Target data in MicroStrategy Web using the CData Software ODBC Driver for Adobe Target.
-
Build a PostgreSQL Interface for Exa Data using the CData JDBC Driver
Use the Remoting features of the Exa JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bidirectional Access to Sage Cloud Accounting Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage Cloud Accounting data in Filemaker Pro for Mac or Windows.
-
Replicate PayPal Data in Heroku for Use in Salesforce Connect
Replicate PayPal data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Automated Continuous Helpscout Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Helpscout data replication to OneLake in Microsoft Fabric.
-
Integrating Cursor with Act CRM 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.
-
Visualize Simplesat Data in Sisense
Create an ElastiCube in Sisense app with access to Simplesat data.
-
Integrate Live Google Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Google Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Google Ads data.
-
Query SAP Ariba Source Data as a MySQL Database in Node.js
Execute MySQL queries against SAP Ariba Source data from Node.js.
-
Excel Spreadsheet Automation on Salesforce CRM Analytics Data with the QUERY Formula
Pull data from Salesforce CRM Analytics, automate spreadsheets, and more with the QUERY formula.
-
How to Access Live ConvertAPI Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ConvertAPI enables you to integrate ConvertAPI data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Harvest Replication to Snowflake
Use CData Sync for automated, continuous, customizable Harvest replication to Snowflake.
-
Use the CData Software ODBC Driver for ScrapingBee in MicroStrategy
Connect to ScrapingBee data in MicroStrategy Developer using the CData Software ODBC Driver for ScrapingBee.
-
Integrate Live Phoenix Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Phoenix data to Blue Prism using the CData ODBC Driver for Phoenix to create automated workflows for repetitive business tasks.
-
How to work with Productboard Data in Apache Spark using SQL
Access and process Productboard Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect to Klipfolio Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Klipfolio data. Leverage the pyodbc module for ODBC in Python.
-
Prepare, Blend, and Analyze CloudConvert Data in Alteryx Designer (ODBC)
Build workflows to access live CloudConvert data for self-service data analytics.
-
Integrate Oracle Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Oracle data from Informatica Cloud.
-
Visualize ServiceNow Data in Tableau
The CData ODBC driver for ServiceNow enables you integrate ServiceNow data into Tableau dashboards.
-
Connect to iContact Data in RapidMiner
Integrate iContact data with standard components and data source configuration wizards in RapidMiner Studio.
-
Query Amazon Marketplace Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Amazon Marketplace entities in PHP by modeling them as objects.
-
Connect to Airtable Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Airtable.
-
Analyze CloudConvert Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze CloudConvert data with the CData JDBC Driver for CloudConvert.
-
Import and Visualize Raisers Edge NXT Data in Power View
Create data visualizations based on Raisers Edge NXT data in Excel.
-
Connect SAP Ariba Procurement to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP Ariba Procurement data using the CData Python MCP Server.
-
Automated Continuous BambooHR Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable BambooHR replication to Apache Cassandra.
-
Analyze SAP Netweaver Gateway Data in Cognos Analytics
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Cognos Analytics and analyze live SAP Netweaver Gateway data.
-
Access QuickBooks from RazorSQL
Connect to QuickBooks company file data through the RazorSQL database query tool.
-
Connect to PayPal Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for PayPal data in the Denodo Virtual DataPort Administrator.
-
Connect to Azure Synapse Data from a Connection Pool in Jetty
The Azure Synapse JDBC Driver supports connection pooling: This article shows how to connect faster to Azure Synapse data from Web apps in Jetty.
-
Automate Marketo Data Replication to Azure Synapse
Use CData Sync to customize and automate Marketo data replication to Azure Synapse.
-
Automated Continuous Square Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Square replication to Apache Kafka.
-
Integrating LlamaIndex with Facebook Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Facebook data in real time.
-
Getting Started with the CData Python Connector for PayPal
Learn to install and license the CData Python Connector and configure a connection to live PayPal data.
-
Import Real-Time YouTube Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use YouTube Analytics data in ColdFusion.
-
Connect to Microsoft Exchange Data in CloverDX (formerly CloverETL)
Transfer Microsoft Exchange data using the visual workflow in the CloverDX data integration tool.
-
Connect and Visualize Live Dynamics CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Dynamics CRM data into the Databricks platform and create visualization dashboards with real-time Dynamics CRM data.
-
Access Opsgenie Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Opsgenie data from your Oracle system.
-
Use CData Connect AI to Access SAS Data Sets Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAS Data Sets data in the Power Pivot business intelligence tool.
-
Integrating Kiro with Microsoft Entra ID 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.
-
Build an OLAP Cube in SSAS from Google Cloud Storage Data
Establish a connection to Google Cloud Storage data data from SQL Server Analysis Services, and use the Google Cloud Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Google's Antigravity Agent with Live Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Okta data using the Model Context Protocol.
-
How to connect PolyBase to Omnisend
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Omnisend data.
-
Establish a Live Connection with Nuclia Data using Tableau Bridge
The CData ODBC Driver for Nuclia enables you to integrate live Nuclia data into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Salesforce Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Salesforce data and visualize live Salesforce data in Infragistics Reveal.
-
Build Teradata-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Teradata data and build Teradata-connected web apps with Axios.
-
Replicate Mouseflow Data in Heroku for Use in Salesforce Connect
Replicate Mouseflow data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create SuiteCRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SuiteCRM Data from OutSystems and build custom enterprise apps using live SuiteCRM data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Clari
Provide connectivity to Clari data through an SAP BusinessObjects universe.
-
Automated Drip Data Replication to Teradata
Use CData Sync to Customize and automate Drip data replication to Teradata.