Configuring the Catalog Service to run on SQL Server

Edit online

About this task

By performing the following actions, the data is imported in the SQL database.

Procedure

  1. Open the server.xml file from \wlp\usr\servers\ad_server.
  2. Enable IBM® AD Catalog, by removing the <!-- --> comment around its <webApplication> element. 
    <webApplication contextRoot="com.ibm.etools.ad.catalog" id="com.ibm.etools.ad.catalog" location="com.ibm.etools.ad.catalog.war" name="ad-catalog">
        <application-bnd>
            <security-role name="ADCatalogUser">
                <user name="catalog"/>
            </security-role>
        </application-bnd>
</webApplication>
  3. Open the server.xml file from \wlp\usr\servers\ad_server.
  4. In the <!-- Add the Catalog database connection details--> area, enter the SQL database in the databaseName field. 
    databaseName="Catalog"
  5. In the same area, enter the IP of the server in the serverName field. 
    serverName=
  6. Enter the SQL port in the portNumber field (the default is 1433). 
    portNumber="1433"
  7. Enter the user and password used to connect to the SQL database in the user and password fields.
    This image shows a screen capture of source code.
    Important: The password that is used to connect to the SQL database can be encrypted. The securityUtility command supports plain text encryption for Liberty. For more information, see securityUtility command.
  8. Make sure that IBM® AD Catalog Service is configured in IBM® AD Configuration Server. For more information, see Configuring IBM AD Catalog Service.
  9. Once the configuration is done, go to the Dashboard tab, in IBM® AD Configuration Server, click the menu button of Web Service, and select Restart Service.
    Note:
    • Wait until the services are restarted, this can take a few minutes to complete.
    • The Catalog database will be automatically populated when Data Collector starts for the first time.