User ID/password authentication
- Last Updated: May 8, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
This string includes the properties used to connect with the user ID/password authentication.
jdbc:datadirect:greenplum://servername:port;
AuthenticationMethod=userIdPassword;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.
- userID
-
specifies the user ID that is used to connect to the Greenplum database.
- password
- specifies a password that is used to connect to your Greenplum 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:greenplum://server1:5432;
AuthenticationMethod=userIdPassword;User=test;
Password=secret;");