After setting the CLASSPATH, the required connection information needs to be passed in the form of a connection URL. The following example includes the properties required for connecting with user ID/password authentication.

Connection URL Syntax

The connection URL takes the following form: 

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 to which you want to connect.

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.

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;");
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: The driver connects to the 9996 port and any customized port that is configured on the PostgreSQL wire protocol.