Custom query vs Enhanced query

[Saviyntreh]

What is the difference between Custom query to enhanced query.

why these custom queries needs to be converted to enhanced queries.

Any details articles from Saviynt please share.

[pmahalle]

Hi @Saviyntreh ,

Post 23.7 Saviynt introduced a new Enhanced Query Execution job to address potential security issues and improve the overall stability of the system in the Saviynt environment.

Discontinued the Execute Extension Queries (CUSTOMQUERYJOB): The existing job instances of Execute Extension Queries (CUSTOMQUERYJOB) continue to run. However, no new instances of this job can be created, and any attempt to modify the existing instances of the job are prevented by the system.

Refer below document:

https://docs.saviyntcloud.com/bundle/Release-Notes/page/Content/v23/Release-Notes-23-7.htm#Enhanced_...

[Raghu]

@Saviyntreh 

Custom Query like it is normal script to execution SQL and it will support till 23.7v , and some of reason performance issue it got deprecated , newly relased Enhanced query bulid version,

new version Enhaced query some restiction provided to update and insert statments also majorly , if more info please check below docment:

https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter10-Job-Control-Panel/Job-Cat...

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/enhanced-query-saviynt-upgrade-to-v23-11/m-p/64669

custom query was allowing all database table to update which was causing database deadlock

enhanced query allow selected columns and tables to update with roll back option in case of failure