Integration between MDS and SSIS
Hi, Can you please let me know how MDS ( Master data services) and SSIS (integration services) are inter-linked , in 2008 or in 2012? Thanks,Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/
November 7th, 2012 5:22am

http://blogs.adatis.co.uk/blogs/neil/archive/2011/07/14/a-pattern-to-load-data-to-master-data-services-via-ssis.aspx http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI310 http://blogs.adatis.co.uk/blogs/jeremykashel/archive/2012/10/11/matching-with-master-data-services-dqs-and-ssis.aspx These are just a few of the results for Googling "SSIS 2012 and MDS".MCSA SQL Server 2012 - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2012 8:01am

Hi Deepak MSBI, We can use SQL Server Integration Services (SSIS) to load data into Master data services(MDS). With SSIS we load data into the staging area tables and then in MDS via the import process. Please refer to: http://johanmachielse.blogspot.com/2011/02/master-data-services-loading-data-using.html Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. The "Exporting Master Data from Master Data Services" white paper at http://msdn.microsoft.com/en-us/library/jj218341.aspx describes the subscription views that you can export your master data into, and shows how to use SQL Server Integration Services (SSIS) to import your master data from a subscription view into a SQL Server table. Thanks, Eileen Eileen Zhao TechNet Community Support
November 8th, 2012 3:50am

Hi Deepak MSBI, We can use SQL Server Integration Services (SSIS) to load data into Master data services(MDS). With SSIS we load data into the staging area tables and then in MDS via the import process. Please refer to: http://johanmachielse.blogspot.com/2011/02/master-data-services-loading-data-using.html Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. The "Exporting Master Data from Master Data Services" white paper at http://msdn.microsoft.com/en-us/library/jj218341.aspx describes the subscription views that you can export your master data into, and shows how to use SQL Server Integration Services (SSIS) to import your master data from a subscription view into a SQL Server table. Thanks, Eileen Eileen Zhao TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
November 8th, 2012 3:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics