Set Up Database Connectivity for the Controller Data Mart

If you use a different database for the Controller data mart than you use for the Controller repository, then you must set up connectivity to this separate database. A Controller data mart database is required only if you intend to use the Publish to Data Mart Framework Manager model that is provided with IBM® Controller.

Procedure

Install the appropriate JDBC driver for your Controller data mart, as follows:

Table 1. JDBC drivers for Controller data mart databases
Database	JDBC Driver
Microsoft SQL Server	IBM Controller requires TCP/IP connectivity with Microsoft SQL Server.