Allow to mass update entity mappings - Export / Import custom mappings
The problem with the entity mappings is that there are 3 ways to generate mappings: 1- Refresh data entities - Will refresh metadata for existing entities in the DMFEntity table but will not redo the mapping. (This seems by design to avoid overwriting existing custom entity mappings) 2- Generate...
Create entities in bulk based on underlying tables
To support data warehouse projects spanning systems beyond D365, it is necessary to generate many data entities and in particular entities that are copies of underlying AX tables. These data entities are then exported to an azure sql database for access. Creation of data entities i...
Known limitations with finance and operations tables
As reported on MS docs there are number of tables that have limitation with Azure synapse as shown on the following, our ask is to implement a work around for export from Azure synapse until we are able to rectify this gap or to added on the road maps.
https://learn.microsoft....
Adding legal entity context to EcoResProductAttributeValueV3Entity
EcoResProductAttributeValueV3Entity does not have a field or company/legal entity context. the suggestion here is to add legal entity context to the entity, so that entity can be used to filter the data according to legal entity during import/export for produ...
Provide detailed information in Data Management when export to BYOD (e.g. throttling in Azure DB)
In Current exports to BYOD in Azure SQL DB it happens that the export job remains in status executing while export has stopped progress. The reasons might be duplicate key issue which are not reported or it is related to database throttling of Azure SQL DB. The tracking and analysis of such issue...
Easier creation of data validation tasks
The workspace "Data validation checklist" is a good feature for planning and distributing system config and business config/ data tasks+status. However, when having workshops with customers or while preparing workshops, it would be great if it was possible to be able to create task directly from ...
Efficiently identify all tables with data and associated entities in a gold data environment
Currently there is no way of listing all tables with data in them through the D365 front-end. This is needed in gold data environments as a critical checklist, and to identify missing entities. This would take the form of a listing (form, report) that shows all tables with records as follows: - ...
DMF - Recurring batch queue store original file for view and download
Possibility to view and download original file from the batch job queue.
Sometimes you need to study the original file to see what was wrong with it, as the error given by microsoft is not descriptive enough.
If the file is stuck in queue for a reason or another. Currently there ...
Please make it possible to configure MaxReceiveMessageSize
Please make it possible to configure MaxReceiveMessageSize. This was possible on AX 2012 but is not currently possible on AX7.
Add a data management option to delete records
Sometimes we need to bulk delete records and using data management would be a very convenient utility for this. Another application I've worked with had an additional column that could be added to the import file (e.g. CSV, etc) that was called DELETE. If the column had a cert...
Administrator