MDS 2012 - After Loading Data into Staging Table (mdm.tblStgMember), data is not visible in the Web UI integration section.

Question

MDS 2012 - After Loading Data into Staging Table (mdm.tblStgMember), data is not visible in the Web UI integration section.

It is working through the Excel add-in, but not directly through the Database. Aparently the BATCH_ID field isn't being filled automatically.

Does anyone have an idea of what can be happening?

Thanks

Answer 1

Hi Bruno

Try using Entity Based Staging to load your data. Here's a great video that will help you get started:

http://msdn.microsoft.com/en-us/sqlserver/Video/hh802433

More detailed documentation on the different strategies available for bulk importing data here:

http://msdn.microsoft.com/en-us/library/ee633726.aspx

Arun

---

Arunjeet Singh (Microsoft SQL Server Master Data Services)