Loading Data

You can load data using SQL commands and other utilities in OmniSciDB, or load delimited files in OmniSci Immerse.

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.