I am using SQL 2012 MDS 2012 . I am trying to use versioning concept to flag committed data . We will be loading bulk data every week once and so can't use the MDS frontend to load this data and therefore using Excel add in to load this huge data every week.
I was trying to do versioning and noticed when we lock the version only Explorer on MDS frontend gets locked but EXcel addin still allows to update the data.. IS there any solution for this or is this a bug ??
Appreciate any help on this as we can 't use MDS explorer to load bulk data, as it allow row by row entry.
The committed data should not be updated either using explorer or excel. If you load committed data in excel and make some changes, there will be error raised as this: "The version is read-only. You do not have permission to update the
version." when trying to publish these changes. Please double check if the version was committed or the data is with the committed version in excel?