I was using the file system way because I'm trying to build a Pentaho container from a virtual machine.
However I was also looking for a way to make backups of the site and this seems a great way to do it.
Thank you very much, it is really useful.
Claudio b.
Original Message:
Sent: 06-27-2023 12:21
From: Petr Prochazka
Subject: Where does Pentaho CE stores users, data sources and CD Dashboard?
Hi Claudio,
my fault. Correct location is as you posted.
Another way is call backup of instance to zip file and restore it. You can use import-export script or call REST API http://localhost:8080/pentaho/api/repo/files/backup and http://localhost:8080/pentaho/api/repo/files/systemRestore.
// edit
IMHO you can copy content of directory jackrabbit to new instance of BA server. I do not tested, I use PostgreSQL as persistence layer.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 06-27-2023 09:32
From: Claudio Battaglino
Subject: Where does Pentaho CE stores users, data sources and CD Dashboard?
Ok, the path is: pentaho-solutions/system/jackrabbit/repository
------------------------------
Claudio Battaglino
IT Support Manager
cbc
Original Message:
Sent: 06-27-2023 06:43
From: Claudio Battaglino
Subject: Where does Pentaho CE stores users, data sources and CD Dashboard?
Hi,
but do you mean pentaho-server/data/hsqldb ?
Because if I copy all the "data" directory and its subdirectories into another installation of Pentaho I can't see the folders created in the first server.
It starts as an empty server.
Why does this happen?
Claudio
------------------------------
Claudio Battaglino
IT Support Manager
cbc
Original Message:
Sent: 03-08-2023 05:36
From: Petr Prochazka
Subject: Where does Pentaho CE stores users, data sources and CD Dashboard?
Hi Claudio,
all content is stored in DBMS via JCR (Apache Jackrabbit). As default is used HSQLDB, databases are stored in data/hsqldb directory. As storage can use another DBMS, supported DB are listed in documentation or check data directory where are SQL scripts of these DB.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 03-07-2023 13:06
From: Claudio Battaglino
Subject: Where does Pentaho CE stores users, data sources and CD Dashboard?
Hi,
I can see that Pentaho server uses Tomcat to serve web pages but I can't understand where it saves: users, data sources and CDE dashboards.
Which kind of database does it use?
Is it accessible?
Thank you very much.
Claudio
------------------------------
Claudio Battaglino
IT Support Manager
cbc
------------------------------