Using the IBM InfoSphere Warehouse 9.7 Administration Console, Part 1: Getting started and setting up

This series of articles introduces the IBM InfoSphere® Warehouse Administration Console 9.7, which is part of the IBM InfoSphere Warehouse product. The InfoSphere Warehouse Administration Console provides an integrated Web portal to administer, monitor, and configure related InfoSphere Warehouse components in an operational environment. This Part 1 of this series provides a general introduction to the new features delivered in version 9.7, and it covers topics related to configuration and resource management, including security configuration, system metadata configuration, configuration services management, logging services management, connection management, and system resource management.

Share:

Albert Yao (ayao@us.ibm.com), Advisory Software Engineer, IBM

Albert Yao is an Advisory Software Engineer in the IBM Software Group in Austin, Texas. He is currently working as the solution lead for the Warehouse Administration Console, and he was a key technical lead for the earlier releases of the Administration Console . He has been working in the IBM Business Intelligence area for more than 10 years. He has been a key contributor to multiple BI products at IBM, including InfoSphere Warehouse, DB2 Data Warehouse Edition, WebSphere Commerce Analyzer, Intelligent Miner for Relationship Marketing, and Business Discovery Solutions.. Before joining IBM, Albert worked for Intel and other software companies.



Dimple Bhatia (dimple@us.ibm.com), Advisory Software Engineer, IBM

Dimple Bhatia is an Advisory Software Engineer at the IBM Silicon Valley Lab in San Jose, California. She is currently working on the Administration Console tool in the InfoSphere Warehouse and on the common Web tooling infrastructure for all Web-based tools in the Optim umbrella. Before joining the InfoSphere Warehouse tooling team, she worked as the lead on the Federation Catalog and on migration in the WebSphere Federation Server product. She holds a masters degree in Computer Engineering from Syracuse University, New York.



21 September 2009

Also available in Russian

Introduction

This article is the first of a series of articles that describe how to use the IBM InfoSphere Warehouse Administration Console to perform setup tasks that are prerequisites to using components, including SQL Warehousing, Cubing Services, and Mining. The setup tasks include:

  1. Accessing the consoles
  2. Understanding the new system configuration
  3. Setting the security configuration
  4. Configuring services
  5. Performing system and metadata configuration
  6. Managing connections
  7. Managing data server drivers
  8. Managing system resources

InfoSphere Warehouse is a suite of data warehouse products that use the strength of DB2® Enterprise Edition as a foundation. The suite provides a complete set of applications that you can use to build a complete data warehousing solution, including a highly scalable relational database, data access capabilities, and front-end analysis tools. The InfoSphere Warehouse Administration Console is a Web-based tool that gives you the ability to administer, monitor, and configure related InfoSphere Warehouse components in an operational environment.

The main features available in the InfoSphere Warehouse Administration Console 9.7 are:

  • Information portal for InfoSphere Warehouse-related resources: The Administration Console provides links to a wide range of resources related to InfoSphere Warehouse, such as the InfoSphere Warehouse introduction, the online document, the online tutorial, and online support. It also provides interfaces to the WebSphere® administration console and to the Workload Management console. The information portal links to the online forums for InfoSphere Warehouse and related DB2 communities through the InfoSphere Warehouse home page, as shown in Figures 1 and 2.
  • Configuration and log management: The configuration management feature in 9.7 enables users to configure notification and system logging services. Users can filter the system log file contents and view them, or users can view the entire log content in a browser.
  • Connection management and system resource management: The connection management infrastructure enables users to define, edit, or delete connections to IBM and non-IBM databases. The improved system management infrastructure provides the capability to define, edit, or delete new system resources, such as FTP server connections.
  • SQL Warehousing administration: SQL Warehousing (SQW) administration provides the capability to deploy and manage SQW applications, to perform on-demand execution, and to schedule executions of SQW control flows and monitor the status of the control flow execution. The new scheduler infrastructure provides easier handling of control flow execution scheduling.
  • Cubing Services administration: Cubing Services administration provides the capability to manage cube and cube servers; to start, stop, and monitor cubes and cube servers; to import and manage cube models and metadata; and to manage security roles for cube security, It also provides support for the new Cubing Services features, such as starting and stopping remote cube servers, virtual cube management, and cube dimension security.
  • Mining administration: Mining administration provides the capability to enable databases for mining, to manage the mining models, and to manage cached models. It also provides support for the new Time Series model.

Accessing the consoles

