How to import Metadata using Oracle Connector from IMAM (InfoSphere Metadata Asset Manager) Window (or Information Server DataStage Client) on Unix OS

For any Connector Metadata import user needs to restart the Node agent after setting all the required parameters of a connector. For Oracle Connector we can do MDI (Metadata Import) using below steps

Steps to setup Oracle environment prior to import (Please use root user for below steps)

1   Install Oracle Client/Server on Information Server machine

2 Set the Oracle related environments like ORACLE_HOME, LD_LIBRARY-PATH/LIBPATH, PATH using one of the below steps

export ORACLE_HOME=/home/oracle/client/product/11.2.0/client_1

export LD_LIBRARY-PATH=/home/oracle/client/product/11.2.0/client_1/lib:$ LD_LIBRARY-PATH

export PATH= =/home/oracle/client/product/11.2.0/client_1:$PATH

OR

Add the below parameters in dsenv

            PATH=/home/oracle/client/product/11.2.0/client_1/bin:$PATH export PATH

LD_LIBRARY_PATH=/home/oracle/client/product/11.2.0/client_1/lib:$LD_LIBRARY_PATH     export LD_LIBRARY_PATH  

           

ORACLE_HOME=/home/oracle/client/product/11.2.0/client_1 export ORACLE_HOME  

Now source dsenv and restart the DSEngine.

*LIBPATH needs to use for AIX instead of LD_LIBRARY_PATH

3  Source dsenv, it can be done by below command

 source /opt/IBM/InformationServer/Server/DSEngine/dsenv

4  Goto /opt/IBM/InformationServer/ASBNode/bin/ and run restart the Node agent as  ./NodeAgents.sh restart

5  Goto DataStage Client or IMAM GUI Window and run the Oracle Connector Metadata import steps.

Steps to Import MDI using IMAM GUI
1) Connect to IMAM GUI by using below link

https://localhost:9443/ibm/imam/console/loginForm.jsp  (where as localhost is your machine hostname or IP)

2) Goto Administration tab and create Metadata Interchange Server.

3) Goto Import Tab and Click on New Import Area

3) Select IBM InfoSphere  Oracle Connector From the Bridge/Connector Selection after selecting Metadata Interchange Server and give the Import area name and Click on Next button

4) Select the DataConnection

5) Select Asset to Import and click on Next button

6) Provide the Host System name and click on next button

7) In next page Select Express Import and click on Import button

8) You can see the imported assets Shared Import Tabs of IMAM Window

Summary: We can import Metadata using Oracle Connector from IMAM GUI (or DataStage Client) after restarting Node agent (after setting all the Oracle client related environments) from root user.

Disclaimer: “The postings on this site are my own and don’t necessarily represent IBM’s positions, strategies or opinions.”