Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse > Process of Configuring the Table Analyze Utility >
Setting the Database Connection Information for the Table Analyze Utility
This task is a step in the Process of Configuring the Table Analyze Utility. You need to set the database connection information before you execute the Table Analyze Utility program. To set the database connection information
- On the server where you installed the Siebel Business Analytics, navigate to the $Siebel\Etl\AnalyzeUtility folder.
- Open the database.properties file using Microsoft WordPad or Notepad.
- Edit fields in the database.properties file depending on your database type, as shown in the following table.
|
|
|
|
|
|
DatabaseUsername |
A database user with permission to read and write. |
JDBCTableowner |
Name of the table owner. |
JDBCDBType |
Oracle (OCI8) |
Oracle (Thin) |
DB2 |
MSSQL |
Teradata |
JDBCConnString |
TNS name |
Service name or SID |
Connection string |
Database name |
Database name |
JDBCHost |
None |
Server host |
None |
Server host |
Server host |
JDBCPort |
None |
Server port |
None |
Server port |
Server port |
|