Enable Authentication Cascading - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software
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.
  1. 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
  2. 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.
  3. 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.