Loading Data

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

Loading Data with OmniSci Core Utilities

For more examples of loading data to OmniSci Core Database, 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 OmniSci Core Database 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 OmniSci Core Database using Apache Kafka. See Creating a Kafka Click-through Application.