CData Software - Knowledge Base
Recent Articles
-
Analyze Clari Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Clari data with the CData JDBC Driver for Clari.
-
Use the CData Software JDBC Driver for Salesforce Pardot in MicroStrategy Web
Connect to Salesforce Pardot data in MicroStrategy Web using the CData Software JDBC Driver for Salesforce Pardot.
-
Connect to DocuSign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DocuSign data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Wave Financial Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Wave Financial data from your Excel spreadsheets.
-
Automated Continuous Hugging Face Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Hugging Face replication to delimited files (CSV/TSV).
-
Integrate Devin with Live Azure Table Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Azure Table data.
-
Import Real-Time Instagram Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Instagram data in ColdFusion.
-
Connecting Agentforce with Reckon 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 Reckon data for you.
-
Build an OLAP Cube in SSAS from Acumatica Data
Establish a connection to Acumatica data data from SQL Server Analysis Services, and use the Acumatica Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to Create Power BI Visual Reports with Real-Time Jumpseller Data
Use CData Power BI Connectors to visualize Jumpseller data in Power BI.
-
How to Create Power BI Visual Reports with Real-Time Webex Data
Use CData Power BI Connectors to visualize Webex data in Power BI.
-
Integrate Live Notion 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 Notion data from within the IDE.
-
Integrate Cursor with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live HCL Domino data from within the editor.
-
Integrate with Clari Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Clari data to a JSON file on disk.
-
Build AI/ML Models with Live Azure Table Data using Dataiku
Connect Azure Table Data with Dataiku using the CData JDBC Driver for Azure Table.
-
Interact with Live Bannerbear Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Bannerbear data.
-
Integrating Cursor with Attio 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.
-
Replicate Avaza Data to Multiple Databases via the CData Sync CLI
Replicate Avaza data to disparate databases with a single configuration.
-
Connect to MailerLite from Asprova with CData Software ODBC Driver for MailerLite
This article shows how to connect faster to MailerLite data from Asprova.
-
Access Live Microsoft Ads Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
How to Access HBase Data Using Entity Framework
This article shows how to access HBase data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Agents in Relevance AI with Access to Live Google Sheets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Sheets data within intelligent agent workflows.
-
Automate SAP Netweaver Gateway Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Netweaver Gateway data from PowerShell? This article demonstrates how to utilize the SAP Netweaver Gateway Cmdlets for tasks like connecting to SAP Netweaver Gateway data, automating operations, downloading data, and more.
-
Connect to Snowflake Data in RapidMiner
Integrate Snowflake data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To a JDBC Data Source for WooCommerce
Create WooCommerce data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build Apps with Live Asana Data Using the Low-Code Development Platform of Mendix
Connect Asana data with Mendix to build apps using the CData JDBC Driver for Asana.
-
Build Teradata-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Teradata Data and create custom apps in Mendix.
-
Connect to Live SageHR Data in MicroStrategy through CData Connect AI
Create a live connection to SageHR Data in CData Connect AI and connect to your SageHR data from MicroStrategy.
-
How to Build an ETL App for CampaignMonitor Data in Python with CData
Create ETL applications and real-time data pipelines for CampaignMonitor data in Python with petl.
-
Build MVC Applications with Connectivity to Contentful Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Contentful from an ASP.NET MVC application.
-
Build Automated Workflows with Live Greenhouse Data in Workato
Use CData Connect AI to connect to live Greenhouse data and build automated workflows in Workato.
-
Automated Continuous Odoo Replication to Vertica
Use CData Sync for automated, continuous, customizable Odoo replication to Vertica.
-
Connect to Couchbase Data from Crystal Reports
Use CData Connect AI to connect to and report on live Couchbase data from Crystal Reports.
-
Integrate ADP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ADP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ADP data.
-
Build Visualizations of Dynamics 365 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics 365 data in Birst.
-
Work with Live Google Ads Data in Power Query
Use CData Connect AI to connect to Google Ads data and work with live Google Ads data in Microsoft Power Query.
-
Connect to Pipeline CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Pipeline CRM data from PowerBuilder using the Pipeline CRM JDBC Driver.
-
Connect to Certinia Data from PowerBuilder via JDBC
This article demonstrates how to access Certinia data from PowerBuilder using the Certinia JDBC Driver.
-
How to Visualize FHIR Data in Python with pandas
Use pandas and other modules to analyze and visualize live FHIR data in Python.
-
Import and Visualize Zoho Creator Data in Power View
Create data visualizations based on Zoho Creator data in Excel.
-
Connect to SAP Hybris C4C Data in NetBeans
Connect to SAP Hybris C4C data in NetBeans with the data source configuration wizard.
-
Integrating Gumloop with Sugar CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Sugar CRM data within automated workflows.
-
Analyze Productboard Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Productboard from Power Pivot. You will use the Table Import Wizard to load Productboard data. You can visually build the import query or use any SQL supported by the driver.
-
Create Campaigner-Connected Nintex Workflows
Use CData Connect AI to connect to Campaigner Data from Nintex Workflow Cloud and build custom workflows using live Campaigner data.
-
Integrate Salesforce Data in the Pentaho Report Designer
Publish reports based on Salesforce data in the Pentaho BI tool.
-
How to connect to Hive Data from Spring Boot
Connect to Hive in a Spring Boot Application using the CData JDBC Driver for Hive
-
Provide OData Services of Amazon S3 Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amazon S3 data by developing a WCF Service Application.
-
Create Informatica Mappings From/To an ODBC Data Source for BigQuery
Create an ODBC connection to BigQuery in Informatica and browse and transfer BigQuery data.
-
Create Dashboards and Visualize Live Smartsheet Data in Geckoboard
Use CData Connect AI to connect to live Smartsheet data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Edit and Search External Vault CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Vault CRM data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Vault CRM Data objects that you can access from apps and the dashboard.
-
How to connect Amazon QuickSight to ZohoDesk Data
Create a connection to ZohoDesk data in CData Connect AI and insert ZohoDesk data into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Data Flows from SAP SuccessFactors LMS to SQL Server using SSIS
Easily back up SAP SuccessFactors LMS data to SQL Server using the SSIS components for SAP SuccessFactors LMS.
-
Seamlessly Bring Adobe Analytics Data into Retool Using CData Connect AI
Integrate Adobe Analytics data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize Live Notion Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Notion data into custom reports in Power BI.
-
Automated Continuous SAP ByDesign Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SAP ByDesign replication to Google BigQuery.
-
Connecting Moonlit Workflow with Dynamics 365 Business Central 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 Dynamics 365 Business Central data in real time.
-
Analyze Active Directory Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Active Directory data and visualize Active Directory data in SAP Analytics Cloud.
-
Build Charts with Demio Data in Clear Analytics
Create dynamic charts and perform analytics based on Demio data in Clear Analytics.
-
Connect to Amazon S3 Data from a Connection Pool in JBoss
Integrate Amazon S3 data into Java servlets: Use the Management Console in JBoss to install the Amazon S3 JDBC Driver.
-
Automated Continuous XML Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable XML replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for ZendeskSell in MicroStrategy Web
Connect to ZendeskSell data in MicroStrategy Web using the CData Software ODBC Driver for ZendeskSell.
-
Automated Continuous Printful Replication to Oracle
Use CData Sync for automated, continuous, customizable Printful replication to Oracle.
-
Build Agents in Relevance AI with Access to Live ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ConstantContact data within intelligent agent workflows.
-
SAP Fieldglass Reporting in OBIEE with the SAP Fieldglass JDBC Driver
Deploy the SAP Fieldglass JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Excel Spreadsheet Automation on Telegram Data with the QUERY Formula
Pull data from Telegram, automate spreadsheets, and more with the QUERY formula.
-
Create Guru-Connected Business Apps in AppSheet
Connect to Guru Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Guru data.
-
Use the CData Software ODBC Driver for Google Analytics in MicroStrategy Web
Connect to Google Analytics data in MicroStrategy Web using the CData Software ODBC Driver for Google Analytics.
-
Automated Continuous Xero Replication to SingleStore
Use CData Sync for automated, continuous, customizable Xero replication to SingleStore.
-
Integrate Cursor with Live Mailjet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Mailjet data from within the editor.
-
How to connect and process Freshdesk data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Freshdesk data.
-
Natively Connect to Browserless Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Browserless data. Leverage the native support for ODBC in PHP.
-
Analyze Sage 200 Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Sage 200 data and visualize live Sage 200 data in Infragistics Reveal.
-
How to Connect to Live FTP Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live FTP data securely in real time.
-
Use the CData ODBC Driver for Perigon from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Perigon to connect to Perigon data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Perigon data in Excel.
-
Access Onfleet 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 Onfleet data.
-
Visualize Live RSS Feeds in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live RSS feeds.
-
How to publish and share Slack Data dashboards with Tableau Server
The CData ODBC driver for Slack enables you integrate Slack data into Tableau dashboards.
-
Automated Continuous Quaderno Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Quaderno replication to delimited files (CSV/TSV).
-
Explore Geographical Relationships in eBay Analytics Data with Power Map
Create data visualizations with eBay Analytics data in Power Map.
-
How to Work with Microsoft Planner Data in ETL Validator JDBC
Connect to Microsoft Planner from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Vercel Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Vercel replication to delimited files (CSV/TSV).
-
Visualize Splunk Data in TIBCO Spotfire through ADO.NET
Integrate Splunk data into dashboards in TIBCO Spotfire.
-
Create Reports with Pinterest Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pinterest data.
-
Getting Started with the CData Python Connector for Pinecone
Learn to install and license the CData Python Connector and configure a connection to live Pinecone data.
-
Integrating Gumloop with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SendPulse data within automated workflows.
-
Validate Microsoft Entra ID Data with QuerySurge
Access and validate Microsoft Entra ID data in QuerySurge using the CData JDBC Driver.
-
Integrate Live WordPress Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WordPress data and integrate live WordPress data into apps built in Microsoft Power Apps.
-
Replicate SuiteCRM Data to Multiple Databases via the CData Sync CLI
Replicate SuiteCRM data to disparate databases with a single configuration.
-
Visualize Unbounce Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Unbounce data.
-
Access SpaceX Data from MySQL in PHP
Connect to SpaceX through the standard MySQL libraries in PHP.
-
How to connect and process Calendly data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Calendly data.
-
Query MYOB AccountRight Data through ODBC in Node.js
Use node-odbc to execute SQL queries against MYOB AccountRight data from Node.js.
-
Use the CData Software ODBC Driver for Dynamics CRM in MicroStrategy
Connect to Dynamics CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics CRM.
-
Build Certinia-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Certinia data without replication.
-
Integrate Live Salesforce Marketing Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Salesforce Marketing data to Blue Prism using the CData ODBC Driver for Salesforce Marketing to create automated workflows for repetitive business tasks.
-
Working with Microsoft Exchange Data in LINQPad
Execute LINQ queries to Microsoft Exchange data in LINQPad.
-
Moving Data from AfterShip to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live AfterShip data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Model, Search, and Visualize Live EnterpriseDB Data in ThoughtSpot
Use CData Connect AI to connect to live EnterpriseDB data for modeling, searching, and visualizing.
-
Use CData Connect AI to Access Oracle Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle data in the Power Pivot business intelligence tool.
-
Use the CData ODBC Driver for Stack Exchange in Microsoft Power Query
You can use the CData Stack Exchange ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Stack Exchange data into Microsoft Power Query.