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:
- 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.
- In the Batch Size field, type the maximum number of documents that the driver can handle at one time during a write operation.
- Use the options in the Write Concern Settings area to configure how the driver reports the success of a write operation:
- 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.
- 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.
- 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.
- To require the data to be committed to the journal before a write operation can be acknowledged, select the Journaled Writes check box.
- To save your settings and close the Writeback Options dialog box, click OK.
- Click OK to close the Advanced Options dialog box, and then click OK to close the Simba MongoDB ODBC Driver DSN Setup dialog box.