04-12-2022 01:24 PM
Data Analyzer provides the ability to run select queries against the database schema from a query browser in SSM
Data Analyzer feature allows
username = "ssmdau"
password = "****"
passwordEncrypted = "true"
url = "jdbc:mysql://localhost:3306/schemaname?serverTimezone=UTC&useUnicode=yes&characterEncoding=UTF-8"
driverClassName = "com.mysql.jdbc.Driver"
Only Select operation is allowed on selected set of tables
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
No, we allow to run select only on restricted set of schema tables for security reasons
You have a limit to retrieve up to 100 records from a select query
If the query is unable to run within 10 seconds, then no rows are retrieved from schema and appropriate error message is seen
Yes, we can search and export it excel or csv format from Actions>Export option
Version 5.5.sp2 and above
Solved! Go to Solution.
04-12-2022 03:13 PM