Home/Integrations/SoftAdvice apps/Incremental Exporter
SoftAdvice appIncremental Exporter: M-Files data in your data warehouse
Export predefined sets of M-Files metadata to an SQL database that serves as a data warehouse for reporting. Only the records that changed since the last run are exported, on a schedule, so even large vaults can feed daily BI reports.
See how it works Discuss your reporting
Illustrative example
In short
The Incremental Exporter is an M-Files app built by SoftAdvice that exports predefined sets of M-Files metadata to an SQL database, on premises or in Azure, as a data warehouse for BI reporting. It creates and maintains the tables automatically and supports full and incremental exports. In incremental mode it uses timestamps to export only the records that changed since the previous run, on a schedule, instead of rebuilding the whole reporting database each time. It is made for high-volume vaults that need daily reports.
From M-Files to SQL, one change at a time
Predefined metadata sets in an SQL database
You define which object types and properties are exported. The Incremental Exporter writes them to an SQL database, on premises or in Azure, and creates and maintains the tables automatically.
- Only the metadata you need for reporting
- Tables created and kept up to date by the app
- A data warehouse your BI tool can read

Only what changed since the last run
On every scheduled run the app uses timestamps to find the records that were modified since the previous export, and exports only those. Unchanged records stay where they are in the database.
Illustrative example
A full export when you need one
Next to the incremental mode, the app supports full exports, for example for the first load of the data warehouse or after you add properties to a metadata set.
Illustrative example
Why incremental matters for large vaults
M-Files Reporting empties and rebuilds the complete reporting database at every scheduled refresh. The Incremental Exporter only moves what changed.
| Topic | M-Files Reporting | Incremental Exporter |
|---|---|---|
| What a scheduled run exports | The complete database, emptied and rebuilt | Only the records modified since the last run |
| As the vault grows | Each refresh has more data to process | Each run follows the volume of changes |
| Daily reporting on a high-volume vault | Harder to fit into a daily schedule | Made for it |
| Tables in the SQL database | Rebuilt at each refresh | Created once, then maintained automatically |
Reporting on M-Files data without the heavy lifting
Your M-Files metadata becomes a reliable source for dashboards and analyses.
Daily reports on large vaults
Because only changes are exported, a daily schedule stays realistic as the vault grows.
Lighter for vault and database
No complete rebuild of the reporting database at every refresh.
Your own BI tool
Any reporting tool that reads SQL can use the data warehouse.
No table maintenance
The app creates and maintains the tables itself.
On premises or in Azure
Export to a local SQL database or to one in Azure.
At a glance
The Incremental Exporter is built and supported by SoftAdvice. We help you choose the metadata sets, set up the schedule and connect your reporting tool to the data warehouse.
Datasheet
- Systems
- M-Files and an SQL database
- Database
- On premises or Azure
- Direction
- Outbound: M-Files to SQL
- Export
- Full or incremental, on a schedule
- Changes found by
- Timestamps
- Availability
- International, any sector
Questions about the Incremental Exporter
What does the Incremental Exporter do?
It exports predefined sets of M-Files metadata to an SQL database, which then serves as a data warehouse for reporting and BI.
How is it different from M-Files Reporting?
M-Files Reporting empties and rebuilds the complete reporting database at every scheduled refresh. The Incremental Exporter exports only the records that were modified since the previous run.
Which databases are supported?
An SQL database, either on premises or in Azure. The app creates and maintains the tables itself.
Can we still run a full export?
Yes. The app supports both full and incremental exports.
Who is it for?
For organisations in any sector with high-volume vaults that want daily reports on their M-Files data in their own BI tool.
Daily reports on your M-Files data
We look at your vault and your reports and set up the export with you.