automation-and-operations

The MFSQL Connector provides automation and operational capabilities to streamline metadata management and enhance overall efficiency. This section offers an overview of the key automation features, operational best practices, and strategies for effectively utilizing automation within the connector.

Keeping the metadata structure up to date

Maintaining an accurate and up-to-date metadata structure is crucial for ensuring the integrity and consistency of metadata within the MFSQL Connector. In an environment where the metadata structure may change frequently, it is essential to run the procedure spMFDropAndUpdateMetadata to drop and update the metadata structure tables regularly. We recommend to run this procedure as part of a scheduled job, for example, daily or weekly, depending on the frequency of changes in the M-Files vault. It may even be necessary to run it in before each update process if the metadata structure changes often.

By using the following SQL command in your scheduled job, or procedure you can ensure that the metadata structure tables are always in sync with the M-Files vault:

EXEC spMFDropAndUpdateMetadata @IsStructureOnly = 1;

Keeping valuelist items up to date

When building integrations that rely on valuelist items, it is an important part of the integration routine to keep valuelist items up to date.

The blog Advanced updating of Valuelists from external source provides additional insights and best practices for managing valuelist items effectively.