ODI – Data Quality : Metabase Manager

This post covers overview of Oracle Data Quality Products (in ODI) and connect to Data Quality Repository using Metabase Manager (windows tool)

ODIOracle Data Integrator
ODPOracle Data Profiling
ODQOracle Data Quality

Oracle Data Integrator Suite (more info here and here) consists of Oracle Data Integrator and Oracle Data Quality Products.

Oracle Data Profiling” and “Oracle Data Quality for Data Integrator” comes under Oracle Data Quality component of ODI Suite.

Things good to know about Oracle Data Quality (Metabase Manager)

1. 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).

.

2. Repository and Scheduler configuration screen (shown above) is available only if you select option 1, 3 or 4 during ODI installation .

 .

3. Oracle Data Quality Repository(listening on port 7600) is a collection of one of more metabase.
Note * Repository for Data Quality product (listening on port 7600) is different from Master and Work Repository in ODI.

4. Metabase Manager (available only on windows) is tool to manage metabases, create loader configuration and manage Data Quality users .

5. Metabase Repository and Quality/Profiling enginecan run on Windows, Unix flavors (eg. AIX, HP-UX, Solaris), and Linux where as Metabase Manager(tool to manage metabase) is only supported on Windows.

6. Metabase Server executables are under $OH/ oracledq/ metabase_server/ metabase/ bin/ mtb_server , server

7. Metabase Server Log files are under $OH/ oracledq/ metabase_data/ logs/ mtb_server.log

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

inetconv -i /etc/inet/inetd.conf  (from root)
svcadm restart inetd (from root)

9. root.sh(as part of ODI install) configures repository server (metabase) as service using INTED/XINETD on unix

To install Metabase Manager on Windows and ODI/ODQ server on Unix/Linux –

A. Install ODI Server (including ODQ) on Unix/Linux (make note of repository & scheduler port).
B. Start ODI installer on windows and select Installation Type Client
C.
Provide server hostname and repository/scheduler port
D. Start Metabase Manager from start menu

.

.

References/Related 

  • 762959.1  Installing ODI Integration Suite On Unix/Linux Platforms
  • 827247.1  FAQ For The Oracle Data Integrator ODP And ODQ Companion Tools
  • 882961.1  FAQ Concerning Data Being Used By ODQ Data Discovery Tasks
  • 740816.1  Troubleshooting Oracle Data Integrator ODQ and ODP Issues
  • ODP & ODQ for Data Integrator on OTN

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

9 comments
sajid says May 20, 2010

I have installed ODI 10.1.3.5 on Linux 5.5, along with Oracle DB 11.2

I got the warning NIS detected, as shown in your pic in this blog, what does that means, and what will be its impact on my installation

I have tried to do
netstat -an | grep 7600
netstat -an | grep 7601

only 7600 is showin results. i had used the default ports during installation

Reply
Atul Kumar says May 20, 2010

@ Sajid,
Which image or NIS you are talking about ?

If 7601 is not working then start scheduler (this port is used by scheduler)

Reply
sajid says May 24, 2010

I am talking of the image after

<>

It is saying NIS Detected. I wanted to know what is the impact of this warning.

Secondly how shall I start the scheduler.

Reply
sajid says May 25, 2010

image after following lines
9. root.sh(as part of ODI install) configures repository server (metabase) as service using INTED/XINETD on unix

Reply
Atul Kumar says May 25, 2010

@ Sajid,
I don’t think this is an issue as this is just a warning. Are you hitting any specific issues ?

Reply
sajid says May 25, 2010

no i am not getting any error, but i just wanted to confirm its impact.
In my implementation I have to pull data from sybase database and load it into oracle database. but when i use sybase jdbc driver, I am facing an error:
JDBC driver:com.sybase.jdbc2.jdbc.SybDriver
JDBC Url:jdbc:sybase:Tds:192.168.1.14:2050

Error: connection failed

I am not getting any clear error message, i can ping the ipaddress and also from another machine i can connect to 192.168.1.14:2050 using odbc driver.

can you please suggest something for this.

Reply
Samantha says April 29, 2011

Please help me 🙁

inetconv: command not found

Reply
Atul Kumar says April 29, 2011

@Samantha,
What is your operating system ? What user you are using to find inetconv command ?

Please contact your system/unix administrator.

Reply
Marco says January 9, 2012

Hi, I have a problem. They changed the architecture of oracle db: First three had the same db with the same username and pwd and I only had to make only one connection via topology manager and so dimamico url created dynamically using the variable # STATISTIC.SERVER_DATA. Now the Db is one with three user. How can I adjust everything with the new situation??

Reply
Add Your Reply

Not found