This string includes the properties you may need to connect through a proxy server with user ID/password authentication.

jdbc:datadirect:denodo://servername:port;DatabaseName=database;ProxyHost=proxy_host;
ProxyPassword=proxy_password;ProxyPort=proxy_port;ProxyUser=proxy_user;
User=user_name;Password=password;[property=value[;...]];

where:

servername
specifies either the IP address in IPv4 or IPv6 format, or the server name (if your network supports named servers) of the primary database server.
port
specifies the number of the TCP/IP port.
database
specifies the name of the database you want to connect to.
proxy_host
specifies the proxy server to use for the first connection.
proxy_password
specifies the password needed to connect to a proxy server for the first connection.
proxy_port
specifies the port number where the proxy server is listening for requests for the first connection. The default is 0.
proxy_user
specifies the user name needed to connect to a proxy server for the first connection.
user_name
specifies the user name that is used to connect to the server. For example, jsmith.
password
specifies the password used to connect to the server.
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 strings include the properties required for using a proxy server with user ID/password authentication.

Connection conn = DriverManager.getConnection
  ("jdbc:datadirect:denodo://myserver:9996;DatabaseName=mydb;
    ProxyHost=pserver;ProxyPassword=proxypwd;ProxyPort=123;ProxyUser=johndoe;
    User=jsmith;Password=secret;");