# RDBMS Writer

### Configuration

All component configurations are classified broadly into 3 section

* [Basic ](https://docs.bdb.ai/bdb-documentation/data-pipeline/components/component-base-configuration)
* Metadata
* [Resource Configuration](https://docs.bdb.ai/bdb-documentation/data-pipeline/components/resource-configuration)

Please follow the demonstration to configure the component.

![](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FcooP0CDfIUU4hN7TaGda%2FRDBMS_writer.gif?alt=media\&token=e2a28b46-6a70-4891-b99a-0267b46e2b16)

### Save Modes

RDBMS writers supports 3 save modes

#### Append

Add new records

#### Overwrite

This mode truncates the table and add fresh records.  after every run you will get records which are part of the last run

#### Upsert

This operation allows the users to insert a new record or update existing data into a table. For configuring this we need provide the key. 

We support composite key based upsert, in case of composite key, we can specify the second key by using comma separator eg:- *key1, key2*