The Pervasive PSQL writer module stores attribute records into a live relational database. The Pervasive PSQL writer provides the following capabilities:
- Transaction Support: The Pervasive PSQL 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 Pervasive PSQL writer uses the information within the FME mapping file to automatically create database tables as needed.
- Writer Mode Specification: The Pervasive PSQL writer allows the user to specify what database command should be issued for each feature received. Valid writer modes are INSERT, UPDATE, and DELETE. The writer mode can be specified at three unique levels: on the writer level, on the feature type, or on individual features.