|
Siebel Analytics Installation and Configuration Guide > Configuring Siebel Analytics in the Windows Environment >
Changing Database Connection Pool Settings
This task is part of the Process of Configuring Siebel Analytics Server Under Windows. The SiebelAnalytics.rpd application repository contains multiple, preconfigured database connections. By default the database type is IBM DB2. When you start the Siebel Analytics Server, you receive linker errors in the NQServer.log, such as the following: [54009] Unable to create connection pool Internal System Connection Pool in repository Star.ld.so.1: /t3fs4/AN1393/SiebelAnalytics/Bin/nqsserver.exe: fatal: libdb2.so.1: open failed: No such file or directory
[nQSError: 46029] Failed to load the DLL /t3fs4/AN1393/SiebelAnalytics/Bin/ libnqsdbgatewaydb2cli35.so. Check if 'DB2 CLI' database client is installed.
This behavior is expected. You must reconfigure all the database connections appropriate to your environments. This includes changing the database types and updating the user names and passwords. (In addition, while testing the Siebel Analytics Server installation, you may need to change connection pool settings for items such as the name of the database, the user ID and password, and other settings for the several repositories bundled with applications versions of Siebel Analytics.) The default settings use the following patterns:
- Password for all the database connections is db2. Update the passwords for your particular database connections.
- Data Source Name (DSN) for transactional databases is VALUEOF(OLTP_DSN).
- User for transactional databases is VALUEOF(OLTP_USER).
- Data Source Name (DSN) for data warehouses is VALUEOF(OLAP_DSN).
- User for data warehouses is VALUEOF(OLAP_USER).
The connection pools are described briefly in Table 16.
Table 16. Connection Pools
|
|
BBB Data Warehouse |
Enterprise visibility Siebel Data Warehouse.
Siebel operational applications Analytics customers only. |
BBB OLTP |
Enterprise visibility Siebel transactional database.
Siebel operational applications Analytics customers only. |
BBB XLS Data |
DSN is the same as the connection pool name. Data is stored in C:\Data\Applications\BBB\BBB. Siebel operational applications Analytics customers only. |
DataMining Demo |
Data Warehouse visibility.
Siebel Data Mining customers only. |
ERM Siebel OLTP |
Workforce Analytics connection to Siebel transactional database.
Workforce Analytics customers only. |
Externalized Metadata Strings |
Connection to the Siebel operational application database to load the translations of Metadata Strings.
Financial Services customers and all customers deploying Analytics in a language other than English. NOTE: This connection pool is configured to be the same as the Siebel transactional database.
|
Forecasting Siebel Data Warehouse |
Connection to the Siebel Data Warehouse.
Forecasting Analytics customers only. |
Forecasting Siebel OLTP |
Connection to the Siebel transactional database.
Real-time Forecasting Analytics customers only. |
Incentive Compensation Siebel OLTP |
Database connection to the Siebel transactional database.
Incentive Compensation Analytics customers only. |
Pharma Data Warehouse |
Connection to the Pharmaceutical data warehouse.
Pharmaceutical industry-specific customers only. |
Real-time OLTP |
Connection to the Siebel transactional database.
Real-time Analytics (all customers). |
SIA Data Warehouse |
Connection for Siebel Industry Applications data warehouse.
For Siebel Industry Applications customers only. |
Siebel Analytics Usage |
Usage Tracking Writer Connection Pool connects to the database where you store the usage statistics of the Siebel Analytics Server.
Optional for all customers. NOTE: Using this feature requires that Siebel Analytics Scheduler be set up to load the usage statistics into the database.
|
Siebel Data Warehouse |
Database connection to the Siebel Data Warehouse.
Analytics applications customers only. |
Siebel OLTP |
NOTE: There are two connection pools to the Siebel transactional database. Both should be configured properly.
OLTP DbAuth connects to the Siebel transactional database for Authentication and Authorization. The user name and password is preconfigured to USER and PASSWORD and should be left as such if you want to use database logons to authenticate users. All customers. |
UQ Siebel OLTP |
Connection to the Siebel transactional database.
Universal Queuing customers only. |
Usage Accelerator Datawarehouse |
Database connection to the Siebel Data Warehouse.
Analytics applications customers only. |
| 
