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 setup

Update assembly version manage license status and update context menu setup maintain log data update settings setup reporting validate profile connection test

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.

manage aliases create lookups create tables deployment details drop class tables sync metadata bulk updates update valuelist items

Operations related to metadata alignment

Pull data from MF analyse prepare for update Push to MF Import files (folders and blobs) Export files (folders and blobs) Convert unmanaged objects to managed CSV Operations change class manage additional properties

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

Update comments Get object history Get object versions Get and Set object metadata Set properties (rather than full object) Get and set object file data delete/undelete objects delete history

Operations related to monitoring, analytics and exploration of results

Event log bulk email event email class table column alignment class table stats table to HTML share links search users and usergroups

Operations related to processing activity

Event log show procedure performance email errors logging show update history