CData Software - Knowledge Base
Recent Articles
-
Query Redshift Data as a MySQL Database in Node.js
Execute MySQL queries against Redshift data from Node.js.
-
Enable the ZohoInvoice JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZohoInvoice data.
-
Connect to and Query MongoDB Data in QlikView over ODBC
Create data visualizations with MongoDB data in QlikView.
-
Automated Continuous Pipeline CRM Replication to SingleStore
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to SingleStore.
-
How to Query Snowflake Data in MySQL Workbench
Execute MySQL queries against live Snowflake data from MySQL Workbench.
-
Build Oracle-Connected Apps in Choreo
Use CData Connect AI to connect to Oracle Data from Choreo and build custom apps using live Oracle data.
-
Build Semantic Layer Views for Trello Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Trello data.
-
Create Informatica Mappings From/To an ODBC Data Source for Adobe Analytics
Create an ODBC connection to Adobe Analytics in Informatica and browse and transfer Adobe Analytics data.
-
Create Data Visualizations Based On Mailjet Data in Mode
Use CData Connect AI to connect to Mailjet Data from Mode and build visualizations using live Mailjet data.
-
Automate Ontraport Data Replication to SAP HANA
Use CData Sync to customize and automate Ontraport data replication to SAP HANA.
-
How to connect to MYOB AccountRight Data from IntelliJ
Integrate connectivity to MYOB AccountRight data with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access Sybase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Sybase data.
-
DataBind Controls to Google Drive Data in C++Builder
DataBind to Google Drive data in C++Builder with standard components and controls.
-
Visualize Live Pinterest Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Pinterest data.
-
Getting Started with the CData Excel Add-In for AgileCRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for AgileCRM.
-
Visualize PayPal Data in Tableau
The CData ODBC driver for PayPal enables you integrate PayPal data into Tableau dashboards.
-
Getting Started with the CData JDBC Driver for AlloyDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for AlloyDB.
-
Build Pipelines with Live Cloudant Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Cloudant from Google Cloud Data Fusion, enabling the integration of live Cloudant data into the building and management of effective data pipelines.
-
Use CData Connect AI to Access Salesforce Data 360 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Salesforce Data 360 data in the Power Pivot business intelligence tool.
-
Build Semantic Layer Views for IBM Informix Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for IBM Informix data.
-
Validate PabblySubscriptions Data with QuerySurge
Access and validate PabblySubscriptions data in QuerySurge using the CData JDBC Driver.
-
Automate Vertica Data Replication to Couchbase
Use CData Sync to Customize and automate Vertica data replication to Couchbase.
-
Connect to Helpscout Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Helpscout and work with Helpscout data in your FileMaker applications.
-
Integrating OpenCode with Zoho Projects 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.
-
Analyze Salesloft Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Salesloft data in Microsoft R Open.
-
Prepare, Blend, and Analyze ZohoInvoice Data in Alteryx Designer (ODBC)
Build workflows to access live ZohoInvoice data for self-service data analytics.
-
Integrate with Freshteam Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Freshteam data in SnapLogic.
-
Access Live Databricks Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Databricks data from your Excel spreadsheets.
-
Query Paylocity Data in ColdFusion
Write standard ColdFusion data access code to connect to Paylocity data.
-
Automated Continuous Paylocity Replication to Snowflake
Use CData Sync for automated, continuous, customizable Paylocity replication to Snowflake.
-
Visualize Dotmailer Data in Tableau
The CData ODBC driver for Dotmailer enables you integrate Dotmailer data into Tableau dashboards.
-
Access Live LDAP Objects in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live LDAP objects from your Google Sheets.
-
Integrate Hive Data in Pentaho Data Integration
Build ETL pipelines based on Hive data in the Pentaho Data Integration tool.
-
Automated Continuous SAP ByDesign Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to MongoDB.
-
Automated Continuous Avro Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Avro replication to Apache Cassandra.
-
How to connect to HubSpot Data from IntelliJ
Integrate connectivity to HubSpot data with wizards in IntelliJ.
-
Excel Spreadsheet Automation on Cassandra Data with the QUERY Formula
Pull data from Cassandra, automate spreadsheets, and more with the QUERY formula.
-
Visualize Live Microsoft Teams Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Microsoft Teams data into custom reports in Power BI.
-
Explore Geographical Relationships in Zuora Data with Power Map
Create data visualizations with Zuora data in Power Map.
-
Build MVC Applications with Connectivity to Amplitude Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Amplitude from an ASP.NET MVC application.
-
Integrating Codex with Dynamics 365 Business Central 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.
-
Access Live Splunk Data in TIBCO Data Virtualization
Use the Splunk Tibco DV Adapter to create a Splunk data data source in TIBCO Data Virtualization Studio and gain access to live Splunk data from your TDV Server.
-
Build Salesforce Marketing Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce Marketing data and build visualizations in Tableau.
-
Build AI Agents with Sage Cloud Accounting Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sage Cloud Accounting data through CData Connect AI.
-
Integrate Real-Time Access to Office 365 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Office 365 data in real time.
-
How to Seamlessly Import MailChimp Data into IBM SPSS Modeler
Integrate MailChimp data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Bridge Opsgenie Connectivity with Apache NiFi
Access and process Opsgenie data in Apache NiFi using the CData JDBC Driver.
-
Odoo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Odoo facts in real time.
-
Automated Continuous ZohoPeople Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ZohoPeople replication to Amazon S3.
-
How to Query GitLab Data in MySQL Workbench
Execute MySQL queries against live GitLab data from MySQL Workbench.
-
Connect to HDFS in SpagoBI
Create reports featuring live HDFS data in SpagoBI Studio. Host HDFS reports on SpagoBI Server.
-
Integrate with Live Coda Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Coda from the MuleSoft Anypoint Platform to integrate live Coda data into custom reports and dashboards.
-
Connect to Shopify Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Shopify data.
-
Build an OLAP Cube in SSAS from Supabase Data
Establish a connection to Supabase data data from SQL Server Analysis Services, and use the Supabase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Mastra with Toggl 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 Toggl data, no replication required.
-
How to Visualize Demio Data in Python with pandas
Use pandas and other modules to analyze and visualize live Demio data in Python.
-
Analyze CockroachDB Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of CockroachDB data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Salesforce CRM Analytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Salesforce CRM Analytics data and build Salesforce CRM Analytics-connected web apps with Axios.
-
Build Voice Agents in ElevenLabs with access to Live Pinterest Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Pinterest data.
-
A PostgreSQL Interface for Google Directory Data using the CData ODBC Driver
Use the SQL Gateway and Google Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize IBM Cloud Object Storage Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM Cloud Object Storage data.
-
Using the CData Software ODBC Driver for Dynamics 365 in PyCharm
Connect to Dynamics 365 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics 365.
-
Using the CData Software ODBC Driver for Highrise in PyCharm
Connect to Highrise as an ODBC data source in PyCharm using the CData Software ODBC Driver for Highrise.
-
Visualize Google Cloud Storage 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 Google Cloud Storage data into TIBCO Spotfire.
-
Building Dynamic Web Pages with Salesforce CRM Analytics Data Using AngularJS
Create single-page applications with live connectivity to Salesforce CRM Analytics using the CData API Server.
-
Integrating GitHub Copilot with Redshift 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.
-
Use the CData Software ODBC Driver for Parallel in MicroStrategy Desktop
Connect to Parallel data in MicroStrategy Desktop using the CData Software ODBC Driver for Parallel.
-
Create Reports with Pushbullet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pushbullet data.
-
Visualize Live Amazon Athena Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon Athena data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Quaderno Data in Aqua Data Studio
Access Quaderno data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Quaderno Data from MySQL in PHP
Connect to Quaderno through the standard MySQL libraries in PHP.
-
Analyze Shippo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Shippo from Power Pivot. You will use the Table Import Wizard to load Shippo data. You can visually build the import query or use any SQL supported by the driver.
-
Create Twitter Ads-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Twitter Ads Data from OutSystems and build custom enterprise apps using live Twitter Ads data.
-
How to Connect Flowise AI Agents to Live Sybase Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Sybase data without replication.
-
Integrate Google's Vertex AI Agent with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Zoho Projects data within intelligent workflows.
-
Connect to Anaplan Data from AWS Glue
Use CData Connect AI to gain access to live Anaplan data from your AWS Glue jobs.
-
View Reports on Real-Time Google Drive Data in Power BI Report Server
Use the CData ODBC Driver for Google Drive to visualize Google Drive data in Power BI Desktop and then publish them to Power BI Report Server.
-
Natively Connect to Amazon Athena Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Amazon Athena data. Leverage the native support for ODBC in PHP.
-
How to Visualize Google Ads 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 Google Ads data in Python.
-
Automated Continuous Outlook Replication to Vertica
Use CData Sync for automated, continuous, customizable Outlook replication to Vertica.
-
Use the CData Software JDBC Driver for SAP SuccessFactors LMS in MicroStrategy Desktop
Connect to SAP SuccessFactors LMS data in MicroStrategy Desktop using the CData Software JDBC Driver for SAP SuccessFactors LMS.
-
Enable the Humanity JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Humanity data.
-
Integrating Kiro with AgileCRM 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 ChartMogul Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ChartMogul to connect to ChartMogul data and execute queries in PowerBuilder.
-
Automated Continuous ClickTime Replication to Oracle
Use CData Sync for automated, continuous, customizable ClickTime replication to Oracle.
-
Build Pinterest-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pinterest data.
-
Connecting Moonlit Workflow with Sybase IQ 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 Sybase IQ data in real time.
-
How to Access Live SharePoint Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SharePoint enables you to integrate SharePoint data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Splunk 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 Jumpseller 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 Jumpseller data into TIBCO Spotfire.
-
Import MYOB AccountRight Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to MYOB AccountRight Data and provide access to live MYOB AccountRight data for custom reports in the Power BI Service.
-
Build Apps with Live Google Forms Data Using the Low-Code Development Platform of Mendix
Connect Google Forms data with Mendix to build apps using the CData API Driver for JDBC.
-
Integrating Kiro with Adobe Target 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.
-
Use the CData ODBC Driver for SuiteCRM in Microsoft Power Query
You can use the CData SuiteCRM ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SuiteCRM data into Microsoft Power Query.
-
How to create an RPA flow for GitLab Data in UiPath Studio
Use the GitLab ODBC Driver to create workflows that access real-time GitLab data without any coding.
-
Import and Visualize Telegram Data in Power View
Create data visualizations based on Telegram data in Excel.
-
Connect to Dynamics 365 Business Central Data from HeidiSQL
Use CData Connect AI to connect to and query live Dynamics 365 Business Central data from HeidiSQL.
-
Connect to Foursquare Data from a Connection Pool in JBoss
Integrate Foursquare data into Java servlets: Use the Management Console in JBoss to install the Foursquare JDBC Driver.
-
A PostgreSQL Interface for RabbitMQ Data (MySQL Remoting via JDBC)
Use the Remoting features of the RabbitMQ JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to work with Close Data in Apache Spark using SQL
Access and process Close Data in Apache Spark using the CData Software JDBC Driver.