You can load data using SQL commands and other utilities in OmniSciDB, or load delimited files in OmniSci Immerse.
- Loading Data with OmniSciDB Utilities
- Loading Data with OmniSci Immerse
- Loading Data with Apache Kafka
- Streaming Data with Apache Kafka
Loading Data with OmniSciDB Utilities
For more examples of loading data to OmniSciDB, see Loading Data with SQL.
Loading Data with OmniSci Immerse
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.
Loading Data with Apache Kafka
You can load data files into OmniSciDB using Apache Kafka from the command line. See Inserting Data Using Kafka.
Streaming Data with Apache Kafka
You can stream data from an application directly to the OmniSciDB using Apache Kafka. See Creating a Kafka Click-through Application.