# Loading Data

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

## Loading Data with HeavyDB Utilities <a href="#loading-data-with-omniscidb-utilities" id="loading-data-with-omniscidb-utilities"></a>

{% embed url="<https://www.youtube.com/watch?v=4nXKaj-IUN0>" %}

For more examples of loading data to HeavyDB, see [Loading Data with SQL](https://docs.heavy.ai/loading-and-exporting-data/command-line/load-data).

## Loading Data with Heavy Immerse <a href="#loading-data-with-immerse" id="loading-data-with-immerse"></a>

You can load a CSV or TSV file directly into a table in Heavy Immerse. HEAVY.AI 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 HEAVY.AI.

{% embed url="<https://www.youtube.com/watch?v=TpegfbRBTSc>" %}

## Loading Data with Apache Kafka <a href="#loading-data-with-apache-kafka" id="loading-data-with-apache-kafka"></a>

You can load data files into HeavyDB using Apache Kafka from the command line. See [Inserting Data Using Kafka](https://docs.heavy.ai/loading-and-exporting-data/supported-data-sources/kafka).

## Streaming Data with Apache Kafka <a href="#streaming-data-with-apache-kafka" id="streaming-data-with-apache-kafka"></a>

You can stream data from an application directly to the HeavyDB using Apache Kafka. See [Creating a Kafka Click-through Application](https://docs.heavy.ai/tutorials-and-demos/creating-a-kafka-streaming-application).

{% embed url="<https://www.youtube.com/watch?v=o0BTPCSSz1U>" %}