Loading RDMS Schema

To load the RDMS schema

  1. On the Schema menu, click Load.

    The Load Schema to Repository dialog box appears.

  2. Select Data Manager Type as RDMS from the drop-down list.

  3. Enter the host name or host IP address and the port number in the respective fields.

    If there are multiple network adapters / addresses, enter the host IP address instead of the host name to avoid name resolution issues. When a host name is used, Data Exchange acquires the first available IP address from Domain Name System (DNS) when the Administrative Service starts.

  4. Enter the valid credentials in the Login User and Password fields to connect to the OS 2200 Server.

    Note: Select "Remember Me" to save your credentials for automatic login the next time you load the schema.

  5. (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.

  6. Select the appropriate Application Group and schema name from the drop-down list.

  7. Click OK.

    After the schema is loaded successfully, a status message appears in the DDW status bar. The time taken to load a schema depends on its size.

You can click Cancel to cancel the process.