For Metric Studio, the Application Tier Components must be able to access the metric store. The database client software for the metric store must be installed and configured on each computer where you install Application Tier Components.
To set up database connectivity for the metric store database:
Install the appropriate JDBC driver.
Database | JDBC Driver |
Oracle | JDBC OCI driver |
DB2 | JDBC driver that requires DB2 client installation |
Microsoft SQL Server | Included with Cognos components. No other software is required. Cognos 8 requires TCP/IP connectivity with Microsoft SQL Server. |