Page History

...

Anchor
method1 method1

Method 1 (Invoke an executable)

In your register server dialog, for Login Name and/or password, you specify the value in the format:

...

Below is an example in OS X.

Image Modified

The contents of retrieve_username.sh (hard-coded for illustration purposes). This file echoes "root" which is passed to Aqua Data Studio and then Aqua Data Studio passes "root" for the "Login Name" credential.

...

Below is an example in Windows showing the Login Name referring to retrieve_username.bat and a command prompt showing the contents of the retrieve_username.bat file.

Image Modified

Anchor
method2 method2

Method 2 (Instantiate the Java classname specified)

In your register server dialog, for Login Name, you specify the value in the format:

...

With this approach, Aqua Data Studio will attempt to instantiate the classname specified. If instantiated successfully, Aqua Data Studio will then invoke the class's getUserName() / getPassword() method. The value returned from this method will be used for username/password.

Image Modified

Contents of Java class CredentialPrototype: (hard-coded the username for illustration purposes)

Image Modified

Anchor
method3 method3

Method 3 (Retrieve password or username from Secure Storage)

In this method first navigate to File->Options:Secure Storage and add a Secure Storage entry for your database username or password.

As an example, let us add a password in Secure Storage and make its property hidden. Next, in the Server Registration window, specify ~`credsecure::password`~ in the Password field, to retrieve the credentials from Secure Storage. Once you try to connect to the Database Server, Aqua Data Studio will decrypt the value for the password field specified in Secure Storage, use it as the password and connect to the Database Server.

Image Modified

In your register server dialog, for a corresponding entry for your database Username, you specify the value in the format:

...