CData Software - Knowledge Base

Recent Articles

---

• «
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• »

• Access Gorgias Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Gorgias from HeidiSQL.

• Integrating Cursor CLI with Google Ad Manager 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 Helpscout from SharePoint Excel Services

  This article demonstrates how to use the CData ODBC Driver for Helpscout to connect to Helpscout from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Helpscout in Excel.

• Build an OLAP Cube in SSAS from Bitly Data

  Establish a connection to Bitly data from SQL Server Analysis Services, and use the Bitly Data Provider to build OLAP cubes for use in analytics and reporting.

• How to work with Oracle Eloqua Data in Apache Spark using SQL

  Access and process Oracle Eloqua Data in Apache Spark using the CData Software JDBC Driver.

• Operational Reporting on RSS Feeds from Spotfire Server

  Create and share Spotfire data visualizations with real-time connectivity to remote RSS Feeds.

• Connect to Harvest Data in Aqua Data Studio

  Access Harvest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

• Use the CData API Server in Microsoft Power BI

  You can use the CData API Server to feed Wistia to Power BI dashboards. Simply drag and drop Wistia into data visuals on the Power BI canvas.

• Integrate Real-Time Access to PolarTeamPro in SAPUI5 MVC Apps

  Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to PolarTeamPro in real time.

• Connect to Apify Data in RapidMiner

  Integrate Apify with standard components and data source configuration wizards in RapidMiner Studio.

• Automated Continuous QuickBooks Time Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable QuickBooks Time replication to OneLake in Microsoft Fabric.

• Automated Continuous Insightly Replication to Local Delimited Files

  Use CData Sync for automated, continuous, customizable Insightly replication to delimited files (CSV/TSV).

• Visualize WordPress Data in TIBCO Spotfire through OData

  Integrate WordPress into dashboards in TIBCO Spotfire.

• Automated Continuous Epicor Kinetic Data Replication to OneLake in Microsoft Fabric

  Use CData Sync for automated, continuous, customizable Epicor Kinetic replication to OneLake in Microsoft Fabric.

• Connect to DocuSign Data as a Linked Server via SQL Gateway

  Use the SQL Gateway and the ODBC Driver to set up a linked server for DocuSign.

• Query Elasticsearch Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your Elasticsearch and perform CRUD operations on Elasticsearch from Node.js.

• Access Live FTP Data in Excel (Desktop) through Connect Spreadsheets

  Use Connect Spreadsheets by CData to gain access to live FTP Servers from your Excel spreadsheets.

• Getting Started with the CData ODBC Driver for ConvertKit

  Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ConvertKit.

• How to Import Data from Smartsheet into Google Sheets

  Import Smartsheet into a Google spreadsheet that is automatically refreshed.

• Getting Started with the CData Excel Add-In for ShipStation

  Complete guide to installing, licensing, and connecting with the CData Excel Add-In for ShipStation.

• Automated Continuous Cvent Replication to MySQL

  Use CData Sync for automated, continuous, customizable Cvent replication to MySQL.

• Build Placid-Powered Applications in Claude Code with CData MCP Server

  Use the CData API Driver for MCP Server to explore live Placid Data in Claude Code to assist with building Placid-powered applications.

• How to Connect the Power BI Service to OData: Complete Guide

  Connect to the CData Software Power BI Connector for OData from PowerBI.com to provide real-time OData across the organization.

• Easily Integrate SendGrid Data in Lazarus Pascal IDE

  Learn how to easily integrate live SendGrid in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• Automated Pingdom Data Replication to Teradata

  Use CData Sync to Customize and automate Pingdom replication to Teradata.

• Visualize Zoho Inventory Data in Tableau

  The CData ODBC driver for Zoho Inventory enables you integrate Zoho Inventory into Tableau dashboards.

• How to Connect to Live Jira Data in Mistral AI Workflows

  Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Atlassian Jira without replication.

• Build SAP Business One-Connected Apps in Mendix

  Use CData Connect AI to create an OData feed for SAP Business One Data and create custom apps in Mendix.

• How to Seamlessly Import Zoho Creator Data into IBM SPSS Modeler

  Integrate Zoho Creator data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.

• Build Charts with Datadog Data in Clear Analytics

  Create dynamic charts and perform analytics based on Datadog in Clear Analytics.

• Easily Integrate Paddle Data in Lazarus Pascal IDE

  Learn how to easily integrate live Paddle in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.

• How to integrate Metabase with Microsoft Planner Data

  Use CData Connect AI to connect to live Microsoft Planner and create an interactive dashboard in Metabase from Microsoft Planner.

• Connect to Real-Time SuiteCRM Data in Power Apps Using Dataflows to Build Custom Applications

  Use CData Power BI Connector for SuiteCRM and Dataflow to import and use SuiteCRM in Power Apps.

• Integrating GitHub Copilot CLI with SurveyMonkey 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.

