Originally posted on July 10 2020 at 21:11 UTC
- What is Data Analyzer?
Data Analyzer provides the ability to run select queries against the database schema from a query browser in SSM
- Why do we need data analyzer?
Data Analyzer feature allows
- To eliminate access to RDS/DB for any data debugging
- To self-check and fine tune queries before building analytic reports
- What are the pre-requisites to configure data analyzer?
- 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)
- 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"
}
- What sql operations are allowed?
Only Select operation is allowed on selected set of tables
- 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
- 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
- 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
- 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
- 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
- Which version of SSM supports Data Analyzer?
Version 5.5.sp2 and above
