Using impersonate from JDBC driver for BI server

Answer you are looking for. First set a new property and then add the property to your getConnection method call.

Example:

Properties oProps = new Properties();
oProps.setProperty("IMPERSONATE", "USER_TO_IMPERSONATE_GOES_HERE");
oConn = DriverManager.getConnection(url, oProps);

The rest is standard to your jdbc calls.