After setting the CLASSPATH, the connection information needs to be passed in the form of a connection URL. This section provides examples of connection strings configured to use common features and functionality. You can modify and/or combine these examples to create a connection string for your environment.

Note:
  • Connection property names are case-insensitive. For example, Password is the same as password.
  • For connection properties that support string values, use the following escape sequence to specify values containing leading or trailing spaces and curly brackets: {value}. For example: User={hello } or Password={{hello}}.
jdbc:datadirect:postgresql://servername:port;
[property=value[;...]];

User ID/password authentication

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

Connection conn = DriverManager.getConnection
  ("jdbc:datadirect:postgresql://server1:5432;User=test;Password=secret;");

For more information on these properties and values, see User ID and password authentication.

Microsoft Entra ID user ID/password authentication

This string includes the properties used to connect with the Microsoft Entra ID (Azure Active Directory) user ID and password authentication.

Connection conn = DriverManager.getConnection 
("jdbc:datadirect:postgresql://myserver.postgres.database.azure.com:5432;
AuthenticationMethod=EntraIDPassword;User=test@mydomain.com;
Password=secret;AzureTenantID=xyz012");

For more information on these properties and values, see Microsoft Entra ID authentication.

Microsoft Entra ID service principal authentication

This string includes the properties used to connect with the Microsoft Entra ID (Azure Active Directory) service principal authentication.

Connection conn = DriverManager.getConnection 
("jdbc:datadirect:postgresql://myserver.postgres.database.azure.com:5432;
AuthenticationMethod=EntraIDServicePrincipal;User=1234abcd-1234-abcd-1234-abcd1234abcd;
Password=ABcdEFg/hiJkLmNOPqR01stUvWxyzYx2wvUTsrQpO;AzureTenantID=xyz012");

For more information on these properties and values, see Microsoft Entra ID authentication.

Kerberos authentication

This string includes the properties used to connect with Kerberos authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:postgresql://server1:5432;DatabaseName=postgresqlDB;AuthenticationMethod=kerberos;
ServicePrincipalName=postgres/myserver.example.com@EXAMPLE.COM;");

For more information on these properties and values, see Kerberos authentication.

Proxy server authentication

This string includes the properties used to connect with proxy server authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:postgresql://server1:5432;ProxyHost=pserver;ProxyPassword=secret;
ProxyPort=808;ProxyUser=PUser;User=jsmith@example.com;Password=secret;");

For more information on these properties and values, see Connection property descriptions.

AWS IAM authentication

This string includes the properties used to connect with AWS IAM authentication.

Connection conn = DriverManager.getConnection
("jdbc:datadirect:postgresql://server1:5432;AuthenticationMethod=AWSIAM;
  AccessKey=ABCDEFGHIJKL1EXAMPLE;Region=us-east-2;
  SecretKey=aBcdeFGhiJKLM/N1OPQRS/tUvWxyzAEXAMPLEKEY");

For more information on these properties and values, see AWS IAM authentication.