The driver supports the user ID/password authentication. It authenticates using a database user name and password provided by the application.

To configure the driver to use user ID/password authentication.
  • Set the ServerName property to specify either the IP address in IPv4 or IPv6 format, or the name of your server.
  • Set the PortNumber property to specify the TCP port of the primary database server that is listening for connections to the database.
    Note: The driver connects to the 9996 port and any customized port that is configured on the PostgreSQL wire protocol.
  • Set the DatabaseName property to specify the name of the database to which you want to connect.
  • Set the User property to specify the user name that is used to connect to the server.
  • Set the Password property to specify the password.

The following examples show the connection information required to establish a connection using user ID/password authentication.

Connection URL

Connection conn = DriverManager.getConnection 
("jdbc:datadirect:denodo://myserver:9996;
  DatabaseName=mydb;User=jsmith;Password=secret);

Data Source

DenodoDataSource mds = new DenodoDataSource();
mds.setDescription("My Denodo Data Source");
mds.setServerName("myserver");
mds.setPortNumber("9996");
mds.setDatabaseName("payroll");
mds.setUser("jsmith");
mds.setPassword("secret");
Note: The User and Password properties are not required to be stored in the connection string. They can also be passed separately by the application.
Note: Setting the password using a data source is generally not recommended. The data source persists all properties, including the Password property, in clear text.