Setting up the Database - Installation - Foundation 23.2 - Foundation 23.2 - Ready - Content Composer - external - Content-Composer/Installation/Foundation-23.2/Content-Composer-Installation/Advanced-Installation/Setting-up-the-Database - 2024-03-25 - To install Odin and MWS on a database using the Database Setup wizard, complete the following steps:

Content Composer Installation
Platform
Content Composer
Product
Installation
Release
Foundation 23.2
License

To install Odin and MWS on a database using the Database Setup wizard, complete the following steps:

  1. In the Content Composer installation directory, start the Composer.Database.Setup.exe.
  2. On the Composer Database Setup page, verify the installation prerequisites. Each step of the list must show OK before you can proceed to the next page.
  3. Optional. Resolve all indicated errors and click Test.
  4. Click Next.
  5. On the Select Procedure page, select Create Odin/MWS Schema and click Next.
  6. On the Database Connection page, select one of the following database products and complete the appropriate procedure.
    Option Description

    MS SQL Server - Odin/MWS database

    On the SQL Server Connection page, complete the following steps:

    1. In the Enter or select server name box, type the name of the SQL Server instance.

    2. In the Server logon box, complete one of the following substeps:

      • Select the Use SQL Server Authentication check box.

        In the User box, type the name of the database user you want to use to create the database schema and in the Password box, type the password of the database user

        Note: Use the database user created in Create the database users in SQL Server that has the composer_full role.
      • Select the Use Windows authentication check box.

    3. In the Database box, type the name of the SQL Server database to which you want to install the Odin and MWS database schema.

    4. Click Test Connection and then click OK.

    Oracle - Odin/MWS database

    In the Connection Properties page, complete the following substeps:

    1. In the Enter server name box, type the name of the Oracle server instance.

    2. In the User box, type the name of the database user you want to use to create the Odin/MWS database schema.

      Note: Use the database user that was created by the Ora_Rep_CreateUser.sql script because the user must have specific permissions.

    3. In the Password box, type the password of the database user.

    4. Click Test Connection and then click OK.

Oracle - Odin/MWS database

  1. In the Select Odin or MWS Option page, select one of the following options. Create Odin Schema.
    • Create Odin Schema.
    • Create MWS Schema.
    • Create Odin and MWS Schema.
  2. Click Next. Complete the following substeps:
    1. In the Installation page, click Start installation.
    2. When the installation is completed, click OK.