BI publisher integration with JD Edwards native reports
Hi experts,
I have setup a JDBC connection in BI publisher with the following parameters
Driver Type : Other
Database Driver Class : com.jdedwards.jdbc.driver.JDBCDriver
Connection String : jdbc:oracle:enterpriseone://JPD910;TDSC=1;UDSC=1;enterpriseone.role=*ALL;
UserName:JDE
password=***
As JDE is a super-user in JD Edwards with no restrictions I am able to retrieve all the data . However I would like see the data which are assigned to a specific user based on security server of JDE .
According to manual I need to check the box "Use Proxy Authentication" , where BI Publisher will pass the user name of the individual user (as logged into BI Publisher) to the data source and thus preserves the client identity and privileges when the BI Publisher server connects to the data source. This means that I need to migrate/setup each user of JD Edwards/DB in BI publisher ?