Database connector - Connection attribute to reconcile accounts and access from Target System Database?

[Community_User]

Originally posted on August 3 2020 at 08:25 UTC

Hello Team,

In Database Connector, is there any JSON Query based attribute (similar to CREATEACCOUNTJSON) in connection which can be used to reconcile accounts and entitlements from target system?

I could see connection attribute "ACCOUNTSIMPORT" which uses XML content.

Regards,

Ksheetij

[Community_User · Accepted solution]

Originally posted on August 6 2020 at 09:40 UTC

Hi Ksheetij,

You can utilize ACCOUNTSIMPORT and ENTITLEMENTVALUEIMPORT section of the connector to pull Accounts and Entitlements from the target system.

These are xml based and in that you can use sql query to fetch data from target DB and map the data against Saviynt to import.

Thanks,

Ranjan