CData Software - Knowledge Base
Recent Articles
-
How to connect to Yelp Data with Squirrel SQL client
Connect to Yelp data and execute queries in the Squirrel SQL Client.
-
Integrate Google's Vertex AI Agent with Live Active Directory 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 Active Directory data within intelligent workflows.
-
Perform Batch Operations with Epicor Kinetic Data in Apache NiFi
Connect to Epicor Kinetic data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use the CData Software ODBC Driver for IBM Cloud Object Storage in MicroStrategy Web
Connect to IBM Cloud Object Storage data in MicroStrategy Web using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
How to connect Amazon QuickSight to Certinia Data
Create a connection to Certinia data in CData Connect AI and insert Certinia data into Amazon QuickSight SPICE to build interactive dashboards.
-
Object-Relational Mapping (ORM) with Azure DevOps 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 Azure DevOps data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with HubDB Data in DBxtra
Create dynamic dashboards and perform analytics based on HubDB data in DBxtra.
-
Model, Search, and Visualize Live MailerLite Data in ThoughtSpot
Use CData Connect AI to connect to live MailerLite data for modeling, searching, and visualizing.
-
Build PingOne-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for PingOne Data and create custom apps in Mendix.
-
Integrating Kiro with REST 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 Zoho Projects Data in JRuby
Create a simple JRuby app with access to live Zoho Projects data.
-
Access Vault CRM Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Vault CRM data from your Oracle system.
-
View Reports on Real-Time Cosmos DB Data in Power BI Report Server
Use the CData ODBC Driver for Cosmos DB to visualize Cosmos DB data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Biml to Build SSIS Tasks to Replicate Vimeo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Vimeo data to SQL Server.
-
Automate Coda Data Replication to SAP HANA
Use CData Sync to customize and automate Coda data replication to SAP HANA.
-
Build Charts with Drip Data in Clear Analytics
Create dynamic charts and perform analytics based on Drip data in Clear Analytics.
-
How to connect to Miro Data in DBVisualizer
Integrate Miro data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Real-Time Access to GitHub in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to GitHub data in real time.
-
Build a PostgreSQL Interface for MariaDB Data using the CData JDBC Driver
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Outlook Replication to SingleStore
Use CData Sync for automated, continuous, customizable Outlook replication to SingleStore.
-
How to connect to SendInBlue Data in DBVisualizer
Integrate SendInBlue data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Spotify in SpagoBI
Create reports featuring live Spotify data in SpagoBI Studio. Host Spotify reports on SpagoBI Server.
-
Connect to Salesforce Data 360 from a Connection Pool in WebLogic
Use the CData JDBC Driver for Salesforce Data 360 to connect to Salesforce Data 360 data from Web applications running on WebLogic.
-
Automated Continuous Wistia Replication to SingleStore
Use CData Sync for automated, continuous, customizable Wistia replication to SingleStore.
-
How to Connect to & Open Adobe Experience Manager Data in Microsoft Excel
This article uses the CData ODBC driver for Adobe Experience Manager to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Deploy the ADO.NET Provider for XML on an SSRS Report Server
Connect to XML data 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.
-
Analyze Couchbase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Couchbase from Power Pivot. You will use the Table Import Wizard to load Couchbase data. You can visually build the import query or use any SQL supported by the driver.
-
Analyze eBay Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of eBay Analytics data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
DataBind Controls to SAP HANA XS Advanced Data in Delphi
DataBind to SAP HANA XS Advanced data in Delphi with standard data access components and controls.
-
How to integrate Metabase with Shortcut Data
Use CData Connect AI to connect to live Shortcut data and create an interactive dashboard in Metabase from Shortcut data.
-
Build Salesforce CRM Analytics-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce CRM Analytics data and build web apps with connectivity to live Salesforce CRM Analytics data.
-
Connect to ClickUp Data in DBArtisan
Use wizards in DBArtisan to configure ClickUp data as a data source.
-
Connect RSS to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live RSS feeds using the CData Python MCP Server.
-
Automated Continuous Demio Replication to SingleStore
Use CData Sync for automated, continuous, customizable Demio replication to SingleStore.
-
Build AI/ML Models with Live SpaceX Data using Dataiku
Connect SpaceX Data with Dataiku using the CData API Driver for JDBC.
-
Seamlessly Bring EnterpriseDB Data into Retool Using CData Connect AI
Integrate EnterpriseDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Google Drive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Google Drive data.
-
Build Data Flows from Simplesat to SQL Server using SSIS
Easily back up Simplesat data to SQL Server using the SSIS components for Simplesat.
-
Integrating OpenCode with Cloudant 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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ServiceDesk Plus
Provide connectivity to ServiceDesk Plus data through an SAP BusinessObjects universe.
-
Use Agno to Talk to Your Marketo 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 Marketo data for you.
-
Integrating GitHub Copilot with SAS xpt 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 Google Forms Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Google Forms data through MCP integration.
-
How to create Telegram federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Telegram data in MySQL .
-
Stream LaunchDarkly Data into Apache Kafka Topics
Access and stream LaunchDarkly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Short.io with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Short.io with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Short.io data.
-
Write a Simple Go Application to work with Superchat Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Superchat data.
-
Getting Started with the CData Connect AI Python SDK for Active Directory
Install the CData Connect AI Python SDK to read and write live Active Directory data with standard DB-API 2.0 Python code.
-
How to Connect Flowise AI Agents to Live Aweber 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 Aweber data without replication.
-
Connecting GenSpark with Timely Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Timely data without any replication or custom integration required.
-
Connect to Adobe Experience Manager Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Adobe Experience Manager to connect to Adobe Experience Manager data and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for Teamgate in MicroStrategy Web
Connect to Teamgate data in MicroStrategy Web using the CData Software ODBC Driver for Teamgate.
-
How to Build an ETL App for Slack Data in Python with CData
Create ETL applications and real-time data pipelines for Slack data in Python with petl.
-
How to connect to Keap Data from Spring Boot
Connect to Keap in a Spring Boot Application using the CData API Driver for JDBC
-
Query Pipeliner CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Pipeliner CRM data from Node.js.
-
Connect to Reckon Data from PowerBuilder via JDBC
This article demonstrates how to access Reckon data from PowerBuilder using the Reckon JDBC Driver.
-
Visualize MongoDB Data in TIBCO Spotfire through OData
Integrate MongoDB data into dashboards in TIBCO Spotfire.
-
Integrate Oracle Sales with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle Sales with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle Sales data.
-
Use the CData SSIS Components to Insert New or Update Existing Sugar CRM Records from SQL Server
Easily push SQL Server data to Sugar CRM using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sugar CRM or update existing records with data from a SQL Server database.
-
Use the CData Software JDBC Driver for Cassandra in MicroStrategy Web
Connect to Cassandra data in MicroStrategy Web using the CData Software JDBC Driver for Cassandra.
-
Integrating Cursor with Klipfolio 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.
-
Integrate Dify with Live MailerLite Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live MailerLite data.
-
Use the CData Software ODBC Driver for Aha! in SAS for Real-Time Reporting and Analytics
Connect to real-time Aha! data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Aha!.
-
Automated Continuous Egnyte Replication to SingleStore
Use CData Sync for automated, continuous, customizable Egnyte replication to SingleStore.
-
Automated Continuous Sybase Replication to MySQL
Use CData Sync for automated, continuous, customizable Sybase replication to MySQL.
-
Automated Continuous PabblySubscriptions Replication to Snowflake
Use CData Sync for automated, continuous, customizable PabblySubscriptions replication to Snowflake.
-
Create Dynamics 365-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Dynamics 365 Data from OutSystems and build custom enterprise apps using live Dynamics 365 data.
-
Work with Live SAP Concur Data in Power Query
Use CData Connect AI to connect to SAP Concur data and work with live SAP Concur data in Microsoft Power Query.
-
Access Live Dynamics 365 Business Central Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Dynamics 365 Business Central data through MCP integration.
-
Trigger Shopify IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Shopify with standard wizards in Logic Apps.
-
Integrating LlamaIndex with Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Pipedrive data in real time.
-
How to publish and share Sybase Data dashboards with Tableau Server
The CData ODBC driver for Sybase enables you integrate Sybase data into Tableau dashboards.
-
Deploy the ADO.NET Provider for Flowlu on an SSRS Report Server
Connect to Flowlu data 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.
-
Automated Continuous Epicor Kinetic Replication to Databricks
Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to Databricks.
-
Attio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Attio facts in real time.
-
Build Samanage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Samanage data.
-
Consume SQL Analysis Services OData Feeds in PowerBuilder
This article demonstrates how to consume SQL Analysis Services data as OData feeds from PowerBuilder using the API Server.
-
Connect to and Visualize Live Insightly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Insightly data.
-
Connect to GraphQL Data from HeidiSQL
Use CData Connect AI to connect to and query live GraphQL data from HeidiSQL.
-
Connect to WooCommerce Data in Google Apps Script via Connect AI
Use CData Connect AI to access WooCommerce data in Google Apps Script.
-
Analyze Oracle Financials Cloud Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Financials Cloud data in Microsoft R Open.
-
DataBind Controls to Ontraport Data in C++Builder
DataBind to Ontraport data in C++Builder with standard components and controls.
-
Work with Live Apollo Data in Power Query
Use CData Connect AI to connect to Apollo data and work with live Apollo data in Microsoft Power Query.
-
Automated Continuous Tavily Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Tavily replication to Azure SQL Database.
-
Build AI/ML Models with Live SAP Fieldglass Data using Dataiku
Connect SAP Fieldglass Data with Dataiku using the CData JDBC Driver for SAP Fieldglass.
-
Create Data Visualizations in Cognos BI with Sentry Data
Access Sentry data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access QuickBooks Online Data from MySQL in PHP
Connect to QuickBooks Online through the standard MySQL libraries in PHP.
-
How to connect and process BigQuery data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live BigQuery data.
-
Choosing the Best Method to Connect HCL Domino to SQL Server: 5 Options Explained
Discover multiple ways to connect and use HCL Domino data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Manus AI to Talk to Your Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle data.
-
Create Dashboards and Visualize Live Trello Data in Geckoboard
Use CData Connect AI to connect to live Trello data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for Xero Data using the CData ODBC Driver
Use the SQL Gateway and Xero ODBC Driver to create a PostgreSQL entry-point for data access.
-
Build Salesforce Data 360 Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Salesforce Data 360 data and build visualizations in Tableau.
-
Automated Continuous NASA Replication to MySQL
Use CData Sync for automated, continuous, customizable NASA replication to MySQL.
-
Integrate with ActiveCampaign Data in JReport Designer
Create charts and reports based on ActiveCampaign data in JReport Designer.
-
Visualize Live CSV Data in the Power BI Service
Use CData Connect AI to connect to live CSV data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Mailjet Data in Aqua Data Studio
Access Mailjet data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Power BI Connector for Azure Analysis Services
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Azure Analysis Services.
-
Access Live Salesloft Data in Excel 365 Online (Excel for the web)
Connect to Salesloft data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Semantic Layer Views for Acumatica Data in APOS Live Data Gateway
Use the CData Connector for Acumatica in APOS Live Data Gateway to build Semantic Layer Views for Acumatica data.