EJB 2.1 Database Mapping - CMS Project Dialog

1) Open the ejb-jar.xml file
    Select the ProjectInvolmenet bean
    Create new CMP field and save
    This will modify the ProjectInvolvement and ProjectInvolvementBean classes

2) Change the IDE to Data perspective and open data models
    Select ProjectInvolvement in the dbo,
    Right click and select 'Add Data Object' and 'Column'
    Insert the Name and data type

3) Open the Map.mapxmi
     Select the ProjectInvolvement from the Top Left Enterprise Beans Section
     Expand the node and select new column added
     select 'Create and map database elements from EJB elements.

    This will create and map Enterprise bean property with the tables
     
    
   

MS Report server configurations:

This is highlevel steps how to confifure MS reportserver:

1) Login to the database:
     This can be done in two ways:
         Windows authantication.
          Database authantication

2) Create or restore the database.

3)  Open the MS Reporting Services Configuration Manager.

     3.1) Hit the 'Web Service URL' and change the SSL certificate to 'WMSVC'
     3.2) Hit the 'Report Manager URL' and try to login to the report services.

4) On the report server console, create new datasource:
   
    4.1) Connect using "Credentials stored securely in the report server:" by giving the user crated in
           MS SQL server.
 
   4.2)  This user needs to be created in MS SQL server.

•  In the MS SQL Management Studio go to Security Logins: and create user eg rwmp_v3.3
• Define the database you want to connect and generate reports
• Assign the admin role to the user- In the Server roles tab
• Map the database you want to connect : In the Server Mapping tab.

   4.3)  Hit the 'Test Connection'



   4.4) Create new folder for the reports

   4.5) Deploy reports.

   4.6) Click the manage option of the deployed report.
          In the Data source tab, select the shared datasource which you have created in step 4



   4.7)  Click the report and 'View Report' button  to see the report is being rendered properly.

  Allways give admin user to start services:
    Tomcat server