Connecting to Integration Server

Integration Server manages access to OLAP Metadata Catalogs and to data sources. A catalog stores information that defines the external data source and the structure of OLAP model and metaoutline elements. To create an OLAP model or a metaoutline, you must connect to Integration Server.

Note:

The Integration Server system administrator must provide a user name and password to an OLAP Metadata Catalog before you can connect to the server.

Note:

It is highly recommended that you do not connect the Integration Server and Integration Services Console via a wide area network (WAN). Doing so may cause severe performance degradation.

  To connect to Integration Server:

  1. To display the Login dialog box from the OLAP Model main window of the Integration Services Console, select Connections, then OLAP Metadata Catalog, then Connect.

    Note:

    The Login dialog box is displayed automatically when you start Integration Services Console. You can redisplay the Login dialog box by using the procedures described in this topic.

  2. In the Server drop-down list under Integration Services, enter or select the name or IP address of an Integration Server computer; for example, cypress.

    If the port number on which Essbase Integration Server communicates with the console has been set to a value other than the default, you must type the server name or IP address and type the nonstandard port number, separated by a colon; for example:

    cypress:3390

  3. In the OLAP Metadata Catalog drop-down list, select the data source name of an OLAP Metadata Catalog; for example, TBC_MD for the sample TBC (The Beverage Company) catalog database.

    Oracle:TBC_MD

  4. In the Code Page drop-down list box, select the code page of the language you want to use during the current Integration Services Console session.

    The code page is a portion of the locale which identifies the local language and cultural conventions such as the formatting of currency and dates and the sort order of data.

  5. In the User Name drop-down list box under Integration Services, type or select your user name.

    It is necessary to type a user name the first time it is used. After a user is successfully connected to Integration Services, the user name is then displayed in the User Name drop-down list.

  6. In the Password text box under Essbase Integration Server, type your password.

    Note:

    Use the same user name and password that you use to connect directly to the database server and to access the database that contains the OLAP Metadata Catalog.

  7. Click OK or enter information for connecting to an instance of Essbase Server.