Database Connection
Database
When you enter the Database in the Destination Dataset field, the Database field will be automatically populated in the Parameters box.
Username and Password
Enter the username and password to access the database, user account, or wherever authentication is required.
Persistent Connection
When enabled, the database connection persists for the duration of an FME session.
For example, it may be desirable to maintain a connection when running a batch of 100 workspaces on the same database connection, which saves the processing time required to make and break a database connection.
FME considers the database connection to be the same when the database name, the username, and password are the same.
Connection Timeout
The time (seconds) after which to terminate a query to the database if it has not yet returned a connection/result.
If it is set to 0, there is no timeout. The default is 30.
Advanced
Abort Translation On Bad Data
Some features may contain out-of-range or invalid attribute values. These features will be rejected and cannot be written to the database. If Yes, the translation aborts immediately after encountering bad data. If No, the translation continues, but rejected features are not written to the database.
Features Per Transaction
The number of features that FME places in each transaction before a transaction is committed to the database.