Practical tips and Use Cases

The best way to illustrate the use MFSQL Connector is by reviewing existing use cases.  The use cases are illustrated as blogs on different topics.

These use cases are not a comprehensive list, but rather a taste of what can be done.

The blogs can also be accessed by using the search for any related term, or navigate to the blog section of this guide.

Using MFSQL Connector

• Table relations - views for reporting

• Insert new records from SQL

• Getting to know MFSQL Connector

• Considerations for deleted records

• Considerations for large volume vault

• MultiSelectLookups

Reporting

• Near real time reporting

• Status report using context menu

• Working with object change history

• Table relations - views for reporting

• Considerations for deleted records

• Getting to know MFSQL Connector

• Considerations for large volume vault

• MultiSelectLookups

• Reports from the extended Event log

• Report designers and the Connector

Metadata management

• Updating only records that changed

• Deleting duplicate objects

• Moving documents from one class to another

• Aligning valuelist items with different owners

• Updating incorrect properties across multiple related classes

• Align metadata from an external source with data in M-Files

• Moving metadata from text properties to Valuelist items

Integration with third party applications

• Insert new records from SQL

• Getting to know MFSQL Connector

• Using hyperlinks with MFSQL Connector

• Using event handler for SQL action

• Processing scanned documents

• Using the External_ID to match third party app tables

• CRM and Emailer Management

• Integration with test equipment

• Integration with SAGE 50

Building extended applications

• Building applications around M-Files

• Create a scheduled pull from M-Files using SQL Server Agent

• Getting started with a custom application

• Integration whitepaper

• Processing scanned documents

• Updating only records that changed