|
Siebel Data Warehouse 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 45 provides a description of the database connection properties.
Table 45. Database Connection Properties
|
|
Name |
Logical name for the connection. (The metadata that comes with Siebel Analytics Data Warehouse has two data sources: OLTP, which points to the Siebel transactional database, and the data warehouse.) |
Type |
Source or Warehouse. |
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. |
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. You should use this command on the machine where the DAC server is running. If the DAC server is not running, you will be asked whether you want to test the connection on the local machine. The results of such a test 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.
|
