none
Importing criteria based group from file/sql table RRS feed

  • Question


  • Experts,
    I have following data in file as well as in SQL table.

    #Deptname,deptnumber

    I want to create group in FIM Portal with name DEPT_deptname and criteria 'user's having such deptnumber'.

    Not able to find anyway.

    Please suggest.

    Thanks,
    Mann
    Sunday, April 20, 2014 5:38 PM

Answers

  • Thanks Poulson!

    As I understand, filter attribute in FIM Service is storing the criteria that we create in FIM Portal.

    So I will create an inbound rule and will flow the value mentioned by you in 'filter'.

    Let me try.

    -Mann

    • Marked as answer by Mann.Cool Tuesday, April 22, 2014 4:14 PM
    Monday, April 21, 2014 3:43 PM

All replies

  • Hi,

    Speaking off top of my head, I'd do the following:

    • Establish attribute flow for group object with FIM MA,
    • Do not forget to add Filter Attribute on FIM MA, add filter attribute in FIM Sycnhronization engine on group object
    • I think you can go and try with Inbound Synchronization Rule for SQL MA, for filter attribute, create custom expression:
    • "<Filter xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Dialect="http://schemas.microsoft.com/2006/11/XPathFilterDialect" xmlns="http://schemas.xmlsoap.org/ws/2004/09/enumeration">/Person[DeptNumber='" + deptNumber + "']</Filter>"

    Again, this hasn't been tested at all (for instance, you'll have to escape quotation marks, used inside filter), but I think this approach should work for you..

    Regards, P

    Monday, April 21, 2014 10:23 AM
  • Thanks Poulson!

    As I understand, filter attribute in FIM Service is storing the criteria that we create in FIM Portal.

    So I will create an inbound rule and will flow the value mentioned by you in 'filter'.

    Let me try.

    -Mann

    • Marked as answer by Mann.Cool Tuesday, April 22, 2014 4:14 PM
    Monday, April 21, 2014 3:43 PM