|
Siebel Business Analytics Applications Installation and Administration Guide > DAC Functional Reference > About the DAC Setup View >
About the DAC Database Connections Tab
This tab provides access to the database connection properties. The top pane Indices tab displays a list of the properties and their current values. You can edit the property values in the top pane by double-clicking in a cell. Table 51 provides a description of the database connection properties.
Table 51. Database Connection Properties
|
|
Name |
Logical name for the connection. (The metadata that comes with Siebel Business Analytics has two data sources: OLTP, which points to the Siebel transactional database, and the data warehouse.) |
Type |
Possible values are: - Source
- Warehouse
- Informatica Repository
- DAC Repository
- Other
|
Connection Type |
Type of database connection. Possible values are the following: - Oracle (OCI8). Connect to Oracle using the tnsnames entry.
- Oracle (Thin). Connect to Oracle using thin driver.
- DB2. DB@ UDB database.
- DB2-390. DB2 390 database.
- MSSQL. Microsoft SQL Server.
- Teradata. Teradata database.
|
Connection String |
If you are using... - Oracle (OCI8) use the tnsnames entry.
- Oracle (Thin) use instance name.
- SQL server use the database name.
- DB2-UDB/DB2-390 use the connect string as defined in the DB2 configuration.
- Teradata use the database name.
|
Table Owner |
Name of table owner. |
Password |
Password for table owner. |
Max Num Connections |
Maximum number of database connections this connection pool can contain. For information about determining how to set this value, see Determining the Number of Transactional and Data Warehouse Database Connections |
DBHost |
Host machine where the database resides. This field is mandatory if you are using Oracle (Thin) or MSSQL but is not required if you are using Oracle (OCI8), DB2, or DB2-390. |
Port |
Port where the database receives requests. Required for Oracle (Thin) and MSSQL databases. Not required for Oracle (OCI8), DB2, or DB2-390 databases. |
Actions Available
The following actions are available in the top pane toolbar and in the right-click menu when the Database Connections tab is active. Test Connection
This command allows you to test the connection to the database. The DAC client will attempt to delegate the test to the DAC server. If the DAC server is not running, you will be asked whether you want to test the connection on the local client machine. The results of a test on the local client machine may not be true for the DAC server environment. Internal Tasks
This command allows you to manage internal tasks. The following options are available: - Source (Change Capture Tasks). Generates internal tasks for performing change capture for Siebel sources only.
- Data Warehouse (W_PARAM_G update, Query Index Creation). The supported configuration is one data warehouse for each repository; however, you can create aliases for the same database to be able to filter tasks. To do so, create either of the following tasks for the aliases:
- Update W_PARAM_G. This task updates the W_PARAM_G table with the ETL preferences defined in the DAC.
- Create Query Indexes. If the system preference CreateQueryIndexesAtTheEnd is set to True, then this task will hold the details of all the created query indexes.
|
