{"id":1411,"date":"2009-12-09T04:01:15","date_gmt":"2009-12-09T08:01:15","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2009\/12\/09\/odi-data-quality-metabase-manager\/"},"modified":"2009-12-09T04:01:15","modified_gmt":"2009-12-09T08:01:15","slug":"odi-data-quality-metabase-manager","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2009\/12\/09\/odi-data-quality-metabase-manager\/","title":{"rendered":"ODI – Data Quality : Metabase Manager"},"content":{"rendered":"

This post covers overview of Oracle Data Quality<\/strong> Products (in ODI) and\u00a0connect to\u00a0Data Quality Repository<\/strong>\u00a0using Metabase Manager<\/strong> (windows tool)<\/p>\n

ODI<\/strong> – O<\/strong>racle D<\/strong>ata I<\/strong>ntegrator
\nODP<\/strong> – O<\/strong>racle D<\/strong>ata P<\/strong>rofiling
\nODQ<\/strong> – O<\/strong>racle D<\/strong>ata Q<\/strong>uality<\/p>\n

Oracle Data Integrator Suite (more info here<\/a> and here<\/a>) consists of Oracle Data Integrator<\/strong> and Oracle Data Quality<\/strong> Products.<\/p>\n

“Oracle Data Profiling<\/strong>” and “Oracle Data Quality for Data Integrator<\/strong>” comes under Oracle Data Quality component of ODI Suite.<\/p>\n

Things good to know about Oracle Data Quality (Metabase Manager)
\n<\/u><\/strong>
\n1.<\/strong> When you install Oracle Data Quality (from ODI suite) product you configure ODQ Repository and scheduler to listen on specific port (7600 for repository and 7601 for scheduler are default ports).<\/p>\n

<\/a><\/p>\n

.<\/p>\n

2.<\/strong> Repository<\/strong> and Scheduler<\/strong> configuration screen (shown above)\u00a0is available only if you select option 1, 3 or 4 during ODI installation .<\/p>\n

<\/a><\/p>\n

\u00a0.<\/p>\n

3. <\/strong>Oracle Data Quality Repository<\/strong>(listening on port 7600) is a collection of one of more metabase.
\nNote * Repository for Data Quality product (listening on port 7600) is different from Master and Work Repository in ODI.<\/font><\/p>\n

4. <\/strong>Metabase Manager (available only on windows) is tool to manage metabases, create loader configuration and manage Data Quality users .<\/p>\n

5. <\/strong>Metabase Repository<\/strong> and Quality\/Profiling engine<\/strong>can run on Windows, Unix flavors (eg. AIX, HP-UX, Solaris), and Linux where as Metabase Manager<\/strong>(tool to manage metabase) is only supported on Windows.<\/p>\n

6. <\/strong>Metabase Server executables <\/strong>are under $OH\/ oracledq\/ metabase_server\/ metabase\/ bin\/ mtb_server<\/strong> , server<\/strong><\/p>\n

7. <\/strong>Metabase Server\u00a0Log files are\u00a0under $OH\/ oracledq\/ metabase_data\/ logs\/ mtb_server.log<\/strong><\/p>\n

8. <\/strong>Metabase Server runs as service using INETD<\/strong> \/ XINETD<\/strong> on Unix and if you have installed ODI<\/strong> (with Data Quality<\/strong> component) on Solaris 10<\/strong> then follow these steps (convert inet.conf to smf repository using inetconv<\/strong><\/font>)<\/p>\n

inetconv -i \/etc\/inet\/inetd.conf<\/strong>\u00a0 (from root)
\nsvcadm restart inetd<\/strong> (from root)<\/p>\n

9.<\/strong> root.sh<\/strong>(as part of ODI install) configures repository server (metabase) as service using INTED\/XINETD on unix<\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

To install\u00a0Metabase Manager<\/strong> on Windows and ODI\/ODQ server on Unix\/Linux\u00a0–<\/p>\n

A.<\/strong> Install\u00a0ODI Server (including ODQ) on Unix\/Linux (make note of repository & scheduler port<\/font>).
\nB. <\/strong>Start ODI installer on windows and select Installation Type Client
\nC. <\/strong>Provide server hostname and repository\/scheduler port
\nD<\/strong>. Start Metabase Manager from start menu<\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

<\/a><\/p>\n

.<\/p>\n

.<\/p>\n

References\/Related<\/u><\/strong>\u00a0<\/p>\n