Integration Server

Integration Server is the primary component of Integration Services. Integration Server is software that uses the information stored in the OLAP Metadata Catalog to extract from data sources the dimension and member names needed to build an associated Essbase outline.

When the outline is complete, Integration Server extracts data from the data sources, performs the operations specified in the associated metaoutline, and loads the data into the Essbase database. See the Oracle Essbase Integration Services System Administrator's Guide.

Integration Server includes several subcomponents, as illustrated in Figure 2, Integration Services :

OLAP Metadata Catalog: A structured query language (SQL) relational database containing:
- Metadata describing the nature, source, location, and type of data to retrieve
- Metadata describing information required to generate Essbase outlines
- OLAP models and metaoutlines

You can create multiple OLAP Metadata Catalogs to store OLAP models and metaoutlines. Using XML Import/Export, you can move OLAP models and metaoutlines to a different OLAP Metadata Catalog.

The OLAP Metadata Catalog is a data source that is configured for Open Database Connectivity (ODBC). See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide or the ODBC user documentation.

Essbase Integration Services Shell: A command-line tool used to access Integration Server to load members and data into an Essbase database. See the Oracle Essbase Integration Services System Administrator's Guide.