Essbase - Integration Services - OLAP Metadata Catalog

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.

Steps on Windows

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;

Creation of the system DSN ODBC

Olap metadata catalog_setup

_

Documentation/Reference


Powered by ComboStrap