HI, can I use multiple views into Single MA so that i needn't create lots of MA and synch rules, to code a bit is k... and that'll increase the efficiency as well. Kindly suggest me is there any way out??? My scenario is I have four views and for Employee and students i need to create diffrent SQL MA and ADMA, respectively. It becomes to hectic. I therefore need to synch all the views into one SQL MA so that it could be easy to Provision users into AD. Kindly suggest me with favourable response... Regards, Abhinav

Hi, Are the views similar in format? I'd probably create a new view which does a UNION (or UNION ALL depending on your data) on the four existing views. You could also include a "hardcoded" column which indicates where the data came from, or even have a column indicating which objectType the row is (student/employee) and have different synchronisation rules on the object type. BR Tobias

You could either do what Tobbe suggest with a SQL UNION ALL if the data is similar. If not, you could create a new table and do some SQL stuff to populate that table from the other sources. The table could then act as a single source instead of the four views. Also, I have previously done something similar with my PowerShell MA (http://blog.goverco.com/p/powershell-management-agent.html) where I write a PowerShell Import script to "merge" some data from a few different sources into one. Using this approach also allows you to clean data if needed. However, if you are more familar with SQL, you should probably go in that direction instead of PowerShell (I just prefer the flexibility of PowerShell) :-)Regards, Soren Granfeldt blog is at http://blog.goverco.com | twitter at https://twitter.com/#!/MrGranfeldt

Yes, in fact, I would prefer to aggregate data from many SQL tables or views into a single view. The performance is going to be better than trying to join all the data in FIM and reduces the overall FIM complexity. The only thing I've run into trouble with is to watch out that if you're writing attributes back to SQL, not all views are updatable.Frank C. Drewes III - Architect - Oxford Computer Group