Add Database Connections
You must have working database connections for your Extract and Replicat processes. Follow these steps to configure database connections to connect your source and target hosts for replication.
-
Launch the Administration Service interface and log in.
-
Click DB Connections from the left navigation pane.
-
Click the plus sign (+) sign next to DB Connections. The Credentials dialog box is displayed.
-
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, such as ggeast.
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.For other databases, specify the user id of the database user.
Password
Password used by database user to log in to the database.
-
Click Submit.
-
Click the Connect database icon to verify 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.
-
From the DB Connections page, you can also perform the following tasks from the Action column:
-
Connect to database
-
Copy DB Connection
-
Alter the DB Connection
-
Delete the DB Connection
-
After successfully connecting to the database, you can add TRANDATA, SCHEMATRANDATA, checkpoint, and heartbeat tables that would be used by the Extract and Replicat processes on the source and target side.