• Migrating data from Miro to Databricks using CData SSIS Components.

  Easily push Miro to Databricks using the CData SSIS Tasks for Miro and Databricks.

• Automated Continuous Adobe Target Replication to SingleStore

  Use CData Sync for automated, continuous, customizable Adobe Target replication to SingleStore.

• Build an OLAP Cube in SSAS from Parallel Data

  Establish a connection to Parallel data from SQL Server Analysis Services, and use the Parallel Data Provider to build OLAP cubes for use in analytics and reporting.

• Integrate Cloudant with External Services using SnapLogic

  Use CData JDBC drivers in SnapLogic to integrate Cloudant with External Services.

• Build SAP BusinessObjects BI-Powered Applications in Gemini Code Assist with CData MCP Server

  Use the CData MCP Server for SAP BusinessObjects BI to explore live SAP BusinessObjects BI Data in Gemini Code Assist to assist with building SAP BusinessObjects BI-powered applications.

• How to Connect to & Open Workable Data in Microsoft Excel

  This article uses the CData ODBC driver for Workable to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• How to use SQLAlchemy ORM to access Google Ad Manager Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Ad Manager.

• Access Act CRM Data from MySQL in PHP

  Connect to Act CRM through the standard MySQL libraries in PHP.

• Query ClickUp Data using the OData SDK for PHP

  Use the API Server and the OData PHP SDK to easily consume ClickUp entities in PHP by modeling them as objects.

• Stream Google Cloud Storage Data into Apache Kafka Topics

  Access and stream Google Cloud Storage in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

• Build Klaviyo-Connected Apps in Choreo

  Use CData Connect AI to connect to Klaviyo Data from Choreo and build custom apps using live Klaviyo.

• Create Informatica Mappings From/To a JDBC Data Source for Freshdesk

  Create Freshdesk data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

• Connect to Datadog Data in CloverDX (formerly CloverETL)

  Transfer Datadog using the visual workflow in the CloverDX data integration tool.

• Replicate Multiple LaunchDarkly Accounts

  Replicate multiple LaunchDarkly accounts to one or many databases.

• Feed Avalara AvaTax Data into FineReport

  How to set Avalara AvaTax as a JDBC data source in FineReport.

• How to Connect to & Open SAP Business One Data in Microsoft Excel

  This article uses the CData ODBC driver for SAP Business One to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

• Consume Phoenix OData Feeds in PowerBuilder

  This article demonstrates how to consume Apache Phoenix as OData feeds from PowerBuilder using the API Server.

• Create Exact Online-Connected Nintex Workflows

  Use CData Connect AI to connect to Exact Online Data from Nintex Workflow Cloud and build custom workflows using live Exact Online.

• How to Visualize Oracle Eloqua Reporting Data in Python with pandas

  Use pandas and other modules to analyze and visualize live Oracle Eloqua Reporting in Python.

• How to use SQLAlchemy ORM to access Shopify Data in Python

  Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shopify.

• Excel Spreadsheet Automation on NASA Data with the QUERY Formula

  Pull data from NASA, automate spreadsheets, and more with the QUERY formula.

• Connect to Acumatica Data in HULFT Integrate

  Connect to Acumatica as a JDBC data source in HULFT Integrate

• Edit and Search NASA External Objects in Salesforce Connect (API Server)

  Use the API Server to securely provide OData feeds of NASA to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create NASA objects that you can access from apps and the dashboard.

• ETL Unbounce in Oracle Data Integrator

  This article shows how to transfer Unbounce into a data warehouse using Oracle Data Integrator.

• Build Charts with Office 365 Data in Clear Analytics

  Create dynamic charts and perform analytics based on Microsoft Office 365 in Clear Analytics.

• Access Keap Data from MySQL in PHP

  Connect to Keap through the standard MySQL libraries in PHP.

• Back Up Monday.com to SQL Server through SSIS

  Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Monday.com. In this article, we will employ an SSIS workflow to populate a database with Monday.com data.

• Build Data Flows from DocuSign to SQL Server using SSIS

  Easily back up DocuSign to SQL Server using the SSIS components for DocuSign.

• How to connect and process LDAP from Azure Databricks

  Use CData, Azure, and Databricks to perform data engineering and data science on live LDAP.

• Add Toggl Data to Informatica Enterprise Data Catalog

  Use the CData Software JDBC Driver for Toggl with the Informatica Enterprise Data Catalog to classify and organize data.

• Replicate SAP Hybris C4C Data from PowerShell

  Write a quick PowerShell script to query SAP Hybris C4C. Use connectivity to the live data to replicate SAP Hybris C4C to SQL Server.

• Getting Started with the CData Python Connector for Reckon Accounts Hosted

  Learn to install and license the CData Python Connector

• Connect to SharePoint Data in JRuby

  Create a simple JRuby app with access to live Microsoft SharePoint.

• Connect to Freshdesk Data in RunMyProcess through Connect AI

  Use CData Connect AI to create on OData API for Freshdesk Data and connect to Freshdesk in Akorbi Digital RunMyProcess.

