To create a database connection in Windows, use the Windows ODBC Data Source Administrator to create a system DSN for each source and target database.
On the Windows system, open the Control Panel folder.
Open the Administrative Tools folder.
Open ODBC Data Sources (64-bit). The ODBC Data Source Administrator dialog box is displayed.
Select the System DSN tab, and then click Add.
Under Create New Data Source, select the Oracle GoldenGate PostgreSQL Wire Protocol driver and click Finish.
The Create a New Data Source wizard is displayed.
Supply the following:
For Data Source Name, type a name for the DSN, up to 32 alpha-numeric characters in length, excluding special keyboard characters except for the underscore and dash.
(Optional) For Description, type a description of this DSN.
Provide the database server’s Host Name, the database Port Number, and Database Name.
Click OK to close the dialog box.
You can also provide the User Name information under the Security tab but it is recommended instead to leave this field empty and instead store the user name and password in the Oracle GoldenGate wallet as a credential alias, and reference them with the USERIDALIAS parameter in Extract and Replicat.