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.