JDBC Provisioning in IDN

Hi All,

I have configured JDBC Application and written global provisioning rule. How can I upload global provisioning rule in IDN? and where can we select rule in application configuration?

Could you please guide me?

Hi @Reddyp

You can upload connector rules like the JDBC provisioning rule using the Connector Rules API. More details here: Sign In to Compass - Compass

Thank you so much for your reply Paul.

Small question:
Once we upload rule in VA using Connector rule API where can we see JDBC Prov Rule in IDN UI ? Do we need to select rule anywhere once its uploaded?

Hi @Reddyp

You can’t see the rule in the UI, but you can use the API to attach the rule to the source.

Use the Update Source API: update-source | SailPoint Developer Community
The body should be something like this:

[
    {
        "op": "add",
        "path": "/connectorAttributes/jdbcProvisionRule",
        "value": ["My Rule"]  
    }
]

replacing “My Rule” with the name of your rule.

2 Likes

Thank you so much Paul.

@Reddyp Have you passed any input or output values in the provisioning Rule?

“description”: “This is test rule from API”,
“type”: “JDBCProvision”,
“signature”: {
“input”: ,
“output”: {
“name”: “”,
“description”: null,
“type”: null
}
},

Is it mandatory?

We are trying to use provisioning rule but receiving errors .

Thank you!
Sailaja Prathi

The signature input & output values are not mandatory as far as I know(I have a somewhat working provisioning rule set up with none included).
What’s the error you’re receiving?
First thing I’d check is if the “name” of the JDBC rule matches the name of the rule referenced in the Source configuration for the source you’re attempting to use it for.

2 Likes

@M_rtenH We were able to resolve the issue. Yes, input & output values are not mandatory.

Thank you!
Sailaja Prathi

1 Like

Does the “value” need to be within [" "]? Or can we have “value”: “My Rule”?

“value”: [“My Rule”]
VS
“value”: “My Rule”

Also, is this call documented anywhere? I know other rules are added to the /connectorAttributes/nativeRules