Saviynt database access (SQL EDITOR)

[ArvindKumar33]

Hi Folks, 

is it possible to have read access on Saviynt DB and can we develop queries on SQL editor instead of using Saviynt analytic. 

Regards, 

Arvind 

[Nikitaj]

Hi Arvind,

Not sure which version you are on, for v2021 this is not possible. Please reach out to our support team via FD ticket and they will be able to help you more on this.

You can also use Data Analyzer in the meantime.

[ArvindKumar33]

Hi Nikita, 

We have currently version Saviynt v5.5SP3, © Copyright 2022, Saviynt All Rights Reserved. 

In data Analyzer some of tables are restricted. 

Regards, 

Arvind 

[Nikitaj]

Thanks for confirming ...Please raise a FD ticket and our support team will be able to help you.

[sundas7]

Hi ,

I was also having similar issues and was desperately looking for read only access to use Sql Workbench for constructing queries.

I remember creating the ticket as well and it was closed saying we will not be provided access to DB even if it is read only( We are also SP3.5 version)

Thanks

Shyam

[rushikeshvartak]

You can always run query from Analytics --> Analytics Config List -->

add below details

• Analytics name
• SQL Query
• Category
• Risk

_-> Click on Preview 🙂 

[ArvindKumar33]

Hi, 

I'm only using the analytical module right now while creating SQL queries. However, debugging SQL queries on a user interface is not much more illuminating. The precise error results are not displayed to me.

Regards,

Arvind 

[rushikeshvartak]

Error log provide detail error if column name is wrong or subquery returns more than 1 value. which error you are looking for ?