Exporting Data from MDS 2012 entity to SQL 2012 database table

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246977 More actions · Answer 2

Koen Verbeeck (7/30/2014)
Create a Subscription View (Master Data Services)

+1 - beat me to it.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

Phil Parkin (7/30/2014)
Koen Verbeeck (7/30/2014)
Create a Subscription View (Master Data Services)
+1 - beat me to it.

I just had myself a cup of caffeine 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

karthik M One Orange Chip Points: 29139 More actions · Answer 4

I am not still clear.

Once I create the subscription view, how should i access that view from the user database?

karthik

Phil Parkin SSC Guru Points: 246977 More actions · Answer 5

Same as any other view.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 6

karthik M (7/30/2014)
I am not still clear.
Once I create the subscription view, how should i access that view from the user database?

With a SELECT statement.

You can automate this through stored procedures or with SSIS.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP