> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-pipeline/components/writers/rdbms-writer.md).

# RDBMS Writer

### Configuration

All component configurations are classified broadly into 3 section

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

Please follow the demonstration to configure the component.

![](/files/uIndLy6QiW0vS22GCJOt)

### 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*