Overview

The MFSQL Connector provides a comprehensive set of features for working with M-Files metadata. This section offers an overview of the key metadata concepts, structures, and best practices for effectively utilizing metadata within the connector.

Metadata can broadly be categorized into the metadata structure and the metadata values assigned to objects. The metadata structure defines how metadata is organized, including object types, classes, properties, and relationships. Metadata values are the actual data assigned to objects based on this structure. The metadata structure is stored in a set of tables within the SQL database, which are synchronized with the M-Files vault. The metadata values are stored in class-specific tables that correspond to the classes defined in the metadata structure.

The following sections provide detailed information on the metadata structure tables, including their columns, relationships, and usage. Additionally, best practices for managing and utilizing metadata effectively within the MFSQL Connector are discussed.

The section on working with class tables provides insights into how to interact with class-specific tables, including querying, updating, and managing metadata values.