The InfoSphere Warehouse portal and the InfoSphere Warehouse Administration Console can be accessed though the URL http://hostname:port_number/ibm/warehouse where hostname is the host name of the computer where WebSphere Application Server is installed. The port_number is the default host port number of the WebSphere Application Server profile where the InfoSphere Warehouse Administration Console application is installed. For example, the URL might be http://netlab2.austin.ibm.com:9080/ibm/warehouse

InfoSphere Warehouse Administration Console 9.7 provides an improved user interface with rich Internet application implementation. In addition to support for the features available in previous releases, version 9.7 also offers support for new features that are available in the related InfoSphere Warehouse components in the 9.7 product. The Administration Console is an integrated administration portal where users can manage system configuration, control data sources, control system resources, and manage the operations in the SQL Warehousing Tool, Cubing Services, and Mining. It also provides access to a large set of online information related to the InfoSphere Warehouse and to the InfoSphere Warehouse Administration Console through the new InfoSphere Warehouse home portal, as shown in Figure 1.

Figure 1. InfoSphere Warehouse home portal
Screen cap showing Welcome to InfoSphere Warehouse screen, including My Tools section on the left.

Access the InfoSphere Warehouse Administration Console by clicking the InfoSphere Warehouse Administration Console link on the InfoSphere Warehouse home page under the My Tools section. The InfoSphere Warehouse Administration Console window appears, as shown in Figure 2.

Figure 2. InfoSphere Warehouse Administration Console
Screen cap showing Welcome to InfoSphere Warehouse Administration Console and tabs

Understanding the new system configuration

A set of new configuration services has been added to the Administration Console application. The Administration Console enables the application to automatically set up most of the configuration and metadata needed for normal operations. For example, the backend SQW administration services and the CS administration service handle the metadata tables needed for controlling SQW metadata and the repository tables needed for controlling Cubing Services metadata. The configuration services are automatically created when the system is initialized. Also, a set of the configuration services has been added for configuring the e-mail services and system logging.

In previous releases, the configuration tool handled most of the setup and configuration during installation of InfoSphere Warehouse. With the new configuration services infrastructure added to the Administration Console in version 9.7, the configuration tool has been phased out. The related functions are replaced by the new configuration services and by the default functions that are already provided in the WebSphere Application Server administration console.


Setting the security configuration

In earlier versions of the Administration Console, the install configuration tool handled the security configuration, which provided a way to quickly set up the basic WebSphere Application Server security needed for the Administration Console. However, the install configuration tool covers only limited cases needed for security setup. Instead of providing limited setup cases for using the local operating system user repository and the LDAP user repository with Tivoli Directory server in standard configuration, the new Administration Console lets you fully use the WebSphere Application Server Administration Console to configure security and the user repository.

Enabling global security

During the installation of InfoSphere Warehouse 9.7, you have the option to use the existing version of WebSphere Application Server 7 on your system or to install the WebSphere Application Server packaged with InfoSphere Warehouse 9. After the installation is complete, global security is enabled in WebSphere Application Server. By default, global security uses the local operating system user registry for authentication.

To perform global security configuration in WebSphere Application Server, select Security > Global security from the WebSphere Application Server administration console navigation tree. The resulting Global security window appears, as shown in Figure 3.

Figure 3. Global security configuration
Screen cap showing Global Security window

The global security setting required for the InfoSphere Warehouse Administration Console enables only the global security related to administration security and application security for the WebSphere Application Server. It does not enable the Java™ 2 security for this configuration (see Figure 3).

Setting up the user repository

You can now take advantage of the supported user repositories in WebSphere Application Server, including the local operating system, LDAP, and the federated repositories. You can use the security configuration wizard in the WebSphere Application Server administration console to complete the security configuration and repository configuration. To start the security configuration wizard, select Security > Global security from the WebSphere Application Server administration console navigation tree, and then click the Security Configuration Wizard button on the Global security page. The resulting Configure Security window appears, as shown in Figure 4.

Figure 4. Security configuration wizard
Screen cap of Configure Security window

See Resources for details on WebSphere Application Server security configuration and for information on how to configure LDAP user repository in WebSphere Application Server 7.0.

Security role mapping for the Administration Console

Three security roles are defined for the InfoSphere Warehouse Administration Console 9.7. They are:

  • Administrator
  • Operator
  • Viewer

These roles are related. The Administrator is a super-user role that implicitly includes all the privileges that Operators and Viewers have. The Operator includes all the privileges that Viewers have.

