ODBC FTP / SFTP Driver (for CSV Files)

⚡ Key Benefits

• SQL on FTP/SFTP CSV — Query CSV/TSV files on FTP, SFTP, or FTPS servers using SELECT, WHERE, GROUP BY syntax
• Wildcard & Multi-File — Read single or multiple files using pattern matching (e.g., folder/cust*-?.csv)
• Custom Delimiters — Parse comma, tab, pipe, or any character-delimited files with header row control
• Compressed File Streaming — Read GZip and Zip CSV files directly without pre-extraction
• Centralized Access — Share driver via Data Gateway without local installs on client machines

📸 Visual Overview & Setup

1. Configure FTP / SFTP Connection 🔍 View Full Size	2. Browse FTP/SFTP CSV Files 🔍 View Full Size	3. Use in Power BI 🔍 View Full Size
4. Use in Excel 🔍 View Full Size	5. Query from SQL Server (T-SQL) 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

-- Aggregate CSV invoice data from FTP/SFTP server
SELECT
    Country AS Invoice_Country,
    SUM(UnitPrice * Quantity) AS Invoice_Total
FROM $
WHERE Discount > 0
GROUP BY Country
HAVING SUM(UnitPrice * Quantity) > 1000
ORDER BY Invoice_Total DESC
LIMIT 3
WITH (SRC='zappysys-public-bucket/invoices.csv')

🔧 Key Features

Read & Query CSV from FTP / SFTP

• SELECT with WHERE, ORDER BY, GROUP BY, LIMIT, and HAVING on FTP/SFTP-hosted CSV/TSV files
• Read single file (folder/cust-1.csv) or multiple files via wildcard (folder/cust*-?.csv)
• Custom column delimiter: comma, tab, pipe, or any character (ColumnDelimiter='|')
• UNION ALL and temp tables (#tbl) for combining results from multiple queries

CSV Parser Options

• Header row detection with HasColumnHeaderRow option
• Skip rows, trim fields, trim headers for messy input files
• Ignore blank lines and blank rows (no data for each column)
• Allow comments inside CSV files
• Error handling: throw on empty file or column count mismatch

SQL Functions & Language

• String: substr, printf, upper, lower, replace, trim, length
• Date/time: DATE, DATETIME, STRFTIME, JULIANDAY with modifiers
• Math: abs, round, random
• Control flow: COALESCE, IFNULL, NULLIF, CASE

File Handling & Compression

• Read GZip and Zip compressed CSV files in streaming mode
• Auto-fill missing columns with null values
• Pivot data — transform columns into rows
• Recursive sub-folder scanning with RECURSIVE='True'

Security & Platform

• FTP, SFTP (SSH), and FTPS (TLS/SSL) protocols with username/password or key-based authentication
• Standard ODBC for Power BI, Tableau, Qlik, Excel, SSRS, Informatica, Talend, SSIS, and custom apps
• Server-side access via Data Gateway — no local driver install required

💡 Common Use Cases

Typical scenarios for the FTP / SFTP ODBC Driver for CSV Files in reporting, ETL, and app development:

• FTP CSV reporting in Power BI or Excel: Query CSV files on FTP/SFTP servers and load into BI dashboards.
  Example: SELECT * FROM $ WITH (SRC='uploads/cust-1.csv')
• Multi-file aggregation: Read and aggregate many CSV files using wildcard patterns.
  Example: SELECT * FROM $ WITH (SRC='data/logs*.csv', RECURSIVE='True')
• Parse pipe-delimited or TSV files: Use custom delimiter settings for non-comma-separated data.
  Example: SELECT * FROM $ WITH (SRC='folder/data.tsv', ColumnDelimiter='|')
• Handle messy CSV files: Skip header rows, trim fields, ignore blank lines, and handle column mismatches.
  Example: configure skip rows, trim headers, and error handling in the DSN or WITH clause.
• Query compressed FTP files: Read GZip or Zip CSV files directly without extracting first.
  Example: the driver streams and decompresses on-the-fly.
• Server-side access without local ODBC: Route queries through Data Gateway from SQL Server Linked Server or JDBC clients.
  Example: Java or Linux services query FTP/SFTP CSV data via the gateway JDBC connection.

🎯 Summary

Bring FTP/SFTP CSV data into the ODBC ecosystem your team already uses.
Query with SQL, handle custom delimiters and messy files, aggregate across multiple files, and connect from Power BI, SQL Server, Excel, or code — without writing custom file-transfer integrations.

Trusted by Developers & IT Teams Worldwide Built for ODBC Workloads: One driver model across BI, ETL, databases, and custom code. Expert Technical Support: Engineers help with connection strings, SQL queries, and FTP/SFTP configuration. Proven Enterprise Scale: Thousands of teams worldwide rely on ZappySys for API and cloud connectivity.

ODBC PowerPack Includes FTP / SFTP ODBC Driver for CSV Files Read reviews on Capterra →