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.
Articles Related
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;