Configuring an OLAP metadata catalog on AIX, HP-UX, and Solaris is similar to configuring a data source. For the OLAP Metadata Catalog database, add a data source name and section to the odbc.ini file, as described in Editing the odbc.ini file. No other changes are required.
You can also use the odbcconfig utility to define an OLAP Metadata Catalog configuration. See the Integration Server Administration Guide for information on odbcconfig. You must create an OLAP Metadata Catalog database in a supported RDBMS before configuring it as an ODBC data source.
The following example illustrates how you might edit odbc.ini to connect to the OLAP Metadata Catalog, TBC_MD, on DB2 Universal Database (on Solaris Operating System), using a native ODBC driver:
[ODBC Data Sources] ocd6a5a=db2 v6 ... [ocd6a5a] Driver=/home/db2instl/sqllib/lib/db2.0 Description=db2
The following example illustrates how you might edit odbc.ini to connect to an OLAP metadata catalog, such as TBC_MD, on the Solaris Operating System using a MERANT ODBC driver:
[ODBC Data Sources] sybdata=Sybase11 on Solaris Operating System ... [sybdata] Driver=/home/hyperion/essintegration/ odbc/merant40/lib/ARase17.so Description=Data in sybase database on solaris Database=sybdata LogonID=uid Password=pwd NetworkAddress=serverhost,4100 EnableDescribeParam=1 EnableQuotedIdentifiers=0 OptimizePrepare=1 RaiseErrorPositionBehavior=0 SelectMethod=0 ApplicationUsingThreads=1