Menu
Simba Technologies
Simba Technologies

Simba MongoDB ODBC Driver with SQL Connector 2.2.3
Installation and Configuration Guide

Simba > Drivers > MongoDB > ODBC Installation Guide > Windows > Configuration > Configuring Write-Back Options

Configuring Write-Back Options

You can configure write-back options to modify how the driver writes data to the MongoDB data store.

For detailed information about the options on this page, see Write-back Driver Configuration Options

To configure write-back options:

  1. To access write-back options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, click Configure, click Advanced Options, and then click Writeback Options.
  2. In the Batch Size field, type the maximum number of documents that the driver can handle at one time during a write operation.
  3. Use the options in the Write Concern Settings area to configure how the driver reports the success of a write operation:
    1. In the Write Concern field, type the total number of primary and secondary servers that must acknowledge a write operation in order for the driver to report a successful write operation.
    2. Note:

      • If you use a value that is greater than 1, make sure to also specify an appropriate value in the Timeout field. Setting this option to a value greater than 1 without specifying a timeout interval may cause the driver to wait indefinitely for replica set members to come online.
      • The process for acknowledging a write operation typically takes four times longer than an INSERT or UPDATE operation, but it is necessary if fault tolerance is important.
    3. In the Timeout field, type the maximum number of seconds that the driver waits for a secondary server to acknowledge a write operation before reporting that the operation has failed.
    4. To require the data to be committed to the journal before a write operation can be acknowledged, select the Journaled Writes check box.

    Note:

    For detailed information about the write concern feature in MongoDB, see "Write Concern" in the MongoDB Manual: https://docs.mongodb.org/manual/core/write-concern/.

  4. To save your settings and close the Writeback Options dialog box, click OK.
  5. Click OK to close the Advanced Options dialog box, and then click OK to close the Simba MongoDB ODBC Driver DSN Setup dialog box.