GoldenGate Credential Store:

 GoldenGate Credential Store: 

1.  The credential store in GoldenGate manages the user ID and its password that are used by GoldenGate processes to interact with the database.
2. The credential store eliminates the need to specify user names and password in the GoldenGate parameter files. Instead of clear-text password and username, an optional alias can be used in the parameter files.

When we create credential store using ADD CRENDENTIALSTORE command, an empty wallet file gets created in the GoldenGate default location under directory "dircrd" which stores the DB logins credentials.

Step to create Credential store:

 Without credentialstore, DB logins from Goldengate utility is done using the clear-text password and we can observe the wallet file does not exist in the default location.

dblogin userid ggadmin password ggadmin;

 sh ls -lrt /u01/app/oracle/product/gg/dircrd

By creating credentialstore and we can notice the wallet file gets created in the default location.

 add credentialstore;

To check information in the credentialstore. Default is empty.

info credentialstore;

Add  the user credentials to the credential store and verify it using "info credentialstore".

alter credentialstore add user ggadmin password ggadmin alias ggadmin;

With credentialstore, DBlogins are done not with clear-text password instead connected using alias name ggadmin.

dblogin useridalias ggadmin;

 If the password of the user ggadmin is modified at Database level, we can modify the same in the credentialstore using the below command.

alter  credentialstore replace user ggadmin password ggadmin1 alias ggadmin;

To delete from credentialstore using alias.

alter credentialstore delete user ggadmin;

We can observe, deleting the credentialsore will delete the wallet file automatically from the Goldengate default location.

delete credentialstore;