Call multiple stored procedures during account and entitlement import

[Ankky]

Hello experts,

We have a DB application which supports multiple entitlement types. Application team has provided different stored procedures to obtain the information about each entitlement type, for example:

1. Get the list of roles

2. Get the list of groups

3. Get the list of user to role mapping

4. Get the list of user to group mapping

We tried passing 2 stored procedures during entitlement import with ; separation but it only executed the first stored procedure. Could you please help us understand if we can club 2 or more stored procedures in account and entitlement import?

Thanks

[Amit_Malik]

Hi @Ankky , you can have two XML files created with import mapping and calling procedures and while scheduling Jobs , can use different files.

Thanks,

Amit

[rushikeshvartak]

• You can have one stored procedure per connection.
• In order to support your use case, create multiple connections if stored procedure can't be merged