About SQL Integration #

The SQL Integration module enables powerful integration between M-Files and an MS SQL database. This module allows you to:

• Execute and call a stored procedure with parameters, based on Event or Schedule.
• Read data from the database based on Event or Schedule.

For instance, when an object within M-Files changes its state, the SQL Integration module can automatically send the relevant data to the SQL database, making it available to use in other systems.

Accessing SQL Integration #

1. Open M-Files Admin.
2. In the left-side tree view, expand the desired connection to the M-Files Server.
3. In the left-side tree view, expand the Document Vaults node.
4. Still in the left-side tree view, expand the vault where you installed the connector and select Configurations.
5. Expand Other Applications.
6. Expand Extension Kit.
7. Click on SQL integration.

Initial configuration steps #

To begin configuring a rule, you need to define four fundamental fields to establish the rule’s essentials. For detailed descriptions, please click on each field below:

• Name
• Description
• Enabled
• Configuration mode.