CData Software - Knowledge Base
Recent Articles
-
How to Visualize Vimeo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Vimeo data in Python.
-
Integrate Zoho Creator Data into Power Automate Desktop using CData Connect
CData Connect for Zoho Creator Data enables you to integrate Zoho Creator data into workflows built using Microsoft Power Automate Desktop.
-
Model, Search, and Visualize Live AfterShip Data in ThoughtSpot
Use CData Connect AI to connect to live AfterShip data for modeling, searching, and visualizing.
-
Use Azure AI Foundry to Talk to Your Oracle Financials Cloud 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 Oracle Financials Cloud data for you.
-
Automate RSS Feeds Replication to SAP HANA
Use CData Sync to customize and automate RSS feeds replication to SAP HANA.
-
Create Jumpseller-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Jumpseller Data from OutSystems and build custom enterprise apps using live Jumpseller data.
-
Use Dash to Build Web Apps on Salesforce Data 360 Data via CData Connect AI
Build interactive Dash web apps on live Salesforce Data 360 data using pandas and the CData Connect AI Python SDK.
-
Connect to ZohoPeople Data in ACL Analytics
Connect to ZohoPeople data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoPeople data.
-
Tavily Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Tavily facts in real time.
-
Integrating Codex with Act-On 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 Oracle-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Oracle Data from Zoho Analytics and import live Oracle data.
-
Connecting Mastra with Authorize.Net 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 Authorize.Net data, no replication required.
-
Connect to SAP Fieldglass Data from PowerBuilder via JDBC
This article demonstrates how to access SAP Fieldglass data from PowerBuilder using the SAP Fieldglass JDBC Driver.
-
Build Data Flows from SQL Server to Oracle Eloqua through SSIS
Easily push SQL Server data to Oracle Eloqua using the CData SSIS Tasks for Oracle Eloqua.
-
Automated Continuous Bullhorn CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to MySQL.
-
Enable the Google Forms JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Forms data.
-
Use CData Connect AI to Access Zoho Books Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Zoho Books data in the Power Pivot business intelligence tool.
-
Build Adobe Analytics-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Adobe Analytics Data and create custom apps in Mendix.
-
How to Connect Flowise AI Agents to Live SAP Fieldglass 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 SAP Fieldglass data without replication.
-
How to work with Postmark Data in Apache Spark using SQL
Access and process Postmark Data in Apache Spark using the CData Software JDBC Driver.
-
Explore Geographical Relationships in Campaigner Data with Power Map
Create data visualizations with Campaigner data in Power Map.
-
Access Google Contacts Data from MySQL in PHP
Connect to Google Contacts through the standard MySQL libraries in PHP.
-
Interact with Live MariaDB Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live MariaDB data.
-
Automated Continuous Microsoft Teams Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Microsoft Teams replication to Google BigQuery.
-
Access Live Monday.com Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Monday.com data from your Excel spreadsheets.
-
Create Power BI Reports on Real-Time Adobe Experience Manager Data
Use the CData ODBC Driver for Adobe Experience Manager to visualize Adobe Experience Manager data in Power BI Desktop.
-
Integrate Google Spanner Data in the Pentaho Report Designer
Publish reports based on Google Spanner data in the Pentaho BI tool.
-
Analyze SparkPost Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SparkPost data and visualize SparkPost data in SAP Analytics Cloud.
-
Create ServiceNow-Connected Applications in Appsmith
Connect to ServiceNow Data via CData Connect AI in Appsmith and create custom business applications with real-time access to ServiceNow data.
-
Integrating OpenCode with Pingdom 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 Excel Online Data from HeidiSQL
Use CData Connect AI to connect to and query live Excel Online data from HeidiSQL.
-
Access Live Optimizely Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Optimizely data from your Excel spreadsheets.
-
Connect to IBM Informix Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for IBM Informix data.
-
Visualize EnterpriseDB Data in TIBCO Spotfire through OData
Integrate EnterpriseDB data into dashboards in TIBCO Spotfire.
-
How to connect PolyBase to LinkedIn
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live LinkedIn data.
-
Integrate with REST Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy REST data to a JSON file on disk.
-
Visualize OneNote 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 OneNote data into TIBCO Spotfire.
-
Connect to Bright Data Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Bright Data data.
-
Use Azure AI Foundry to Talk to Your ZohoInvoice 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 ZohoInvoice data for you.
-
Use Azure AI Foundry to Talk to Your Guru 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 Guru data for you.
-
Migrating data from Couchbase to Databricks using CData SSIS Components.
Easily push Couchbase data to Databricks using the CData SSIS Tasks for Couchbase and Databricks.
-
How to Connect to Live Sugar CRM Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Sugar CRM data for you.
-
How to Connect DBeaver to SAP Fieldglass via a JDBC Driver
Manage SAP Fieldglass data with visual tools in DBeaver like the query browser.
-
How to integrate Google Tasks with Apache Airflow
Access and process Google Tasks data in Apache Airflow using the CData JDBC Driver.
-
Connect to LeadDesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LeadDesk data using standard SQL.
-
Object-Relational Mapping (ORM) with Elorus Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Elorus data into a Java-based ORM framework, Hibernate.
-
Create Data Visualizations in Cognos BI with OData Services
Access OData services as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Devin with Live Vertica Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Vertica data.
-
Replicate Multiple Jira Accounts
Replicate multiple Jira accounts to one or many databases.
-
Integrating Perplexity Data in Talend Cloud Data Management Platform
Connect Perplexity Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Query Contentful Data in ColdFusion
Write standard ColdFusion data access code to connect to Contentful data.
-
Connect SAP Concur to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP Concur with IBM WebSphere for seamless data integration and connectivity.
-
Integrating OpenCode with ConstantContact 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 Real-Time Oracle Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle and Dataflow to import and use Oracle data in Power Apps.
-
Build iContact Visualizations in Tableau Desktop
Use CData Connect AI to connect to live iContact data and build visualizations in Tableau.
-
Create Apify-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Apify Data from Klipfolio and build custom visualizations using live Apify data.
-
Create Informatica Mappings From/To a JDBC Data Source for Avro
Create Avro data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Pipelines with Live Excel Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Excel Online from Google Cloud Data Fusion, enabling the integration of live Excel Online data into the building and management of effective data pipelines.
-
How to import Onfleet Data into Apache Solr
Use the CData Software JDBC Driver for Onfleet in Data Import Handler and create an automated import of Onfleet data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData ADO.NET Provider for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Visualize Dynamics 365 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 Dynamics 365 data into TIBCO Spotfire.
-
Automated Continuous Front Replication to MongoDB
Use CData Sync for automated, continuous, customizable Front replication to MongoDB.
-
How to use SQLAlchemy ORM to access Azure Data Catalog Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Azure Data Catalog data.
-
Connect to Dotmailer Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Dotmailer data using standard SQL.
-
A PostgreSQL Interface for Shopify Data using the CData ODBC Driver
Use the SQL Gateway and Shopify ODBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for Spark
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Spark.
-
Operational Reporting on HCL Domino Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote HCL Domino data.
-
Replicate ServiceDesk Plus Data from PowerShell
Write a quick PowerShell script to query ServiceDesk Plus data. Use connectivity to the live data to replicate ServiceDesk Plus data to SQL Server.
-
How to Connect to Live Spark Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Spark data securely in real time.
-
How to Visualize Dynamics 365 Business Central Data in Python with pandas
Use pandas and other modules to analyze and visualize live Dynamics 365 Business Central data in Python.
-
How to Query Live Microsoft Teams Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Teams data data in natural language using Python.
-
How to connect to Airtable Data with Squirrel SQL client
Connect to Airtable data and execute queries in the Squirrel SQL Client.
-
How to Connect to Live PingOne Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live PingOne data without replication.
-
ConvertKit Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ConvertKit facts in real time.
-
Use ChatGPT to Talk to Your Couchbase 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 Couchbase data for you.
-
Use the CData Software JDBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps data in MicroStrategy Desktop using the CData Software JDBC Driver for Azure DevOps.
-
Use ChatGPT to Talk to Your Sage 200 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 Sage 200 data for you.
-
Create Reports from Discord Data in Looker Studio
Use CData Connect AI to gain access to live Discord data and create custom reports in Looker Studio.
-
Connect to Freshservice Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Freshservice data.
-
Back Up XML data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for XML. In this article, we will employ an SSIS workflow to populate a database with XML data data.
-
How to create Salesforce federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce data in MySQL .
-
Bidirectional Access to Gmail Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Gmail data in Filemaker Pro for Mac or Windows.
-
Connect to and Query Authorize.Net Data in QlikView over ODBC
Create data visualizations with Authorize.Net data in QlikView.
-
Extract, Transform, and Load MessageBird Data in Informatica PowerCenter
Create a simple Workflow for MessageBird data in Informatica PowerCenter.
-
Excel Spreadsheet Automation on Auth0 Data with the QUERY Formula
Pull data from Auth0, automate spreadsheets, and more with the QUERY formula.
-
Integrate NASA Data in Pentaho Data Integration
Build ETL pipelines based on NASA data in the Pentaho Data Integration tool.
-
Query Live Microsoft Dataverse 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 Microsoft Dataverse data directly from the development environment.
-
Automated Continuous ActiveCampaign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to AlloyDB.
-
Integrating LangGraph with Xero Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Xero data within automated workflows.
-
Connect to Sendwithus Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Sendwithus data.
-
Access Live OneNote Data in Coginiti Pro
Connect to and query live OneNote data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Establish a Live Connection with Humanity Data using Tableau Bridge
The CData ODBC Driver for Humanity enables you to integrate live Humanity data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to JSON Services in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for JSON services in Airbyte.
-
Getting Started with the CData ODBC Driver for FormSite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for FormSite.
-
Integrate Theia IDE with Live API Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live API data from within the development environment.
-
Automated Continuous Accelo Replication to Vertica
Use CData Sync for automated, continuous, customizable Accelo replication to Vertica.
-
Connect to Azure DevOps from a Connection Pool in WebLogic
Use the CData JDBC Driver for Azure DevOps to connect to Azure DevOps data from Web applications running on WebLogic.
-
Publish Crystal Reports on Certinia Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Certinia data.
-
Create Informatica Mappings From/To an ODBC Data Source for FreshBooks
Create an ODBC connection to FreshBooks in Informatica and browse and transfer FreshBooks data.
-
Build a Simple VCL Application for Google Forms Data
How to build a simple VCL Application to view Google Forms data in RAD Studio using the CData ODBC Driver for Google Forms.