MFSQL Data Exchange and Reporting Connector

This module is the foundation of the Connector and include all the functionality to enable the connector framework and is used where the Connector is deployed to perform data exchange only, with no need for building integrations or applications. It is particularly useful for reporting scenarios.

This section will cover the installation, configuration, and operation of the Data Exchange and Reporting Connector.

The next section covers the Integration module that builds on this foundation and includes additional helper functions and procedures that may be useful for more extensive data exchange operations.

After installation and basic configuration, the following sections will cover working with metadata, class tables, context menu operations, and reporting.

Example use cases for this module include:

  • Extract metadata from M-Files into SQL for reporting, troubleshooting, analysis, and data cleansing.

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

  • Extract data from a third‑party system and update that data into M-Files.

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

The deep dive sections, blogs and example scripts provide practical examples of how to apply the functionality in different scenarios.