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:
- 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 connector can handle at one time during a write operation.
- Use the options in the Write Concern Settings area to configure how the connector 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 connector 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 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.
- 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.
- 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.
Note:
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/.
- DMLBatch Size
- Write Concern
- WriteConcernTimeout
- WriteConcernJournaled Writes
- Creating a Data Source Name
- Driver Configuration Options on page 1