This string includes the properties used to connect with the user ID/password authentication.

jdbc:datadirect:denodo://servername:port;DatabaseName=database;
User=userID;Password=password;[property=value[;...]];

where:

servername

is the IP address or name of the server to which you are connecting.

port

is the number of the TCP/IP port.

database

is the name of the database you want to connect to.

userID

specifies the user ID that is used to connect to the Denodo database.

password
specifies a password that is used to connect to your Denodo database.
property=value
specifies connection property settings. Multiple properties are separated by a semi-colon.
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.

The following example connection string includes the properties required for connecting with the user ID/password authentication.

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