MFSQL Connector Operations

MFSQL Connector is a collection or framework of operations or capabilities.

These operations covers a wide range of interactions and analysis of M-files using SQL.

Scope of MFSQL Connector

The fundamental scope of MFSQL Connector determines the selection of operations available. MFSQL Connector allows a user of the tool to use Microsoft SQL to perform operations without resorting to coding the operations using the M-Files APIs. Each MFSQL Connector instance is a separate database related to a single vault.

Operations related to the metadata structure

The metadata structure and vault configurations at the core of an M-Files vault determines all operations related to the content of a vault.

Operations related to class objects

The most used operation is to create, update or deleted class objects. This operation is used in a wide range of scenarios and allows for many different types of options

Operations related to monitoring, analytics and exploration of results

Operations related to activity