Exporting Data from MDS 2012 entity to SQL 2012 database table

Question

Exporting Data from MDS 2012 entity to SQL 2012 database table

karthik M

One Orange Chip

Points: 29139
More actions
July 30, 2014 at 5:57 am

#289387

Hi All,
How to export data from MDS 2012 entity to SQL 2012 user database table ?
Inputs are welcome!
Thanks
Karthik M
karthik

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: 259105 More actions · Answer 1

Create a Subscription View (Master Data Services)

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: 246956 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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 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: 246956 More actions · Answer 5

Same as any other view.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 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