How to Change Pentaho Repository

Question

I'm using Pentaho Spoon to Data iteration now, and I want to Change Repository Database of Pentaho.

As I know Pentaho repository server is HsqlDB, and I want to change HsqlDB to MSSQL

So I searched about this, and I followed page 'https://help.hitachivantara.com/Documentation/Pentaho/8.0/Setup/Installation/Archive/Start_Pentaho_Server' , but it didn't work out.

Is there any way to change repository of Pentaho?

Answer 1

I assume that you install archive version of Pentaho Server from your link so you can follow the steps to config MS SQL Server as a repository database from here but if you install manual version of Pentaho Server you can follow from here