DirecTutor.com

show the data from different Entities in a Single Applet by Creating a Database View

1. Create a new Database view e.g. ‘CX_V_CMP_CN_SUM’. The process of creating a new Database view is following: 

  1. Start SQL Developer and connect to your database.
  2. Check if you have sufficient rights to create and modify a database view.
  3. Create a Database view. The following file contains a pseudo SQL query used to create a database view. 
  4. Write a similar SQL query based upon your requirement to create the database view.
  5. Also run the below mentioned SQL statement to grant SELECT access to other user on the database view:

GRANT SELECT ON SIEBEL. CX_V_CMP_CN_SUMTO SSE_ROLE;

 2. Now, Go to your database connection and navigate to ‘Views’. You can see the newly created database view e.g. ‘CX_V_CMP_CN_SUM’ under ‘Views’ tab. One can see ‘Columns’, ‘Data’, ‘Grant’, Dependencies’, ‘Details’ and the SQL details of the database view here.

After creating database views on physical database, create a table in Siebel tools with the same name as of the Database view i.e. ‘CX_V_CMP_CN_SUM’.

                The ‘Type’ of this table should be ‘Virtual Table’ as it is mandatory.

Now, create all the columns as it is mentioned while creating the ‘Database view’.

3. Check In the newly created table ‘CX_V_CMP_CN_SUM’ to Server. No need to Apply and Activate the table as it is a database view and it is already created on the physical schema. 

4. Now, create a business component on the table ‘CX_V_CMP_CN_SUM’. Also, create all the mandatory fields based upon the column in the table ‘CX_V_CMP_CN_SUM’. 

5. Create a new applet to expose these fields on the user interface.

 NOTE: This is a very useful method for showing the results of a complex SQL query on Siebel application

Tags
Siebel EAI