Configuring Write-Back Options

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

For detailed information about the options on this page, see Writeback Driver Configuration Options on page 1

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 connector can handle at one time during a write operation.
  3. Use the options in the Write Concern Settings area to configure how the connector 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 connector 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 connector 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 connector 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.