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’,‘’)