CData Software - Knowledge Base
Recent Articles
-
Integrating Claude Code CLI with ZohoPeople 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.
-
Automated Continuous Stack Exchange Replication to Oracle
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Oracle.
-
Build Automated Workflows with Live Google Forms Data in Workato
Use CData Connect AI to connect to live Google Forms data and build automated workflows in Workato.
-
Automated Continuous Tickspot Replication to Snowflake
Use CData Sync for automated, continuous, customizable Tickspot replication to Snowflake.
-
How to Connect to Live Office 365 Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Office 365 data for you.
-
Use the CData ODBC Driver for Adobe Target in Microsoft Power Query
You can use the CData Adobe Target ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Target data into Microsoft Power Query.
-
Publish Quaderno-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Quaderno data.
-
Moving Data from Wrike to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Wrike data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Working with Vercel Data in LINQPad
Execute LINQ queries to Vercel data in LINQPad.
-
Working with Google Contacts Data in LINQPad
Execute LINQ queries to Google Contacts data in LINQPad.
-
Use CData Connect AI to Access HDFS Data in Microsoft Power Pivot
Use CData Connect AI to connect to live HDFS data in the Power Pivot business intelligence tool.
-
Connect to Elasticsearch Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Elasticsearch data in the Denodo Virtual DataPort Administrator.
-
Build Azure DevOps-Connected Apps in Choreo
Use CData Connect AI to connect to Azure DevOps Data from Choreo and build custom apps using live Azure DevOps data.
-
Extract, Transform, and Load Coda Data in Informatica PowerCenter
Create a simple Workflow for Coda data in Informatica PowerCenter.
-
Access Live SAP BusinessObjects BI Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP BusinessObjects BI data from your Google Sheets.
-
Use the CData Software ODBC Driver for Oracle Eloqua in MicroStrategy Desktop
Connect to Oracle Eloqua data in MicroStrategy Desktop using the CData Software ODBC Driver for Oracle Eloqua.
-
Automated Continuous LaunchDarkly Replication to SingleStore
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to SingleStore.
-
Connect to Dynamics 365 Business Central Data from a Connection Pool in JBoss
Integrate Dynamics 365 Business Central data into Java servlets: Use the Management Console in JBoss to install the Dynamics 365 Business Central JDBC Driver.
-
Create SSAS Tabular Models from Browserless Data
How to build a SQL Server Analysis Service Tabular Model from Browserless data using CData drivers.
-
Write a Simple Go Application to work with Figshare Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Figshare data.
-
Build Azure DevOps-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure DevOps data and build web apps with connectivity to live Azure DevOps data.
-
Integrating Codex with HelloSign 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 Gong in Microsoft Power Query
You can use the CData Gong ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gong data into Microsoft Power Query.
-
How to Access Microsoft Teams Data Using Entity Framework
This article shows how to access Microsoft Teams data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to create an RPA flow for Vercel Data in UiPath Studio
Use the Vercel ODBC Driver to create workflows that access real-time Vercel data without any coding.
-
Query Kintone Data in DataGrip
Create a Data Source for Kintone in DataGrip and use SQL to query live Kintone data.
-
Write a Simple Go Application to work with Dynamics 365 Business Central Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Dynamics 365 Business Central data.
-
Import Bannerbear Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Bannerbear Data and provide access to live Bannerbear data for custom reports in the Power BI Service.
-
Automate MySQL Integration Tasks from PowerShell
Are you in search of a quick and easy way to access MySQL data from PowerShell? This article demonstrates how to utilize the MySQL Cmdlets for tasks like connecting to MySQL data, automating operations, downloading data, and more.
-
How to Deploy Cross-Platform CData Sync to IIS
Deploying Cross-Platform CData Sync to Microsoft Internet Information Services (IIS) and setting up IIS as a reverse proxy for CData Sync.
-
Build Semantic Layer Views for Yelp Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Yelp data.
-
Integrate Live DocuSign Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to DocuSign data and integrate live DocuSign data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Power BI Connector for EmailOctopus
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate Webex Data to Multiple Databases via the CData Sync CLI
Replicate Webex data to disparate databases with a single configuration.
-
How to Connect GetResponse Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live GetResponse data in real time using natural language.
-
Connect REST to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect REST with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Google Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Google Ads replication to Google Cloud SQL.
-
Viewing Act CRM Data in RAD Studio Data Explorer
How to view Act CRM data in RAD Studio Data Explorer using the CData ODBC Driver for Act CRM.
-
Object-Relational Mapping (ORM) with DB2 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 DB2 data into a Java-based ORM framework, Hibernate.
-
Use CData Connect AI to Access Greenplum Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Greenplum data in the Power Pivot business intelligence tool.
-
Connect to Excel Online Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Excel Online and the SQL Gateway to access Excel Online data from Google Apps Script.
-
Use the CData Software ODBC Driver for REST in SAS for Real-Time Reporting and Analytics
Connect to real-time REST data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for REST.
-
Replicate Multiple Amazon DynamoDB Accounts
Replicate multiple Amazon DynamoDB accounts to one or many databases.
-
Integrating Cursor with Sage 300 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 with Live SAP Fieldglass Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to SAP Fieldglass from the MuleSoft Anypoint Platform to integrate live SAP Fieldglass data into custom reports and dashboards.
-
Visualize Live Reckon Accounts Hosted Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Reckon Accounts Hosted data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Quickbase Data in Power View
Create data visualizations based on Quickbase data in Excel.
-
Import SFTP Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SFTP Data and provide access to live SFTP data for custom reports in the Power BI Service.
-
Process & Analyze Dropbox Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Dropbox Data.
-
Connect to Hive Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Hive data.
-
Connecting Agentforce with HBase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your HBase data for you.
-
How to Build an ETL App for Klaviyo Data in Python with CData
Create ETL applications and real-time data pipelines for Klaviyo data in Python with petl.
-
Build Semantic Layer Views for Microsoft Teams Data in APOS Live Data Gateway
Use the CData Connector for Microsoft Teams in APOS Live Data Gateway to build Semantic Layer Views for Microsoft Teams data.
-
DataBind Controls to SurveyMonkey Data in C++Builder
DataBind to SurveyMonkey data in C++Builder with standard components and controls.
-
Creating GraphQL-Connected Applications in Unqork
You can use CData Connect AI to feed GraphQL data to Unqork and build custom business apps.
-
Connect to Adobe Target Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Adobe Target Data and connect to Adobe Target data in Akorbi Digital RunMyProcess.
-
Integrate SAP Business One Data into Power Automate Desktop using CData Connect
CData Connect for SAP Business One Data enables you to integrate SAP Business One data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Codex with Klaviyo 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 Parquet from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Parquet to connect to Parquet data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Parquet data in Excel.
-
Create ServiceNow-Connected Dashboards in Grafana
Connect to ServiceNow Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to ServiceNow data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Accelo
Provide connectivity to Accelo data through an SAP BusinessObjects universe.
-
Working with Aha! Data in LINQPad
Execute LINQ queries to Aha! data in LINQPad.
-
Integrating GitHub Copilot with ConvertAPI 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 a Data Access Object for Onfleet Data using JDBI
A brief overview of creating a SQL Object API for Onfleet data in JDBI.
-
View Reports on Real-Time Billsby Data in Power BI Report Server
Use the CData ODBC Driver for Billsby to visualize Billsby data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Toggl Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Toggl replication to Amazon S3.
-
How to use SQLAlchemy ORM to access SingleStore Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SingleStore data.
-
How to Connect to Live MYOB AccountRight Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your MYOB AccountRight data for you.
-
Build AI/ML Models with Live JSON Data using Dataiku
Connect JSON Data with Dataiku using the CData JDBC Driver for JSON.
-
Connect to Eventbrite Data in Aqua Data Studio
Access Eventbrite data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect SAP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SAP data using the CData Python MCP Server.
-
Connect to Salesforce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Salesforce data from Filemaker Pro on Mac.
-
Enable the Instantly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Instantly data.
-
Build an OLAP Cube in SSAS from Excel Data
Establish a connection to Excel data data from SQL Server Analysis Services, and use the Excel Data Provider to build OLAP cubes for use in analytics and reporting.
-
Building a Salesforce Churn Analysis Pipeline: Designing Multi-Step AI Agent Workflows with Claude Code and CData CLI
Build a multi-step AI agent pipeline that queries Salesforce for churn risk signals, drafts personalized outreach emails, creates follow-up tasks, and produces an executive digest using Claude Code and CData CLI.
-
Consume Google Ad Manager OData Feeds in PowerBuilder
This article demonstrates how to consume Google Ad Manager data as OData feeds from PowerBuilder using the API Server.
-
Interact with Live SFTP Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live SFTP data.
-
How to Query Azure Analysis Services Data in MySQL Workbench
Execute MySQL queries against live Azure Analysis Services data from MySQL Workbench.
-
Automate ZohoPeople Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoPeople data replication to Azure Data Lake.
-
Automated Continuous SpaceX Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SpaceX replication to Amazon S3.
-
Automated Continuous Telegram Replication to Vertica
Use CData Sync for automated, continuous, customizable Telegram replication to Vertica.
-
Build Charts with ConvertAPI Data in Clear Analytics
Create dynamic charts and perform analytics based on ConvertAPI data in Clear Analytics.
-
Create Marketo Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Marketo data access from reports, embedded analytics, and more.
-
Analyze ShipStation Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ShipStation data in Microsoft R Open.
-
Build SAP Ariba Source-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SAP Ariba Source data and build web apps with connectivity to live SAP Ariba Source data.
-
Automated Continuous xBase Replication to Databricks
Use CData Sync for automated, continuous, customizable xBase replication to Databricks.
-
Query ServiceNow Data in ColdFusion
Write standard ColdFusion data access code to connect to ServiceNow data.
-
How to Connect to Live BambooHR Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your BambooHR data through natural language.
-
Access Live Exact Online Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Exact Online data from your Excel spreadsheets.
-
Build Data Flows from Hive to SQL Server using SSIS
Easily back up Hive data to SQL Server using the SSIS components for Hive.
-
Create Dashboards and Visualize Live Greenplum Data in Geckoboard
Use CData Connect AI to connect to live Greenplum data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Integrate Cursor with Live Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Monday.com data from within the editor.
-
A PostgreSQL Interface for Onfleet Data using the CData ODBC Driver
Use the SQL Gateway and Onfleet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData SSIS Components to Insert New or Update Existing OneNote Records from SQL Server
Easily push SQL Server data to OneNote using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into OneNote or update existing records with data from a SQL Server database.
-
Integrate with Exa Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Exa data in SnapLogic.
-
Integrating GitHub Copilot with Exa 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.
-
How to connect to Monday.com Data in DBVisualizer
Integrate Monday.com data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Easily Query Excel Data in OpenOffice Base
Connect to Excel data in OpenOffice Base using the CData ODBC Driver for Excel and generate reports with live data insights.
-
Use the CData ODBC Driver for HubSpot from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HubSpot to connect to HubSpot data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HubSpot data in Excel.
-
Automated Continuous Wistia Replication to MySQL
Use CData Sync for automated, continuous, customizable Wistia replication to MySQL.