SFTP Data Cloud Connectivity

Jerod Johnson
Director, Technology Evangelism

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

CData Connect AI provides access to SFTP 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 SFTP 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 SFTP Data
Agno	Connect AI	Use Agno to Talk to Your SFTP Data
Sourcegraph Amp	Connect AI	How to Connect to Live SFTP Data from Sourcegraph Amp
Antigravity	Connect AI	Integrate Google's Antigravity Agent with Live SFTP Data
Boomi AgentStudio	Connect AI	Integrating Boomi AgentStudio with SFTP Data
ChatGPT	Connect AI	Connect SFTP Data to ChatGPT
Claude Agent SDK	Connect AI	How to Connect to Live SFTP Data from Claude Agent SDK
Claude Code	Connect AI	How to Query Live SFTP in Claude Code
Claude.ai	Connect AI	Use Claude.ai to Talk to Your SFTP Data
Cline	Connect AI	Integrate Cline with Live SFTP Data
MS Copilot Studio	Connect AI	Connect SFTP Data to Microsoft Copilot Studio
crewAI	Connect AI	How to Connect to Live SFTP Data from crewAI Agents
Cursor	Connect AI	Integrate Cursor with Live SFTP Data
Databricks Agent Bricks	Connect AI	Use Databricks Agent Bricks to Talk to SFTP Data
Dataiku	Connect AI	Integrating Dataiku with SFTP Data
Dify	Connect AI	Integrate Dify with Live SFTP Data via CData Connect AI
ElevenLabs	Connect AI	Build Voice Agents in ElevenLabs with Access to Live SFTP Data
Emergent	Connect AI	Access Live SFTP Data in Emergent
Flowise	Connect AI	How to Connect Flowise AI Agents to Live SFTP Data
Azure AI Foundry	Connect AI	Use Azure AI Foundry to Talk to Your SFTP Data
Gemini Enterprise	Connect AI	How to Connect to Live SFTP Data from Gemini Enterprise
Gemini (CLI)	Connect AI	How to Connect to Live SFTP Data from Gemini CLI
GenSpark	Connect AI	Connecting GenSpark with SFTP Data
Google ADK	Connect AI	How to Connect to Live SFTP Data from Google ADK Agents
Google Vertex AI	Connect AI	Integrate Google Vertex AI Agents with Live SFTP Data
Goose	Connect AI	Integrate Goose with Live SFTP Data via CData Connect AI
Grok	Connect AI	Use Grok to Talk to Your SFTP Data
Gumloop	Connect AI	Integrating Gumloop with SFTP Data
IBM watsonx Orchestrate	Connect AI	Build AI Agents with SFTP Data in IBM watsonx Orchestrate
Langchain	Connect AI	Integrating LangChain with SFTP Data
LangGraph	Connect AI	Integrating LangGraph with SFTP Data
LibreChat	Connect AI	Integrate LibreChat with Live SFTP Data
LlamaIndex	Connect AI	Integrating LlamaIndex with SFTP Data
Manus AI	Connect AI	Use Manus AI to Talk to Your SFTP Data
Mastra	Connect AI	Connecting Mastra with SFTP Data
Mistral (Le Chat)	Connect AI	Connect SFTP Data to Mistral
Moonlit	Connect AI	Connecting Moonlit Workflow with SFTP Data
n8n	Connect AI	Build SFTP-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)	Connect AI	How to Connect to Live SFTP Data from OpenAI Python Applications
OpenCode	Connect AI	Integrate OpenCode with Live SFTP Data via CData Connect AI
Open WebUI	Connect AI	Integrate Open WebUI with Live SFTP Data
Relevance AI	Connect AI	Build Agents in Relevance AI with Access to Live SFTP Data
Roo Code	Connect AI	Access Live SFTP Data in Roo Code
Theia IDE	Connect AI	Integrate Theia IDE with Live SFTP Data
Windsurf	Connect AI	Integrate Live SFTP Data in the Windsurf IDE
Zed	Connect AI	Query Live SFTP Data in Zed Editor

Business Intelligence & Analytics

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

ETL & Replication

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

Data Virtualization

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

Software Development

Product	Article Title
Google Apps Script	Connect to SFTP Data in Google Apps Script
AppSheet	Create SFTP-Connected Business Apps in AppSheet
Appsmith	Create SFTP-Connected Applications in Appsmith
Axios	Build SFTP-Connected Web Apps with Axios and CData Connect AI
Bubble.io	Build SFTP-Connected Apps in Bubble
Choreo	Build Custom Apps on SFTP Data in Choreo
Dash (Python)	Use Dash to Build Web Apps on Live SFTP Data
Jitterbit	Integrate with Live SFTP Data in Jitterbit
Mendix	Build SFTP-Connected Apps in Mendix (Connect AI)
NodeJS	Query SFTP Data in Node.js (via Connect AI)
OutSystems	Create SFTP-Connected Enterprise Applications in OutSystems
pandas (Python)	How to Visualize SFTP Data in Python with pandas
Microsoft Power Apps	Integrate Live SFTP Data into Custom Business Apps Built in Power Apps
Python	Getting Started with the CData Connect AI Python SDK for SFTP
Retool	Build SFTP-Connected Apps in Retool
RunMyProcess	Connect to SFTP Data in RunMyProcess
Unqork	Create SFTP-Connected Applications in Unqork

Data Management

Product	Article Title
HeidiSQL	Connect to SFTP Data in HeidiSQL

Workflow Automation

Product	Article Title
Nintex Workflow Cloud	Build SFTP-Connected Workflows in Nintex
Pipedream	Connecting Pipedream with SFTP Data via CData Connect AI
Power Automate	Integrate SFTP 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

CData is the data layer that makes AI work in production—live connectivity and replication across hundreds of the most critical enterprise sources, semantic context, and built-in governance. Powering AI for Databricks, Microsoft, Google, Palantir, and 10,000+ customers worldwide.