Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Did you know? You have the ability to analyze data using sql queries from sql query browser

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on July 10 2020 at 21:11 UTC


  1. What is Data Analyzer?

Data Analyzer provides the ability to run select queries against the database schema from a query browser in SSM


  1. Why do we need data analyzer?

Data Analyzer feature allows

  1. To eliminate access to RDS/DB for any data debugging
  2. To self-check and fine tune queries before building analytic reports
  1. What are the pre-requisites to configure data analyzer?
  1. DB user ‘ssmdau’ to be created with readonly access to a set of pre-defined tables as part of new install/upgrade (Will be taken care by upgrade or Devops team)
  2. Add below lines in Config.groovy

extSQLConnection {

username = "ssmdau"

password = "****"

passwordEncrypted = "true"

url = "jdbc:mysql://localhost:3306/schemaname?serverTimezone=UTC&useUnicode=yes&characterEncoding=UTF-8"

driverClassName = "com.mysql.jdbc.Driver"

}

  1. What sql operations are allowed?

Only Select operation is allowed on selected set of tables

  1. Where is Data Analyzer?

You can view the Data Analyzer from Admin>Admin Functions>Data Analyzer tab

Schema:Schema section displays all the schema tables with columns available to be queried on

SQL builder:You can enter and execute the sql query and view results below in a tabular format


  1. Do we allow to query all SSM schema tables?

No, we allow to run select only on restricted set of schema tables for security reasons

  1. How many records can be retrieved and shown in Data Analyzer?

You have a limit to retrieve up to 100 records from a select query

  1. What happens if the select query runs for more than 10 seconds?

If the query is unable to run within 10 seconds, then no rows are retrieved from schema and appropriate error message is seen

  1. Can you search and export the results of select query?

Yes, we can search and export it excel or csv format from Actions>Export option


  1. Which version of SSM supports Data Analyzer?

Version 5.5.sp2 and above



This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.
1 REPLY 1

Community_User
Saviynt Employee
Saviynt Employee
Originally posted on July 14 2020 at 04:09 UTC

THanks Aarthi

This message was previously posted on Saviynt's legacy forum by a community user and has been moved over to this forum for continued exposure.