Whether you are installing Integration Services for the first time or upgrading from a previous release, after you start the console, the OLAP Metadata Catalog Setup dialog box is displayed. Using this dialog box, you can either create a catalog or upgrade an existing catalog.
Note: | An OLAP Metadata Catalog must be created and configured before you can connect to it. For information on configuring a relational data source for an OLAP Metadata Catalog, see Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. For information on creating OLAP Metadata Catalogs, see Creating, Upgrading, and Deleting OLAP Metadata Catalogs. |
After the process of creating or upgrading an OLAP Metadata Catalog is complete, you can begin to create OLAP models and metaoutlines. You must connect to Integration Server, to an external data source, and to the OLAP Metadata Catalog where you want to store the OLAP models and metaoutlines that you create.
To use Integration Services Console to perform data loads, member loads, or member and data loads, you must connect the client software to an additional server component, Essbase Server.
You are prompted by the Login dialog box to connect to an Integration Server and an OLAP Metadata Catalog. Optionally, in the Login dialog box, you can also connect to an instance of Essbase Server and create default connection settings for both server components.
For information on troubleshooting connections to server components, see Troubleshooting ODBC and Connections.