Documents to Sample

SamplingLimit

Key Name Default Value Required

SamplingLimit

100

No

Description

The maximum number of records that the connector can sample to generate a temporary schema definition. When this option is set to 0, the connector samples every document in the database.

Important:

Important:

  • Make sure to configure the connector to sample all the necessary data. Documents that are not sampled do not get included in the schema definition, and consequently do not become available in ODBC applications.
  • Typically, sampling a large number of documents results in a schema definition that is more accurate and better able to represent all the data in the database. However, the sampling process may take longer than expected when many documents are sampled, especially if the database contains complex, nested data structures.