Export Data Integrator projects to text file to move between environments
Need the ability to develop a complex integration using data integrator and export it out so we can then import to a client or other tenant from where originally developed. Change management within the same client is not enough.
Improvement of data exchange process with data management platform
In one of our assets we use Data management platform for operation data exchange between D365FOE and third systems. We faced here with some limits and issues. The correction of them could improve the data exchange process:
- Concurrent processing of data entity:
If...
Entity metadata structure extraction
In order to discuss with customer the structure of enttity (string and length, integer float, enum with its values, and so on) for importing data into Dynamics D365 for F&O could be very useful to have a tool for export the data structure and metadata for entity or for any table in D365. (like...
Data Import Error Message Correction
Error message is incorrect for data that exceeds the character limit - it says duplicate rows
Out of the box role for data management operations user with no access to delete execution history.
There should be an out of the box security role similar to “Data management operations user” which should allow data import export but not allow deletion of execution history. Currently there is no such role and if assigned to users, users can delete the trace of a data import.
update documentation
Currently if new fields are added on a data import or export project you can see if new fields are added. So that the user is informed that the entity is updated since the last mapping date.
Link to Line in file required when Import Fails due to bad / unclean data
When importing data into an entity, if there is bad data (Examples below), the exceptions are recorded in Staging log details. These lines will never make it into the staging tables. The errors are usually of type "value violates integrity". The column of the table that threw this error is hig...
Hi Shashi--
We are closing this idea for lack of details as asked earlier. If you would like us to consider this idea, pls share the requested information with me at sunilg@microsoft.com.
Sincerely,
Sunil Garg
Microsoft.
DUNS number should be part of the Global Address Book entity (DirPartyV2Entity)
Currently there is no way to export or import DUNS number for Parties in the Global Address Book. The field is shown as part of the "General" fields displayed for at party. It should be possible to export and import parties with the DUNS number.
Data project with insert-only
New setting for data project / entities - insert-only. Sometimes we want to be sure that the same primary key is not received twice. Simple setting like this would ensure that the data is not manipulated with duplicates after received.
Refresh entity list by batch
Please, give us possibility to refresh entities by batch. Run refresh is needed after each update (ISV, etc.) and it is often forgotten.
Administrator
Thank you for your feedback.
We need some more details to understand your suggestion better. Can you please help us by answering the following questions?
It is not clear as to what the ask is. If you would like, we can discuss over email at sunilg@microsoft.com.
Once we understand better as to what the ask and the use cases are, we will definitely take this for review.
Sincerely,
Sunil Garg
Microsoft.