GetObject for JDBC connector

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi,
For the JDBC connector in IDN, how the getObject for single identity works automatically. For instance, as soon as the provisioing is done in the target system, it should run single account aggregation automatically and relfect the data on the IDN UI account. Basically the way getObject works for AD.

We have a Single Account Query config in UI but is there any other configuration we need to do to achieve it?

In the connetor doc, The JDBC source retrieves an object after it has been provisioned, when

  • the getObjectSQL query is configured.–I have configured the single account query
  • the CON_JDBC_USE_GET_OBJECT_AFTER_PROVISION feature flag is enabled. I have set it as true under the connector attributes

Thanks

2

Can you please share the query you have used for Single Object Aggregation?

4

Hi,

The query looks like this-

SELECT firstname, lastname,email, profile FROM “tableName” WHERE id=‘$(identity)’.

The query works fine when i run the aggregate account from UI for that particular record, so there is no issue with the query.

Thanks

5

I discussed it with my colleague and he is also facing the same issue. Data is not getting reflected after provisioning until full aggregation runs.

@colin_mckibben - Did something change with respect to the connector from the Sailpoint end which could have caused this?

6

We’re also seeing this behavior in one of our customers. I checked the SaaS release notes but didn’t find any update related to JDBC source.

@colin_mckibben, just wondering if it would be possible to check with the product/engineering team if something went in past 1-2 weeks for JDBC source that might have caused the issue?

7

If this was working until recently then you should open a support ticket. It sounds like a bug or a regression, and support knows how to route these to the right team.

1 Like
8

There was a change in the way the connector works. Please add the below in the source and let us know if the issue gets fixed.

Patch : https://{{tenant}}.api.identitynow.com/v3/sources/:id
Body:

[
  {
    "op": "add",
    "path": "/connectorAttributes/getObjectAfterProvision",
    "value": true
  }
]
9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.