To enable your JDBC driver to connect to an Aster Database using the Aster Database JDBC driver, make the following adjustments to the usual Aster Database JDBC configuration.
-
Set the following parameters to configure the JDBC driver to connect to the Aster Database:
Parameters for the JDBC driver Parameter Required? Description Domain Name Required The exact IP address of the Queen. JDBC URL Required (jdbc:ncluster://domain/database?AUTOAUTHENTICATE=true) Database Name Optional If not supplied, the system will re-connect to the database you are currently logged into. Port Number Optional Will connect to default port: 2406 -
The new argument "?AUTOAUTHENTICATE=true" (included in the JDBC URL) enables the Authentication Cascading functionality.
conn=DriverManager.getConnection(jdbc:ncluster://domain/ database?AUTOAUTHENTICATE=true)// Authentication Cascading
In the code example above, the section in bold is the entire JDBC URL that contains the "?AUTOAUTHENTICATE=true" argument to enable Authentication Cascading. -
Enable Authentication Cascading by setting "AUTOAUTHENTICATE" to "TRUE".
The username and password are now hidden from SQL statements that invoke driver functions in the Analytic Foundation. Passwords are not visible on ACT Command Line, client SQL scripts, database logs, AMC, and Viewpoint portlets.