Utility Tables

A number of special tables are included in the Connector. The purpose and key columns of these tables are described below.

  • MFDataType: Used by the Connector to convert M‑Files data types

    to SQL data types. Do not change this table; doing so will make the assemblies inoperable.

  • MFDeploymentDetail: Stores deployment details.

  • MFSettings: Stores connection details for the Connector database and other

    settings.

  • MFVaultSettings: Stores the connection details to the M‑Files vault.

  • MFProcess: Includes the process ID and description of the process.

MFDataType

The MFDataType table defines conversions between M‑Files data types and SQL data types. This table is used with spMFCreateTable to set the columns of class tables.

Note that the ‘Time’ data type in M‑Files converts a varchar value to a valid time in M‑Files. The input value in SQL for a time‑ based column must be a string of the format nn:nn using the 24‑hour time format. Hours and minutes outside 1–24 and 0–59 will result in an M‑Files data type error.

MFDeploymentDetail

The MFDeploymentDetail table is maintained by the Connector and shows the latest version of the Connector that is deployed to the database.

MFSettings

The settings table defines key settings used by the Connector. It can also store application‑specific settings as long as the structure of the table is not changed and the minimum requirements for the Connector are met.

The table stores the M‑Files user and vault settings for the Connector, as outlined in the security section.

Use the encrypt and decrypt procedures when the M‑Files password is updated in the settings table, as described in the CLR integrated security section.

The table is also used for email settings, as described in the error management section.

Enable Database Mail on the SQL Server instance and create an email profile for the Connector. This email profile name must be stored in the value column of the setting SupportEmailProfile.

MFProcess table

Several process_ID values are used by the Connector to indicate the status of a record in the ClassTable for processing. These IDs are defined in the Process table. The following process_id values are predefined and must be retained in the settings table. Additional application‑specific processes may be added.