LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: vijayramachandran

Hi,

Say if a user is trying to connect to Hive server from Lavastorm client using JDBC drivers, is there a way to restrict it?


ODBC, yes, we will have to hardcode the .ini with the server information.


But what would be case for JDBC?

Thanks,

Vijay

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

Like with any DB system you will need certain components to connect.

* IP Connectivity
* Authentication Credentials
* Driver or Connection Protocol
* Application that can make the connection and service the query request

Connecting with LAE is no different than any other query client. The Query nodes (JDBC, ODBC, Hive, etc) are needed to make the connection.
You must have the correct driver or API as the conduit to the DB.
You need the correct login information to make the connection.
And last you must have connectivity to the DB Server through the appropriate ip address and port.

For restricting JDBC connections in LAE you have a few options.

* Restrict access to an individual user through the DB authentication layer.
* Restrict access by not giving the user the specific HIVE nodes needed to connect.
(in future LAE releases we will have the ability to license nodes by type to specific users)
* Restrict connectivity by blocking a port.