Add Database Credentials
You must have a working database credential for your Extract and Replicat processes.
-
Launch the Administration Service interface and log in.
-
Click Configuration from the Application Navigation pane.
-
Click the plus sign (+) sign next to Credentials.
-
Enter the following details in the displayed fields:
Database Credential Options Description Credential Domain
Specify a domain name to which the database credential is associated. For example, "OracleGoldenGate" is the default domain name, incase you don't specify a domain name.
Credential Alias
This is the alias for your database credential.
User ID
This is the username of the database user.
For Oracle database, if you use the EZconnect syntax to connect to the database, then you can specify the value in this field in the following manner:
dbusername@hostname:
port
/service_name
dbusername
is the database user name.hostname
or IP address of the server where the database is running.port
is the port number for connecting to the database server. Usually, this value is 1521.service_name
is the name of the service provided in the tnsnames.ora file for the database connection.Password
Password used by database user to log in to the database.
-
Click Submit.
-
Click the Connect to database icon to test that the connection is working correctly. If the connection is successful, the Connect to database icon turns blue. You'll also see sections to set up checkpoint and heartbeat tables after the connection is successful.