CData Software - Knowledge Base
Recent Articles
-
Import Real-Time Smartsheet Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Smartsheet data in ColdFusion.
-
Automated Continuous HCL Domino Replication to SingleStore
Use CData Sync for automated, continuous, customizable HCL Domino replication to SingleStore.
-
Connect to Demio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Demio data.
-
Provide OData Services of Microsoft Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Ads data by developing a WCF Service Application.
-
Connect to Elasticsearch Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Elasticsearch data using standard SQL.
-
How to Work with Reply.io Data in ETL Validator JDBC
Connect to Reply.io from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Acumatica Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Acumatica from Power Pivot. You will use the Table Import Wizard to load Acumatica data. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Couchbase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Couchbase data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Multiple Office 365 Accounts
Replicate multiple Office 365 accounts to one or many databases.
-
Connect to Gmail in SpagoBI
Create reports featuring live Gmail data in SpagoBI Studio. Host Gmail reports on SpagoBI Server.
-
Connect to Microsoft Planner 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 Microsoft Planner data.
-
Connect to FTP Data in ACL Analytics
Connect to FTP data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FTP data.
-
Automated Continuous Google Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Analytics replication to SQL Server.
-
Write a Simple Go Application to work with SAP Fieldglass Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Fieldglass data.
-
Integrate Live Slack Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Slack from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Slack data.
-
LINQ to Greenhouse 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 Greenhouse Data Provider.
-
How to import OData Services into Apache Solr
Use the CData Software JDBC Driver for OData in Data Import Handler and create an automated import of OData services to Apache Solr Enterprise Search platform.
-
Connect to Harvest Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Harvest and the SQL Gateway to access Harvest data from Google Apps Script.
-
Connect to Factorial Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Factorial data.
-
Access Live ConvertAPI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConvertAPI data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Tanda Reporting in OBIEE with the Tanda JDBC Driver
Deploy the Tanda JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Desktop
Connect to PingOne data in MicroStrategy Desktop using the CData Software JDBC Driver for PingOne.
-
Query Anaplan Data as a MySQL Database in Node.js
Execute MySQL queries against Anaplan data from Node.js.
-
Import Real-Time Oracle Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle data in ColdFusion.
-
Publish Reports with Procore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Procore data.
-
How to load ADP data into Elasticsearch via Logstash
Introducing a simple method to load ADP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Desktop
Connect to Mixpanel data in MicroStrategy Desktop using the CData Software JDBC Driver for Mixpanel.
-
How to Connect to Live Google Analytics 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 Google Analytics data for you.
-
Connect to Impala Data in Aqua Data Studio
Access Impala data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Helpscout Replication to SingleStore
Use CData Sync for automated, continuous, customizable Helpscout replication to SingleStore.
-
Model RSS Feeds Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and RSS, enabling the direct import of real-time RSS feeds.
-
Consume Sage 300 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 300 data as OData feeds from PowerBuilder using the API Server.
-
Connect to EmailOctopus Data in CloverDX (formerly CloverETL)
Transfer EmailOctopus data using the visual workflow in the CloverDX data integration tool.
-
Query Accelo Data in ColdFusion
Write standard ColdFusion data access code to connect to Accelo data.
-
Seamlessly Bring Zoho Creator Data into Retool Using CData Connect AI
Integrate Zoho Creator data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Teradata Data Replication to Azure Synapse
Use CData Sync to customize and automate Teradata data replication to Azure Synapse.
-
Connect to Scrapfly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Scrapfly as an External Source in Dremio.
-
Manage HubDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HubDB.
-
Integrate Workday Data into Power Automate Desktop using CData Connect
CData Connect for Workday Data enables you to integrate Workday data into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share Jodoo Data dashboards with Tableau Server
The CData ODBC driver for Jodoo enables you integrate Jodoo data into Tableau dashboards.
-
Analyze Live Aweber Data in SAS Viya
Use CData Connect AI to connect to Aweber data from SAS Viya and deploy self-service analytics using live Aweber data.
-
Getting Started with the CData Python Connector for Mocean
Learn to install and license the CData Python Connector and configure a connection to live Mocean data.
-
Build Charts with Reply.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Reply.io data in Clear Analytics.
-
Work with SAP Business One Data in FoxPro
Load SAP Business One data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Campaigner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Campaigner data in Microsoft R Open.
-
Integrating LangChain with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act CRM data within automated workflows.
-
Provide OData Services of Workday Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Workday data by developing a WCF Service Application.
-
Integrating Kiro with Redis 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.
-
Viewing Mixpanel Data in RAD Studio Data Explorer
How to view Mixpanel data in RAD Studio Data Explorer using the CData ODBC Driver for Mixpanel.
-
Use the CData ODBC Driver for XML in Microsoft Power Query
You can use the CData XML ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import XML data into Microsoft Power Query.
-
Automate Vercel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Vercel data from PowerShell? This article demonstrates how to utilize the Vercel Cmdlets for tasks like connecting to Vercel data, automating operations, downloading data, and more.
-
Integrating ZohoInvoice Data in Talend Cloud Data Management Platform
Connect ZohoInvoice Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Access Live CSV Data in AWS Lambda (with IntelliJ IDEA)
Connect to live CSV data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating GitHub Copilot with Pushbullet 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.
-
Query Live Cloudflare 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 Cloudflare data through a conversational interface.
-
Getting Started with the CData ODBC Driver for Tally
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Tally.
-
Getting Started with the CData Python Connector for Retently
Learn to install and license the CData Python Connector and configure a connection to live Retently data.
-
Integrate Live Spark Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Spark data and integrate live Spark data into apps built in Microsoft Power Apps.
-
Integrate Open WebUI with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Amazon Athena data from within the chat interface.
-
Analyze Google Forms Data in Looker
Use CData Connect AI to connect to Google Forms Data from Looker and build custom apps using live Google Forms data.
-
Visualize Gong Data in Tableau
The CData ODBC driver for Gong enables you integrate Gong data into Tableau dashboards.
-
Write a Simple Go Application to work with Office 365 Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Office 365 data.
-
Build AI Agents with Freshteam 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 Freshteam data through CData Connect AI.
-
Working with Mistral AI Data in LINQPad
Execute LINQ queries to Mistral AI data in LINQPad.
-
Automated Continuous Act CRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Act CRM replication to Amazon Redshift.
-
Integrate Browserless with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Browserless with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Browserless data.
-
Integrating GitHub Copilot with Invoiced 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 Facebook Data in Python with pandas
Use pandas and other modules to analyze and visualize live Facebook data in Python.
-
Build BigQuery-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live BigQuery data and build BigQuery-connected web apps with Axios.
-
Query Pipedrive Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipedrive data.
-
How to connect SharePoint with Box Data through external lists
Provide Box data to SharePoint users as an external list.
-
Create Dashboards and Visualize Live HubDB Data in Geckoboard
Use CData Connect AI to connect to live HubDB data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Google Contacts Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Contacts data from Crystal Reports.
-
Create Pingdom Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Pingdom data access from reports, embedded analytics, and more.
-
Connect and Visualize Live Marketo Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Marketo data into the Databricks platform and create visualization dashboards with real-time Marketo data.
-
Bridge Shortcut Connectivity with Apache NiFi
Access and process Shortcut data in Apache NiFi using the CData JDBC Driver.
-
Transfer Company File Data using the CData Excel Add-In
This article shows how to use the CData Excel Add-In for QuickBooks to transfer data from one company file to another. You will use the Excel Add-In to manage multiple connections and transfer customer records from one company file to another.
-
How to connect to PabblySubscriptions Data with Squirrel SQL client
Connect to PabblySubscriptions data and execute queries in the Squirrel SQL Client.
-
Integrate Vertica Data into Power Automate Desktop using CData Connect
CData Connect for Vertica Data enables you to integrate Vertica data into workflows built using Microsoft Power Automate Desktop.
-
Automate Excel Online Data Replication to Couchbase
Use CData Sync to Customize and automate Excel Online data replication to Couchbase.
-
Create Informatica Mappings From/To an ODBC Data Source for Perigon
Create an ODBC connection to Perigon in Informatica and browse and transfer Perigon data.
-
Getting Started with the CData ODBC Driver for SpaceX
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SpaceX.
-
Analyze SQL Analysis Services Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SQL Analysis Services from Power Pivot. You will use the Table Import Wizard to load SQL Analysis Services data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect to Live Salesforce Marketing 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 Salesforce Marketing data for you.
-
Integrate OpenCode with Live RSS Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live RSS feeds from within your AI coding agent.
-
Connect to WooCommerce Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with WooCommerce Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Automate MailerLite Data Replication to SAP HANA
Use CData Sync to customize and automate MailerLite data replication to SAP HANA.
-
Build a Simple VCL Application for Google Cloud Storage Data
How to build a simple VCL Application to view Google Cloud Storage data in RAD Studio using the CData ODBC Driver for Google Cloud Storage.
-
Connect to Typeform Data in RazorSQL
Connect to Typeform from wizards and query Typeform data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Everhour Replication to SQLite
Use CData Sync for automated, continuous, customizable Everhour replication to SQLite.
-
Use Dash to Build to Web Apps on Access Data
Create Python applications that use pandas and Dash to build Access-connected web apps.
-
Automate HBase Data Replication to Azure Synapse
Use CData Sync to customize and automate HBase data replication to Azure Synapse.
-
Connect to Freshservice Data from HeidiSQL
Use CData Connect AI to connect to and query live Freshservice data from HeidiSQL.
-
Connecting Moonlit Workflow with Printify 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 Printify data in real time.
-
Integrate Real-Time Access to Salesforce Pardot in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Salesforce Pardot data in real time.
-
Connect to Oracle Eloqua Reporting Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Oracle Eloqua Reporting data.
-
Create Omnisend-Connected Business Apps in AppSheet
Connect to Omnisend Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Omnisend data.
-
Visualize MailChimp Data in TIBCO Spotfire through OData
Integrate MailChimp data into dashboards in TIBCO Spotfire.
-
Object-Relational Mapping (ORM) with ConvertKit 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 ConvertKit data into a Java-based ORM framework, Hibernate.
-
Use the CData Software ODBC Driver for Freshservice in MicroStrategy Desktop
Connect to Freshservice data in MicroStrategy Desktop using the CData Software ODBC Driver for Freshservice.