MFSQL Connector modules

MFSQL Connector is available as separate modules with different functionality and pricing.

This documentation describes the functionality of all the modules of the product. Contact support if your licensed package does not include a specific procedure or functional element described in the documentation.

MFSQL Connector Data Exchange

This module is used where the Connector is deployed to perform only data exchange with no need for extensive development of integrations and applications using M-Files APIs.

Examples of usage of this module:

  • Extract metadata from M-Files into SQL for reporting, trouble shooting or analysis and data cleansing

  • Upload metadata from SQL into M-Files. This is particularly relevant when the data preparation is complex or requires the extensive data management tools of SQL.

  • Simple extraction of data from a third party system and updating the data into M-Files

  • Combine M-Files metadata with other corporate data that is not in M-Files for reporting and analysis

The Data Exchange module includes the following:

  • Assemblies that apply the M-Files COM APIs and facilitates the connection between M-Files and SQL

  • Tables, Procedures and functions to operate all the different capabilities and functionality of the Connector in SQL, including but not limited to data exchange between M-Files and SQL

  • Context Menu in M-Files to trigger SQL operations from the M-Files user interface.

MFSQL Integration Connector

This module includes the Data Exchange module and additional procedures and functions to assist the developer to develop extensive integrations and applications around M-Files using SQL.

Examples of use cases when this module is required:

  • Building complex integration services with third party application

  • Complex metadata structure management and analysis

  • Process management and error handling

  • Exploring M-Files Event Log in SQL

  • Optimising large volumes of data and updates.

  • Iterative development cycles using the helper functions and procedures

The Developer module adds the following components:

  • Helper and accelerator procedures and functions

  • ETL module

  • Exporting M-Files Event Log

  • Integrating M-Files Reporting Tool with the Connector

  • Error Logging and analysis

  • Extended Context Menu functionality allowing for calling an SQL procedure from an action menu in M-Files, workflow state change, or event handler.

Example uses for the Context Menu functionality include:

  • Starting a SQL update process such as updating information from a third party system from within M-Files using a menu option button.

  • Performing a complex data preparation or copy function including multiple objects using a context sensitive button in M-Files

  • Automatically call a SQL store procedure to perform complex functions when a workflow state change takes place.