1 ACCEPTED ANSWER
This is not the correct way to do it you have to set the connections as follows in "[Your pdi installation]\data-integration\simple-jndi\jdbc.properties". Change user name, password, ports,dns and ip accordingly
SampleData/type=javax.sql.DataSource
SampleData/driver=org.h2.Driver
SampleData/url=jdbc:h2:file:samples/db/sampledb;IFEXISTS=TRUE
SampleData/user=PENTAHO_USER
SampleData/password=PASSWORD
Quartz/type=javax.sql.DataSource
Quartz/driver=org.hsqldb.jdbcDriver
Quartz/url=jdbc:hsqldb:hsql://localhost/quartz
Quartz/user=pentaho_user
Quartz/password=password
Hibernate/type=javax.sql.DataSource
Hibernate/driver=org.hsqldb.jdbcDriver
Hibernate/url=jdbc:hsqldb:hsql://localhost/hibernate
Hibernate/user=hibuser
Hibernate/password=password
Shark/type=javax.sql.DataSource
Shark/driver=org.hsqldb.jdbcDriver
Shark/url=jdbc:hsqldb:hsql://localhost/shark
Shark/user=sa
Shark/password=
# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_DataMart.
AAAR_DataMart/type=javax.sql.DataSource
AAAR_DataMart/driver=org.postgresql.Driver
AAAR_DataMart/url=jdbc
ostgresql://[Your DNS name or IP]:5433/AAAR_DataMart
AAAR_DataMart/user=postgres
AAAR_DataMart/password=admin
# A.A.A.R. - Alfresco Audit Analysis and Reporting - AAAR_Kettle.
AAAR_Kettle/type=javax.sql.DataSource
AAAR_Kettle/driver=org.postgresql.Driver
AAAR_Kettle/url=jdbcostgresql://[Your DNS name or IP]/AAAR_Kettle
AAAR_Kettle/user=postgres
AAAR_Kettle/password=admin
