Siebel Architecture Basic Concepts: Siebel Database Server Explanation

Siebel Architecture Basic Concepts: Siebel Database Server Explanation in detail

Siebel eBusiness application software supports a number of different relational database systems; the document “Siebel System Requirements and Supported Platforms” contains details of the supported vendors and versions.

Siebel eBusiness software is delivered complete with a database schema that must be created on the chosen database. This schema is managed as part of the Siebel application configuration process and allows for a number of different types of extensions as a result of configuration.

Each Siebel eBusiness component that requires access to the database, such as the Siebel Application server, will use ODBC. The Siebel Application servers will maintain multiple connections to the database server, including support for the user sessions. To avoid many thousands of connections, the Siebel Application server can be configured to use connection pooling. This will cause the Siebel Application server to use a single database connection to service multiple tasks or user sessions.

All data manipulation interactions that occur must do so through a Siebel eBusiness application component, since referential integrity and data quality are controlled at the application layer. Direct insert, update and delete operations against the database are not supported. Although data retrieval operations are permitted directly from the database, Siebel does not guarantee or warrant that the results achieved will be as required.

The Siebel eBusiness database contains user data, reference data and the application definition, also known as the Siebel Repository. Access to the data contained within the database is controlled through users’ responsibilities and positions defined within the application. Database security is not employed to control access to data elements or attributes and as a result, to preserve data security, users must not be given the means to access the database directly.
When defining the database, several accounts will be required. They are typically:

• Table or schema owner – SIEBEL
• Application administration user – SADMIN
• User role for all users – SSE_ROLE

The above is the information the Siebel eBusiness product is supplied preconfigured. The user accounts and roles must be added to the database by the database administrator, as must all user accounts.
#siebel