Data Files URL Formatting

Use the following table to determine the URL format you need to enter into the Data Files URL field in the SQL Loader Account Connection and Group Connection, based on your server protocol and file type.

Protocol Server

File Type

Example

FTP server

.csv

jdbc:csv:ftp://<host/ server IP>/<directory path>

.txt

jdbc:text:ftp://<host/ server IP>/<directory path>

SFTP server

.csv

jdbc:csv:sftp://<host/ server IP>/<directory path>

.txt

jdbc:text:sftp://<host/ server IP>/<directory path>

HTTP server

.csv

jdbc:csv:http://www.<http_host_path>

.txt

jdbc:text:http://www.<http_host_path>

HTTPS server

.csv

jdbc:csv:https://www.<https_host_path>

.txt

jdbc:text:https://www.<https_host_path>