Advanced SQL integration with M-Files
Connect M-Files to your SQL databases with advanced capabilities — set property values from SQL, call stored procedures or advanced queries, and more.
When you need more than basic queries
Your clients expect accurate, up-to-date information.
When an invoice is marked as Paid in M-Files, they want that change reflected immediately in their SQL database, not hours later via a scheduled sync.
To meet all of your clients’ expectations and deliver reliable results, you might need to:
- Join multiple tables to gather precise, contextual data from SQL
- Format values before applying them to M-Files properties
- Call stored procedures with dynamic parameters for clean, structured updates
M-Files supports basic SQL queries on a fixed schedule, but when your solution demands more complex logic, real-time updates, and deeper control, you need a more powerful approach — one that supports advanced SQL operations without even writing code.
Expand the integration potential
Unlock advanced SQL capabilities that go beyond basic query support.
With Extension Kit Core, you can perform complex operations within the same rule and without the need for coding.
Execute SQL stored procedures directly from M-Files, triggered by object events or scheduled rules — with full support for dynamic parameters.
Run complex SQL queries that join tables and return the contextual data you need for accurate decision-making.
Automatically apply returned values to properties on the triggering object, a vault search result, or a specified object.
Automatically execute database operations when objects are created, deleted, or modified — no need to wait for scheduled syncs.
Fast, flexible, and always in sync
Build smarter SQL integrations — without code and without limits.
Use cases
A customer manages contracts in M-Files and needs to sync key data with an external database. Extension Kit lets you call any stored procedure and send data to any SQL database.
A customer uses M-Files to manage incoming invoices. After invoices are OCR-processed and approved, the relevant data is automatically sent to their ERP system for further processing.
See the configurationAutomatically send alerts or notifications from M-Files when specific conditions in the SQL database are met, such as overdue payments or low stock, by querying the database and updating metadata.
Ready to simplify your next M-Files implementation?
Empower your M-Files implementation and cut development time and cost with Extension Kit for M-Files - low-code/no-code solutions that accelerate deployment, simplify configuration, and deliver advanced features.
