Functional Overview

The following is a functional overview of all the different aspects of MFSQL Connector by package.   Refer to Connector Modules for more detail about the different packages.

Overview of functional composition of the modules

The columns below reference the following modules

1. Data Exchange and Reporting Connector

2. Integration Connector

Functional element	1	2
Metadata structure
Auto create metadata structure tables
Analyse and refresh metadata using SQL
Drop & recreate metadata
Update names and aliases from SQL
Insert new valuelist items from SQL
Update aliases in bulk
Analyse metadata structure relationships
Show login accounts, user accounts details
Show workflows and workflow states
Show valuelists and valuelist items
Auto Create valuelist and workflow views
Show complex ownership relationships
Explore metadata usage in vault
Get metadata structure version
Class Tables
Create new class tables
Drop and re-create all class tables
Batch update of records
Update only changed records
Concurrent update processes
Update from and to M-Files
Update records from specific date
Update records with specific objids
Update records changed by specific SQL user
Update all included in Application tables
Update using filters
Helper procedures for update filters
Insert new records
Hyperlinks to show and links in M-Files
Format Hyperlinks for use in excel
Get object hyperlink to public links
Change classes and properties
Delete records
Delete adhoc properties in bulk
Get objver of objects
Copy objects in M-Files
Add comments for objects
Search objects
Delete adhoc properties
Special Functions
Work with delimited string objects
Convert data into html format for reporting
Include table in notification
Send html formatted email
Remove special characters in naming
Insert update multi lookup values
Send bulk notifications using templates
Files
Export files from M-Files to Folders
Send bulk emails with attachments
Import files from Database Blobs
Checksum of a file in M-Files
Import files from network folders
Get file size
Get data on files without downloading file
Views and Reporting
Explore full metadata structure
Create views for related lookups in bulk
Class Table Statistical report
Explore use of columns and errors
Explore valuelist item ownership relations
Export and views of M-Files event log
Export object history from M-Files
Produce process log summary for class tables
View Error log
Get and create comments of objects
View Update History
View Process Batch logs
View User Messages
View Audit History
Valuelists and valuelist items
Create valuelist lookup views
Create workflow state lookup views
Create, update, delete valuelist items
Operations in M-Files
Configurable context menu withitems
Access Website
Execute procedure on object
Execute procedure with workflow trigger
Execute procedure event handler trigger
Show user message
Process procedures synchronously
Process with feedback message
Process procedure asynchronously
Using SQL actions with WebAPI in cloud vault
Error Handling
Email notification of SQL errors
User Messages
Error logging
Email sent log
Process logging
show user message from SQL in M-Files
Formatted emailed process results
Show feedback message in M-Files
Validate email profile
Perform Class Table audits
Delete history logs
Special Applications
External application user to filter updates
Action M-Files Reporting Data Export
Update metadata on demand
Update metadata scheduled
Change history of any class property
Installation and upgrade
Installation package
License control by module
Auto setup of default authentication for SQL
Auto and manual install
Customize default settings
Retain custom settings when upgrading
Sample scripts to aid development
Install connectors for multiple vaults
Control log of all versions of procedures
Upgrade packages