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?
Does this mean that I cannot use Jaspersoft ETL with such databases setups where OS Authentication is used?
I was evaluating Jaspersoft ETL for my team and we use OS Authentication for all our databases.
http://docs.oracle.com/cd/B28359_01/java.111/b31224/clntsec.htm says that it can be done (or is my understanding incorrect?): look for
JDBC Code Using OS Authentication
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.