Exposing a Database as a Web Service RRS feed

  • Question

  • Hi All FIM Guru,

    What is the best practise to build connectors.

    Every application has some sort of database at the backed, Can we build webservice to query it and insert in Microsoft SQL table and do the processing with SQL MA.


    We have to build ECMA always to achieve this.

    Anirban Singha

    Tuesday, February 9, 2016 4:39 AM

All replies

  • Hi,

    depends a little on you and of course the customer.

    Some customers don't like for example 3rd party tools.

    So for me I following there guidelines.

    1. If it is possible in a good way I use OOB features (like SQL MA or new generic SQL MA)

    2. If it's not possible or not in a good way I use cummunity features (like PS MA from Soren)

    3. If both will not fit, I create custom solution for customer.

    OOB features are much easier to maintain on upgrades for example

    So in short if you are able to access (and are allowed) to read/write the database of a application, why not use one of the SQL MAs.

    I often use transfer tables, dedicated to FIM and before reading or afer writing to that table a stored procedure will transfer the data from the original tables to my transfer table.

    This also give that application owner the possibility to check updates to their application.


    Peter Stapf - ExpertCircle GmbH - My blog:

    Tuesday, February 9, 2016 9:18 AM
  • Thanks Peter,

    Anirban Singha

    Tuesday, February 9, 2016 2:27 PM