This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Help
Gopi
New Contributor II
New Contributor II
since ‎09/29/2022
‎06/05/2023

User Statistics

  • 38 Posts
  • 0 Solutions
  • 4 Kudos given
  • 0 Kudos received

User Activity

Need to convert UTC to EST time in SQL Query

06/02/2023
Hi all,In this query hear I need to convert the CURRENT_TIMESTAMP UTC time to EST time while inserting the record into the table. Can someone suggest how I can achieve this?{"memberOf":["INSERT INTO PS_EAP_SUB_IN (EMPLID, OPRID, ROLENAME, EAP_TRANSAC...

DB connector UPDATEACCOUNTJSON

05/19/2023
Hi all,Is it possible to add more than 2 update queries in the UPDATEACCOUNTJSON block of the DB connector?The requirement is that once the user value is updated we need to update 3 tables in target.Is it possible in the connection?Regards,Gopi. 

Entitlement Owner campaign

05/18/2023
Hi all,The requirement is that for the entitlement every Owner in the list should certify it. Will Saviynt support it? if Yes what is the primary configuration that I need to do?Regards,Gopi. 

Entitlement Recon from Oracle DB is not working

04/13/2023
Hi team,In Target I can see there are 1460 records, but in Saviynt I can recon only 454 records.Error is:Code:<dataMapping> <before-import> </before-import> <sql-query description="This is the Source DB Query"><![CDATA[SELECT 'PeopleSoft HR' as secur...

Not able to insert fetched entitlement value in entitlement table.

04/10/2023
Hi team,I'm facing this error while entitlement import from the DB connection.Query:<dataMapping> <before-import> </before-import> <sql-query description="This is the Source DB Query"><![CDATA[SELECT 'Oracle DB HRDEV' as securitysystem,'Oracle DB HRD...
View more
Latest Tags
No tags yet
Kudos given to
Contact Me
Online Status
Offline
Date Last Visited
‎06/05/2023 01:38 AM
Copyright © 2023 Khoros, LLC