Thursday, 20 July 2017

Pentaho Connection : Oracle Database Connection


1. Go to View tab
2. Click Database Connection  > New




 3.Select General > Oracle > Native(JDBC)



4. Database Name : (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = scan.xxxx.yyy.my)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = database1.xxx.yyy.my)))

5. Port Number : -1
6. User Name : eai
7. Password : password
8.Test Connection : OK

No comments:

Post a Comment

Pentaho Transformation : Simple Transformation Oracle - MySQL

1. Click File > New > Transformation