AllowMetadataFromMultipleCatalogs

Default Value Data Type Required

true

Boolean

No

Description

This option specifies whether metadata is retrieved from all catalogs when the connector makes a call to SQLTables or SQLColumns.

  • true: The connector retrieves metadata from all catalogs when making calls to SQLTables or SQLColumns.
  • false: The connector only retrieves metadata from the specified catalog when making calls to SQLTables or SQLColumns.

Note:

  • If this option is disabled, you must specify a catalog to make calls to SQLTables or SQLColumns. You can specify a catalog in the call to SQLTables or SQLColumns, or in the Catalog connection property.
  • Disabling this option may improve connector performance.