Configure the Database Connection
Oracle GoldenGate gets the name of the database it is supposed to connect to from the SOURCEDB
parameter. To configure the connection for the SOURCEDB
parameter, use the following format:
SOURCEDB dbname@hostname:port, USERID mysqluser, PASSWORD welcome
The dbname
is the name of the MySQL instance, hostname
is the name or IP address of the MySQL database server, port
is the port number of the MySQL instance. If using an unqualified host name, that name must be properly configured in the DNS database. Otherwise, use the fully qualified host name, for example myhost.company.com
.