Connect to Cloudera Impala while working offine

Hi there, I am using 7.7 and would like to ask about connecting to Cloudera Impala while working offline (Spotfire server not availble / not yet installed).

When choosing "Add Data Tables", there is an option "Cloudera Impala".
I can only connect to the Hadoop database using "Username and Password" as authentication method.
After I connect successfully, I can only choose one database from the list.
After saving the visualization file (.dxp) locally, I was prompted for database login and password when I reopened the file.

Would like to ask:

  1. Is it possible to access multiple databases when connecting to Cloudera Impala? I would like to join tables from different databases
  2. Is it possible to save the database login and password?

Thanks in advance.

Best Regards,

(1) Answer