MFSQL Connector Operations

MFSQL Connector provides a framework of operations that cover a wide range of interactions with M‑Files using SQL, plus supporting analysis and automation.

Scope

Use Microsoft SQL Server to perform many M‑Files operations without coding directly against the M‑Files APIs. Each MFSQL Connector instance is a separate database associated with a single vault.

Setup operations

  • Update assembly version (keep API versions aligned)

  • Manage license status and updates

  • Configure the context menu

  • Maintain log data

  • Update settings

  • Set up reporting

  • Validate email profile

  • Connection tests

Metadata structure operations

The vault’s metadata structure and configuration drive content‑related operations.

  • Manage aliases

  • Create lookup views

  • Create tables

  • Record deployment details

  • Drop class tables

  • Synchronize metadata

  • Perform bulk updates

  • Update value list items

Metadata alignment

  • Pull data from M‑Files

  • Analyze data

  • Prepare for updates

  • Push updates to M‑Files

  • Import files (folders and blobs)

  • Export files (folders and blobs)

  • Convert unmanaged objects to managed

  • CSV operations

  • Change class

  • Manage additional properties

Class object operations

Creating, updating, or deleting class objects is the most common workflow. Typical operations include:

  • Update comments

  • Get object history

  • Get object versions

  • Get and set object metadata

  • Set properties (instead of full object updates)

  • Get and set object file data

  • Delete/undelete objects

  • Delete history

Monitoring, analytics, and exploration

  • Event log

  • Bulk email

  • Event email

  • Class table column alignment

  • Class table statistics

  • Table to HTML

  • Share links

  • Search

  • Users and user groups

Processing activity

  • Event log

  • Show procedure performance

  • Email errors

  • Logging

  • Show update history