(use ‘mysql.exe’ on Windows platform and ‘./mysql’ on Linux based platforms)

Deploy the new version of the sample reports.

With this deployment, a new version of the sample reports are released to insure compressed times with a big quantity of audit data. Let’s start with tasks:

Extract ‘reports.zip’ in the ‘data-integration’ folder. ‘report.zip’ contains 5 files with ‘prpt’ extension, each one containing one Pentaho Reporting Designer report. By default, and to let the report production simpler, are saved in the default folder: ‘data-integration’.

For the PostgreSQL platform: check if the ‘alfresco’ user of the database has password equal to ‘alfresco’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:

For each prpt report in the ‘data-integration’ folder, execute what is described below.

Open the prpt report, one by one, with the Pentaho Reporting Designer.

Click on the ‘Data’ tab on the top right of the interface.

Right click on the JDBC:AAAR_DataMart in the Data sets.

Select ‘Edit Datasource’.

Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the PostgreSQL one because two connections are defined: one for PostgreSQL and one for Mysql.

Click on the pencil.

Modify the password.

(OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.

Save the report.

Remember to repeat the tasks for all the prpt reports.

For the MySql platform: check if the ‘root’ user of the database has password equal to ‘root’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:

For each prpt report in the ‘data-integration’ folder, execute what is described below.

Open the prpt report, one by one, with the Pentaho Reporting Designer.

Click on the ‘Data’ tab on the top right of the interface.

Right click on the JDBC:AAAR_DataMart in the Data sets.

Select ‘Edit Datasource’.

Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the MySql one because two connections are defined: one for PostgreSQL and one for Mysql.

Click on the pencil.

Modify the password.

(OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.