Hi,
For the enterprise resource planning module I propose the following:
1) A periodic extraction of data from the user's enterprise resource planning object oriented database.
By going to the data direct we eliminate links in the chain that may cause issues in the future, and which we have no direct control over.
2) A flexible view builder so that users can generate the queries they need themselves rather than having to request the same.
For security we will restrict the user's view of Data Manager data to just that they have permissions for.
3) Two more export procedures that will work in tandem: Export Worksheet (which defines what data and formatting template to use) and Export Workbook (which defines which worksheets the workbook will contain).
The process chain will be Access front-end, MySQL back-end, custom C++ dynamic link library, Power-shell script, Microsoft Excel.
4) Export helpers for the new export procedures so that the learning curve is very slight.
The above will be implemented in an abstract way so that the features described are relevant to all other users as well.
Please let me know if you have any questions.
Best regards