Take the following steps to configure user ID/password authentication:

  • Set the User property to specify the user ID.
  • Set the Password property to specify the password.
  • Set the DatabaseName property to specify the database name.
  • Specify values for minimum required properties for establishing a connection.
    • Set the ServerName property to specify either the IP address in IPv4 or IPv6 format, or the server name for your server.
    • Set the PortNumber property to specify the TCP port of the primary database server that is listening for connections to the database.
For example, the following is a connection string with only the required properties for making a connection using user ID/password authentication.
Connection conn = DriverManager.getConnection 
("jdbc:datadirect:impala://Server3:21050;
  DatabaseName=dbname;User=test;Password=secret);