CData Software - Knowledge Base
Recent Articles
-
How to Access Live ADP Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ADP enables you to integrate ADP data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live SuiteCRM Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SuiteCRM data for you.
-
Use Agno to Talk to Your Paylocity 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 Paylocity data for you.
-
Use the CData Software ODBC Driver for Supabase in SAS for Real-Time Reporting and Analytics
Connect to real-time Supabase data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Supabase.
-
Use the CData ODBC Driver for Microsoft OneDrive from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Microsoft OneDrive to connect to Microsoft OneDrive data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft OneDrive data in Excel.
-
How to connect and process Google Spanner data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Spanner data.
-
Integrate with CSV Data in SnapLogic
Use CData Connect AI to connect to and integrate with live CSV data in SnapLogic.
-
Easily Integrate Brex Data in Lazarus Pascal IDE
Learn how to easily integrate live Brex data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Import SuiteCRM Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to SuiteCRM Data and provide access to live SuiteCRM data for custom reports in the Power BI Service.
-
How to import Cloudant Data into Apache Solr
Use the CData Software JDBC Driver for Cloudant in Data Import Handler and create an automated import of Cloudant data to Apache Solr Enterprise Search platform.
-
Build Semantic Layer Views for Confluence Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Confluence data.
-
Visualize LinkedIn Ads 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 LinkedIn Ads data into TIBCO Spotfire.
-
Access Snapchat Ads Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Snapchat Ads data.
-
Build AI Agents with xBase 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 xBase data through CData Connect AI.
-
Integrating OpenCode with Blackbaud FE NXT 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.
-
Creating Elasticsearch-Connected Applications in Unqork
You can use CData Connect AI to feed Elasticsearch data to Unqork and build custom business apps.
-
Viewing ShipStation Data in RAD Studio Data Explorer
How to view ShipStation data in RAD Studio Data Explorer using the CData ODBC Driver for ShipStation.
-
Integrate Cursor with Live ShipEngine Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ShipEngine data from within the editor.
-
Connect to Quaderno Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Quaderno and work with Quaderno data in your FileMaker applications.
-
Object-Relational Mapping (ORM) with Harvest 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 Harvest data into a Java-based ORM framework, Hibernate.
-
Connect to Live SAS Data Sets Data in MicroStrategy through CData Connect AI
Create a live connection to SAS Data Sets Data in CData Connect AI and connect to your SAS Data Sets data from MicroStrategy.
-
Connecting Agentforce with BenchmarkEmail 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 BenchmarkEmail data for you.
-
Easily Integrate Access Data in Lazarus Pascal IDE
Learn how to easily integrate live Access data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to create an RPA flow for NASA Data in UiPath Studio
Use the NASA ODBC Driver to create workflows that access real-time NASA data without any coding.
-
Use Biml to Build SSIS Tasks to Replicate Paddle Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paddle data to SQL Server.
-
Build Semantic Layer Views for Azure Data Lake Storage Data in APOS Live Data Gateway
Use the CData Connector for Azure Data Lake Storage in APOS Live Data Gateway to build Semantic Layer Views for Azure Data Lake Storage data.
-
Connect to SharePoint Excel Services Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SharePoint Excel Services data in the Denodo Virtual DataPort Administrator.
-
Using the CData Software ODBC Driver for JobNimbus in PyCharm
Connect to JobNimbus as an ODBC data source in PyCharm using the CData Software ODBC Driver for JobNimbus.
-
Build AI/ML Models with Live VWO Data using Dataiku
Connect VWO Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData SSIS Components for SAP Business One
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAP Business One.
-
Connect to BenchmarkEmail Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to BenchmarkEmail and work with BenchmarkEmail data in your FileMaker applications.
-
Use ChatGPT to Talk to Your Cvent 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 Cvent data for you.
-
Getting Started with the CData JDBC Driver for Rootly
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Rootly.
-
Access Live JotForm Data in Coginiti Pro
Connect to and query live JotForm data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect and Visualize Live Elasticsearch Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Elasticsearch data into the Databricks platform and create visualization dashboards with real-time Elasticsearch data.
-
Create Reports with Office 365 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Office 365 data.
-
Use Databricks Agent Bricks to Talk to Your Mailgun Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Mailgun data for you.
-
Connect to Deel Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Deel to connect to Deel data and execute queries in PowerBuilder.
-
How to connect PolyBase to Salesforce
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Salesforce data.
-
Visualize Live Databricks Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Databricks data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode with Google Cloud Storage 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.
-
Integrating Antigravity CLI with Notion data via CData CLI
Connect Notion data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Live Salesforce Data 360 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Salesforce Data 360 data and integrate live Salesforce Data 360 data into apps built in Microsoft Power Apps.
-
Connect to API Data from AWS Glue
Use CData Connect AI to gain access to live API data from your AWS Glue jobs.
-
Connect to Guru Data in ACL Analytics
Connect to Guru data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Guru data.
-
Automated Continuous MailerSend Replication to SQLite
Use CData Sync for automated, continuous, customizable MailerSend replication to SQLite.
-
How to Work with Campaigner Data in AWS Glue Jobs Using JDBC
Connect to Campaigner from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Analyze Ontraport Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Ontraport data with the CData JDBC Driver for Ontraport.
-
Connect to Codat Data in Aqua Data Studio
Access Codat data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Phoenix with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Phoenix with External Services.
-
Use the CData SSIS Components to Insert New or Update Existing Square Records from SQL Server
Easily push SQL Server data to Square using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Square or update existing records with data from a SQL Server database.
-
How to Access Live Everhour Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Everhour enables you to integrate Everhour data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Xero Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Xero data for you.
-
How to Connect to Live CouchDB Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your CouchDB data for you.
-
Connect to Figshare Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Figshare and work with Figshare data in your FileMaker applications.
-
How to Connect to Amplitude Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Amplitude data. Leverage the pyodbc module for ODBC in Python.
-
Model IBM Cloud Object Storage Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and IBM Cloud Object Storage, enabling the direct import of real-time IBM Cloud Object Storage data.
-
How to Create Power BI Visual Reports with Real-Time Paddle Data
Use CData Power BI Connectors to visualize Paddle data in Power BI.
-
How to Query Live SAP Fieldglass Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP Fieldglass data data in natural language using Python.
-
Use Crystal Reports to create reports with Salesforce data
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.
-
Getting Started with the CData ODBC Driver for Ontraport
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Ontraport.
-
Query Reckon Accounts Hosted Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Reckon Accounts Hosted entities in PHP by modeling them as objects.
-
How to connect to Sugar CRM Data from Spring Boot
Connect to Sugar CRM in a Spring Boot Application using the CData JDBC Driver for Sugar CRM
-
Access Google Ad Manager Data from MySQL in Amazon QuickSight
Connect to Google Ad Manager and build visualizations of Google Ad Manager data using a MySQL Connection in Amazon QuickSight.
-
Automated Continuous Instagram Replication to SingleStore
Use CData Sync for automated, continuous, customizable Instagram replication to SingleStore.
-
Connect to Real-Time Brex Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Brex data in Power Apps.
-
Create Dashboards and Visualize Live Azure Table Data in Geckoboard
Use CData Connect AI to connect to live Azure Table data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Replicate Salesloft Data in Heroku for Use in Salesforce Connect
Replicate Salesloft data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Replicate AgileCRM Data to Multiple Databases
Replicate AgileCRM data to disparate databases with a point-and-click configuration.
-
Migrating data from Close to Snowflake using CData SSIS Components.
Easily push Close data to Snowflake using the CData SSIS Tasks for Close and Snowflake.
-
How to connect and process Cassandra data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Cassandra data.
-
Import Real-Time Gong Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Gong data in ColdFusion.
-
Automated Continuous ShipEngine Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ShipEngine replication to PostgreSQL.
-
Explore Geographical Relationships in Mixpanel Data with Power Map
Create data visualizations with Mixpanel data in Power Map.
-
How to Connect to Live Supabase 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 Supabase data for you.
-
Automate SAP Concur Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Concur data from PowerShell? This article demonstrates how to utilize the SAP Concur Cmdlets for tasks like connecting to SAP Concur data, automating operations, downloading data, and more.
-
Automated Continuous Tally Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tally data replication to OneLake in Microsoft Fabric.
-
Connect to Qualaroo Data in NetBeans
Connect to Qualaroo data in NetBeans with the data source configuration wizard.
-
Connect to Freshdesk Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Freshdesk data.
-
Moving Data from Exa to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Exa data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Elasticsearch Data into Power Automate Desktop using CData Connect
CData Connect for Elasticsearch Data enables you to integrate Elasticsearch data into workflows built using Microsoft Power Automate Desktop.
-
Moving Data from Google Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Google Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Timely Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Timely and the SQL Gateway to access Timely data from Google Apps Script.
-
Bind Live Oracle Service Cloud Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Oracle Service Cloud data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Integrate with Live Sage 200 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from the MuleSoft Anypoint Platform to integrate live Sage 200 data into custom reports and dashboards.
-
Integrating OpenCode with SAP SuccessFactors LMS 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 Amazon S3 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Amazon S3 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to create SAP Fieldglass federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Fieldglass data in MySQL .
-
Connect to Avro Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Avro data.
-
Connect to RSS Feeds in CloverDX (formerly CloverETL)
Transfer RSS feeds using the visual workflow in the CloverDX data integration tool.
-
Write a Simple Go Application to work with Typeform Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Typeform data.
-
Connect to Grafana 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 Grafana data.
-
Automated Highrise Data Replication to Teradata
Use CData Sync to Customize and automate Highrise data replication to Teradata.
-
Import and Visualize Superchat Data in Power View
Create data visualizations based on Superchat data in Excel.
-
Connect Scrapfly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Scrapfly data using the CData Python MCP Server.
-
Connect to eBay Data from AWS Glue
Use CData Connect AI to gain access to live eBay data from your AWS Glue jobs.
-
Connect to Tally Data in JRuby
Create a simple JRuby app with access to live Tally data.
-
Integrate Twilio with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Twilio with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Twilio data.
-
Connect to GitHub Data from AWS Glue
Use CData Connect AI to gain access to live GitHub data from your AWS Glue jobs.
-
How to Connect to & Open Salesforce Marketing Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce Marketing to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.