• Use the CData Software ODBC Driver for HubSpot in MicroStrategy Web

  Connect to HubSpot in MicroStrategy Web using the CData Software ODBC Driver for HubSpot.

• Analyze CouchDB Data in Looker

  Use CData Connect AI to connect to CouchDB Data from Looker and build custom apps using live Apache CouchDB.

• Import Oracle Financials Cloud Data Using Azure Data Factory

  Use CData Connect AI to connect to Oracle Financials Cloud Data from Azure Data Factory and import live Oracle Financials Cloud.

• Connecting GenSpark with Klaviyo Data via CData Connect AI MCP Server

  Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Klaviyo without any replication or custom integration required.

• Analyze Autopilot Data in R via JDBC

  Use standard R functions and the development environment of your choice to analyze Autopilot with the CData JDBC Driver for Autopilot.

• Access Live LaunchDarkly Data in TIBCO Data Virtualization

  Use the CData API Driver for Tibco DV to create a LaunchDarkly data source in TIBCO Data Virtualization Studio and gain access to live LaunchDarkly from your TDV Server.

• Connect to Jumpseller Data in JRuby

  Create a simple JRuby app with access to live Jumpseller.

• Viewing ZohoSubscriptions Data in RAD Studio Data Explorer

  How to view ZohoSubscriptions in RAD Studio Data Explorer using the CData ODBC Driver for ZohoSubscriptions.

• Connect to Monday.com Data in JRuby

  Create a simple JRuby app with access to live Monday.com.

• Integrating Claude Code CLI with BigQuery 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 OneNote Data from MySQL in HeidiSQL

  Use CData ODBC Driver and SQL Gateway to connect and query live Microsoft OneNote from HeidiSQL.

• SuiteCRM Reporting in OBIEE with the SuiteCRM JDBC Driver

  Deploy the SuiteCRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.

• Import Real-Time OnePageCrm Data via JDBC in ColdFusion to Build Applications

  Use CData JDBC drivers to import and use OnePageCrm in ColdFusion.

• Integrate with Phoenix Data in SnapLogic

  Use CData Connect AI to connect to and integrate with live Apache Phoenix in SnapLogic.

• How to create an RPA flow for ServiceDesk Plus Data in UiPath Studio

  Use the ServiceDesk Plus ODBC Driver to create workflows that access real-time ServiceDesk Plus without any coding.

• How to create Act-On federated tables in MySQL

  Use the SQL Gateway and the ODBC Driver to set up federated tables for Act-On in MySQL .

• Enable the Zoho Recruit JDBC Driver in KNIME

  Use standard data access components in KNIME to create charts and reports with Zoho Recruit.

• Connecting Moonlit Workflow with Jira Assets 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 Jira Assets in real time.

• Connect to and Query LinkedIn Ads Data in QlikView over ODBC

  Create data visualizations with LinkedIn Ads in QlikView.

• Connect to Microsoft OneDrive Data from AWS Glue

  Use CData Connect AI to gain access to live Microsoft OneDrive from your AWS Glue jobs.

• Automated Continuous ZohoDesk Replication to Amazon S3

  Use CData Sync for automated, continuous, customizable ZohoDesk replication to Amazon S3.

• Automated Continuous TaxJar Replication to Apache Kafka

  Use CData Sync for automated, continuous, customizable TaxJar replication to Apache Kafka.

• Build Epicor Kinetic-Powered Applications in Claude Code with CData MCP Server

  Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in Claude Code to assist with building Epicor Kinetic-powered applications.

• Access Live HubSpot 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 HubSpot through MCP integration.

• Build Amplitude-Connected ETL Processes in Google Data Fusion

  Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Amplitude.

• Publish BigQuery-Connected Dashboards in Tableau Server via JDBC

  Use CData JDBC drivers and Tableau Server to visualize live Google BigQuery.

• Integrate with Azure DevOps Data in JReport Designer

  Create charts and reports based on Azure DevOps in JReport Designer.

• Connect to Couchbase from Excel & GoogleSheets!

  Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Couchbase, and over 250 other data sources, right inside your Excel and Google spreadsheets!

• Prepare, Blend, and Analyze LinkedIn Data in Alteryx Designer (Connect AI)

  Build workflows to access live LinkedIn for self-service data analytics.

• Create SAP Netweaver Gateway-Connected Dashboards in Grafana

  Connect to SAP Netweaver Gateway Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP Netweaver Gateway.

• Query BambooHR Data from Node.js

  Use the OData endpoint of the CData API Server to connect to your BambooHR and perform CRUD operations on BambooHR from Node.js.

• Create Power BI Reports on Real-Time Flowlu Data

  Use the CData ODBC Driver for Flowlu to visualize Flowlu in Power BI Desktop.

• «
• 61
• 62
• 63
• 64
• 65
• 66
• 67
• 68
• 69
• 70
• »