Siebel Analytics Installation and Configuration Guide > Accessing Analytics Through Siebel Applications > Changing the Preconfigured Database Connections >

Connection Pools


Siebel Analytics uses multiple connection pools. In Changing the Database Type, you configured these connection pools for your operational database. Table 17 explains the purpose of some connection pools.

NOTE:  The default password for all the database connections is db2. Update the passwords for your database connections.

Table 17.  Connection Pools
Connection Name
Description
BBB Data Warehouse
Enterprise visibility Siebel Data Warehouse (Siebel eBusiness Applications Analytics customers only).
BBB OLTP
Enterprise visibility Siebel transactional database (Siebel eBusiness Applications Analytics customers only).
ERM Siebel OLTP
Workforce Analytics connection to Siebel transactional database (Workforce Analytics customers only).
Externalized Metadata Strings
Connection to the Siebel eBusiness application database to load the translations of Metadata Strings (Financial Services and all customers deploying Analytics in non English language).
This is configured to be the same as the Siebel transactional database.
Forecasting Siebel Data Warehouse
Connection to the Siebel Data Warehouse for Forecasting Analytics customers only.
Forecasting Siebel OLTP
Connection to the Siebel transactional database for real-time forecasting Analytics customers only.
Incentive Compensation Siebel OLTP
Database connection to the Siebel transactional database for Incentive Compensation Analytics customers only.
Pharma Data Warehouse
Connection to the Pharmaceutical data warehouse for pharmaceutical industry-specific Analytics.
Real-time OLTP
Connection to the Siebel transactional database for real-time Analytics (all customers.)
SIA Data Warehouse
Connection for Siebel Industry Applications data warehouse, covering the following Siebel Industry Applications: Financial Services, Automotive, Consumer Sector and Communications.
Siebel Analytics Usage
Connect to the database where you store the usage statistics of the Siebel Analytics Server. Using this requires Siebel Analytics Scheduler to load the usage statistics into the database (optional for all customers).
Siebel Data Warehouse
Database connection to the Siebel Data Warehouse (all customers).
Siebel OLTP
Connection to the Siebel transactional database for Authentication and Authorization (all customers).
There are two connection pools to the Siebel transactional database. Both should be configured properly. The OLTP DbAuth Connection Pool is used for database authentication of users. The user name and password is preconfigured to :USER and :PASSWORD and should be left as such if you want to use database logins to authenticate users.
UQ SIebel OLTP
Connection to the Siebel transactional database for Universal Queuing customers only.

 Siebel Analytics Installation and Configuration Guide
 Published: 09 September 2004