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