In previous releases (9.1.x and 9.5.x), the three roles defined for the Administration Console were Administrator, Manager, and Operator. The Administrator role restrictions were assigned to the features related to the administration tasks in the Administration Console. The Manager and Operator roles were mostly used in SQL Warehousing administration for managing functions in control flow execution and monitoring. The roles were not related. A user could have multiple roles. A user's privileges would be the union of the privileges for all the roles that user had.

To configure the security role mappings for the InfoSphere Warehouse Administration Console application, complete the following steps:

  1. Launch the WebSphere Application Server administration console.
  2. Select Application > Application Types > Enterprise Applications.
  3. On the Enterprise Applications page, click IBMDataToolsWeb. The IBMDataToolsWeb application configuration page appears.
  4. Click the link under Detail properties > Security role to user/group mapping, which is the security role to user/group mapping for the InfoSphere Warehouse Administration Console application. The resulting Enterprise Applications window appears, as shown in Figure 5. You can map a role to a group of users defined in a group in the user repository, or you can map a role to a specific user or users.
Figure 5. Security role to user/group mapping for the InfoSphere Warehouse Administration Console application
Screen cap showing Enterprise Applications and Roles and Mapped Groups ready for mapping
  1. To map a set of groups defined in the user registry to a role, click the Map Groups button, and follow the steps and instructions to complete this task.
  2. Repeat this procedure for all three roles (Administrator, Operator, and Viewer).
  3. To map on a set of users defined in the user registry, click the Map users button and follow the steps and instructions.

Configuring services

Configuring the notification service

In 9.7, the InfoSphere Warehouse Server provides the notification service that can be configured using the Administration Console. Select the Notification Service entry from the data grid, and click the Configure button, as shown in Figure 6 (see larger image).

Figure 6. Configuration of services
Screen cap of InfoSphere Warehouse Administration Console with Configuration tab selected

You can specify the details about the outbound SMTP mail server, as shown in Figure 7. The port number is 25 by default.

Figure 7. Configuring the notification service
Screen cap of Configure the Notification Service

Before you save the configuration, you can test your configuration using the Send a Test E-mail button, where you can enter the To and From addresses, as shown in Figure 8.

Figure 8. Sending test e-mail
Screen cap of email addresses entered for test email

Once the test is successful, click the OK button to save the configuration in the repository.

Configuring the logging service

In 9.7, you can configure the system logger properties. Select the System logging service from the grid on the Configuration tab, and click Configure. The Configure the System Logging Service window appears, as shown in Figure 9.

Figure 9. Configuring the system logger
Screen cap showing path, error level, and rolling log indicator

The log configuration is loaded with the default values for the properties. You can modify the default values for the properties, including the log file path and name, the log level, and the rolling log. After you modify any of these properties, WebSphere Application Server must be restarted for the changes to take effect.


Performing system and metadata configuration

Metadata repository configuration

As a part of the InfoSphere Warehouse 9.7 installation process, users are required to provide information about the control database, including the database name and other connection and authentication information. This database is used as the metadata repository for the InfoSphere Warehouse applications where the metadata related to common configurations, SQL Warehousing, and Cubing Services are stored. The InfoSphere Warehouse installer sets up the configuration needed to connect to the control database. The related configuration is saved in the metadb.properties file located in the directory <ISW_INSTALL_DIR>/Config. By default, <ISW_INSTALL_DIR> is C:\Program Files\IBM\ISWarehouse for Windows® and /opt/IBM/ISWarehouse for UNIX.

Listing 1 shows the contents of the metadb.properties file.

Listing 1. The metadb.properties file
driverClass=com.ibm.db2.jcc.DB2Driver
URL=jdbc:db2://localhost:50000/ISWCTRL
dataServerType=DB2LUW
databaseName=ISWCTRL
user=db2admin
password=23ab6683f7bfcbfefc

Normally the repository information is set up during the installation. If Cubing Services is installed, a similar metadata database connection for Cubing Services is saved in another configuration file called cubingservices.xml in the directory <ISW_INSTALL_DIR>/CubingServices. If you want to change the metadata repository to a different database or to change the user ID or password, a command line utility called metadbconfig is provided. You can find this utility under the <ISW_INSTALL_DIR>/Config/cmdutil directory. Detailed instructions for how to use this utility can be found in the README file in the same directory, or in the online InfoSphere Warehouse Information Center (see Resources).

System diagnostics

As part of the new system infrastructure, a system diagnostics tool is provided. Access this tool through the View System Diagnostics link under My Configuration on the InfoSphere Warehouse home portal. This tool generates a system diagnostics report for the system environment that is running InfoSphere Warehouse and InfoSphere Warehouse Administration Console, as shown in Figure 10 (see larger image).

