It is recommended that you update the RDMS schema in DDW if there is any change or modification in the database definition on the host.
Select the database in the Schema View for which the schema has to be updated.
On the Schema menu, click Update.
Alternatively, right-click the database and click Update.
The Update Schema dialog box appears.
Note: The name of the database type automatically appears as RDMS in the Data Manager Type field.
Enter the port number of the server where the database is hosted.
Enter the login credentials in the Login User and Password fields.
Note: Select "Remember Me" to save your credentials for automatic login the next time you update the schema.
(Optional) Click Verify Connection to ensure that a connection can be established with the database.
If the connection is successful, a success notification appears. If the connection fails, an error message appears.
Click OK.
The status bar displays the status once the update is complete.
You can click Cancel to cancel the process.