Essbase - Integration Services - OLAP Metadata Catalog

Essbase Overview

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

ODBC - How to create a DSN connection in Windows

Eis Meta Odbc

Olap metadata catalog_setup

Eis Olap Metadata Catalog Setup

Documentation/Reference





Discover More
Essbase Eis Tbc Dsn Odbc
Essbase - Integration Service - Setting up the TBC sample application

To set up the Beverage Company sample application in integration service, you have two possibilities : automatically manually Log in the Oracle Database and perform this statement ...
Essbase Overview
Essbase - Integration Services (EIS)

Oracle Essbase Integration Services—an optional product component—provides a metadata-driven environment to bridge the gap between data stored in database and detailed data stored in relational databases....



Share this page:
Follow us:
Task Runner