Bulk load data into a database

Overview

A Bulk Load is a method provided by a database management system to load multiple rows of data from the source file into a database table. The Etlworks Integrator includes several Flow types optimized for the bulk load. 

When to use Bulk Load Flows

Usually, bulk operations are not logged, and transactional integrity is not enforced. Often, bulk operations bypass triggers and integrity checks. This improves performance for loading large amounts of data quite significantly.

In many cases, using bulk load is overkill, and setting it up is a more complex process than alternative methods available in the Etlworks Integrator. Read how to load data into databases without bulk operations.   

Bulk load with ETL

Use ETL with a bulk load when you need to extract data from any source, transform and load it into the database which supports a bulk load.

Bulk load files without ETL

Use the flow type Bulk load files into database without transformation when you need to load files in the local or cloud storage directly into the database which supports a bulk load.