The following screens show the setup initially made before adding the Custom Views to the CASTORE1 database.

This section is used to highlight the procedure which must then be followed to include the additional custom Views, since a local Cognos datasource copy is made for the loaded tables, and on making any additional changes, the Datasource must be refreshed.

Figure 5-14The Manage menu option is selected from the drop-down menu list

From the Manage menu, a long list of options is displayed as shown in Figure 5-15, from which we select the “Data server connections” menu.

Figure 5-15The Data server connections submenu is selected

In the next slide-out frame, we can then enter the Data connection name, AUDIT_DB_CASTORE1, and then click the + Add data server icon.

Figure 5-16The Data server connection name, AUDIT_DB_CASTORE1, is entered

The Data server connection name, AUDIT_DB_CASTORE1, is entered, and then the Add data server + icon is clicked to give a list of Data server connection types.

 

Figure 5-17The slide-out panel now gives a list of datasource types, and IBM Db2 is selected

There is a long scrollable list of Database and Datasource types (as shown in Figure 5-17) from which we select the IBM Db2 database type.

 

Figure 5-18The option to use a signon for the IBM Db2 connection is selected

First, we need to enter a value (AUDIT_DB_CASTORE1) to replace the New data server connection default value shown at the top of the second panel.

Next, as shown in Figure 5-18, the option to use a signon is selected, and the + icon causes the third panel to slide open with a JDBC URL template for entry of the <hostname>, <port>, and <databasename> values replacing these placeholders.

Figure 5-19The CASTORE1 db2inst1 user signon credentials are entered

The entered credentials are tested.

Figure 5-20The AUDIT_DB_CASTORE1 Datasource is tested with the entered credentials

The Manage menu is selected again.

Figure 5-21The Manage menu option is selected

The Manage option is selected, which then displays the Data server connection we created.

Figure 5-22The Data server connections showing the AUDIT_DB_CASTORE1 connection

The Cognos user permissions can now be updated using the screen shown in Figure 5-23 after clicking the AUDIT_DB_CASTORE1 Data server connection.

Figure 5-23The permissions are set for the Cognos users for AUDIT_DB_CASTORE1

 

Figure 5-24The Administration console… is selected next

From the top-left “Hamburger” icon in Figure 5-24, we now select the Administration console… menu item, and then we select the Configuration tab shown in Figure 5-25.

Figure 5-25The Configuration tab, as highlighted, is selected