SharePoint Data Cloud Connectivity

Jerod Johnson
Director, Technology Evangelism

Explore a compilation of guides and tutorials demonstrating how to establish connections to SharePoint data through CData Connect AI using different applications and tools.

CData Connect AI provides access to SharePoint data from popular BI, analytics, ETL, and custom applications. In addition to pre-built client tools, CData Connect AI enables direct real-time bi-directional integration from a wide range of cloud applications. Below you will find a list of guides and tutorials for integrating with live SharePoint data.

Connect AI Integrations

Click below to jump to articles related to specific integration use-case.

Artificial Intelligence - agents, chatbots, and workflows (Claude, ChatGPT, n8n, crewAI, etc.)
Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
ETL & Replication - moving and replicating data (AWS Glue, Oracle Data Integrator, etc.)
Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)

Artificial Intelligence

Product	Technology	Article Title
Agentforce	Connect AI	Connecting Agentforce with SharePoint Data
Azure AI Foundry	Connect AI	Use Azure AI Foundry to Talk to Your SharePoint Data
Boomi AgentStudio	Connect AI	Integrating Boomi AgentStudio with SharePoint Data
ChatGPT	Connect AI	Connect SharePoint Data to ChatGPT
Claude Code	Connect AI	How to Query Live SharePoint in Claude Code
Claude.ai	Connect AI	Use Claude.ai to Talk to Your SharePoint Data
crewAI	Connect AI	How to Connect to Live SharePoint Data from crewAI Agents
Cursor	Connect AI	Integrate Cursor with Live SharePoint Data
Databricks Agent Bricks	Connect AI	Use Databricks Agent Bricks to Talk to SharePoint Data
Dataiku	Connect AI	Integrating Dataiku with SharePoint Data
Flowise	Connect AI	How to Connect Flowise AI Agents to Live SharePoint Data
Gemini (CLI)	Connect AI	How to Connect to Live SharePoint Data from Gemini CLI
Gemini Enterprise	Connect AI	How to Connect to Live SharePoint Data from Gemini Enterprise
Google ADK	Connect AI	How to Connect to Live SharePoint Data from Google ADK Agents
Google Vertex AI	Connect AI	Integrate Google Vertex AI Agents with Live SharePoint Data
Gumloop	Connect AI	Integrating Gumloop with SharePoint Data
IBM watsonx Orchestrate	Connect AI	Build AI Agents with SharePoint Data in IBM watsonx Orchestrate
Langchain	Connect AI	Integrating LangChain with SharePoint Data
LangGraph	Connect AI	Integrating LangGraph with SharePoint Data
Mastra	Connect AI	Connecting Mastra with SharePoint Data
Mistral (Le Chat)	Connect AI	Connect SharePoint Data to Mistral
MS Copilot Studio	Connect AI	Connect SharePoint Data to Microsoft Copilot Studio
n8n	Connect AI	Build SharePoint-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)	Connect AI	How to Connect to Live SharePoint Data from OpenAI Python Applications
Relevance AI	Connect AI	Build Agents in Relevance AI with Access to Live SharePoint Data
Sourcegraph Amp	Connect AI	How to Connect to Live SharePoint Data from Sourcegraph Amp

Business Intelligence & Analytics

