Multiple Entitlement Types for JDBC Source

Identity Security Cloud (ISC) ISC Discussion and Questions
1

I’m working with a JDBC source with multiple types of entitlements. We’ve configured each entitlement type through the UI, but it’s not clear from the JDBC documentation what additional configuration I need to make through the API to specify an SQL call for each type.

https://community.sailpoint.com/t5/IdentityNow-Connectors/JDBC-Source-Configuration-Reference-Guide/ta-p/73881

1 Like
2

Example: Through the UI we add an entitlement type call capabilities.

API call to add the SQL entries for the new Entitlement Type

https://{​tenant}​.api.identitynow.com/beta/sources/{​id}​

[
    {​
        "op": "add",
        "path": "/connectorAttributes/capabilities.SQL",
        "value": "select * from capabilities order by capability_id;"
    }​,
    {​
        "op": "add",
        "path": "/connectorAttributes/capabilities.useStoredProcedureGetObject",
        "value": false
    }​,
    {
        "op": "add",
        "path": "/connectorAttributes/capabilities.mergeRows",
        "value": false
    }
]

Replace the value capabilities with the name of the Entitlement Type(s) you create.