For file processing, comma-separated value (CSV) and fix block value (FBV) file formats are supported. To improve performance you can specify an FTP/FTPS/HTTP/HTTPS server, and/or split the files into several parts to allow Exasol to read/write the data in parallel.
With the IMPORT command you can load CSV/FBV files directly from your local file system, from FTP/FTPS/HTTP/HTTPS servers, or from S3 or Hadoop.
If integration with an external bulk loading tool is required you can use the exajload tool, which is available as a part of the JDBC driver package. exajload is a bulk loading tool for local files. You can use it if you want to start a loading job by scripts without opening a JDBC connection. To learn more about the available options, run the command ./exajload -help for Linux environments or java -jar ./exajload.jar -help for Windows environments.
For more information about EXAjload including examples of use, see EXAjload: advanced techiniques.