User ID/password authentication
- Last Updated: March 5, 2024
- 1 minute read
- DataDirect Connectors
- JDBC
- Documentation
Create your user credentials in the LDAP server.
To configure the driver to use user ID/password authentication via LDAP:
- Specify values for minimum required properties for establishing a
connection:
- Set the ServerName property to specify either the IP address in IPv4 or IPv6 format, or the server name for your server.
- Set the PortNumber property to specify the TCP port of the primary database server that is listening for connections to the database.
- Set the DatabaseName property to specify the database name.
- Set the User property to specify the user ID of the LDAP server.
- Set the Password property to specify the password of the LDAP server.
Connection URL:
Connection conn = DriverManager.getConnection
("jdbc:datadirect:impala://myserver:21050;
DatabaseName=dbname;User=Jsmith@example.com;Password=secret); Note: The User ID and Password properties are not required
to be stored in the connection string. They can also be passed separately by the
application.
Data Source:
ImpalaDataSource mds = new ImpalaDataSource();
mds.setDescription("My Impala Data Source");
mds.setServerName("server_name");
mds.setPort("port");
mds.setDatabaseName("ImpalaDB");
mds.setUser("jsmith@example.com");
mds.setPassword("secret");