Starting Integration Services Shell

Before you start Integration Services Shell, make sure that the following programs are running. These programs can be on network server computers and do not need to be on your local computer to be available to Integration Services Shell:

A database that contains the OLAP Metadata Catalog where the metadata is stored
One or more data sources that you want to use to create OLAP models and metaoutlines
Essbase Integration Server
See Starting Integration Server.
Essbase Server
See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

To start Integration Services Shell, use one of the following methods:

From the Windows Start menu, select All Programs, then Oracle EPM System, then Essbase, then Integration Services, then Shell.
Enter the executable name on the command line; for example, type
```
olapicmd 
```

To set the TCP port number with which Essbase Integration Server communicates with its clients to a port different from the default 3388, enter the executable name and -Pportnumber when you start Integration Services Shell; for example, type

olapicmd -P3390

Note:

If Integration Services Shell does not start when olapicmd is executed from the command line, the operating system path may not be updated correctly. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.

The Integration Services Shell window opens, as shown in Figure 5, Essbase Integration Services Shell Window:

Figure 5. Essbase Integration Services Shell Window

In the Integration Services Shell window, enter commands at the command prompt. For example, type the following commands:

Type login machine_name to log on to a server running on the same machine.
Type shutdown to stop the server.
Type exit to stop Integration Services Shell.
Type help to get a list of Integration Services Shell commands.