Search

Configuring the Simba ODBC Driver for MongoDB

Configuring the Simba ODBC Driver for MongoDB

Back Next

MongoDB ODBC Data Source Advanced Properties

MongoDB ODBC Data Source Advanced Properties

When you create a data source name, configure the advanced properties from

Advanced Options

.

The following table describes the advanced properties in the MongoDB ODBC driver:

Property	Description
Enable Double-Buffering	Specifies whether the driver retrieves the data using double-buffering or single-buffering. When enabled, the driver uses double-buffering to retrieve the data. When disabled, the driver uses single-buffering to retrieve the data.
Documents to fetch per block	The maximum number of documents that a query returns at a time. Default is 4096.
Expose strings as SQL_WVARCHAR	Specifies how the String data type maps to SQL. When enabled, the MongoDB String data type maps to SQL_WVARCHAR. When disabled, the MongoDB String data type maps to SQL_VARCHAR.
String Column Size	The maximum number of characters that a STRING column can contain. You can specify a maximum value of 2147483647.
Expose binary as SQL_LONGVARBINARY	Specifies whether the driver returns Binary columns as data of type SQL_LONGVARBINARY or SQL_VARBINARY. When enabled, the driver returns Binary columns as SQL_LONGVARBINARY data. When disabled, the driver returns Binary columns as SQL_VARBINARY data.
Binary Column Size	The maximum data length for Binary columns. You can specify a maximum value of 2147483647.
Enable Passdown	Specifies whether the driver optimizes joins between virtual tables, and passes filtering and aggregation optimizations to the MongoDB database for handling. When enabled, the driver optimizes joins between virtual tables, and passes filtering and aggregation optimizations to the MongoDB database for handling. When disabled, the driver does not optimize joins, and does not pass filtering and aggregation optimizations to the MongoDB database.
Mechanism	Specifies where the driver looks for the schema definition. If you select Database, the driver loads the schema definition from the MongoDB database. If you select Local File, the driver loads the schema definition from the JSON file specified in the Local File field or the LocalMetadataFile key.
Sampling Method	Specifies how the driver samples data when generating a temporary schema definition. You can choose from the following options: Forward: The driver samples data starting from the first record in the database, then samples the next record, and so on. Backwards: The driver samples data starting from the last record in the database, then samples the preceding record, and so on.
Sampling Count	The maximum number of records that the driver can sample to generate the schema definition. To sample every record in the database, set this option to 0.
Sampling Interval	The interval at which the driver samples records when scanning through the database to generate a temporary schema definition. For example, if you set the sampling interval to 2, the driver samples every second record in the database.

Configuring the Data Source Name on Windows

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.