Figure 10. System diagnostics report
Screen cap of System Diagnostics Report

Managing connections

You can define connections using the default drivers pre-defined in the InfoSphere Warehouse Administration Console application. You can also define new drivers for other databases needed to make connections to other non-IBM databases.

Manage database connections

All user-defined connections are listed under the connection management main page. You can add a new connection, test the connection status of a defined connection, update the properties of an existing connection, or delete a connection, as shown in Figure 11 (see larger image).

Figure 11. Manage connections
Screen cap of Manage Connections window containing connection details

You can add a new connection by clicking the Add Connection button. In the Add Connection wizard, enter a new connection name, select which data server driver to use, and provide the database connection information, such as the database name, the host name, and the database port number, as shown in Figure 12. You can also provide user ID and password information for database authentication, and you can select the encryption method for the password.

Figure 12. Add a new connection
Screen cap with details defining a connection

By default, the connection is available to all Administration Console users. The access permission is defined as Public, as shown in Figure 13. The connection can also be defined as Restricted, which is only available to the users who have the specified security role. The connection can also be defined as Private, which is only available to the user specified for this connection.

Figure 13. Define connection permission
Screen cap of Add Connections window with Permission tab selected

Default data server drivers are pre-defined for common IBM databases. In order to create database connections for non-IBM databases, data server drivers for this type of database need to be defined first.

Note: You can also use the command line interface to add or delete connections (see Resources).


Managing data server drivers

The functions for managing the data server drivers are listed under the Manage Data Server Drivers tab. Four default data server drivers are pre-defined in the system:

  • DB2 for Linux®, UNIX® and Windows
  • DB2 for z/OS®
  • Informix JCC
  • Informix JDBC

You can add a new data server driver, delete a user-defined data server driver, or edit a user-defined driver, as shown in Figure 14. The pre-defined default drivers cannot be deleted or changed.

Figure 14. Manage data server drivers
Screen cap with Manage Data Server Drivers selected

You can add a new driver to the system by clicking the Add driver button. The following information is needed to successfully define a new driver:

  • Driver name
  • Data server type
  • Driver class name
  • Driver file

The driver files are the database JDBC driver jar files provided by database vendors. They are required to define the connection to this type of data server driver. The jar files used for defining new data server drivers must exist on the computer where the WebSphere Application Server is located, as shown in Figure 15.

Refer to the vendor documentation for detailed information, including the URL format, the driver class name, and the name and location of the driver jar files. Note that the CLASSPATH defined in the driver file entry must match the format required by the server machine. For example, files separators should be ";" for Windows but ":" for UNIX or Linux).

Figure 15. Add a new data server driver
Screen cap of Add Data Server Driver details

Managing system resources

You can add, edit, or delete system resources on the Manage System Resources tab, as shown in Figure 16 (see larger image).

Figure 16. Manage system resources
Screen cap of Manage System Resources tab selected

Creating a system resource

Click the Add button to add a system resource. The resulting Add System Resource window appears, as shown in Figure 17. The resource type could be:

  • Plain server
  • FTP server
  • Datastage server
Figure 17. Create a new system resource
Screen cap of Add System Resource window with Resource Details tab selected and Type is Plain Server

You can restrict the access to this system resource by specifying access only to a private user, as shown in Figure 18, or by restricting access to a specific role: Administrator, Operator, or Viewer.

Figure 18. Specify system resource permission
Screen cap of Add System Resource window with Permissions tab selected and Access is Private

Conclusion

The new InfoSphere Warehouse Administration Console provides users with flexibility to control the system setup and configuration related to the WebSphere environment. The Administration Console enables users to fully use the WebSphere Application Server administration console interface to configure security settings, user repositories, user role mappings, and user group mappings. The configuration services enable you to control the mail settings, log settings, and other configuration parameters. The metadata table control-table creation processes are automated.

New infrastructure for connection management and system resource management provide more customized options and provide enhanced features to fit the needs of the new Administration Console.

Other articles in this series dive deep into more Administration Console components, including SQL Warehousing administration, Cubing Services administration, and Mining administration.

Acknowledgments

We would like to thank Sriram Srinivasan for reviewing the technical contents of this article and for providing valuable insights and comments.

Resources

Learn

Get products and technologies

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=428852
ArticleTitle=Using the IBM InfoSphere Warehouse 9.7 Administration Console, Part 1: Getting started and setting up
publish-date=09212009