Configure Connections from Oracle GoldenGate

Configuring source and target connections from Oracle GoldenGate deployments requires specifying connection details for the source and target in Oracle GoldenGate, using either the web interface, Admin Client, or REST API.

Credential types

GoldenGate distinguishes credential types when it resolves a USERIDALIAS.

The following table lists the different authentication behavior for different credential types.

Description	AdminClient Command	UserID	Password	Type	Learn More
Password credential	ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1 ALIAS u1alias PASSWORD u1pw;	“u1”	“u1pw”	(not sent)	Add Database Connections
Kerberos credential (legacy syntax)	ALTER CREDENTIALSTORE ADD USER /@cdb1_pdb1 NOPASSWORD ALIAS u1alias;	“/”	“”	(not sent)	Authenticate with Kerberos Credentials
Kerberos credential (new syntax)	ALTER CREDENTIALSTORE ADD USER /@cdb1_pdb1 KERBEROS ALIAS u1alias;	“/”	“”	“KERBEROS”	Authenticate with Kerberos Credentials
Plugin credential (legacy syntax)	ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1 NOPASSWORD ALIAS u1alias;	“u1”	“”	(not sent)	Authenticate the Database Connection Using the Database Password Plugin
Plugin credential (new syntax)	ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1 PLUGIN ALIAS u1alias;	“u1”	“”	“PLUGIN”	Authenticate the Database Connection Using the Database Password Plugin
Plugin credential with Secret (new syntax)	ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1 PLUGIN SECRET abc ALIAS u1alias;	“u1”	“abc”	“PLUGIN”	Authenticate the Database Connection Using the Database Password Plugin
OAuth credential	ALTER CREDENTIALSTORE ADD USER /@cdb1_pdb1 ALIAS u1alias OAUTHSECRET abc	“/”	“abc”	“OAUTH”	Authenticate Database Connection with Microsoft EntraID

For example, a standard password credential is created as follows:

ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1
  PASSWORD u1pw
  ALIAS ali_u1_pdb1

A NOPASSWORD credential is created as follows:

ALTER CREDENTIALSTORE ADD USER u1@cdb1_pdb1
  NOPASSWORD
  ALIAS ali_u1_pdb1

Path Connections

You can set up path connections for connecting two deployments on remote servers. See Add a Path Connection for details.

Note: After configuring the database connections, you need to set up other database configurations such as supplemental logging, tables for processing, and other additional settings. To set up these configurations, see Prepare Oracle GoldenGate for your specific source or target.