Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Custom query vs Enhanced query

Saviyntreh
New Contributor III
New Contributor III

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.

3 REPLIES 3

pmahalle
All-Star
All-Star

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_...


Pandharinath Mahalle(Paddy)
If this reply helps your question, please consider selecting Accept As Solution and hit Kudos 🙂

Raghu
Honored Contributor
Honored Contributor

@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...

 

 


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.