How mysql repository works in Pentaho User console?
Based on Pentaho guideline (https://help.pentaho.com/Documentation/8.2/Setup/Installation/Archive/MySQL_Repository) I successfully converted pentaho File based repository to MySQL database repository.
Now does anyone have any idea how MySQL repository store the data in database? It means If create new folder, new dashboard or new connection then how pentaho store this data in mysql database. Also need to know which tables is used for which purpose of data store.
Default created attached schema and tables based on mysql pentaho repository. 
Please Provide any inputs or any reference material for same?
Pentaho's repository comprises three third party technologies: Jackrabbit, Hibernate, and Quartz. Reports/Jobs/Transformations and any other artifacts stored inside the Pentaho Server are generally stored in Jackrabbit. Scheduling info and triggers are stored in Quartz. And diagnostic info is stored in Hibernate (such as who accessed what reports, how long a report took to run, etc.).
None of this info is designed to be human readable directly out of the database tables. These are sort of "black box" technologies. These are third party technologies that Pentaho simply leverages for its repository functions. If you have additional questions, I'd recommend checking out the technologies themselves on their project pages.
- How to configure Pentaho Carte to accept HTTPS request instead of HTTP
- Pentaho/POI throws InvocationTargetException
- Git Not In Sync with Local Branch
- "RecursionError: maximum recursion depth exceeded" from ssl.py: `super(SSLContext, SSLContext).options.__set__(self, value)`
- How do I clear the cache in Pentaho Data Integration
- What is the difference between data integration softwares and ESB?
- Create a near real time DWH with Pentaho Community edition
- Set the charset for Firebird connection from Pentaho DI
- Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
- Pentaho Data Integration 9.3 - Postgres Incremental load
- How to find unique values from set of rows using pentaho kettle?
- How to add zero in front of single digit values using REGEX in pentaho
- Pentaho File Repository Moves Jobs & Transformations to root
- Use a field from a previous hop as a parameter in a Table input using Pentaho Kettle
- Pentaho kettle Can't run transformation due to plugin missing
- Waiting for Transformations in a Job
- Pentaho CDE: Is there a way to debug the sql command being executed?
- Pentaho Kettle replace cell value if value exists in other two columns
- How to find where KETTLE HOME is defined
- REST API calls through Pentaho Data Integration (Spoon)
- Pentaho PDI || Windows Current User
- Pentaho check if at least one row LDAP is 0
- Get row number from stream to perform concat
- How input data in line chart in Pentaho?
- Pentaho-carte rest api?
- How to run Pentaho transformations in parallel and limit executors count
- Pentaho to kill all running transformations if any one them fails
- Pentaho Business Inteligence Automation
- How to delete rows which were deleted in source table (Pentaho data integration)
- Connection between pentaho and mysql is reset