In this step, you specify the database server information to allow the Content Manager to connect to the database you use for the content store (as discussed in the Creating the Content Store section). After you set the database connection properties, you can test the connection between Content Manager and the content store.
ACI requires the TCP/IP protocol to access data and the content store. Ensure that the database server has the protocol set to TCP/IP.
Before starting Cognos Configuration, copy your JDBC driver to the
<ATG9dir>\ACI9.3\c8\webapps\p2pd\WEB-INF\libdirectory.If using Windows, from the Start menu, select Programs > ACI9.3 > Cognos Configuration. On UNIX, make sure that your
DISPLAYvariable is set correctly and run cogconfig.sh.In the Explorer window, under Data Access, Content Manager, right-click IBM Cognos Content Store and click Delete to delete the default resource.
Right-click Content Manager, and then click New resource, Database.
In the Name box, type a name for the resource.
In the Type box, select the type of database and click OK.
To use an Oracle Net8 keyword-value pair to manage the database connection, select Oracle database (Advanced).
In the Resource Properties window, provide values depending on your database type:
Microsoft SQL Server
Type the appropriate values for the Database server with port number or instance name and Database name properties. You can use either a port number, such as 1433, or a named instance as the value. To connect to a named instance, you must specify the instance name as a JDBC URL property or a data source property. For example, you can type localhost\instance1. If no instance name property is specified, a connection to the default instance is created.Note that the properties specified for the named instance, along with the user ID and password, and database name, are used to create a JDBC URL. Here is an example:
jdbc:JSQLConnect://localhost\\instance1/user=
sa/more properties as requiredDB2
For the Database name property, type the database alias.Oracle
Type the Database server and port number and Service name.Advanced Oracle
For the Database specifier property, type the Oracle Net8 keyword-value pair for the connection.Here is an example:
(description=(address=(host=myhost)(protocol=tcp)(port=1521)
(connect_data=(sid=(orcl)))))Sybase
ATG products do not support Sybase.
To change the logon credentials, specify a user ID and password:
Click the Value box next to the User ID and password property and then click the edit button when it appears.
Type the appropriate values and click OK.
From the File menu, click Save. The logon credentials are immediately encrypted.
To test the connection between Content Manager and the content store, in the Explorer window, right-click the new database and click Test.
Content Manager can now create the required tables in the content store when you start the Cognos 8 service for the first time. If the connection properties are not specified correctly, you cannot connect to Cognos Connection.
To verify the database information, right-click Content Store, and then click Test. Verify the database connection exists without errors.
Note: If running IIS in a port other than 80, you need to change port 80 for the URLs to match your IIS port. Under Local Configuration> Environment. Gateway URI and Controller URI for gateway. Example:
http://localhost:80/arc/controllerServer.Note: If the Web server is not running locally, you must also change the host name.
In
<ATG9dir>\ACI9.3\c8\configuration\AuthenticiationProvider.:
propertiesWSCAPSOAPAddressString=http://hostname:port/wscap/services/wscapSOAPNote: Host and port numbers should be set where your WSCAP authentication provider is running.
Save your configuration changes.
Start the Cognos Service:
From the Actions menu, click Start (or from the toolbar, click the Start button).
Verify that the service runs without errors.
Open your browser to
http:/hostname:port/arcto verify that the login page displays.
