Entering Connection Data for the Odin or MWS Database in the Configuration (Content Composer Server) - Entering Connection Data for the Odin or MWS Database in the Configuration (Content Composer Server) - In Content Composer Studio, complete the following steps: - Content Composer - Installation - Content-Composer/Installation/Foundation-24.1/Content-Composer-Installation/Advanced-Installation/Entering-Connection-Data-for-the-Odin-or-MWS-Database-in-the-Configuration-Content-Composer-Server - Foundation 24.1 - Foundation 24.1

In Content Composer Studio, complete the following steps:

1. In the top left, click the Select System button.
2. In the Select System dialog box, select the system and click OK.
3. In the Administration tab, click the DB Alias Administration button. To configure the MWS or Odin database connection, complete the following substeps:
   1. In the DB Alias Administration pane, double-click MWS or Odin.
   2. In the Data Link Properties dialog box, complete the following substeps:
      1. Under Data Provider, select Native SQL for MS SQL Server or Microsoft Oracle for an Oracle database.
      2. In the SQL Template field, click Standard Value. The default value is inserted.
      3. In the SQL Field Template field, click the Standard Value. The default value is inserted.
      4. Click the Ellipsis button to the right of the Connection String box.
      5. In the Connection Properties dialog box, enter the connection information for the DB user previously created for the respective schema using the Ora_Odin_CreateUser.sql script or the MSSql_CreateUser.sql script.
         Note: For SQL Server, use the database user created in Create the database roles and users in SQL Server that has the composer_full role.
      6. Ensure that you select the Allow saving password option.
      7. Click OK.
   3. Repeat the previous steps for Odin or MWS DB alias and save your changes.