ODBC 3.x Database Writer Parameters

When you enter the Database in the Destination Dataset field, the Database field will be automatically populated in the Parameters box.

Enter the username and password to access the database, user account, or wherever authentication is required.

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.

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.

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.

The number of features that FME places in each transaction before a transaction is committed to the database.

The default value is 1000.