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:
- Accessing the consoles
- Understanding the new system configuration
- Setting the security configuration
- Configuring services
- Performing system and metadata configuration
- Managing connections
- Managing data server drivers
- 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
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
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
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
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
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
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:
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:
- Launch the WebSphere Application Server administration console.
- Select Application > Application Types > Enterprise Applications.
- On the Enterprise Applications page, click IBMDataToolsWeb. The IBMDataToolsWeb application configuration page appears.
- 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
- 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.
- Repeat this procedure for all three roles (Administrator, Operator, and Viewer).
- To map on a set of users defined in the user registry, click the Map users button and follow the steps and instructions.
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
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
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
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
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
By default, <ISW_INSTALL_DIR> is
Files\IBM\ISWarehouse for Windows® and
/opt/IBM/ISWarehouse for UNIX.
Listing 1 shows the contents of the
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
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).
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
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
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
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
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
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
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
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
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
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.
We would like to thank Sriram Srinivasan for reviewing the technical contents of this article and for providing valuable insights and comments.
- Use an RSS feed to request notification for the upcoming articles in this series. (Find out more about RSS feeds of developerWorks content.)
- Refer to the IBM InfoSphere Warehouse 9.7 Information Center for many more details about InfoSphere Warehouse.
- See Securing applications and their environment in the WebSphere Application Server Information Center for more details about application security.
- Check out Configuring Lightweight Directory Access Protocol user registries in the WebSphere Application Server Information Center for more details about LDAP.
- Refer to Changing the connection settings to the metadata repository in the IBM InfoSphere Warehouse 9.7 Information Center.
- Learn more about the Administration Console command line interface in the IBM InfoSphere Warehouse 9.7 Information Center.
- Explore the Data Warehousing area on developerWorks to get the resources you need to advance your skills on IBM InfoSphere Warehouse.
- Learn more about Information Management at the developerWorks Information Management zone. Find technical documentation, how-to articles, education, downloads, product information, and more.
- Stay current with developerWorks technical events and webcasts.
Get products and technologies
- Download a trial version of InfoSphere Warehouse 9.7 Enterprise Edition.
Dig deeper into Information management on developerWorks
Get samples, articles, product docs, and community resources to help build, deploy, and manage your cloud apps.
Keep up with the best and latest technical info to help you tackle your development challenges.
Software development in the cloud. Register today to create a project.
Evaluate IBM software and solutions, and transform challenges into opportunities.