SIEBEL is the leading provider of Customer Relationship Management (CRM) software. Siebel CRM is a software technology provided with server frameworks that help to offer solutions like integration, development, deployment, diagnostic, and mobile service applications. This framework tool assures delivering comprehensive premises and on-demand solutions based on CRM products. Siebel CRM is first developed by Oracle corporations.
It is a shared directory that stores compressed files used by Siebel applications. Examples: Product literature, sales tools, presentations Read/write access is controlled by the File System Manager component on Siebel Server.
CRM stands for Customer Relationship Management. It is a strategy and practices that companies use to manage and analyze customer interactions and data throughout the customer lifecycle.
You can see the hierarchical level in the Siebel CRM architecture, under the organization section the division will come.The main purpose of using an organization is to control the data visibility and where this cannot be possible with the division.
There are 5 types of tables used in Siebel CRM;
MultiValue field has the child values from a child BC for the parent record configured through MVL. single value field will be either from the base table or joined table.
The Difference between Single Value Field (SVF) and MultiValue Field(MVF)
SVF- a field in BC which references a column in a table.
MVF- a field in parent BC which references a field in child BC.
Field-Identifies and defines a field in a business component. All fields making up a business component record contain entries from both Single Value Field and MultiValue Field object types.
Below are the various advantages of using Siebel CRM;
CRM composes are grouped into three classifications
The snag for CRM accomplishment to an association incorporates
A portion of the difficulties that the association needs to confront is
Resonate is a third party software development tool, which is used for distributing the client request to the least laden Siebel server.
Limit base tables and columns to be processed by using: only base Tables, ignore base Tables, only base Columns, ignore base Columns.
Always delete batches from EIM tables upon completion. Leaving old batches in the EIM table wastes space and can adversely affect performance. For other suggestions on working with batches.
Run independent EIM jobs in parallel. Two or more EIM processes can be started simultaneously by using the Siebel Server Manager.
On the off chance that you have subsequent inquiries unanswered, you may require CRM arrangement,
Modify the object definitions in the local repository.
Q17. What does business module components user mode indicate?
Usually, the business component in user mode defines the visibility in the BC.
For example “All”
“Personal”
“Manager”
“Organization”.
You can see the hierarchical level in the Siebel CRM architecture, under the organization section the division will come.
The main purpose of using an organization is to control the data visibility and where this cannot be possible with the division.
EIM is used to import a large amount of data or delete a large amount of data.
EAI is used to integrate any application.
The complex joins are the joins that hold conditional mapping like <, >, =, AND, NOT. We can also use ‘=’ to represent primary and foreign key values.
Primary key and foreign key value are always starting from (1-N).
The Complex join uses the (1 -0, 1) and (0, 1 –N) kind of relationships.
This is possible with the help of scripting;
For example:
Go to preinvoked method -> then click on button option
Window. Open (URL NAME)
Now open the webpage for the respective URL using URL NAME variables.
S_opty is a base table used to store the parent data.
S_opty_x is an extension table used in Siebel CRM to define 1:1 relationship.
S_opty_xm is an extension table used in Siebel CRM to define 1.m relationship.
Create a new static pick list. Add BC field that will be populated. Map the BC field to the pick list BC field. Specify which control or list column will invoke the pick list applet. Picklist will be empty until values are put in the S_LST_OF_VAL table.
Create a Pick list using a BC representing the joined table. Associate the Pick list with a BC field. Map the BC fields to the Pick list BC fields. Create a Pick list applet. Specify which control or list column will invoke the Pick list applet.
Data Storage layer, Business Layer & Data Presentation Layer.
We can enter free text incase of Unbounded Picklist. But, incase of Bounded Picklist, we can not enter free text.
Explorer & List Editor.
Standard extension tables – Predefined tables which support 1:1 or M:1 relationships. Part of the existing physical database. Custom extension tables and custom extension columns – New 1:1 table, New columns that are added to new and existing tables.