CData Software - Knowledge Base
Recent Articles
-
Integrate Google's Vertex AI Agent with Live Paylocity 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 Paylocity data within intelligent workflows.
-
Replicate Multiple Bitbucket Accounts via the CData Sync CLI
Replicate multiple Bitbucket accounts to one or many databases.
-
Integrate LibreChat with Live MarkLogic Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MarkLogic data from within the chat interface.
-
How to create an RPA flow for Keap Data in UiPath Studio
Use the Keap ODBC Driver to create workflows that access real-time Keap data without any coding.
-
How to Connect to Live FTP 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 FTP data for you.
-
Import Real-Time Freshservice Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Freshservice data in ColdFusion.
-
Configure the CData JDBC Driver for PostgreSQL in a Connection Pool in Tomcat
Connect to PostgreSQL data from a connection pool in Tomcat.
-
Connect to Supabase Data in HULFT Integrate
Connect to Supabase as a JDBC data source in HULFT Integrate
-
How to Connect to Live SparkPost 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 SparkPost data for you.
-
Access Live SFTP Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SFTP data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Seamlessly Bring MYOB AccountRight Data into Retool Using CData Connect AI
Integrate MYOB AccountRight data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automated Continuous SAP HANA Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP HANA replication to Google BigQuery.
-
DataBind Controls to Tickspot Data in Delphi
DataBind to Tickspot data in Delphi with standard data access components and controls.
-
Connect to Azure Data Lake Storage Data in RapidMiner
Integrate Azure Data Lake Storage data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect PhantomBuster to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PhantomBuster data using the CData Python MCP Server.
-
Viewing Typeform Data in RAD Studio Data Explorer
How to view Typeform data in RAD Studio Data Explorer using the CData ODBC Driver for Typeform.
-
Connect to Oracle Eloqua 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 Oracle Eloqua data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Elasticsearch
Provide connectivity to Elasticsearch data through an SAP BusinessObjects universe.
-
Build Apps with Live Amazon S3 Data Using the Low-Code Development Platform of Mendix
Connect Amazon S3 data with Mendix to build apps using the CData JDBC Driver for Amazon S3.
-
Automated Continuous Salesloft Replication to Snowflake
Use CData Sync for automated, continuous, customizable Salesloft replication to Snowflake.
-
Enable the Google Calendar JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Calendar data.
-
Replicate Multiple Adobe Analytics Accounts
Replicate multiple Adobe Analytics accounts to one or many databases.
-
Prepare, Blend, and Analyze IBM Informix Data in Alteryx Designer (Connect AI)
Build workflows to access live IBM Informix data for self-service data analytics.
-
Connect to MariaDB Data in RapidMiner
Integrate MariaDB data with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Google's Antigravity Agent with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live LinkedIn data using the Model Context Protocol.
-
Create Reports from Redis Data in Looker Studio
Use CData Connect AI to gain access to live Redis data and create custom reports in Looker Studio.
-
Connect to Spotify Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Spotify and work with Spotify data in your FileMaker applications.
-
Operational Reporting on Paymo Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Paymo data.
-
How to Connect to Live HubSpot Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live HubSpot data without replication.
-
Working with YouTube Analytics Data in LINQPad
Execute LINQ queries to YouTube Analytics data in LINQPad.
-
Access Live Discord Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Discord data into the statistical analysis tools available in SAS JMP. This article shows how to use Discord data in the Graph Builder and Query Builder.
-
Back Up Okta data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Okta. In this article, we will employ an SSIS workflow to populate a database with Okta data data.
-
How to Visualize Stripe Data in Python with pandas
Use pandas and other modules to analyze and visualize live Stripe data in Python.
-
Object-Relational Mapping (ORM) with SAP Concur 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 SAP Concur data into a Java-based ORM framework, Hibernate.
-
Integrate HDFS Data in Pentaho Data Integration
Build ETL pipelines based on HDFS data in the Pentaho Data Integration tool.
-
Publish Reports with Drip Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Drip data.
-
Work with Flowlu Data in FoxPro
Load Flowlu data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Goose with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Elasticsearch data from within the local AI agent.
-
Back Up Attio data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Attio data data.
-
Replicate AdRoll Data to Multiple Databases
Replicate AdRoll data to disparate databases with a point-and-click configuration.
-
Analyze Azure Synapse Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure Synapse data with the CData JDBC Driver for Azure Synapse.
-
DataBind Charts to Wave Financial Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Wave Financial data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Import Real-Time MailerLite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MailerLite data in ColdFusion.
-
Back Up SharePoint Excel Services data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SharePoint Excel Services. In this article, we will employ an SSIS workflow to populate a database with SharePoint Excel Services data data.
-
Query Eventbrite Data as a MySQL Database in Node.js
Execute MySQL queries against Eventbrite data from Node.js.
-
Access Live CampaignMonitor Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CampaignMonitor data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Natively Connect to Smartsheet Data in PHP
The CData ODBC driver for Smartsheet enables you to create PHP applications with connectivity to Smartsheet data. Leverage the native support for ODBC in PHP.
-
How to Query Amazon S3 Data in MySQL Workbench
Execute MySQL queries against live Amazon S3 data from MySQL Workbench.
-
Add eBay Analytics Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for eBay Analytics with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous Microsoft Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Ads replication to Amazon S3.
-
Extract, Transform, and Load Coda Data in Informatica PowerCenter
Create a simple Workflow for Coda data in Informatica PowerCenter.
-
Build MVC Applications with Connectivity to Zoom Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoom from an ASP.NET MVC application.
-
Access Salesforce CRM Analytics Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Salesforce CRM Analytics data from your Oracle system.
-
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.
-
How to Visualize Postmark Data in Python with pandas
Use pandas and other modules to analyze and visualize live Postmark data in Python.
-
Connect to Jira Assets Data in HULFT Integrate
Connect to Jira Assets as a JDBC data source in HULFT Integrate
-
Integrating LangGraph with Redis Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Redis data within automated workflows.
-
PhantomBuster Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on PhantomBuster facts in real time.
-
Build Vertica-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Vertica data.
-
Automated Continuous Bitly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Bitly replication to Apache Cassandra.
-
Build Apps with Live SendGrid data in Adalo using CData Connect AI
Use CData Connect AI to integrate live SendGrid data into the Adalo platform and build custom mobile and web applications with real-time SendGrid data.
-
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.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for SAP Business Warehouse
Provide connectivity to SAP Business Warehouse data through an SAP BusinessObjects universe.
-
Build Voice Agents in ElevenLabs with access to Live Trello Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Trello data.
-
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.
-
Visualize Sybase Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Sybase data.
-
LINQ to Aircall Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Aircall Data Provider.
-
Connect CampaignMonitor Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your CampaignMonitor data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build a Singer.io Tap for SAP Hybris C4C With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Hybris C4C data using the CData Python Connector.
-
Access Live SuiteCRM Data in TIBCO Data Virtualization
Use the SuiteCRM Tibco DV Adapter to create a SuiteCRM data data source in TIBCO Data Virtualization Studio and gain access to live SuiteCRM data from your TDV Server.
-
Provide OData Services of SAP Fieldglass Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Fieldglass data by developing a WCF Service Application.
-
Integrate Live Azure DevOps Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Azure DevOps from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure DevOps data.
-
Create Informatica Mappings From/To a JDBC Data Source for JobNimbus
Create JobNimbus data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
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 Discord Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Discord data replication to OneLake in Microsoft Fabric.
-
Integrate Theia IDE with Live Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Zoho Books data from within the development environment.
-
How to Connect Flowise AI Agents to Live PingOne 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 PingOne data without replication.
-
Use the CData Software ODBC Driver for Spotify in MicroStrategy Desktop
Connect to Spotify data in MicroStrategy Desktop using the CData Software ODBC Driver for Spotify.
-
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.
-
SAP Ariba Procurement Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP Ariba Procurement data through CData Connect AI using different applications and tools.
-
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.
-
How to Query Excel Online Data in MySQL Workbench
Execute MySQL queries against live Excel Online data from MySQL Workbench.
-
Automated Continuous ZohoSubscriptions Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to AlloyDB.
-
Create Reports from DocuSign Data in Looker Studio
Use CData Connect AI to gain access to live DocuSign data and create custom reports in Looker Studio.
-
Access Live Gumroad Data in AWS Lambda
Connect to live Gumroad data in AWS Lambda using the CData JDBC Driver.
-
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.
-
Consume SAP Netweaver Gateway OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP Netweaver Gateway feeds that reflect any changes in SAP Lumira.
-
Integrate Google's Antigravity Agent with Live Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Zuora data using the Model Context Protocol.
-
Visualize Superchat 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 Superchat data into TIBCO Spotfire.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy Desktop
Connect to Avalara AvaTax data in MicroStrategy Desktop using the CData Software JDBC Driver for Avalara AvaTax.
-
Use the CData ODBC Driver for Onfleet in Microsoft Power Query
You can use the CData Onfleet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Onfleet data into Microsoft Power Query.
-
Load NetSuite Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load NetSuite data to a database.
-
Query Shopify Data as a SQL Server Database in Node.js
Execute SQL Server queries against Shopify data from Node.js.
-
How to Query Live WordPress Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live WordPress data data in natural language using Python.
-
Using the CData Software ODBC Driver for Contentful in PyCharm
Connect to Contentful as an ODBC data source in PyCharm using the CData Software ODBC Driver for Contentful.
-
Connect to SharePoint Excel Services in SpagoBI
Create reports featuring live SharePoint Excel Services data in SpagoBI Studio. Host SharePoint Excel Services reports on SpagoBI Server.
-
Access Live Microsoft Exchange Data in AWS Lambda
Connect to live Microsoft Exchange data in AWS Lambda using the CData JDBC Driver.
-
How to Seamlessly Import LinkedIn Data into IBM SPSS Modeler
Integrate LinkedIn data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
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.