The Database writer module stores attribute records into a live relational database. The Database writer provides the following capabilities:
- Transaction Support: The Database writer provides transaction support that eases the data loading process. Occasionally, a data load operation terminates prematurely due to data difficulties. The transaction support provides a mechanism for reloading corrected data without data loss or duplication.
- Table Creation: The Database writer uses the information within the FME mapping file to automatically create database tables as needed.
- Bulk Loading: The Database writer uses a bulk loading technique to ensure speedy data load only when there are no LOB (BLOBs or CLOBs) columns in the table. The performance vastly exceeds a one-insert-at-a-time approach.