You can load data using SQL commands and other utilities in OmniSciDB, or load delimited files in OmniSci Immerse.
For more examples of loading data to OmniSciDB, see Loading Data with SQL.
You can load a CSV or TSV file directly into a table in OmniSci Immerse. OmniSci supports Latin-1 ASCII format and UTF-8. If you want to load data with another encoding (for example, UTF-16), convert the data to UTF-8 before loading it to OmniSci.
You can load data files into OmniSciDB using Apache Kafka from the command line. See Inserting Data Using Kafka.
You can stream data from an application directly to the OmniSciDB using Apache Kafka. See Creating a Kafka Click-through Application.