Building custom applications and integrations

The main focus of the connector is to allow for building small and large custom applications and integrations around M-Files. Building these applications does not require deep knowledge of the M-Files API’s or .Net application development although it may be useful in some cases. The connector is built for and is very useful in the hands of someone with T-SQL query experience. This documentation does not prescribe a specific UI or app generator. You can build on any platform that works with SQL Server, or operate directly from SQL and M-Files where appropriate.

Architecture overview

At a high level, solutions use the Connector to bridge SQL and M-Files through: - Class tables for modeled objects and their versions - Procedures for CRUD and synchronization (e.g. spMFUpdateTable, batch logging) - Metadata sync (spMFDropAndUpdateMetadata) to keep schemas aligned - Optional lookup views for value lists/workflows to simplify joins

This architecture enables building UI or services on any platform that can talk to SQL Server, while leveraging M-Files for object storage, workflows, and permissions.