MFSQL Connector applications work together with your in-house systems to enhance the application of M-Files and help your company find, share, and secure documents and information. This integration allows access for M-Files metadata to a range of different types of applications.

While we won’t illustrate the use of MFSQL Connector with individual use cases here, we will look at the top five MFSQL Connector applications and show you how they can help your company.

1.   Enable Complex Applications

MFSQL Connector can enable complex applications, including scan capture integration, online quote systems, online special stock orders, and more.

Using M-Files and SQL Server, you can access and edit MS SQL tables, views, functions, and stored procedures with any development platform. Data in MS SQL can be synchronized with M-Files using MFSQL Connector while metadata remains intact.

2. Create Deep ERP Integrations

One of the most popular MFSQL Connector applications is creating a deeper connection for SQL Server-based ERP data. With MFSQL Connector, you can tailor M-Files/ERP integrations such as managing vendor approvals, synchronizing full vendor invoices, and then post them automatically to the ERP.

How does this work? Using specific stored business procedures built into either the MFSQL Connector database or ERP SQL database, the SQL database automatically updates when certain conditions are met.

3. Simplify Data Management

It is easier to move data to and from M-Files using MFSQL Connector because it eliminates the need to understand the M-Files APIs or be proficient with Microsoft, .NET, VB Scripting, or Web technologies. In fact, a large volume of data can be analyzed, compared, aligned, and updated within SQL, and metadata can be automatically updated and processed without advanced programming knowledge.

MFSQL Connector can also find missing data, eliminate duplicate files, or combine data from M-Files and other systems. If you only need to manage a specific issue, MFSQL Connector can be rented short term.

4. Reduce Vault Complexity

Metadata needs to align between systems, or users will be lost when looking for content. Sometimes, metadata classes must be combined or split to make the vault more usable. Valuelists may need to be cleaned out, text-based properties may need to be moved to lookups, and object owners may need to be reset.

MFSQL Connector can extract M-Files information from your documents and automatically analyze how users add metadata. This improves the usability, accuracy, and alignment of M-Files metadata, thus reducing vault complexity.

5. Better Understand and Utilize Data

MFSQL Connector is often needed to extract, clean, align, and update mass data in M-Files. The benefit of this is a better understanding of what data you actually have. It can also show you where inaccurate or incomplete data needs to be updated or deleted from your document management system.

Once you see and understand your data, it becomes easier to clean it up. Once you complete this process, you can better understand and utilize data, creating tighter compliance and simplified audits.

MFSQL Connector Applications Simplify Business Data