Supported Protocols

The SQL Loader connector reads and writes data from flat file data, which uses a delimiter character to index the information. The flat file can be either a text file (.txt) or a CSV file (.csv).

The SQL Loader connector supports the file transfer protocols listed in the following table when a file is in a shared or remote location and is accessible to the configured Virtual Appliance cluster. The file sharing protocol supported varies depending on the server platform in use:

File Transfer Protocol

Supported Platform

Supported Operations

FTP

Linux

Read/Write

SFTP

Linux

Read/Write

HTTP

Linux

Read

HTTPS

Windows and Linux

Read

FTPS

Linux

Read/Write

Note

  • When using FTP, SFTP, or SFTP protocols, the connector may intermittently fail with timeout or login failed errors for aggregation and provisioning operations.

  • The connector can provision values to all attributes with a length less than or equal to 19 characters.