Essbase - Integration Services - OLAP Metadata Catalog

> Database > Oracle Hyperion - Essbase

1 - About

To create OLAP models or build metaoutlines with Integration Services, you must connect Integration Services to a database that contains metadata (the OLAP Metadata Catalog database). To make these connections, you must configure a data source name for an OLAP Metadata Catalog database. You do this by mapping a supported Open Database Connectivity (ODBC) driver.

Advertising

3 - Steps on Windows

3.1 - Creation of the schema

C:\Documents AND Settings\gerardnico>sqlplus / AS sysdba
 
SQL*Plus: RELEASE 11.1.0.7.0 - Production ON Ma Dec 21 05:47:34 2009
 
Copyright (c) 1982, 2008, Oracle.  ALL rights reserved.
 
 
Connected WITH:
Oracle Database 11g Enterprise Edition RELEASE 11.1.0.7.0 - Production
WITH the Partitioning, OLAP, Data Mining AND REAL Application Testing options
 
SQL> CREATE USER EIS_META_USER IDENTIFIED BY EIS_META_USER
  2  DEFAULT tablespace users
  3  TEMPORARY tablespace temp
  4  quota unlimited ON users;
 
USER IS created
 
SQL>
SQL> GRANT CONNECT, resource TO EIS_META_USER;

3.2 - Creation of the system DSN ODBC

3.3 - Olap metadata catalog_setup

4 - Documentation/Reference

db/essbase/olap_metadata_catalog.txt · Last modified: 2018/02/13 11:26 by gerardnico