Monday 7 July 2014

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.”


No comments:

Post a Comment