Create Account

Feedback Documentation Feedback Connectivity Documentation Feedback
1

Select Create Account to provide an SQL query or stored procedure to create an account. Enter the SQL query or stored procedure into the SQL Query or Stored Procedure field as appropriate.

This is the companion discussion topic for the documentation at https://documentation.sailpoint.com/connectors/jdbc/help/integrating_jdbc/prov_query_create_acct.html
2

When these queries are built, there is some general guidance about variable names in the provisioning plan. Is there a more specific way to determine what replacements can be included when “replaceTokensAndGenerateQueries” is executed? It appears the variables we are trying to use (attribute names from the Create Account/schema lists) are not valid.

CALL ADD_ACCOUNT($plan.I_RACF.string$,$plan.N_NAME.string$,$plan.I_REQ.string$,$plan.ACTIVE_STATUS.string$,‘default comments’,‘00’,‘’)

seems to be yielding
ADD_ACCOUNT(?, ?, ?, ?, ‘default comments’,‘00’,‘’)

5

Hi @rmccoy-unum. Thank you for your input. This appears to be related to using the product features. I’ve moved your comment to our ISC Discussions and Questions category for greater help from the community. This may get you a more speedy response.

I’ve also created CONDOCS-7193 to track the effort to research how this can be added to the documentation.