CData Software - Knowledge Base
Recent Articles
-
Back Up SAP Hybris C4C data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Hybris C4C. In this article, we will employ an SSIS workflow to populate a database with SAP Hybris C4C data data.
-
Integrating Claude Code CLI with FormSite 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.
-
Process & Analyze Mocean Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Mocean Data.
-
Build an OLAP Cube in SSAS from Zendesk Data
Establish a connection to Zendesk data data from SQL Server Analysis Services, and use the Zendesk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with Microsoft Exchange Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Microsoft Exchange data to a JSON file on disk.
-
DataBind Controls to Amazon Marketplace Data in Delphi
DataBind to Amazon Marketplace data in Delphi with standard data access components and controls.
-
Connect to Zoho Projects Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Zoho Projects and the Script function in FileMaker Pro to connect to Zoho Projects and work with Zoho Projects data in your FileMaker application.
-
Integrating Kiro with Tally 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 Jira Assets Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Jira Assets Data and connect to Jira Assets data in Akorbi Digital RunMyProcess.
-
Integrate Live FHIR Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live FHIR data from within the IDE.
-
Access Live Google Tasks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Tasks data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate ADP Data Replication to Couchbase
Use CData Sync to Customize and automate ADP data replication to Couchbase.
-
Connect to Twitter Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Twitter Ads and the Script function in FileMaker Pro to connect to Twitter Ads and work with Twitter Ads data in your FileMaker application.
-
Use the CData Software JDBC Driver for Paylocity in MicroStrategy
Connect to Paylocity data in MicroStrategy Developer using the CData Software JDBC Driver for Paylocity.
-
Use the CData Software ODBC Driver for Freshdesk in SAS for Real-Time Reporting and Analytics
Connect to real-time Freshdesk data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Freshdesk.
-
Integrating LangChain with Exact Online Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Exact Online data within automated workflows.
-
Getting Started with the CData Excel Add-In for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PhantomBuster.
-
Build Gumroad-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gumroad data.
-
Build an OLAP Cube in SSAS from Facebook Ads Data
Establish a connection to Facebook Ads data data from SQL Server Analysis Services, and use the Facebook Ads Data Provider to build OLAP cubes for use in analytics and reporting.
-
Object-Relational Mapping (ORM) with iContact 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 iContact data into a Java-based ORM framework, Hibernate.
-
How to connect SharePoint with Confluence Data through external lists
Provide Confluence data to SharePoint users as an external list.
-
Use Agno to Talk to Your DB2 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 DB2 data for you.
-
Excel Spreadsheet Automation on Wrike Data with the QUERY Formula
Pull data from Wrike, automate spreadsheets, and more with the QUERY formula.
-
Integrate with Live Zoom Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Zoom from the MuleSoft Anypoint Platform to integrate live Zoom data into custom reports and dashboards.
-
Extract, Transform, and Load Copper Data in Informatica PowerCenter
Create a simple Workflow for Copper data in Informatica PowerCenter.
-
Access Live OneNote Data in AWS Lambda (with IntelliJ IDEA)
Connect to live OneNote data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live Rebilly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Rebilly data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Zoho Creator
Provide connectivity to Zoho Creator data through an SAP BusinessObjects universe.
-
Integrate Google's Antigravity Agent with Live Salesloft Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Salesloft data using the Model Context Protocol.
-
Automated Continuous Amplitude Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amplitude replication to IBM DB2.
-
Connect to Live SAP Fieldglass Data in MicroStrategy through CData Connect AI
Create a live connection to SAP Fieldglass Data in CData Connect AI and connect to your SAP Fieldglass data from MicroStrategy.
-
Integrate Trae with Live ActiveCampaign Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ActiveCampaign data from within the AI-powered IDE.
-
Query Live Mailgun Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Mailgun data through a conversational interface.
-
Query Sage Cloud Accounting Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage Cloud Accounting entities in PHP by modeling them as objects.
-
Connect to GraphQL from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from GraphQL data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Excel Spreadsheet Automation on Rebilly Data with the QUERY Formula
Pull data from Rebilly, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Power BI Connector for CloudConvert
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Replicate Yelp Data in Heroku for Use in Salesforce Connect
Replicate Yelp data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Visualize Act-On 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 Act-On data into TIBCO Spotfire.
-
Connect to Amazon Marketplace in SpagoBI
Create reports featuring live Amazon Marketplace data in SpagoBI Studio. Host Amazon Marketplace reports on SpagoBI Server.
-
Build Automated Oracle Eloqua-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Eloqua data and build automated workflows in Zapier.
-
Integrate with SuiteCRM Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SuiteCRM data in SnapLogic.
-
View Reports on Real-Time Missive Data in Power BI Report Server
Use the CData ODBC Driver for Missive to visualize Missive data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Cursor with SAP Business One 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.
-
Manage ConvertAPI Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ConvertAPI.
-
Easily Integrate Oracle HCM Cloud Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle HCM Cloud data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating Codex with Apollo 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.
-
Object-Relational Mapping (ORM) with Cvent 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 Cvent data into a Java-based ORM framework, Hibernate.
-
Integrating Boomi Agentstudio with Facebook Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Facebook data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connecting Pipedream with SAP HANA XS Advanced Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP HANA XS Advanced data in real time.
-
Automated Continuous Phoenix Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Phoenix replication to Google BigQuery.
-
Bridge SAP BusinessObjects BI Connectivity with Apache NiFi
Access and process SAP BusinessObjects BI data in Apache NiFi using the CData JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Neo4J
Create an ODBC connection to Neo4J in Informatica and browse and transfer Neo4J data.
-
How to Build an ETL App for SparkPost Data in Python with CData Connect AI
Extract and transform live SparkPost data in Python with petl and the CData Connect AI Python SDK.
-
Replicate PolarTeamPro Data in Heroku for Use in Salesforce Connect
Replicate PolarTeamPro data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect to Live Dropbox Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Dropbox data securely in real time.
-
Use Grok to Talk to Your Klipfolio Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Klipfolio data for you.
-
How to connect to Pingdom Data with Squirrel SQL client
Connect to Pingdom data and execute queries in the Squirrel SQL Client.
-
Build MVC Applications with Connectivity to Parquet Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Parquet from an ASP.NET MVC application.
-
Natively Connect to Twilio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Twilio data. Leverage the native support for ODBC in PHP.
-
Integrating Gumloop with Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Zoho CRM data within automated workflows.
-
Work with LinkedIn Data in FoxPro
Load LinkedIn data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to PolarTeamPro Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for PolarTeamPro and the SQL Gateway to access PolarTeamPro data from Google Apps Script.
-
Automated Continuous FreshBooks Replication to Oracle
Use CData Sync for automated, continuous, customizable FreshBooks replication to Oracle.
-
ETL MessageBird in Oracle Data Integrator
This article shows how to transfer MessageBird data into a data warehouse using Oracle Data Integrator.
-
Integrating Tickspot Data in Talend Cloud Data Management Platform
Connect Tickspot Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Migrating data from Facebook Ads to Google BigQuery using CData SSIS Components.
Easily push Facebook Ads data to Google BigQuery using the CData SSIS Tasks for Facebook Ads and Google BigQuery.
-
Getting Started with the CData SSIS Components for Sage 200
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage 200.
-
Integrate Trae with Live Databricks Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Databricks data from within the AI-powered IDE.
-
Create Tavily Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Tavily from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build an OLAP Cube in SSAS from Hive Data
Establish a connection to Hive data data from SQL Server Analysis Services, and use the Hive Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Copper-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Copper data and build web apps with connectivity to live Copper data.
-
Build Apps with Live Helpscout Data Using the Low-Code Development Platform of Mendix
Connect Helpscout data with Mendix to build apps using the CData API Driver for JDBC.
-
Connect to REST Data in CloverDX (formerly CloverETL)
Transfer REST data using the visual workflow in the CloverDX data integration tool.
-
Getting Started with the CData ADO.NET Provider for Hugging Face
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrating Codex with AgileCRM 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 Visualize Deel Data in Python with pandas
Use pandas and other modules to analyze and visualize live Deel data in Python.
-
Integrate Goose with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Marketo data from within the local AI agent.
-
Integrating Claude Code with API Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on API data within assisted coding and automated development workflows.
-
Create SSAS Tabular Models from Monday.com Data
How to build a SQL Server Analysis Service Tabular Model from Monday.com data using CData drivers.
-
Build Charts with Parquet Data in Clear Analytics
Create dynamic charts and perform analytics based on Parquet data in Clear Analytics.
-
Getting Started with the CData ADO.NET Provider for Printful
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Mouseflow Reporting in OBIEE with the Mouseflow JDBC Driver
Deploy the Mouseflow JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Enable the Qualaroo JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Qualaroo data.
-
Automated Continuous Salesforce Marketing Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Azure SQL Database.
-
How to import Invoiced Data into Apache Solr
Use the CData Software JDBC Driver for Invoiced in Data Import Handler and create an automated import of Invoiced data to Apache Solr Enterprise Search platform.
-
Access Live Power BI XMLA Data in AWS Lambda
Connect to live Power BI XMLA data in AWS Lambda using the CData JDBC Driver.
-
How to Easily Query Printify Data in OpenOffice Base
Connect to Printify data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automate Recurly Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Recurly data from PowerShell? This article demonstrates how to utilize the Recurly Cmdlets for tasks like connecting to Recurly data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Tavily in MicroStrategy Web
Connect to Tavily data in MicroStrategy Web using the CData Software JDBC Driver for Tavily.
-
Getting Started with the CData Power BI Connector for GitLab
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Connect to SAP Netweaver Gateway Data as an External Source in Dremio
Use the CData JDBC Driver to connect to SAP Netweaver Gateway as an External Source in Dremio.
-
Automated Continuous ZeroBounce Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ZeroBounce replication to PostgreSQL.
-
Enable the GetResponse JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with GetResponse data.
-
Connect to Real-Time AdRoll Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use AdRoll data in Power Apps.
-
Enable the Aircall JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Aircall data.
-
Stream EmailOctopus Data into Apache Kafka Topics
Access and stream EmailOctopus data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Zoho Inventory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Zoho Inventory with IBM WebSphere for seamless data integration and connectivity.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse data through an SAP BusinessObjects universe.
-
Natively Connect to Adobe Commerce Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Adobe Commerce data. Leverage the native support for ODBC in PHP.