Monday, July 21, 2014

Pentaho Connection : Oracle Database Connection


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




 5.Select General > Oracle > Native(JDBC)



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

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



No comments:

Post a Comment