Discover how a bimodal integration strategy can address the major data management challenges facing your organization today.
Get the Report →FTP Integration Guides and Tutorials
A list of guides and tutorials for connecting to and working with live FTP data.
CData Software's connectivity tools enable users to connect directly to live FTP data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live FTP data.
Integration Use-Cases
Click below to jump to articles related to specific integration use-case.
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (CData Sync, 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.)
Business Intelligence & Analytics
ETL & Replication
Data Virtualization
Product | Technology | Article Title |
---|---|---|
Access Linked Tables | ODBC | Update FTP with a Microsoft Access Linked Table |
APOS Live Data Gateway | JDBC | Build Semantic Layer Views for FTP (JDBC) |
Denodo | JDBC | Create A Data Source for FTP in Denodo Platform |
Dremio | JDBC | Connect to FTP as an External Source in Dremio |
MySQL Federated Tables | ODBC | Connect to FTP as Federated Tables in MySQL |
Oracle Database | ODBC | Access FTP as a Remote Oracle Database |
PostgreSQL FDW | JDBC | A PostgreSQL Interface for FTP |
Salesforce Connect | Connect Server | Edit and Search FTP External Objects in Salesforce Connect |
SQL Server Linked Servers | ODBC | Connect to FTP as a Linked Server |
SQL Server PolyBase | ODBC | Connect to FTP as an External Data Source using PolyBase |
Software Development
Data Management
Product | Technology | Article Title |
---|---|---|
Apache Solr | JDBC | Import FTP Data into Apache Solr |
Coginiti Pro | JDBC | Access Live FTP Data in Coginiti Pro |
DataGrip | JDBC | Qeury FTP Data in DataGrip |
DB Artisan | JDBC | Manage FTP in DBArtisan as a JDBC Source |
DB Artisan | ODBC | Connect to FTP in DBArtisan |
DBeaver | JDBC | Connect to FTP in DBeaver |
DbVisualizer | JDBC | Connect to FTP in DBVisualizer |
Informatica Enterprise Data Catalog | JDBC | Add FTP to Informatica Enterprise Data Catalog |
MySQL Workbench | Connect Server | Query FTP Data in MySQL Workbench (Connect Server) |
MySQL Workbench | ODBC | Query FTP in MySQL Workbench (ODBC) |
QuerySurge | JDBC | Validate FTP Data with QuerySurge |
RazorSQL | JDBC | Connect to FTP in RazorSQL |
SQuirreL | JDBC | Connect to FTP in Squirrel SQL Client |
Workflow Automation
Product | Technology | Article Title |
---|---|---|
MuleSoft Anypoint | JDBC | Access FTP in Anypoint Using SQL |
Nintex Workflow Cloud | Connect Server | Build FTP-Connected Workflows in Nintex |
Power Automate | Connect Server | Integrate FTP Data into Power Automate Automated Tasks |
SSIS Export | SSIS | Export Data from SQL Server to FTP through SSIS |
SSIS Import | SSIS | Import FTP Data into SQL Server using SSIS |
SSIS Lookup | SSIS | Insert New or Update Existing FTP Records from SQL Server |