gbdenaro

Hello, yes, you can use ETL with OS authentication and jdbc. For Oracle you can use either OCI or Thin drivers. Note that you can modify the database parameter REMOTE_OS_AUTHENT = TRUE This parameter is obsolete starting from version 11g R2 (ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance – expected – can be ignored.) so it is better to use strong authentication as explained in the link you provided. Cheers gb

Thank you for your reply, I was looking for an "automatic" solution ( I mean, first installation already working as expected without manual intervention) but your suggestion works as expected: I have modified the rights of the Ad-hoc components and Topics folders to "Execute Only", moved all ad-hoc views into the Topic folder and created a Report folder with read-only rights where I moved all the reports. When "read-only" users now login to JasperServer, they can see only "Reports", and even if they modify the filter on the Library page to show "ad-hoc views" they do not see anything. Meaning that I have to prepare a manual for the "first parameterizazion" for my customers. Anyway, very good! Thanks a lot and have a wonderful day. GB

Hello everybody! Based on roles, I want that some users can only be able to see reports and other can create ad-hoc view. Actually I have modified the actionModel-navigaion.xml file by hiding repository browser based on my "read-only" role and users can see only search and library page, but if they click on library and change the filter to show ad-hoc view, they can create them. I tried to comment out the "filter section" on the result.jsp module but in this way I cannot see anything, it seems that the search filter will be disabled. Basically I would like to "block" the library filter to show only reports based on a role or to hide the "ad-hoc" filter from the left menu. Do you know how can I do this, what files i have to modify and how? Thank you in advance to anyone should help me. GB

Hi, I know it is an old post, but I am trying to do the same thing and cannot find enough information shared in the same place. Could you provide me the solution? Thanks!

Hello everybody! I have to use Jaspersoft ETL to load data to an Oracle Database; the JDBC user must be the same OS user which launches the java etl program. To do so I created an Oracle user with the clause : IDENTIFIED EXTERNALLY and I can test the connection directly via OS. I leave blank values for username and password, but when I run Jasper ETL, I receive the following error and cannot connect: java.sql.SQLException:ORA-01017: invalid username/password; logon denied Does anyone knows how to create a JDBC connection with an OS user? Thanks!