Add Database Credentials

You must have a working database credential for your Extract and Replicat processes.

  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. You'll also see sections to set up checkpoint and heartbeat tables after the connection is successful.