User ID/password authentication
- Last Updated: May 13, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- SAP HANA 6.0
- Documentation
This string includes the properties used to connect with the user ID/password authentication.
jdbc:datadirect:saphana://server_name:port_number;User=user_name;
Password=password;[property=value[;...]];
where:
- server_name
- specifies either the IP address or the server name of the primary database server.
- port_number
- specifies the TCP port of the primary database server that is
listening for connections to the database. The default value is
30015.
- user_name
- specifies the user ID that is used to connect to the SAP HANA database.
- password
- specifies a password that is used to connect to your SAP HANA 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:saphana://MyServer:30015;User=JSmith;Password=secret;");