CData Software - Knowledge Base
Recent Articles
-
Create Reports with Redis Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Redis data.
-
Connect Microsoft Entra ID to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Microsoft Entra ID with IBM WebSphere for seamless data integration and connectivity.
-
Query Azure Analysis Services Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Analysis Services data.
-
Getting Started with the CData SSIS Components for Oracle SCM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Oracle SCM.
-
Build a Singer.io Tap for Templated With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Templated data using the CData Python Connector.
-
How to Connect Flowise AI Agents to Live Salesforce Marketing 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 Salesforce Marketing data without replication.
-
Building Dynamic Web Pages with MYOB AccountRight Data Using AngularJS
Create single-page applications with live connectivity to MYOB AccountRight using the CData API Server.
-
How to connect Amazon QuickSight to YouTube Analytics Data
Create a connection to YouTube Analytics data in CData Connect AI and insert YouTube Analytics data into Amazon QuickSight SPICE to build interactive dashboards.
-
Bridge Salesforce CRM Analytics Connectivity with Apache NiFi
Access and process Salesforce CRM Analytics data in Apache NiFi using the CData JDBC Driver.
-
Adobe Analytics Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Adobe Analytics data through CData Connect AI using different applications and tools.
-
Visualize Cassandra Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Cassandra data.
-
How to Visualize Zoom Data in Python with pandas
Use pandas and other modules to analyze and visualize live Zoom data in Python.
-
Query Live Salesforce Marketing 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 Salesforce Marketing data through a conversational interface.
-
Design BIRT Reports on CouchDB Data
Provide current CouchDB data to your embedded analytics.
-
Rapidly Develop Keap-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Keap.
-
Excel Spreadsheet Automation on Salesforce Data with the QUERY Formula
Pull data from Salesforce, automate spreadsheets, and more with the QUERY formula.
-
Connect to Scrapfly Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Scrapfly data in the Denodo Virtual DataPort Administrator.
-
How to Connect Oracle SCM Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Oracle SCM data in real time using natural language.
-
Create Paylocity-Connected Nintex Workflows
Use CData Connect AI to connect to Paylocity Data from Nintex Workflow Cloud and build custom workflows using live Paylocity data.
-
Working with Salesloft Data in LINQPad
Execute LINQ queries to Salesloft data in LINQPad.
-
Use ChatGPT to Talk to Your LDAP Objects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your LDAP objects for you.
-
Visualize Webflow Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Webflow data.
-
Analyze Snapchat Ads Data in Cognos Analytics
Use CData Connect AI to connect to Snapchat Ads Data from Cognos Analytics and analyze live Snapchat Ads data.
-
Build Agents in Relevance AI with Access to Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Table data within intelligent agent workflows.
-
How to Connect to Live Sage 300 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 Sage 300 data for you.
-
Integrate Live SAP SuccessFactors LMS Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SAP SuccessFactors LMS data and integrate live SAP SuccessFactors LMS data into apps built in Microsoft Power Apps.
-
Integrate RSS Feeds in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live RSS feeds from Informatica Cloud.
-
Integrate Attio Data in the Pentaho Report Designer
Publish reports based on Attio data in the Pentaho BI tool.
-
Automated Continuous Phoenix Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon S3.
-
Migrating data from XML to Databricks using CData SSIS Components.
Easily push XML data to Databricks using the CData SSIS Tasks for XML and Databricks.
-
Automated Continuous Templated Replication to Snowflake
Use CData Sync for automated, continuous, customizable Templated replication to Snowflake.
-
Deploy the ADO.NET Provider for Retently on an SSRS Report Server
Connect to Retently data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Connect to LeadDesk in SpagoBI
Create reports featuring live LeadDesk data in SpagoBI Studio. Host LeadDesk reports on SpagoBI Server.
-
Choosing the Best Method to Connect Certinia to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Certinia data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Replicate ZarMoney Data in Heroku for Use in Salesforce Connect
Replicate ZarMoney data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a PostgreSQL Interface for Oracle Service Cloud Data using the CData JDBC Driver
Use the Remoting features of the Oracle Service Cloud JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Workday Data from AWS Glue
Use CData Connect AI to gain access to live Workday data from your AWS Glue jobs.
-
Automated GitHub Data Replication to Teradata
Use CData Sync to Customize and automate GitHub data replication to Teradata.
-
How to update Microsoft Dataverse from Excel
This article explains how to transfer data from Excel to Microsoft Dataverse using the Excel Add-In for Microsoft Dataverse.
-
Integrate Live Pinterest 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 Pinterest data from within the IDE.
-
Automated Continuous Humanity Replication to MySQL
Use CData Sync for automated, continuous, customizable Humanity replication to MySQL.
-
Connect to SAP HANA XS Advanced Data in DBeaver
Use the CData ODBC Driver to connect to SAP HANA XS Advanced data in DBeaver.
-
Access Marketo Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Marketo data from HeidiSQL.
-
Automated Continuous ZarMoney Replication to Vertica
Use CData Sync for automated, continuous, customizable ZarMoney replication to Vertica.
-
Visualize ScrapingBee Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ScrapingBee data.
-
How to Visualize WooCommerce Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live WooCommerce data in Python.
-
Create LinkedIn Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to LinkedIn Ads Data from Klipfolio and build custom visualizations using live LinkedIn Ads data.
-
Automate Egnyte Data Replication to Couchbase
Use CData Sync to Customize and automate Egnyte data replication to Couchbase.
-
Automated Continuous ShipEngine Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipEngine data replication to OneLake in Microsoft Fabric.
-
Query Act CRM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Act CRM data from Node.js.
-
Integrating Dataiku with Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Figshare data.
-
Automated Continuous Bannerbear Replication to SQL Server
Use CData Sync for automated, continuous, customizable Bannerbear replication to SQL Server.
-
Connect to Discourse Data in Jaspersoft Studio
Execute SQL to remote Discourse data in Jaspersoft Studio.
-
Analyze Bitbucket Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Bitbucket data and visualize Bitbucket data in SAP Analytics Cloud.
-
Getting Started with the CData ADO.NET Provider for OnePageCrm
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Integrate Google's Vertex AI Agent with Live Amazon DynamoDB 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 Amazon DynamoDB data within intelligent workflows.
-
Access Live Perplexity Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Perplexity data from your Google Sheets.
-
Integrate Google's Vertex AI Agent with Live Google Search 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 Google Search results within intelligent workflows.
-
Build Zoho Creator Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Zoho Creator data and build visualizations in Tableau.
-
Connect to NetSuite Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live NetSuite data.
-
Connect Salesforce CRM Analytics to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Salesforce CRM Analytics data using the CData Python MCP Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GitHub
Provide connectivity to GitHub data through an SAP BusinessObjects universe.
-
Integrating Kiro with Insightly 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.
-
Use the CData Software ODBC Driver for Dynamics NAV in MicroStrategy Desktop
Connect to Dynamics NAV data in MicroStrategy Desktop using the CData Software ODBC Driver for Dynamics NAV.
-
How to create an RPA flow for Smartsheet Data in UiPath Studio
Use the Smartsheet ODBC Driver to create workflows that access real-time Smartsheet data without any coding.
-
Build Timely-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Timely Data and create custom apps in Mendix.
-
Integrate Cursor with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Redshift data from within the editor.
-
Getting Started with the CData Excel Add-In for Amazon S3
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Amazon S3.
-
Build a Simple VCL Application for SAP ByDesign Data
How to build a simple VCL Application to view SAP ByDesign data in RAD Studio using the CData ODBC Driver for SAP ByDesign.
-
Query Spark Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Spark entities in PHP by modeling them as objects.
-
Building Dynamic Web Pages with Google Drive Data Using AngularJS
Create single-page applications with live connectivity to Google Drive using the CData API Server.
-
Connecting Moonlit Workflow with AlloyDB 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 AlloyDB data in real time.
-
Use the CData Software ODBC Driver for Sendwithus in MicroStrategy Web
Connect to Sendwithus data in MicroStrategy Web using the CData Software ODBC Driver for Sendwithus.
-
Create NetSuite Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time NetSuite data access from reports, embedded analytics, and more.
-
How to connect to Xero Data from IntelliJ
Integrate connectivity to Xero data with wizards in IntelliJ.
-
Connect to MessageBird Data in CloverDX (formerly CloverETL)
Transfer MessageBird data using the visual workflow in the CloverDX data integration tool.
-
Access Live Sybase IQ Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Sybase IQ data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Google Search Results with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Search from Power Pivot. You will use the Table Import Wizard to load Google Search results. You can visually build the import query or use any SQL supported by the driver.
-
A PostgreSQL Interface for Adobe Commerce Data using the CData ODBC Driver
Use the SQL Gateway and Adobe Commerce ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query Live NetSuite 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 NetSuite data through a conversational interface.
-
View Reports on Real-Time Bannerbear Data in Power BI Report Server
Use the CData ODBC Driver for Bannerbear to visualize Bannerbear data in Power BI Desktop and then publish them to Power BI Report Server.
-
Operational Reporting on Okta Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Okta data.
-
Use the CData Software JDBC Driver for Gong in MicroStrategy Web
Connect to Gong data in MicroStrategy Web using the CData Software JDBC Driver for Gong.
-
Query Azure Synapse Data in ColdFusion
Write standard ColdFusion data access code to connect to Azure Synapse data.
-
Build MySQL-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to MySQL Data from Zoho Analytics and import live MySQL data.
-
Publish Zoho Books-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Zoho Books data.
-
Design BIRT Reports on TigerGraph Data
Provide current TigerGraph data to your embedded analytics.
-
Build Semantic Layer Views for Contentful Data in APOS Live Data Gateway
Use the CData Connector for Contentful in APOS Live Data Gateway to build Semantic Layer Views for Contentful data.
-
Connect to ConvertAPI Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ConvertAPI data using standard SQL.
-
How to Build an ETL App for Wave Financial Data in Python with CData Connect AI
Build ETL pipelines that read and write live Wave Financial data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Shippo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Shippo data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to connect and process Suadeo data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Suadeo data.
-
Integrating Antigravity CLI with Cloudflare data via CData CLI
Connect Cloudflare data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Back Up Splunk data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Splunk. In this article, we will employ an SSIS workflow to populate a database with Splunk data data.
-
Integrate Live Campaigner Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Campaigner data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Integrate Trae with Live Trello Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Trello data from within the AI-powered IDE.
-
Automated Continuous CampaignMonitor Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to PostgreSQL.
-
How to Connect to Live SAP ByDesign 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 SAP ByDesign data for you.
-
Visualize Azure Synapse Data in Sisense
Create an ElastiCube in Sisense app with access to Azure Synapse data.
-
Integrating Antigravity CLI with Dynamics 365 data via CData CLI
Connect Dynamics 365 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.