JDBC connection error from BIP to Cloudera-Impala DB
I am trying to connect to Cloudera/Impala DB from BIP, I have copied ImpalaJDBC42.jar to:oracle_home/wlserver/server/lib and oracle_home/user_projects/domains/bi/lib which I have done for other JDBC connections, I get this error from test connection: Could not establish connection. [Cloudera][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: Connection timed out (Connection timed out).
Need to confirm if this string is correct: connection string: jdbc:impala://servername:21050/databasename.
If I open jar file this seems to be correct: Database Driver Class: com.cloudera.impala.jdbc.Driver
Thanks, John