Product	Article Title
Alteryx Designer	Work with Live SharePoint Data in Alteryx Designer (Connect AI)
Amazon QuickSight	Build Interactive Dashboards from SharePoint Data in Amazon QuickSight
Amazon SageMaker	Integrate Live SharePoint data into Amazon SageMaker Canvas
Azure Analysis Services	Model SharePoint Data Using Azure Analysis Services
Cognos Analytics (On-Prem)	Analyze SharePoint Data in Cognos Analytics
Gecokboard	Create Dashboards and Visualize Live SharePoint Data in Geckoboard
Google Sheets	Access Live SharePoint Data in Google Sheets
Grafana	Create SharePoint-Connected Dashboards in Grafana
Infragistics Reveal	Analyze SharePoint Data in Infragistics Reval
Klipfolio	Create SharePoint-Connected Visualizations in Klipfolio
Looker	Analyze SharePoint Data in Looker
Looker Studio	Create Reports from SharePoint Data in Looker Studio
Metabase	Create Interactive SharePoint-Connected Metabase Dashboards
Microsoft Excel	Access Live SharePoint Data in Excel Desktop
Microsoft Excel for the Web	Access Live SharePoint Data in Excel for the Web
MicroStrategy	Connect to Live SharePoint Data in MicroStrategy through Connect AI
Mode Analytics	Create SharePoint-Connected Visualizations in Mode
Power BI Service	Visualize Live SharePoint Data in the Power BI Service
Qlik Cloud	Create Apps from SharePoint Data in Qlik Sense Cloud
Redash	Query, Visualize, and Share live SharePoint Data in Redash
SAP Analytics Cloud	Analyze SharePoint Data in SAP Analytics Cloud
SAP Crystal Reports	Publish Reports with SharePoint in Crystal Reports (Connect AI)
SAS Viya	Analyze Live SharePoint Data in SAS Viya
Tableau	Visualize SharePoint in Tableau Desktop (Connect AI)
Tableau Cloud	Build SharePoint Visualizations in Tableau Cloud
ThoughtSpot	Model, Search, and Visualize Live SharePoint Data in ThoughtSpot
Zoho Analytics	Create SharePoint-Connected Dashboards in Zoho Analytics

ETL & Replication

Product	Article Title
Airbyte	Connect to SharePoint Data in Airbyte ELT Pipelines
AWS Glue	Build ETL Jobs with SharePoint Data in AWS Glue Jobs
Azure Data Factory	Import SharePoint Data Using Azure Data Factory
Google Data Fusion	Build Pipelines with Live SharePoint Data in Google Cloud Data Fusion (CData Connect AI)
Microsoft Power Automate	Build SharePoint-Connected Automated Tasks with Power Automate (Desktop)
SnapLogic	Integration with SharePoint Data in SnapLogic (Connect AI)
SQL Server Linked Server	Connect to SharePoint Data as a SQL Server Linked Server
Workato	Build Automated Workflows with Live SharePoint Data in Workato
Zapier	Build Automated SharePoint-Connected Workflows in Zapier

Data Virtualization

Product	Article Title
APOS Live Data Gateway	Build Semantic Layer Views for SharePoint Data (Connect AI)
Salesforce Connect	Edit and Search SharePoint External Objects in Salesforce Connect
Salesforce External Services	Connect to SharePoint through External Services in Salesforce
SQL Server PolyBase	Connect to SharePoint Data using PolyBase with Connect AI

Software Development

Product	Article Title
Axios	Build SharePoint-Connected Web Apps with Axios and CData Connect AI
AppSheet	Create SharePoint-Connected Business Apps in AppSheet
Bubble.io	Build SharePoint-Connected Apps in Bubble
Choreo	Build Custom Apps on SharePoint Data in Choreo
Google Apps Script	Connect to SharePoint Data in Google Apps Script
Jitterbit	Integrate with Live SharePoint Data in Jitterbit
Mendix	Build SharePoint-Connected Apps in Mendix (Connect AI)
Microsoft Power Apps	Integrate Live SharePoint Data into Custom Business Apps Built in Power Apps
NodeJS	Query SharePoint Data in Node.js (via Connect AI)
OutSystems	Create SharePoint-Connected Enterprise Applications in OutSystems
Retool	Build SharePoint-Connected Apps in Retool
RunMyProcess	Connect to SharePoint Data in RunMyProcess
Unqork	Create SharePoint-Connected Applications in Unqork

Data Management

Product	Article Title
HeidiSQL	Connect to SharePoint Data in HeidiSQL

Workflow Automation

Product	Article Title
Nintex Workflow Cloud	Build SharePoint-Connected Workflows in Nintex
Power Automate	Integrate SharePoint Data into Power Automate Automated Tasks

Ready to get started?

Learn more about CData Connect AI or sign up for free trial access:

Free Trial

URL: https://www.cdata.com/kb/tech/sharepoint-cloud-integration.rst