Add Database Credentials to Connect to the Source Database

To create and run Extract and Replicat processes, you need to set up database credentials to connect Extract/Replicat users to the respective source or target databases.

1. Launch the Administration Service interface and log in.
2. Click Configuration from the Application Navigation pane.
3. Click the plus sign (+) sign next to Credentials.
4. 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.

5. Click Submit.
6. 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.

When you successfully log into your database, you can add and manage checkpoint tables, transaction information (TRANDATA), and heartbeat tables. All of the tables can be searched using the various search fields. As you type, the table is filtered and you can use the search button with the search text.