JDBC connector provisioning queries

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

Hi, I am new to JDBC provisioning queries, at the time only been working with provisioining rules, but I want to give a try on this.

I am working with an Oracle database, and I have some store procedure for account creation (let say that SP name is createUser, which receives login, password, status, description, name and last name).

In which format do I must write this in the account creation provisioing query? How do I deal with plan variables that can be sent empty, they appear as NULL? (for example $plan.description.string$).

2

Hi @jsosa

You can refer to this article. Let me know if you need more help on this.

1 Like
3

Hi @msingh900 thanks for responding, I am looking for provisioning queries configuration, not provisioning rule.

4

Hey Julian!

The queries are written in velocity basicly

The SQL query format is as follows:

insert into databasename.tablename (column1, column2) values ($plan.attribute1$, $plan.attribute2$)

if database name is already specify in additional attribute at query settings:

insert into tablename (column1, column2) values ($plan.attribute1$, $plan.attribute2$)

For example:

insert into Employee (name, city) values ($plan.NAME$, $plan.CITY$)

Simples as that.

5

Hi Ivan! Thanks for your response! Do you know how it deals with null values? For example, identity description field is empty, do you know if $plan.description passes as NULL or ‘‘?

6

empty value i bellieve.

7

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